PHP5 mysqli增改删表

<?php

//连接数据库，MySQL server安装在本地，my_db是已创建的database

$mysqli = mysqli_init();
$mysqli->real_connect("127.0.0.1","root","","my_db");


if(mysqli_connect_errno())
{
    echo mysqli_connect_error();
}




// Create table in my_db database


$sql = "CREATE TABLE Persons 
(
FirstName string(15),
LastName string(15),
Age int
)";


$mysqli->query($sql);


/ /新增记录
$sql = "insert into persons(FirstName, LastName,Age) values('lily', 'li',38)";
$rst=$mysqli->query($sql);

//修改记录
$sql = "update persons set Age=28 where FirstName='lily'";

 

//删除记录

$sql = "delete from persons where Age=38";
$rst=$mysqli->query($sql);




if($rst === false)
{
    echo($mysqli->errno);
    echo($mysqli->error);
}


$sql = "select * from persons";
$rst=$mysqli->query($sql);
if($rst === false)
{
    echo($mysqli->errno);
    echo($mysqli->error);
}


$mysqli->close();
?>