Some simple operations of php and Mysql, phpmysql_PHP tutorial

Some simple operations of php and Mysql, phpmysql

Post the code first

Copy code The code is as follows:

& 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

2. Create table

3. Enrich the content of the table according to needs

The above is the entire content of this article, I hope you guys will like it.

http://www.bkjia.com/PHPjc/960702.html

www.bkjia.com

truehttp: //www.bkjia.com/PHPjc/960702.htmlTechArticleSome simple operations of php and Mysql, phpmysql first paste the code and copy the code as follows: html head title database related/ title /head body php $con = mysql_connect("localhost","root","...