本文整理汇总了PHP中mysqli_stmt_fetch函数的典型用法代码示例。如果您正苦于以下问题：PHP mysqli_stmt_fetch函数的具体用法？PHP mysqli_stmt_fetch怎么用？PHP mysqli_stmt_fetch使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqli_stmt_fetch函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: createExtFile
function createExtFile($type)
{
$pathOfExt = "C:/data/ext/";
$pathOfDatabase = "C:/data/database/";
$t = time();
$temp_id = array();
$con = mysqli_connect("localhost", "root", "1212312121", "proj4d");
mysqli_set_charset($con, "utf8");
$query = "SELECT id FROM " . $type . "_detail WHERE isValid = 1";
$statement = mysqli_prepare($con, $query);
$success = mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement, $id);
$path = $pathOfExt . $type . $t . ".ext";
$myfile = fopen($path, "w") or die("Unable to open file!");
while (mysqli_stmt_fetch($statement)) {
array_push($temp_id, $id);
}
$i = 0;
for ($i; $i < sizeof($temp_id) - 1; $i++) {
$id = $temp_id[$i];
$txt = $pathOfDatabase . $type . "/" . $id . "/1.png;" . $id . PHP_EOL;
fwrite($myfile, $txt);
$txt = $pathOfDatabase . $type . "/" . $id . "/2.png;" . $id . PHP_EOL;
fwrite($myfile, $txt);
}
$id = $temp_id[$i];
$txt = $pathOfDatabase . $type . "/" . $id . "/1.png;" . $id . PHP_EOL;
fwrite($myfile, $txt);
$txt = $pathOfDatabase . $type . "/" . $id . "/2.png;" . $id;
fwrite($myfile, $txt);
fclose($myfile);
return $type . $t . ".ext";
}
开发者ID:paratab，项目名称:Proj_ImgApp，代码行数:34，代码来源:ImageExeCalling.php
示例2: registrator
function registrator($link)
{
//Функция регистрации пользователя (Взято из интернета "редактированно")
if (!empty($_POST["submit"])) {
if (!preg_match("/^[a-zA-Z0-9]+\$/", $_POST['login'])) {
$err[] = "Логин может состоять только из букв английского алфавита и цифр<br>";
}
if (strlen($_POST['login']) < 3 or strlen($_POST['login']) > 30) {
$err[] = "Логин должен быть не меньше 3-х символов и не больше 30<br>";
}
$query = "SELECT COUNT(user_id) FROM users WHERE user_login='" . mysqli_real_escape_string($link, $_POST['login']) . "'";
if ($stmt = mysqli_prepare($link, $query)) {
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $user_id);
mysqli_stmt_store_result($stmt);
mysqli_stmt_fetch($stmt);
mysqli_stmt_close($stmt);
}
if (!$user_id == 0) {
$err[] = "Пользователь с таким логином уже существует в базе данных<br>";
}
if (count($err) == 0) {
$login = $_POST['login'];
$password = md5(md5(trim($_POST['password'])));
mysqli_query($link, "INSERT INTO users SET user_login='" . $login . "', user_password='" . $password . "'");
header("Location: login.php");
exit;
} else {
print "<b>При регистрации произошли следующие ошибки:</b><br>";
foreach ($err as $error) {
print $error . "<br>";
}
}
}
}
开发者ID:Latinoz，项目名称:shop_catalog，代码行数:35，代码来源:lib.inc.php
示例3: update_vote
function update_vote($image_id)
{
//get number of votes and update
global $link;
$data = array();
$stmt = mysqli_prepare($link, "SELECT `amount` FROM `votes_amount` WHERE `imageID`=?;");
mysqli_stmt_bind_param($stmt, 'i', $image_id);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $num);
while (mysqli_stmt_fetch($stmt)) {
$amount['amount'] = $num;
}
mysqli_stmt_close($stmt);
$new_amount = $amount['amount'] + 1;
$stmt = mysqli_prepare($link, "UPDATE `votes_amount` SET `amount`=" . $new_amount . " WHERE `imageID`=?;") or die(mysqli_error($link));
mysqli_stmt_bind_param($stmt, 'i', $image_id);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
//return ajax data
if (isset($_SESSION['id']) && !isset($_POST['action']) && !isset($_POST['votePic'])) {
$data = array('new_amount' => $new_amount, 'imageID' => $image_id);
} elseif (isset($_POST['action']) && $_POST['action'] == 'anonymous_voting') {
//get another two images
$result = mysqli_query($link, "SELECT * FROM `image` ORDER BY RAND() LIMIT 2;") or die(mysqli_error($link));
//$data = array();
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
}
mysqli_close($link);
return $data;
}
开发者ID:tinggao，项目名称:woofWarrior，代码行数:32，代码来源:vote.php
示例4: isInQueue
function isInQueue()
{
// Reference Global Variables
global $globalHostName;
global $globalUserName;
global $globalPassword;
global $globalDatabase;
// MySQL Connection
$connection = mysqli_connect($globalHostName, $globalUserName, $globalPassword, $globalDatabase);
// Connection Error Handling
if ($connection->connect_error) {
// Kill the Connection
die("Could Not Connect to the Database");
}
// MySQL Injection Neutralized Email Variable
$safeEmail = mysqli_real_escape_string($connection, $_REQUEST['inputEmail']);
// Query Preparation
$query = mysqli_prepare($connection, 'SELECT COUNT(*) as total FROM users WHERE email = ?');
$query->bind_param('s', $safeEmail);
// Query Execution
mysqli_stmt_execute($query);
// Query Result Analysis
mysqli_stmt_bind_result($query, $total);
$data = mysqli_stmt_fetch($query);
//-----
$connection->close();
// If That Email is Already Registered...
if ($total > 0) {
echo "true";
return true;
} else {
echo "false";
return false;
}
}
开发者ID:hkuchampudi，项目名称:AutomatedExchangeSystem，代码行数:35，代码来源:inQueue.php
示例5: login
function login()
{
include_once 'database_conn.php';
// check is form filled
if (isFormFilled()) {
// if not filled, stop
return;
}
$uid = sanitizeData($_POST['username']);
$pswd = sanitizeData($_POST['password']);
$columnLengthSql = "\n\t\t\tSELECT COLUMN_NAME, CHARACTER_MAXIMUM_LENGTH\n\t\t\tFROM INFORMATION_SCHEMA.COLUMNS\n\t\t\tWHERE TABLE_NAME = 'te_users'\n\t\t\tAND (column_name = 'username'\n\t\t\tOR column_name = 'passwd')";
$COLUMN_LENGTH = getColumnLength($conn, $columnLengthSql);
$isError = false;
$errMsg[] = validateStringLength($uid, $COLUMN_LENGTH['username']);
//uid
$errMsg[] = validateStringLength($pswd, $COLUMN_LENGTH['passwd']);
//pswd
for ($i = 0; $i < count($errMsg); $i++) {
if (!($errMsg[$i] === true)) {
echo "{$errMsg[$i]}";
$isError = true;
}
}
//if contain error, halt continue executing the code
if ($isError) {
return;
}
// check is uid exist
$checkUIDSql = "SELECT passwd, salt FROM te_users WHERE username = ?";
$stmt = mysqli_prepare($conn, $checkUIDSql);
mysqli_stmt_bind_param($stmt, "s", $uid);
mysqli_stmt_execute($stmt);
mysqli_stmt_store_result($stmt);
if (mysqli_stmt_num_rows($stmt) <= 0) {
echo "Sorry we don't seem to have that username.";
return;
}
mysqli_stmt_bind_result($stmt, $getHashpswd, $getSalt);
while (mysqli_stmt_fetch($stmt)) {
$hashPswd = $getHashpswd;
$salt = $getSalt;
}
// if exist, then get salt and db hashed password
// create hash based on password
// hash pswd using sha256 algorithm
// concat salt in db by uid
// hash using sha256 algorithm
$pswd = hash("sha256", $salt . hash("sha256", $pswd));
// check does it match with hased password from db
if (strcmp($pswd, $hashPswd) === 0) {
echo "Success login<br/>";
// add session
$_SESSION['logged-in'] = $uid;
// go to url
$url = $_SERVER['REQUEST_URI'];
header("Location: {$url}");
} else {
echo "Fail login<br/>";
}
}
开发者ID:lowjiayou，项目名称:YearTwoWebOne，代码行数:60，代码来源:login.php
示例6: checkCredentials
function checkCredentials($username, $password)
{
$link = retrieve_mysqli();
//Test to see if their credentials are valid
$queryString = 'SELECT salt, hashed_password FROM user WHERE username = ?';
if ($stmt = mysqli_prepare($link, $queryString)) {
//Get the stored salt and hash as $dbSalt and $dbHash
mysqli_stmt_bind_param($stmt, "s", $username);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $dbSalt, $dbHash);
mysqli_stmt_fetch($stmt);
mysqli_stmt_close($stmt);
// close prepared statement
mysqli_close($link);
/* close connection */
//Generate the local hash to compare against $dbHash
$localhash = generateHash($dbSalt . $password);
//Compare the local hash and the database hash to see if they're equal
if ($localhash == $dbHash) {
return true;
}
// password hashes matched, this is a valid user
}
return false;
// password hashes did not match or username didn't exist
}
开发者ID:HomerGaidarski，项目名称:Gunter-Hans-Transaction-Reports，代码行数:26，代码来源:helper.php
示例7: Get_Safe_Item
public function Get_Safe_Item($table, $field, $var_type, $field_like, $like = FALSE)
{
// Подготавливаем sql-строку и предварительный запрос
$sign = $like ? "LIKE" : "=";
$sql = "SELECT `{$field}` FROM `{$table}` WHERE `{$field}` {$sign} ?";
$statement = mysqli_prepare($this->db_connector, $sql);
// Связываем параметр с меткой и выполняем запрос
switch ($var_type) {
case "string":
$var = "s";
break;
case "integer":
$var = "i";
break;
case "double":
$var = "d";
break;
default:
$var = "b";
break;
}
$field_value = $like ? $field_like . "%" : $field_like;
mysqli_stmt_bind_param($statement, $var, $field_value);
mysqli_stmt_execute($statement);
// Связываем переменную со значением результата запроса и получаем значение результата
mysqli_stmt_bind_result($statement, $safe_value);
if (mysqli_stmt_fetch($statement)) {
return $safe_value;
} else {
return NULL;
}
}
开发者ID:minonadevelop，项目名称:nuc-project，代码行数:32，代码来源:DB_Class.php
示例8: getGameCompInfo
/**
*
* @param type $user_id
* @return GameCompInfo
*/
function getGameCompInfo($user_id)
{
//Add user query
$get_comp_info_q = "SELECT `comp_code`, `score` WHERE `id` = ?";
/* @var $stmt ClassName */
if (!($stmt = $this->mysqli->prepare($get_comp_info_q))) {
$this->throwDBExceptionOnError($this->mysqli->error, $this->mysqli->errno);
}
if (!$stmt->bind_param('i', $user_id)) {
$this->throwDBExceptionOnError($this->mysqli->error, $this->mysqli->errno);
}
if (!$stmt->execute()) {
$this->throwDBExceptionOnError($this->mysqli->error, $this->mysqli->errno);
}
$comp_code = null;
$score = null;
if (!$stmt->bind_result($stmt, $comp_code, $score)) {
$this->throwDBExceptionOnError($this->mysqli->error, $this->mysqli->errno);
}
mysqli_stmt_fetch($stmt);
$stmt->free_result();
$stmt->close();
$this->mysqli->close();
$info = new GameCompInfo($user_id, $comp_code, $score);
return $info;
}
开发者ID:dfimiarz，项目名称:cargame，代码行数:31，代码来源:SQLUserManager.php
示例9: mysqli_fetch_array_large
function mysqli_fetch_array_large($offset, $link, $package_size)
{
/* we are aiming for maximum compression to test MYSQLI_CLIENT_COMPRESS */
$random_char = str_repeat('a', 255);
$sql = "INSERT INTO test(label) VALUES ";
while (strlen($sql) < $package_size - 259) {
$sql .= sprintf("('%s'), ", $random_char);
}
$sql = substr($sql, 0, -2);
$len = strlen($sql);
assert($len < $package_size);
if (!@mysqli_query($link, $sql)) {
if (1153 == mysqli_errno($link) || 2006 == mysqli_errno($link) || stristr(mysqli_error($link), 'max_allowed_packet')) {
/*
myslqnd - [1153] Got a packet bigger than 'max_allowed_packet' bytes
libmysql -[2006] MySQL server has gone away
*/
return false;
}
printf("[%03d + 1] len = %d, [%d] %s\n", $offset, $len, mysqli_errno($link), mysqli_error($link));
return false;
}
/* buffered result set - let's hope we do not run into PHP memory limit... */
if (!($res = mysqli_query($link, "SELECT id, label FROM test"))) {
printf("[%03d + 2] len = %d, [%d] %s\n", $offset, $len, mysqli_errno($link), mysqli_error($link));
return false;
}
while ($row = mysqli_fetch_assoc($res)) {
if ($row['label'] != $random_char) {
printf("[%03d + 3] Wrong results - expecting '%s' got '%s', len = %d, [%d] %s\n", $offset, $random_char, $row['label'], $len, mysqli_errno($link), mysqli_error($link));
return false;
}
}
mysqli_free_result($res);
if (!($stmt = mysqli_prepare($link, "SELECT id, label FROM test"))) {
printf("[%03d + 4] len = %d, [%d] %s\n", $offset, $len, mysqli_errno($link), mysqli_error($link));
return false;
}
/* unbuffered result set */
if (!mysqli_stmt_execute($stmt)) {
printf("[%03d + 5] len = %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysqli_errno($link), mysqli_error($link));
return false;
}
$id = $label = NULL;
if (!mysqli_stmt_bind_result($stmt, $id, $label)) {
printf("[%03d + 6] len = %d, [%d] %s, [%d] %s\n", $offset, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), mysqli_errno($link), mysqli_error($link));
return false;
}
while (mysqli_stmt_fetch($stmt)) {
if ($label != $random_char) {
printf("[%03d + 7] Wrong results - expecting '%s' got '%s', len = %d, [%d] %s\n", $offset, $random_char, $label, $len, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
}
mysqli_stmt_free_result($stmt);
mysqli_stmt_close($stmt);
return true;
}
开发者ID:gleamingthecube，项目名称:php，代码行数:58，代码来源:ext_mysqli_tests_mysqli_fetch_array_large.php
示例10: Get_Safe_Rows
public function Get_Safe_Rows($table, $field, $var_type, $field_like, $like = FALSE, $sql_end = "")
{
// Подготавливаем безопасный запрос в базу данных MyISAM и старых версий MySQL
/*
$field_value = mysqli_real_escape_string($this->db_connector, $field_like);
if ($field_value != $field_like) { return FALSE; }
$sign = ($like) ? "LIKE" : "=";
$field_value = ($like) ? $field_value."%" : $field_value;
$sql = "SELECT `id` FROM `$table` WHERE `$field` $sign '$field_value'";
if ($sql_end != "") {
$sql .= " AND ".$sql_end;
}
$temp_arr = $this->GetMultiItemsBySql($sql, array("id"));
$temp_num = count($temp_arr);
for ($i=0; $i<$temp_num; $i++) {
$arr_of_ids[$i] = $temp_arr[$i]["id"];
}
return $arr_of_ids;
*/
// Подготавливаем sql-строку и предварительный запрос в базу данных InnoDB и современных версий MySQL
$sign = $like ? "LIKE" : "=";
$sql = "SELECT `id` FROM `{$table}` WHERE `{$field}` {$sign} ?";
if ($sql_end != "") {
$sql .= " AND " . $sql_end;
}
$statement = mysqli_prepare($this->db_connector, $sql);
// Связываем параметр с меткой и выполняем запрос
switch ($var_type) {
case $var_type == "string" || $var_type == "str" || $var_type == "s":
$var = "s";
break;
case $var_type == "integer" || $var_type == "int" || $var_type == "i":
$var = "i";
break;
case $var_type == "double" || $var_type == "float" || $var_type == "d" || $var_type == "f":
$var = "d";
break;
default:
$var = "b";
break;
}
$field_value = $like ? "%" . $field_like . "%" : $field_like;
mysqli_stmt_bind_param($statement, $var, $field_value);
mysqli_stmt_execute($statement);
// Связываем переменную со значением результата запроса и получаем значение результата
mysqli_stmt_bind_result($statement, $id);
$arr_of_ids = array();
if (mysqli_stmt_fetch($statement)) {
$arr_of_ids[] = $id;
}
if (!empty($arr_of_ids)) {
return $arr_of_ids;
} else {
return NULL;
}
}
开发者ID:minonadevelop，项目名称:nuc-project，代码行数:58，代码来源:DB_Class.php
示例11: isValid
function isValid($inputEmail)
{
// Reference Global Variables
global $globalHostName;
global $globalUserName;
global $globalPassword;
global $globalDatabase;
if (empty($inputEmail) || !isset($inputEmail) || is_null($inputEmail) || str_replace(" ", "", $inputEmail) == "") {
echo "false";
return false;
}
if (stristr(strtolower($inputEmail), "@sharklasers") || stristr(strtolower($inputEmail), "@guerrillamail") || stristr(strtolower($inputEmail), "@grr") || stristr(strtolower($inputEmail), "@spam4") || stristr(strtolower($inputEmail), "@trbvm.") || stristr(strtolower($inputEmail), "@mailinator") || stristr(strtolower($inputEmail), "@throam")) {
echo "false";
return false;
}
// Gmail Additional Validation
$emailPieces = explode("@", $inputEmail);
// Check if the Address is a Gmail Address
if (stristr(strtolower($emailPieces[1]), "gmail")) {
// If There are Periods or Plus Signs in the First Part of the Email, Notify the User to Remove Them
if (stristr(strtolower($emailPieces[0]), "+")) {
echo "false";
return false;
}
if (stristr(strtolower($emailPieces[0]), ".")) {
echo "false";
return false;
}
}
// MySQL Connection
$connection = mysqli_connect($globalHostName, $globalUserName, $globalPassword, $globalDatabase);
// Connection Error Handling
if ($connection->connect_error) {
// Kill the Connection
die("Could Not Connect to the Database");
}
// MySQL Injection Neutralized Email Variable
$safeEmail = mysqli_real_escape_string($connection, $inputEmail);
// Query Preparation
$query = mysqli_prepare($connection, 'SELECT COUNT(*) as total FROM users WHERE email = ?');
$query->bind_param('s', $safeEmail);
// Query Execution
mysqli_stmt_execute($query);
// Query Result Analysis
mysqli_stmt_bind_result($query, $total);
$data = mysqli_stmt_fetch($query);
//-----
$connection->close();
// If That Email is Already Registered...
if ($total < 1) {
echo "true";
return true;
} else {
echo "false";
return false;
}
}
开发者ID:hkuchampudi，项目名称:AutomatedExchangeSystem，代码行数:57，代码来源:validEmail.php
示例12: selectAllAuthors
/**
* @return array
*/
public function selectAllAuthors()
{
$authors = [];
$stmt = mysqli_prepare($this->connection, 'SELECT author_id, author_name FROM authors');
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $authorID, $author);
while (mysqli_stmt_fetch($stmt)) {
$authors[$authorID] = $author;
}
return $authors;
}
开发者ID:Gecata-，项目名称:PHP，代码行数:14，代码来源:Author.php
示例13: getBook
public function getBook()
{
$books = [];
$stmt = mysqli_prepare($this->connection, 'SELECT book_id,book_title FROM books');
mysqli_stmt_bind_result($stmt, $bookId, $bookName);
mysqli_stmt_execute($stmt);
while (mysqli_stmt_fetch($stmt)) {
$books[$bookId] = $bookName;
}
return $books;
}
开发者ID:Gecata-，项目名称:PHP，代码行数:11，代码来源:BookModel.php
示例14: next
public function next($object = false, $result_type = MYSQL_BOTH)
{
if (\mysqli_stmt_fetch($this->res)) {
foreach ($this->binds as $key => $value) {
$row[substr($key, strpos($key, '.') + 1)] = $value;
}
//fix for ambiguous fieldnames
return $row;
}
return NULL;
}
开发者ID:webcraftmedia，项目名称:system，代码行数:11，代码来源:ResultMysqliPrepare.php
示例15: verify_sql
public function verify_sql($code)
{
$sql = "SELECT " . $this->column1 . "," . $this->column3 . ", " . $this->column4 . " FROM `" . $this->table . "` WHERE " . $this->column4 . "=?";
$stmt = mysqli_prepare($this->con, $sql);
mysqli_stmt_bind_param($stmt, "s", $code);
$this->querystate = mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $nick, $email, $verurl);
mysqli_stmt_fetch($stmt);
$this->dataar = array("nick" => $nick, "email" => $email, "verurl" => $verurl);
$returner = array("sqldata" => $this->dataar, "querychecker" => $this->querystate);
return $returner;
}
开发者ID:KasaiDot，项目名称:simplelogin，代码行数:12，代码来源:sql.php
示例16: getGenres
function getGenres()
{
global $db;
$stmt = mysqli_prepare($db, 'SELECT id, name FROM genres');
mysqli_stmt_execute($stmt);
mysqli_store_result($db);
mysqli_stmt_bind_result($stmt, $id, $genre);
while (mysqli_stmt_fetch($stmt)) {
$genres[$id] = $genre;
}
return $genres;
}
开发者ID:AlexandrosKal，项目名称:mylib，代码行数:12，代码来源:genres_functions.php
示例17: test_format
function test_format($link, $format, $from, $order_by, $expected, $offset)
{
if (!($stmt = mysqli_stmt_init($link))) {
printf("[%03d] Cannot create PS, [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link));
return false;
}
if ($order_by) {
$sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by);
} else {
$sql = sprintf('SELECT %s AS _format FROM %s', $format, $from);
}
if (!mysqli_stmt_prepare($stmt, $sql)) {
printf("[%03d] Cannot prepare PS, [%d] %s\n", $offset + 1, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
if (!mysqli_stmt_execute($stmt)) {
printf("[%03d] Cannot execute PS, [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
if (!mysqli_stmt_store_result($stmt)) {
printf("[%03d] Cannot store result set, [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
if (!is_array($expected)) {
$result = null;
if (!mysqli_stmt_bind_result($stmt, $result)) {
printf("[%03d] Cannot bind result, [%d] %s\n", $offset + 4, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
if (!mysqli_stmt_fetch($stmt)) {
printf("[%03d] Cannot fetch result,, [%d] %s\n", $offset + 5, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
if ($result !== $expected) {
printf("[%03d] Expecting %s/%s got %s/%s with %s - %s.\n", $offset + 6, gettype($expected), $expected, gettype($result), $result, $format, $sql);
}
} else {
$order_by_col = $result = null;
if (!mysqli_stmt_bind_result($stmt, $order_by_col, $result)) {
printf("[%03d] Cannot bind result, [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
return false;
}
reset($expected);
while ((list($k, $v) = each($expected)) && mysqli_stmt_fetch($stmt)) {
if ($result !== $v) {
printf("[%03d] Row %d - expecting %s/%s got %s/%s [%s] with %s - %s.\n", $offset + 8, $k, gettype($v), $v, gettype($result), $result, $order_by_col, $format, $sql);
}
}
}
mysqli_stmt_free_result($stmt);
mysqli_stmt_close($stmt);
return true;
}
开发者ID:gleamingthecube，项目名称:php，代码行数:53，代码来源:ext_mysqli_tests_mysqli_stmt_bind_result_format.php
示例18: GetBooksAndAuthors
/**
* @return array
*/
public function GetBooksAndAuthors()
{
$booksAndAuthors = [];
$stmt = mysqli_prepare($this->connection, 'SELECT * FROM books AS b INNER JOIN books_authors AS ba
ON ba.book_id = b.book_id INNER JOIN authors AS a ON ba.author_id = a.author_id');
mysqli_stmt_bind_result($stmt, $bookId, $bookTitle, $ba_bid, $ba_aid, $authorId, $authorName);
mysqli_stmt_execute($stmt);
while (mysqli_stmt_fetch($stmt)) {
$booksAndAuthors[$bookTitle][] = $authorName;
//$booksAndAuthors[$bookTitle][$authorName]= $authorId;
}
return $booksAndAuthors;
}
开发者ID:Gecata-，项目名称:PHP，代码行数:16，代码来源:BooksAndAuthorsModel.php
示例19: getUserData
function getUserData($uid)
{
global $db;
$stmt = mysqli_prepare($db, "SELECT\n username,\n firstname,\n lastname,\n email,\n profileimg,\n UNIX_TIMESTAMP( registertime )\n FROM users\n WHERE uid = ?\n LIMIT 1\n ");
mysqli_stmt_bind_param($stmt, "s", $uid);
mysqli_stmt_execute($stmt);
mysqli_stmt_store_result($stmt);
mysqli_stmt_bind_result($stmt, $username, $firstname, $lastname, $email, $img, $time);
if (mysqli_stmt_fetch($stmt) == NULL) {
return false;
}
$retData = ['userid' => $uid, 'username' => $username, 'firstname' => $firstname, 'lastname' => $lastname, 'email' => $email, 'img' => $img, 'registerTime' => $time];
return $retData;
}
开发者ID:AlexandrosKal，项目名称:mylib，代码行数:14，代码来源:user_functions.php
示例20: execute
public function execute()
{
$boundParams = $this->getBoundParams();
foreach ($boundParams as $param => $value) {
$this->query = str_replace($param, $value, $this->query);
}
$statement = mysqli_prepare($this->connection, $this->query);
$result = mysqli_stmt_execute($statement);
$return = mysqli_stmt_fetch($statement);
$return = mysqli_stmt_($statement);
var_dump($return);
die;
return $return;
}
开发者ID:emmetog，项目名称:database，代码行数:14，代码来源:MysqliConnection.php
注：本文中的mysqli_stmt_fetch函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论