Web | This Site

Learning MySQL
MySQL Functions
MySQL Useful Resources
Selected Reading
© 2011 TutorialsPoint.COM

| Home |  | References |  | Discussion Forums |  | About TP

# MySQL PHP Syntax

MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of these languages, PHP is the most popular one because of its web application development capabilities.

This tutorial focuses heavily on using MySQL in a PHP environment. If you are interested in MySQL with PERL then you can look into PERL and MySQL Tutorial.

PHP provides various functions to access MySQL database and to manipulate data records inside MySQL database. You would require to call PHP functions in the same way you call any other PHP function.

The PHP functions for use with MySQL have the following general format:

    mysql_function(value,value,...);

The second part of the function name is specific to the function, usually a word that describes what the function does. The following are two of the functions which we will use in our tutorial

    mysqli_connect($connect);
    mysqli_query($connect,"SQL statement");

Following example shows a generic sysntax of PHP to call any MySQL function.

    <html>
    <head>
    <title>PHP with MySQL</title>
    </head>
    <body>
    <?php
       $retval = mysql_function(value, [value,...]);
       if( !$retval )
       {
           die ( "Error: a related error message" );
       }
       // Otherwise MySQL  or PHP Statements
    ?>
    </body>
    </html>

Starting from next chapter we will see all the important MySQL functionality along with PHP.

Advertisement

Online Image Processing

Indian Baby Names