MySQL PHP Syntax

MySQL PHP Syntax

MySQL can be used in many languages, including PERL, C, C + +, JAVA, and PHP. In these languages, MySQL is the most widely used in web development of PHP.

  PHP is introduced in mysqli.

php provides a variety of ways to access and manipulate MySQL database records. Php  mysqli function is formatted as follows:

mysqli_function (Value,value,...); 

mysqli_connect ($connect); Mysqli_query ($connect, "sql  statement"); Mysqli_fetch_array () mysqli_close () 

The following example shows the syntax for PHP to invoke the MySQL function:

Example (MYSQLI)

<?php$retval = mysqli_function(value, [value,...]);if( !$retval ){   die ( "related error Messages" );}//other MySQL or PHP statements?>

MySQL PHP Syntax