Php/mysql connect
mysqli移植メモ
// NG
$conn = mysql_connect($host, $user, $pass);
mysql_select_db("test_db", $conn);
// OK(接続時に指定)
$conn = mysqli_connect($host, $user, $pass, "test_db");
その他
| mysql | mysqli |
|---|---|
| mysql_query($sql) | mysqli_query($this->_conn, $sql) |
| mysql_fetch_array | mysqli_fetch_array |
| mysql_real_escape_string | mysqli_real_escape_string |
| mysql_errno() | mysqli_errno($conn) |
| mysql_error() | mysqli_error($conn) |
| mysql_close() | mysqli_close($conn) |
| mysql_num_rows() | mysqli_num_rows($result) |
| mysql_affected_rows() | mysqli_affected_rows($conn) |
| mysql_select_db() | 不要(接続時に指定) |