Some simple operations of php and Mysql, phpmysql_PHP tutorial

& Lt; table & gt; database -related & lt;/table & gt;


$con = mysql_connect("localhost","root","root"); //Link database
           if(!$con){
DIE ('Connection failed!'. MySQL_ERROR ()); // Determine whether it is successful
                                                                     /*        if(mysql_query("CREATE DATABASE testdb",$con)){ //Query or send commands through mysql_query
echo "testdb created successfully"; }
        else{
                                                                                                                using echo "reason for failure: " . mysql_error(); }
*/ 
mysql_select_db("testdb",$con); //Select the database you just created
               $sql = "CREATE TABLE Persons                                                                         (personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
                         FirstName varchar(15),
                     LastName varchar(15),
Age int)
"; "; "; "; mysql_query($sql,$con); //Execute sql statement
                             
mysql_close($con); //Close the mysql connection
?>





The key content is

1. Link database