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","...