public function execute()
{
$collect = array();
$link_count = count($this->links);
$processed = 0;
do {
$links = $errors = $reject = array();
foreach ($this->links as $link) {
$links[] = $errors[] = $reject[] = $link;
}
if (!mysqli_poll($links, $errors, $reject, 0, 1000)) {
continue;
}
for ($i = 0; $i < $link_count; $i++) {
$link = $this->links[$i];
if (mysqli_errno($link)) {
throw new \RuntimeException(mysqli_error($link), mysqli_errno($link));
}
if ($result = $link->reap_async_query()) {
if (is_object($result)) {
$temp = array();
while (($row = $result->fetch_assoc()) && ($temp[] = $row)) {
}
$collect[$i] = $temp;
mysqli_free_result($result);
} else {
$collect[$i] = $result;
}
}
$processed++;
}
} while ($processed < $link_count);
return $collect;
}
public function getJarigenVanDeMaand()
{
// Query voor het verkrijgen van de jarigen van deze maand
$sSelectiequery = "SELECT voornaam, tussenvoegsel, achternaam, DAY(geboorte_datum) AS dag ";
$sSelectiequery .= "FROM `ledenlijst` ";
$sSelectiequery .= "WHERE MONTH(geboorte_datum)= MONTH(CURRENT_TIMESTAMP) ";
$sSelectiequery .= "ORDER BY DAY(geboorte_datum)";
// Databaseverbinding met MySQL openen
$rDatabaseverbinding = mysqli_connect(MYSQL_SERVER, MYSQL_GEBRUIKERSNAAM, MYSQL_WACHTWOORD) or die(mysqli_errno());
// Verbinding controleren
if (mysqli_connect_errno()) {
echo "Fout bij het maken van een verbinding met MySQL: " . mysqli_connect_error();
}
// De database van BC Rianto selecteren
mysqli_select_db($rDatabaseverbinding, MYSQL_DATABASENAAM) or die(sprintf('Hieronder de foutmelding\\n', mysqli_connect_errno(), mysqli_connect_error()));
// Gegevens van jarigen uit de database halen
$rRecordset = mysqli_query($rDatabaseverbinding, $sSelectiequery) or die(mysqli_error($rDatabaseverbinding));
$n = 0;
$aJarigen = '';
// Stap 5. Resultaten verwerken als een associatieve array
while ($aRecord = mysqli_fetch_array($rRecordset, MYSQL_ASSOC)) {
// Aanmaken nieuwe jarige
$aJarigen[$n] = array('dag' => $aRecord['dag'], 'naam' => $aRecord['voornaam'] . ' ' . $aRecord['tussenvoegsel'] . ' ' . $aRecord['achternaam']);
$n++;
}
// Resultaat in MySQL vrijgeven
mysqli_free_result($rRecordset);
// Databaseverbinding met MySQL sluiten
mysqli_close($rDatabaseverbinding);
// Eventueel nog systeembronnen (resources) opruimen
unset($rRecordset);
unset($rDatabaseverbinding);
return $aJarigen;
}
function insertarMiPrograma()
{
$id_prog = $POST['id_prog'];
$fecha = $POST['fecha'];
$evento = $POST['evento'];
$descripcion = $POST['descripcion'];
$lugar = $POST['lugar'];
$horaInicio = $POST['horaInicio'];
$horaFin = $POST['horaFin'];
$categoria = $POST['categoria'];
$usuario_id = $POST['usuario_id'];
$mysql = new conexion();
$mysqli = $mysql->conctar();
echo "{$id_prog} de porgrama";
echo "{$fecha} de programa";
echo "{$evento} de programa";
echo "{$descripcion} de programa";
echo "{$lugar} de programa";
echo "{$horaInicio} de programa";
echo "{$horaFin} de programa";
echo "{$categoria} de programa";
echo "{$usuario_id} de usuario";
$query = "INSERT INTO programa (id_prog, fecha, evento, descripcion, lugar, horaInicio, horaFin, categoria, usuario_id) VALUES ({$id_prog}, '{$fecha}', '{$evento}', '{$descripcion}', '{$lugar}', '{$horaInicio}', '{$horaFin}' '{$categoria}', '{$usuario_id}');";
mysqli_query($mysqli, $query) or die(mysqli_errno($mysqli));
mysqli_close($mysqli);
}
function check_db($dbhost, $dbuser, $dbpw, $dbname, $tablepre)
{
if (!function_exists('mysql_connect') && !function_exists('mysqli_connect')) {
show_msg('undefine_func', 'mysql_connect', 0);
}
$mysqlmode = function_exists('mysql_connect') ? 'mysql' : 'mysqli';
$link = $mysqlmode == 'mysql' ? @mysql_connect($dbhost, $dbuser, $dbpw) : new mysqli($dbhost, $dbuser, $dbpw);
if (!$link) {
$errno = $mysqlmode == 'mysql' ? mysql_errno() : mysqli_errno();
$error = $mysqlmode == 'mysql' ? mysql_error() : mysqli_error();
if ($errno == 1045) {
show_msg('database_errno_1045', $error, 0);
} elseif ($errno == 2003) {
show_msg('database_errno_2003', $error, 0);
} else {
show_msg('database_connect_error', $error, 0);
}
} else {
if ($query = $mysqlmode == 'mysql' ? @mysql_query("SHOW TABLES FROM {$dbname}") : $link->query("SHOW TABLES FROM {$dbname}")) {
if (!$query) {
return false;
}
while ($row = $mysqlmode == 'mysql' ? mysql_fetch_row($query) : $query->fetch_row()) {
if (preg_match("/^{$tablepre}/", $row[0])) {
return false;
}
}
}
}
return true;
}
function poll_async($offset, $link, $links, $errors, $reject, $exp_ready, $use_oo_syntax)
{
if ($exp_ready !== ($tmp = mysqli_poll($links, $errors, $reject, 0, 1000))) {
printf("[%03d + 1] There should be %d links ready to read from, %d ready\n", $offset, $exp_ready, $tmp);
}
foreach ($links as $mysqli) {
if ($use_oo_syntax) {
$res = $mysqli->reap_async_query();
} else {
$res = mysqli_reap_async_query($mysqli);
}
if (is_object($res)) {
printf("[%03d + 2] %s\n", $offset, var_export($res->fetch_assoc(), true));
} else {
if (mysqli_errno($mysqli) > 0) {
printf("[%03d + 3] Error indicated through links array: %d/%s", $offset, mysqli_errno($mysqli), mysqli_error($mysqli));
} else {
printf("[%03d + 4] Cannot fetch and no error set - non resultset query (no SELECT)!\n", $offset);
}
}
}
foreach ($errors as $mysqli) {
printf("[%03d + 5] Error on %d: %d/%s\n", $offset, mysqli_thread_id($mysqli), mysqli_errno($mysqli), mysqli_error($mysqli));
}
foreach ($reject as $mysqli) {
printf("[%03d + 6] Rejecting thread %d: %d/%s\n", $offset, mysqli_thread_id($mysqli), mysqli_errno($mysqli), mysqli_error($mysqli));
}
}
public static function exeSql($dbname, $sql, $taskid = 0)
{
global $db;
$ret = array();
if ($taskid == 0) {
$taskid = key(end(self::$dbPool));
}
if (!isset(self::$dbPool[$taskid][$dbname]) || empty(self::$dbPool[$taskid][$dbname])) {
$db1 = mysqli_connect($db[$dbname]['host'], $db[$dbname]['user'], $db[$dbname]['pswd']) or die("连接 '" . $dbname . "'库失败");
mysqli_query($db1, "SET NAMES 'UTF8'");
self::$dbPool[$taskid][$dbname] = $db1;
} else {
$db1 = self::$dbPool[$taskid][$dbname];
}
if (!($query = mysqli_query($db1, $sql))) {
throw new \Exception("出錯的SQL：" . $sql . "\t" . mysqli_errno($db1) . ": " . mysqli_error($db1));
}
if ($query instanceof \mysqli_result) {
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$ret[] = $row;
}
return $ret;
} else {
return $query;
}
}
function findRow($offset, $link, $id, $label)
{
$sql = sprintf("SELECT id, label FROM test_mysqli_stmt_bind_param_references_table_1 WHERE id = '%d' AND label = '%s'", $id, $label);
if (!($res = mysqli_query($link, $sql))) {
printf("[%03d + 1] %s failed, [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link));
return false;
}
if (!($row = mysqli_fetch_assoc($res))) {
printf("[%03d + 2] fetch for %s failed, [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link));
return false;
}
mysqli_free_result($res);
if ($row['id'] != $id) {
printf("[%03d + 3] Expecting %s/%s got %s/%s\n", $offset, gettype($id), $id, gettype($row['id']), $row['id']);
return false;
}
if ($row['label'] != $label) {
printf("[%03d + 4] Expecting %s/%s got %s/%s\n", $offset, gettype($label), $label, gettype($row['label']), $row['label']);
return false;
}
$sql = sprintf("DELETE FROM test_mysqli_stmt_bind_param_references_table_1 WHERE id = '%d' AND label = '%s'", $id, $label);
if (!mysqli_query($link, $sql)) {
printf("[%03d + 5] %s failed, [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link));
return false;
}
return true;
}
function verification_mdp($adrentre)
{
global $connect;
$result = mysqli_query($connect, "select mot_de_passe,id_utilisateur,admin from utilisateur where mail='{$adrentre}'") or die("MsQL Erreur : " . mysqli_errno($connect));
$resultat = mysqli_fetch_assoc($result);
return $resultat;
}
function new_recover_sql_query($sql, $error = G5_DISPLAY_SQL_ERROR, $link = null)
{
global $g5;
if (!$link) {
$link = $g5['connect_db'];
}
// Blind SQL Injection 취약점 해결
$sql = trim($sql);
// union의 사용을 허락하지 않습니다.
//$sql = preg_replace("#^select.*from.*union.*#i", "select 1", $sql);
//$sql = preg_replace("#^select.*from.*[\s\(]+union[\s\)]+.*#i ", "select 1", $sql);
// `information_schema` DB로의 접근을 허락하지 않습니다.
//$sql = preg_replace("#^select.*from.*where.*`?information_schema`?.*#i", "select 1", $sql);
if (function_exists('mysqli_query') && G5_MYSQLI_USE) {
if ($error) {
$result = @mysqli_query($link, $sql) or die("<p>{$sql}<p>" . mysqli_errno($link) . " : " . mysqli_error($link) . "<p>error file : {$_SERVER['SCRIPT_NAME']}");
} else {
$result = @mysqli_query($link, $sql);
}
} else {
if ($error) {
$result = @mysql_query($sql, $link) or die("<p>{$sql}<p>" . mysql_errno() . " : " . mysql_error() . "<p>error file : {$_SERVER['SCRIPT_NAME']}");
} else {
$result = @mysql_query($sql, $link);
}
}
return $result;
}
public function __construct()
{
$this->db_conn = mysqli_connect($this->db_host, $this->db_user, $this->db_pass, $this->db_name);
if (mysqli_errno($this->db_conn)) {
die("Failed to connect to database: " + mysqli_error($this->db_conn));
}
}
private function _dbOpen()
{
$this->dbCon = mysqli_connect(dbHost, dbUser, dbPass, dbName);
if (!$this->dbCon) {
die("Connection Failed" . mysqli_errno());
}
}
function dbQuery($query)
{
$db = mysqli_connect(SERVERNAME, USERNAME, PASSWORD, DATABASE);
if (mysqli_connect_errno($db)) {
$_SESSION['feedback'] = ['color' => 'red', 'message' => 'Problem with database connection.'];
header('Location: ../index.php');
die;
}
$result = mysqli_query($db, $query);
if (mysqli_errno($db)) {
$_SESSION['feedback'] = ['color' => 'red', 'message' => 'Problem with query.'];
header('Location: ../index.php');
die;
}
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
}
mysqli_free_result($result);
mysqli_close($db);
if (!empty($data)) {
return $data;
} else {
return NULL;
}
}
function get_read($url = '', $key, $uid = 1)
{
$wzurl = "http://mp.weixin.qq.com/s?{$url}&key={$key}&ascene=1&uin=Nzc5OTI2MTIx&pass_ticket=kzTtalLseTrEcwKVHswOVecGMByySYu94gRKdAXokFv2jg4UAOt%2FkrZHb0IwUlSB";
$bsurl = "http://mp.weixin.qq.com/s?{$url}";
require_once "Snoopy.class.php";
$snoopy = new Snoopy();
$snoopy->agent = "Mozilla/5.0 (iPhone; U; CPU iPhone OS 3_0 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Version/4.0 Mobile/7A341 Safari/528.16";
//伪装浏览器
$snoopy->fetch($wzurl);
//获取所有内容
$content = $snoopy->results;
//显示结果
preg_match('/<span id="readNum">([^<]*)<\\/span>/si', $content, $read);
preg_match('/var likeNum = \'([^<]*)\';/si', $content, $suport);
// $content = htmlspecialchars($content);
$content = str_replace(array("'", "\""), array("\\'", "\\\""), $content);
if ($suport[1] == "赞") {
$suprot = 0;
}
$read = (int) $read[1];
$suport = (int) $suport[1];
$connect = mysqli_connect("127.0.0.1", "root", "root") or die("链接数据库失败！");
mysqli_select_db($connect, "wx_read") or die(mysqli_errno($connect));
mysqli_query($connect, "SET NAMES 'utf8'");
$sql = mysqli_query($connect, "INSERT INTO `wx_article` (`uid`, `url`, `content`, `reads`, `suports`) VALUES ('{$uid}','{$bsurl}','{$content}','{$read}','{$suport}');");
echo "INSERT INTO `wx_article` (`uid`, `url`, `content`, `reads`, `suports`) VALUES ('{$uid}','{$bsurl}','{$content}','{$read}','{$suport}');";
}
function driver_db_errno()
{
$db_conn = $this->db_link;
static $skip_error_codes = array(1091, 1176, 1050, 1060);
$errno = mysqli_errno($db_conn);
return in_array($errno, $skip_error_codes) ? 0 : $errno;
}
function insertWhatappMedia($table_name, $whatsapp_media_id, $whatsapp_media_date, $whatsapp_media_name, $whatsapp_media_sender)
{
$db = $this->dbcon;
$status = 0;
$timestamp = $this->util->generateTimestamp($whatsapp_media_date);
echo $timestamp;
if ($table_name == "_tblwhatsappimage") {
$stmt = $db->prepare("INSERT INTO _tblwhatsappimage (image_id, image_timestamp, image_name, image_sender, image_status) VALUES (?, ?, ?, ?, ?)");
}
if ($table_name == "_tblwhatsappaudio") {
$stmt = $db->prepare("INSERT INTO _tblwhatsappaudio (audio_id, audio_timestamp, audio_name, audio_sender, audio_status) VALUES (?, ?, ?, ?, ?)");
print_r($stmt);
}
if ($table_name == "_tblwhatsappvideo") {
echo "am called";
$stmt = $db->prepare("INSERT INTO _tblwhatsappvideo (video_id, video_timestamp, video_name, video_sender, video_status) VALUES (?, ?, ?, ?, ?)");
print_r($stmt);
}
$stmt->bind_param("sssss", $whatsapp_media_id, $timestamp, $whatsapp_media_name, $whatsapp_media_sender, $status);
$stmt->execute();
if ($stmt->affected_rows > 0) {
echo "Insert ok";
} else {
echo "Error executing::" . mysqli_errno();
}
}
public function query($sql)
{
$pos = stripos($sql, 'select');
if (is_numeric($pos)) {
//是select 语句
$rs = mysqli_query($this->conn, $sql);
if (mysqli_errno($this->conn)) {
die('you have an error ' . mysqli_error($this->conn));
}
if ($rs === false) {
return mysqli_affected_rows($this->conn);
}
//什么时候返回是false呢...哦子查询是select
$columns = array();
while ($property = @mysqli_fetch_field($rs)) {
$columns[] = $property->name;
}
$arr = array();
while ($result = @mysqli_fetch_row($rs)) {
$arr[] = array_combine($columns, $result);
}
return $arr;
} else {
mysqli_query($this->conn, $sql);
if (mysqli_errno($this->conn)) {
die('you have an error ' . mysqli_error($this->conn));
}
return mysqli_affected_rows($this->conn);
}
}
function getAssignments($link, $table, $divisions)
{
// initialize data
$semesterData = array();
foreach ($divisions as $index => $division) {
$semesterData[$division] = 0;
}
// show all assignments
$query = "select t.Task, t.Person, s.Division from {$table} as t inner join Students as s on s.Email = t.Person order by t.Task";
$statement = $link->prepare($query);
$rc = $statement->execute();
if (!$rc) {
$errNum = mysqli_errno($link);
$errMsg = mysqli_error($link);
print " ERROR - could not register selection: ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n";
exit;
}
$statement->bind_result($task, $person, $division);
while ($statement->fetch()) {
$weight = 0;
$myTask = new TeachingTask($task);
if ($myTask->isTa() && $myTask->getEffort() == 'full') {
$weight = 1.0;
}
if ($myTask->isTa() && $myTask->getEffort() == 'half') {
$weight = 0.5;
}
$semesterData[$division] += $weight;
}
$statement->close();
return $semesterData;
}
/**
* Returns the text of the error message from previous database operation
* @return string error message.
*/
function F_db_error($link_identifier = null)
{
if (empty($link_identifier)) {
return '';
}
return '[' . mysqli_errno($link_identifier) . ']: ' . mysqli_error($link_identifier) . '';
}
public function query($sql, $values = array())
{
$sql = new Expressions($sql);
$sql->set_connection($this);
$sql->bind_values($values);
$sql = trim($sql->to_s());
$values = $values ? array_flatten($values) : array();
if (!($sth = mysqli_prepare($this->connection, $sql))) {
throw new DatabaseException(mysqli_error($this->connection), mysqli_errno($this->connection));
}
if (count($values) > 0) {
$params = array($sth, '');
foreach ($values as &$value) {
if (is_int($value)) {
$params[1] .= 'i';
} elseif (is_float($value)) {
$params[1] .= 'd';
} else {
$params[1] .= 's';
}
$params[] =& $value;
}
if ($params[1]) {
call_user_func_array('mysqli_stmt_bind_param', $params);
}
}
if (is_int($ret = mysqli_stmt_execute($sth))) {
return $ret;
}
return new MysqliResultSet($sth);
}
function Query($query, $debugerror = true)
{
global $NATS;
if (!$this->connected) {
return -1;
}
$result = mysqli_query($this->sql, $query);
if ($debugerror) {
// persist the last error state
$this->LastError = mysqli_errno($this->sql);
if ($this->LastError > 0) {
$this->ErrorString = mysqli_error($this->sql) . " (" . mysqli_errno($this->sql) . ")";
} else {
$this->ErrorString = "";
}
}
if (mysqli_errno($this->sql) > 0) {
$err = mysqli_error($this->sql) . " (" . mysqli_errno($this->sql) . ")";
if (isset($NATS) && $debugerror) {
$NATS->Event("Query Failed: " . $query, 2, "DB", "Query");
$NATS->Event("Query Error: " . $err, 2, "DB", "Query");
}
}
return $result;
}
/**
* Validates and updates a user's personal data (and updates the session)
* @param $user_id
* @param $details
* @param $login
* @return string
*/
public function updateUserGeneral($user_id, $details, $login)
{
$ret = '';
if (!preg_match("/^[a-zA-Z]+\$/", $details[0]['value'])) {
$ret = 'Bad first name format';
return $ret;
}
if (!preg_match("/^[a-zA-Z]+\$/", $details[1]['value'])) {
$ret = 'Bad last name format';
return $ret;
}
if (!filter_var($details[2]['value'], FILTER_VALIDATE_EMAIL)) {
$ret = 'Bad email format';
return $ret;
}
$this->_db->query("UPDATE " . TBL_USERS . " SET user_email='" . $details[2]['value'] . "' WHERE user_id={$user_id}");
if (mysqli_errno($this->_db) === 1062) {
$ret = 'This email is already taken';
}
$birthdate = "{$details[5]['value']}-{$details[4]['value']}-{$details[3]['value']}";
$this->_db->query("UPDATE " . TBL_USERS_INFO . " SET user_firstname='{$details[0]['value']}', user_lastname='{$details[1]['value']}', " . "user_birthdate='{$birthdate}', user_about='{$details[6]['value']}' WHERE user_id={$user_id}");
if (!$ret) {
$login->fillSession($this->getUserById($user_id));
}
return $ret;
}
public function query($sql)
{
$resource = mysqli_query($this->link, $sql);
if ($resource != false) {
if ($resource !== true && get_class($resource) == 'mysqli_result') {
$data = array();
if (function_exists('mysqli_fetch_all')) {
$data = mysqli_fetch_all($resource, MYSQLI_ASSOC);
} else {
$i = 0;
while ($result = mysqli_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
}
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = mysqli_num_rows($resource);
mysqli_free_result($resource);
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysqli_error($this->link) . '<br />Error No: ' . mysqli_errno($this->link) . '<br />' . $sql);
exit;
}
}
/**
* Handles all SQL queries
* @param string $sql SQL statement
* @param string $return_type What data to return (RESULT, ROW, NUM_ROWS, QUERY)
* @return mixed
*/
function sqlQuery($sql, $return_type)
{
$result = mysqli_query($this->db_link, $sql);
if (mysqli_errno($this->db_link)) {
echo "MySQLi Error: " . mysqli_error($this->db_link);
}
switch ($return_type) {
default:
case RESULT:
$result_array = array();
while ($row = mysqli_fetch_array($result)) {
$result_array[] = $row;
}
return $result_array;
break;
case ROW:
return mysqli_fetch_assoc($result);
break;
case NUM_ROWS:
return mysqli_num_rows($result);
break;
case QUERY:
break;
}
}
/**
* bouwScherm bouwt het scherm op
* @return boolean False als er iets mis is gegaan, anders true
*/
public function bouwScherm()
{
$this->m_aData['categories'] = '';
$this->m_aData['postlink'] = SchermGenerator::genereerLink(SchermGenerator::WELKOM);
$this->addScript('js/functies.js');
$this->m_sTemplate = 'bezoekerpagina.tpl';
$sSelectiequery = "SELECT pagina_id, titel, inhoud ";
$sSelectiequery .= "FROM `webpaginas` ";
$sSelectiequery .= "WHERE pagina_id = " . $this->m_nPagina;
// Databaseverbinding met MySQL openen
$rDatabaseverbinding = mysqli_connect(MYSQL_SERVER, MYSQL_GEBRUIKERSNAAM, MYSQL_WACHTWOORD) or die(mysqli_errno());
// Verbinding controleren
if (mysqli_connect_errno()) {
echo "Fout bij het maken van een verbinding met MySQL: " . mysqli_connect_error();
}
// De database van BC Rianto selecteren
mysqli_select_db($rDatabaseverbinding, MYSQL_DATABASENAAM) or die(sprintf('Hieronder de foutmelding\\n', mysqli_connect_errno(), mysqli_connect_error()));
// Gegevens van jarigen uit de database halen
$rRecordset = mysqli_query($rDatabaseverbinding, $sSelectiequery) or die(mysqli_error($rDatabaseverbinding));
// Stap 5. Resultaten verwerken als een associatieve array
while ($aRecord = mysqli_fetch_array($rRecordset, MYSQL_ASSOC)) {
$this->p_sKop .= $aRecord['titel'];
$this->p_sInhoud .= $aRecord['inhoud'];
}
$this->m_sHTML = "<h2>" . $this->p_sKop . "</h2>" . $this->p_sInhoud . "<br>";
// Resultaat in MySQL vrijgeven
mysqli_free_result($rRecordset);
// Databaseverbinding met MySQL sluiten
mysqli_close($rDatabaseverbinding);
// Eventueel nog systeembronnen (resources) opruimen
unset($rRecordset);
unset($rDatabaseverbinding);
return true;
}
/**
* Analyze and sends an error.
*
* @param string $string
* @throws DatabaseException If a SQL fails
* @return type
*/
protected function sendError($string)
{
$mysql_error = mysqli_error($this->con);
$mysql_errno = mysqli_errno($this->con);
// 1016: Can't open file '....MYI'
// 2013: Lost connection to server during query.
if (in_array($mysql_errno, array(1016, 2013)) && $this->second_try) {
$this->second_try = false;
// Try to repair the table and run the query again.
if ($mysql_errno == 1016 && preg_match('~(?:\'([^\\.\']+)~', $mysql_error, $match) != 0 && !empty($match[1])) {
mysqli_query($this->con, "\n\t\t\t\t\tREPAIR TABLE {$match['1']}");
}
return $this->query($string, false);
}
$action_url = $this->buildActionUrl();
throw new DatabaseException('
<b>Unsuccessful!</b><br />
This query:<blockquote>' . nl2br(htmlspecialchars(trim($string))) . ';</blockquote>
Caused the error:<br />
<blockquote>' . nl2br(htmlspecialchars($mysql_error)) . '</blockquote>
<form action="' . $action_url . '" method="post">
<input type="submit" value="Try again" />
</form>
</div>');
}
function outputStudents()
{
$conn = database_connect();
//$conn = mysqli_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASS, DATABASE_HOME);
$query = "SELECT seatNumber,name,md5hash FROM students";
$result = mysqli_query($conn, $query);
if (mysqli_errno($conn)) {
echo mysqli_error($conn);
}
echo '<pre>';
while ($row = mysqli_fetch_array($result)) {
// print_r($row);
if ($row['seatNumber'] == $_SESSION['runCounter']) {
echo "CURRENT:\t";
} else {
if ($row['seatNumber'] % 2 == 1) {
echo "ODD:\t";
} else {
echo "EVEN:\t";
}
}
echo $row['seatNumber'] . "\t" . $row['name'] . '<br>';
}
echo '</pre>';
$numRows = mysqli_num_rows($result);
if ($_SESSION['runCounter'] > $numRows) {
$_SESSION['runCounter'] = 1;
}
database_disconnect($conn);
}
private function throw_sql_exception($class)
{
$errno = mysqli_errno($this->cn);
$error = mysqli_error($this->cn);
$msg = $error . "<br /><br /><b>Error number:</b> " . $errno;
throw new Exception($msg);
}
function traite_requete($requete = "")
{
mysqli_query($GLOBALS['db_c'], $requete);
$erreur_no = mysqli_errno($GLOBALS['db_c']);
if (!$erreur_no) {
$retour = "";
} else {
switch ($erreur_no) {
case "1060":
// le champ existe déjà : pas de problème
$retour = "";
break;
case "1061":
// La cléf existe déjà : pas de problème
$retour = "";
break;
case "1062":
// Présence d'un doublon : création de la cléf impossible
$retour = "<span style=\"color:#FF0000;\">Erreur (<b>non critique</b>) sur la requête : <i>" . $requete . "</i> (" . mysqli_errno($GLOBALS['db_c']) . " : " . mysqli_error($GLOBALS['db_c']) . ")</span><br />\n";
break;
case "1068":
// Des cléfs existent déjà : pas de problème
$retour = "";
break;
case "1091":
// Déjà supprimé : pas de problème
$retour = "";
break;
default:
$retour = "<span style=\"color:#FF0000;\">Erreur sur la requête : <i>" . $requete . "</i> (" . mysqli_errno($GLOBALS['db_c']) . " : " . mysqli_error($GLOBALS['db_c']) . ")</span><br />\n";
break;
}
}
return $retour;
}
public function query($sql, $unbuffered = false)
{
if (defined('FEATHER_SHOW_QUERIES')) {
$q_start = get_microtime();
}
$this->query_result = @mysqli_query($this->link_id, $sql);
if ($this->query_result) {
if (defined('FEATHER_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('FEATHER_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, 0);
}
$this->error_no = @mysqli_errno($this->link_id);
$this->error_msg = @mysqli_error($this->link_id);
// Rollback transaction
if ($this->in_transaction) {
mysqli_query($this->link_id, 'ROLLBACK');
}
--$this->in_transaction;
return false;
}
}
/**
* Establish a connection to MySQL.
*
* Create a connection to MySQL and store the connection handle in
* $this->connectionHandle.
* If $select_database is set, the database is selected for further queries.
* Returns true on success or false if connection couldn't be established.
*
* @param string $select_database
* @param string $connectionCharset
* @return boolean
**/
public function dbConnect($selectDatabase = false)
{
if ($this->_mysqli instanceof mysqli) {
return true;
}
$this->_mysqli = @new mysqli($this->server, $this->user, $this->password, $this->dbSelected, $this->port, $this->socket);
if ($this->_mysqli->connect_errno) {
$error = $this->_mysqli->connect_error;
$errno = $this->_mysqli->connect_errno;
$this->_mysqli = null;
return '(' . $errno . ') ' . $error;
}
$this->setConnectionCharset($this->connectionCharset);
if (false === $selectDatabase && $this->dbSelected > '') {
$selectDatabase = $this->dbSelected;
}
if ($selectDatabase) {
if ($this->selectDb($selectDatabase)) {
$this->dbSelected = $selectDatabase;
return true;
} else {
$this->sqlError(mysqli_error(mysqli_error(), mysqli_errno()));
}
}
return true;
}
