How To Use MySQL Easily In PHP

来源：互联网发布：迪曼宠物用品淘宝真假编辑：程序博客网时间：2024/06/05 10:20
How To Use MySQL

// Connect$con = mysql_connect("localhost","root");if(!$con){    echo 'Error When Connect SQL!<br />';    die('Could not connect: ' . mysql_error());}// Create Databaseif(mysql_query("CREATE DATABASE Person_Lists",$con)){    echo "Database created";}else{    echo "Error creating database: " . mysql_error();}// Select Databasemysql_select_db("Person_Lists", $con);// Create table in Person_Lists database$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);mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'AA', '20')");mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'BB', '40')");mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'CC', '30')");$result = mysql_query("SELECT * FROM Persons");while($row = mysql_fetch_array($result)){    echo "Index: ".$row['PersonID']        ." FirstName: ".$row['FirstName']        ." LastName: ".$row['LastName']        ." Age: ".$row['Age'];    echo "<br />";}// Insert// => "INSERT INTO table_name VALUES (value1, value2,....)"// => "INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)"// => "INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'EE', '29')"// Where// => "SELECT column FROM table WHERE column operator value"// => "SELECT * FROM Persons WHERE FirstName='Peter'"// Order By// => "SELECT column_name(s) FROM table_name ORDER BY column_name"// => "SELECT * FROM Persons ORDER BY age"// => "SELECT column_name(s) FROM table_name ORDER BY column_name DESC"// => "SELECT column_name(s) FROM table_name ORDER BY column_name1, column_name2"// Update// => "UPDATE table_name SET column_name = new_value WHERE column_name = some_value"// => "UPDATE Persons SET Age = '36' WHERE FirstName = 'Peter' AND LastName = 'Griffin'"// Delete// => "DELETE FROM table_name WHERE column_name = some_value"// => "DELETE FROM Persons WHERE LastName='BB'"// Closemysql_close($con);echo 'Database Closed!';
Easy To Use! -.-
Donot Be Afraid, Go Ahead, ,,
0 0