Basic tutorial on php and mysql (1/9)_PHP tutorial

php and mysql basic tutorial This chapter introduces how to use PHP to operate MySQL database, including connecting to the database, closing the database connection example, executing SQL statements to obtain query result sets, obtaining SQL statement execution error information, obtaining all records in the result set, displaying data in pages, inserting data into the database, and submitting users The HTML page of information, the PHP program that displays data information, the PHP program that adds and deletes links, and the deletion of database data can be said to be a complete basic tutorial for getting started with PHP mysql.

php tutorial and mysql tutorial basic tutorial
This chapter introduces how to use PHP to operate the MySQL database tutorial, including connecting to the database, closing the database connection example, executing the SQL statement to obtain the query result set, obtaining SQL statement execution error information, obtaining all records in the result set, displaying data in pages, inserting data into the database, and submitting The html page of user information, the php program that displays data information, the php program that adds and deletes links, and the deletion of database data can be said to be a complete basic tutorial for getting started with php mysql.

1.php Example of connecting to the database.
2.php Close the database connection.
3.php Execute sql statement.
4.php Get sql statement execution error information.
5.php Get the query result set.
6.php Get all records in the result set.
7.php Use PHP program to display the data in the table.
8.php displays data in pages.
9.html The html page for submitting user information.
10.php Data is inserted into the database.
11.php PHP program that displays data information.
12.php Add a php program to delete links.
13.php Delete database data.

*/
// 1.php Example of connecting to the database.

$host = 'localhost';
$user_name = 'root';
$password = 'admin';

$conn = mysql_connect($host,$user_name,$password);
if(!$conn)
{
Die('Database connection failed:
'.mysql_error());
}
echo 'Database connection successful! ';

// 2.php Close the database connection.

$host = 'localhost';
$user_name = 'root';
$password = 'admin';

$conn = mysql_connect($host,$user_name,$password);
if(!$conn)
{
Die('Database connection failed:'.mysql_error());
}
echo 'Database connection successful! ';

if(mysql_close($conn))
{
echo '
.....
';
echo 'The connection to the database has been closed successfully';
}

1 2 3 4 5 6 7 8 9