The example in this article describes how PHP uses mysqli to add data to the database. Share it with everyone for your reference. The specific implementation method is as follows:
?
|
1
2
3
4
5
6
7
8
9
|
$mydb = new mysqli('localhost', 'username', 'password', 'databasename');
$sql = "INSERT INTO users (fname, lname, comments)
VALUES ('$_POST[fname]', '$_POST[lname]', '$_POST[comments]')";
if ($mydb->query($sql) == TRUE) {
echo "user entry saved successfully.";
} else {
echo "INSERT attempt failed" ;
}
$mydb->close();
|
1
2
3
4
5
6
7
8
9
|
$mydb = new mysqli('localhost', 'username', 'password', 'databasename');
$sql = "INSERT INTO users (fname, lname, comments)
VALUES ('$_POST[fname]', '$_POST[lname]', '$_POST[comments]')";
if ($mydb->query($sql) == TRUE) {echo "user entry saved successfully.";
} else {
echo "INSERT attempt failed" ;
}
$mydb->close();
|
I hope this article will be helpful to everyone’s PHP programming design.
http://www.bkjia.com/PHPjc/971952.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/971952.htmlTechArticleHow PHP uses mysqli to add data to the database. This article mainly introduces how PHP uses mysqli to add data to the database. , an example analysis of PHP's use of mysqli for database operations...
