转自:
PHP操作MySQL
PHP
操作MySQL
PHP
操作MySQL
的三种方式:
-
MySQL
:非永久连接,性能比较低,PHP5.5
以后废弃;
-
MySQLi
:永久连接,减轻服务器压力,只支持MySQL
;
-
PDO
:能实现MySQLi
的常用功能,支持大部分数据库;
PHP
扩展查看函数:
phpinfo();
php
配置文件:
php.ini
MySQL
方式连接数据库
header('content-type:text/html;charset=utf-8');
$server = '127.0.0.1';
$username = 'root';
$password = '123';
$port = '3309';
$link = mysql_connect("{$server}:{$port}", $username, $password);
$db_name = 'test005';
mysql_select_db($db_name);
$charset = 'utf8';
mysql_set_charset($charset);
$query = '';
mysql_query($query);
$query_insert = 'INSERT INTO users(id, name, salary) VALUES(1, \'张三\', 3000)';
$query_update = 'UPDATE user SET name =\'李四\' WHERE id = 1';
$query_delete = 'DELETE FROM users WHERE id = 1';
$query_drop = 'DROP TABLE IF EXISTS user';
mysql_query($query_insert);
$query_select = 'SELECT * FROM users';
$result = mysql_query($query_select);
$line_row = mysql_fetch_row($result);
$line_assoc = mysql_fetch_assoc($result);
$line_array = mysql_fetch_array($result);
while ($line = mysql_fetch_assoc($result)){
$data[] = $line;
}
var_dump($data);
mysql_close($link);
MySQLi
面向过程方式操作数据库
$host = '127.0.0.1';
$user = 'root';
$password = '123';
$database = 'test005';
$port = '3309';
$connect = mysqli_connect($host, $user, $password, $database, $port);
$query = 'SELECT * FROM user';
$result = mysqli_query($connect, $query);
mysqli_fetch_row($result);
mysqli_fetch_assoc($result);
mysqli_fetch_array($result);
var_dump(mysqli_fetch_assoc($result));
var_dump(mysqli_fetch_all($result));
mysqli_close($connect);