PHP MySQL Insert Into

[php]代码库

 INSERT INTO table_name (column1, column2, column3,...)
 VALUES (value1, value2, value3,...) 



 <?php
 $con=mysqli_connect("example.com","peter","abc123","my_db");
 // Check connection
 if (mysqli_connect_errno())
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }

 mysqli_query($con,"INSERT INTO Persons (FirstName, LastName, Age)
 VALUES ('Peter', 'Griffin',35)");

 mysqli_query($con,"INSERT INTO Persons (FirstName, LastName, Age) 
 VALUES ('Glenn', 'Quagmire',33)");

 mysqli_close($con);
 ?>