使用PDO插入记录

 

<?php 
header("Content-type: text/html; charset=utf-8");
//设置中国时区
date_default_timezone_set('PRC');

$dsn="mysql:host=127.0.0.1;port=3306;dbname=test;charset=utf8";
$username="root";
$password="root";

$pdo=new PDO($dsn,$username,$password);

$sql="INSERT INTO student VALUES(NULL,'李鬼','1',36,default,3000,300,'山东')";
$lines=$pdo->exec($sql);

// var_dump($pdo);

echo "行数：{$lines}";