function conectarse()
{
$enlace = mysqli_connect($this->host, $this->usuario, $this->contrasena, $this->baseDatos);
if ($enlace) {
//echo "Conexion exitosa"; //si la conexion fue exitosa nos muestra este mensaje como prueba, despues lo puedes poner comentarios de nuevo: //
} else {
die('Error de Conexión (' . mysql_connect_errno() . ') ' . mysql_connect_error());
}
return $enlace;
mysqli_close($enlace);
//cierra la conexion a nuestra base de datos, un ounto de seguridad importante.
}
function sisBibAbreConexion()
{
global $Usuario;
global $Password;
global $Servidor;
global $BaseDeDatos;
global $DebuggingMode;
global $programa;
$conexionBD = mysql_connect($Servidor, $Usuario, $Password) or die("<p>======================================================================================</p>" . "<p>ABORTA Modulo: sisBibAbreConexion -- Error al conectarse al servidor de Base de Datos</p>" . "<p> La funcion fue utilizada en el modulo (" . $programa . ")</p>" . "<p> Codigo de error " . mysql_connect_errno() . ": " . mysql_connect_error() . "</p>" . "<p> Datos de conexion al servidor " . " </p><p>Servidor:(" . $Servidor . ")</p><p> Usuario:(" . $Usuario . ")</p><p> Password:(" . $Password . ")</p><p> Base de Datos:(" . $BaseDeDatos . ")</p>" . "<p>======================================================================================</p>");
if ($DebuggingMode) {
echo "<p>======================================================================================</p>" . "<br>Modulo: sisBibAbreConexion envia el siguiente mensaje -- Se conecto al servidor con exito</br>" . "<br> La funcion fue utilizada en el modulo (" . $programa . ")</br>" . "<p> Datos de conexion al servidor " . " </p><p>Servidor:(" . $Servidor . ")</p><p> Usuario:(" . $Usuario . ")</p><p> Password:(" . $Password . ")</p><p> Base de Datos:(" . $BaseDeDatos . ")</p>" . "<p>======================================================================================</p>";
}
$descriptor = mysql_select_db($BaseDeDatos, $conexionBD) or die("<p>======================================================================================</p>" . "<p>ABORTA Modulo: sisBibAbreConexion -- Error al seleccionar la Base de Datos</p>" . "<p> La funcion fue utilizada en el modulo (" . $programa . ")</p>" . "<p> Codigo de error " . mysql_connect_errno() . ": " . mysql_connect_error() . "</p>" . "<p> Datos de conexion al servidor " . " </p><p>Servidor:(" . $Servidor . ")</p><p> Usuario:(" . $Usuario . ")</p><p> Password:(" . $Password . ")</p><p> Base de Datos:(" . $BaseDeDatos . ")</p>" . "<p>======================================================================================</p>");
if ($DebuggingMode) {
echo "<p>======================================================================================</p>" . "<br>Modulo: sisBibAbreConexion envia el siguiente mensaje -- Selecciono la Base De Datos con exito</br>" . "<br> La funcion fue utilizada en el modulo (" . $programa . ")</br>" . "<p> Datos de conexion al servidor " . " </p><p>Servidor:(" . $Servidor . ")</p><p> Usuario:(" . $Usuario . ")</p><p> Password:(" . $Password . ")</p><p> Base de Datos:(" . $BaseDeDatos . ")</p>" . "<p>======================================================================================</p>";
}
return $conexionBD;
//Termina sisBibAbreConexion
}
<?php
# Oppening connection with the database.
$connection = mysql_connect("localhost", "root", "root");
if (!$connection) {
die("<p>The database server is not available</p>" . "<p>Error code: " . mysql_connect_errno() . ": " . mysql_connect_error() . "</p>");
}
# Selecting a database.
$database = mysql_select_db("trabalhos", $connection);
if (!$database) {
die("<p>It was not possible to select the database</p>" . "<p>Error code: " . mysql_errno($connection) . ": " . mysql_error($connection) . "<br />");
}
# Used to store students and their grades.
$students_array = array();
# Used to get the max number of exercices.
$max = getMaxNumberOfExercises();
# Used to calculate the grade for each student.
calculateGrade($max);
function getMaxNumberOfExercises()
{
$max = 0;
# Getting all students in the database.
$query = "SELECT ALUNOS.matricula FROM ALUNOS";
$students = mysql_query($query);
while ($row = mysql_fetch_array($students)) {
# Useful for getting a specific student's homework.
$matricula = $row["matricula"];
# Getting the number of all correct homework of a specific student.
$queryCountCorret = "SELECT COUNT(*)\n FROM TRABALHOS \n WHERE TRABALHOS.aluno = {$matricula}";
$countCorrect = mysql_query($queryCountCorret);
# Getting the numeric result.
<?php
// Load MySQL credentials from config file.
include 'config.php';
// Attempt to connect to the MySQL server.
if (!($db_conn = mysql_connect($servername, $username, $password))) {
die("Failed to connect to the MySQL server: " . mysql_connect_errno());
}
// Attempt to connect to the database.
if (!mysql_select_db($database)) {
die("Failed to select the database: " . $database);
}
function fixTag($tag, $capitalize, $pluralize)
{
if ($pluralize) {
$newTagNames = array('geogName' => 'geographic names', 'persName' => 'person names', 'placeName' => 'place names', 'orgName' => 'organization names', 'title' => 'titles', 'name' => 'names', 'pen_name' => 'pen_names', 'building' => 'buildings', 'book' => 'books', 'poem' => 'poems', 'manuscript' => 'manuscripts', 'anthology' => 'anthologies', 'archive' => 'archives', 'bibliography' => 'bibliographies', 'engraving' => 'engravings', 'essay' => 'essays', 'periodical' => 'periodicals', 'reference' => 'references', 'autobiography' => 'autobiographies', 'biography' => 'biographies', 'magazine' => 'magazines', 'novel' => 'novels', 'archive_digital' => 'digital archives', 'archive_nondigital' => 'nondigital archives', 'bibliography_text' => 'bibliography texts', 'composite' => 'composites', 'gloss' => 'glosses', 'lesson' => 'lessons', 'program' => 'programs', 'sermon' => 'sermons', 'story' => 'stories', 'peom' => 'peoms', 'guidebook' => 'guidebooks', 'map' => 'maps', 'painting' => 'paintings', 'book_chapter' => 'book chapters', 'memoir' => 'memoirs', 'building' => 'buildings', 'sketch' => 'sketches', 'composition' => 'compositions', 'work' => 'works', 'letter' => 'letters', 'scripture' => 'scriptures', 'drawing' => 'drawings', 'catalog_auction' => 'catalog auctions', 'dictionary' => 'dictionaries', 'tale' => 'tales', 'article' => 'articles', 'constellation' => 'constellations');
} else {
$newTagNames = array('geogName' => 'geographic name', 'persName' => 'person name', 'placeName' => 'place name', 'orgName' => 'organization name');
}
if (array_key_exists($tag, $newTagNames)) {
$tag = $newTagNames[$tag];
}
if ($capitalize) {
$tag = strtoupper(substr($tag, 0, 1)) . substr($tag, 1);
}
$tag = str_replace('_', ' ', $tag);
return $tag;
}
function createSearchQuery()
{
// This is our base query. We will add constraints to make this query longer
function xf_db_connect_errno()
{
return mysql_connect_errno();
}
