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; }