php mysql知识总结,PHP MySQL 知识点（继续更新）

1、http://php.net/manual/en/mysqli.quickstart.statements.php

Example #1 Connecting to MySQL

$mysqli = new mysqli("example.com", "user", "password", "database");

if ($mysqli->connect_errno) {

echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;

}

if (!$mysqli->query("DROP TABLE IF EXISTS test") ||

!$mysqli->query("CREATE TABLE test(id INT)") ||

!$mysqli->query("INSERT INTO test(id) VALUES (1)")) {

echo "Table creation failed: (" . $mysqli->errno . ") " . $mysqli->error;

}

?>

Example #2 Navigation through buffered results

$mysqli = new mysqli("example.com", "user", "password", "database");

if ($mysqli->connect_errno) {

echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;

}

if (!$mysqli->query("DROP TABLE IF EXISTS test") ||

!$mysqli->query("CREATE TABLE test(id INT)") ||

!$mysqli->query("INSERT INTO test(id) VALUES (1), (2), (3)")) {

echo "Table creation failed: (" . $mysqli->errno . ") " . $mysqli->error;

}

$res = $mysqli->query("SELECT id FROM test ORDER BY id ASC");

echo "Reverse order...\n";

for ($row_no = $res->num_rows - 1; $row_no >= 0; $row_no--) {

$res->data_seek($row_no);

$row = $res->fetch_assoc();

echo " id = " . $row['id'] . "\n";

}

echo "Result set order...\n";

$res->data_seek(0);

while ($row = $res->fetch_assoc()) {

echo " id = " . $row['id'] . "\n";

}

?>

3、Example #3 Navigation through unbuffered results

$mysqli->real_query("SELECT id FROM test ORDER BY id ASC");

$res = $mysqli->use_result();

echo "Result set order...\n";

while ($row = $res->fetch_assoc()) {

echo " id = " . $row['id'] . "\n";

}

?>