http://www.php.net/manual/en/class.mysqli-stmt.php
http://www.php.net/manual/en/mysqli-stmt.bind-param.php
http://www.php.net/manual/en/mysqli-stmt.bind-param.php
PHP mysqli statement bind parameters
mysqli connect, prepare, bind param, execute, 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
$stmt = $mysqli->prepare("INSERT INTO mytable VALUES (?, ?, ?, ?, ?, ?)");
bind
$stmt->bind_param('iissdd',
$row[1], $row[4], $row[6], $row[8], $row[9], $row[10]);
$row[1], $row[4], $row[6], $row[8], $row[9], $row[10]);
execute
REFERRERS
PhpMySqlDatabases
