The functions available in MySQL (Part 1)

The functions in MYSQL which we use to connect and manipulate data in the database are:

1. mysql_connect

Used to open a connection to a mysql database

            Example:

                mysql_connect(“localhost”,”root”,””);

                  Host                user      password

2. mysql_query

Used to execute commands on the table.      

Example :

            mysql_query(“Select * from produk”);

                             query

3. mysql_select_db

Used to select the database to be used.         

Example :

            mysql_select_db(“penjualan”)

                     databasename

4. mysql_close

            Used to close the connection with mysql.

            mysql_close($koneksi);

                  connectionvariabel