The relationship between PHP and MySQL and some simple operations

Post Code First

PHP$con=mysql_connect("localhost", "root", "root");//Link Database        if(!$con){             die(' Connection Failed! ‘ .Mysql_error());//Judging whether it is successful        }             /*if (mysql_query ("Create DATABASE TestDB", $con)) {//via mysql_query query or send command echo "create TestDB success";         } else{echo "Failure Reason:". mysql_error (); Determine if the creation was successful}*/                mysql_select_db("TestDB",$con);//Select the database that the link just created                        $sql= "CREATE TABLE Persons (personID int not NULL auto_increment, PRIMARY KEY (p Ersonid), FirstName varchar (), LastName varchar (+), age int) 
    ";//Mysql Statement Creation table        mysql_query($sql,$con);//Execute SQL statement                            Mysql_close($con);//Close MySQL Connection?> </body>

The key element is

1. Link Database

2. Create a table

3. Enrich the contents of the table according to needs

The relationship between PHP and MySQL and some simple operations