Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > How to add data to the database using mysqli in php, phpmysqli_PHP tutorial

How to add data to the database using mysqli in php, phpmysqli_PHP tutorial

WBOY

Release： 2016-07-13 10:02:02

Original

1418 people have browsed it

php uses mysqli to add data to the database, phpmysqli

This article describes the example of php using mysqli to add data to the database. Share it with everyone for your reference. The specific implementation method is as follows:

$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();

Copy after login

I hope this article will be helpful to everyone’s PHP programming design.

Related labels：

mysqli php database method

source：php.cn

Previous article：Share the ten most excellent PHP security development libraries with detailed introduction in Chinese, _PHP Tutorial Next article：Implement a function instance that can return multiple values in php, php example_PHP tutorial

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Latest Articles by Author