http://uk.php.net/manual/en/class.mysqli-stmt.php
http://uk.php.net/manual/en/mysqli-stmt.bind-result.php
http://uk.php.net/manual/en/mysqli-stmt.bind-result.php
PHP mysqli statement bind result
mysqli connect, prepare, execute, bind result, fetch, close
connect
include 'connect.php';
$mysqli = new mysqli("localhost", $user, $passwd, $db);
$errno = mysqli_connect_errno();
if ($errno) {
printf("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli = new mysqli("localhost", $user, $passwd, $db);
$errno = mysqli_connect_errno();
if ($errno) {
printf("Connect failed: %s\n", mysqli_connect_error());
}
prepare
if (!$errno) {
$query = "select id,tag,`time`,left(body,10) from wikka_pages limit 10";
$stmt = $mysqli->prepare($query);
$errno = $mysqli->errno;
}
if ($errno) {
printf("SQL failed: %s\n", $mysqli->error);
}
$query = "select id,tag,`time`,left(body,10) from wikka_pages limit 10";
$stmt = $mysqli->prepare($query);
$errno = $mysqli->errno;
}
if ($errno) {
printf("SQL failed: %s\n", $mysqli->error);
}
execute
if (!$errno) {
$stmt->execute();
$stmt->execute();
bind result
/* bind result variables */
$stmt->bind_result($id,$tag,$date,$body);
$stmt->bind_result($id,$tag,$date,$body);
fetch
close
@$stmt->close();
@$mysqli->close();
@$mysqli->close();
REFERRERS
PhpMySqlDatabases
