php+mysql

 php+mysql

    $mysql_server_name="localhost";

    $mysql_username="root";

    $mysql_password="";

    $mysql_database="ptplat4";

    $conn=mysql_connect($mysql_server_name, $mysql_username,$mysql_password);

    mysql_select_db("my_db", $conn);

    $sql = "CREATE TABLE Persons (

    FirstName varchar(15),

    LastName varchar(15),

    Age int   )";//创建数据库

    mysql_query($sql,$conn);

    mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter', 'Griffin', '35')");//插入

    mysql_query("UPDATE Persons SET Age='36' WHERE FirstName='Peter' AND LastName='Griffin'");//更改

    mysql_query("DELETE FROM Persons WHERE FirstName='1'");//删除

    $result=mysql_query("select * from Persons WHERE FirstName='1'");//查找