MySQL PHP Syntax

MySQL kann in vielen Sprachen angewendet werden, einschließlich PERL, C, C++JAVA und PHP, in diesen Sprachen ist MySQL in der PHP-Webentwicklung am weitesten verbreitet.

In this tutorial, most of our examples use PHP language. If you want to learn about the application of MySQL in PHP, you can visit our Introduction to Mysqli in PHP.

PHP provides various ways to access and operate MySQL database records. The format of the PHP mysqli function is as follows:

mysqli_function(value, value,...);

In the above format, the function part describes the function of the MySQL function, such as

mysqli_connect($connect);
mysqli_query($connect, "SQL Statement");
mysqli_fetch_array();
mysqli_close();

The following examples demonstrate the syntax of calling MySQL functions from PHP:

<?php
$retval = mysqli_function(value, [value,...]);
if(!$retval)
{
　　　die("Error message related");
}
//　Other MySQL or PHP Statements
?>

From the next chapter, we will learn more about MySQL function features.