The relationship between PHP and MySQL and some simple operations, phpmysql relationship _php Tutorial

The relationship between PHP and MySQL and some simple operations, phpmysql relationships

Post Code First

            <title>Database related</title>    
 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?>

The key element is

1. Link Database

2. Create a table

3. Enrich the contents of the table according to needs

http://www.bkjia.com/PHPjc/960520.html www.bkjia.com true http://www.bkjia.com/PHPjc/960520.html techarticle the relationship between PHP and MySQL, as well as some simple operations, the phpmysql relationship first paste the code HTML Head title database related/title/headbody? php $con = mysql_connect ("localhost", "Root", "Ro ...

