<?php
$conn = mysqli_connect(
'localhost', /* The host to connect to 连接MySQL地址 */
'root', /* The user to connect as 连接MySQL用户名 */
'root', /* The password to use 连接MySQL密码 */
'mydatabase'); /* The default database to query 连接数据库名称*/
if (!$conn) {
printf("Can't connect to MySQL Server. Errorcode: %s ", mysqli_connect_error());
exit;
}
$sql="insert into student values('zbc','男','itcast0005',23);";
$result = mysqli_query($conn,$sql);
echo $result;
?>
mysql> select * from student;
+-----------+--------+------------+------+
| name | gender | number | age |
+-----------+--------+------------+------+
| 张越 | 男 | itcast0005 | 22 |
| 张越123 | 男 | itcast0005 | 23 |
+-----------+--------+------------+------+
2 rows in set (0.00 sec)
mysql> select * from student;
+-----------+--------+------------+------+
| name | gender | number | age |
+-----------+--------+------------+------+
| 张越 | 男 | itcast0005 | 22 |
| 张越123 | 男 | itcast0005 | 23 |
| zbc | 男 | itcast0005 | 23 |
+-----------+--------+------------+------+
3 rows in set (0.00 sec)
mysql>
