---

Intro: Accessing MySQL with PHP

---

• Accessing the MySQL Database server with PHP
  • Available PHP APIs for accesing MySQL:

    ext/mysql     (MySQL extension --- not recommended) ext/mysqli    (MySQL improved extension) PDO_MySQL    (PHP Data Objects interface -- pure object oriented programming)

    ---

  • I will be teaching on mysqli....

    The MySQL Improved Extension online manual: click here

  ---

  ---

  ---

  ---

• Overview Accessing DB through PHP
  • Steps that you need to do to access the database with PHP (very similar to JDBC (and C)):

    Connect to the database Unlike JDBC, PHP does not need to allocate variables for communication with the SQL server The variables will be created inside the connection object when necessary.... Execute a query (Which will return a result set) Use a loop statement to obtain the tuples from the result set one at a time Free resources (used in a query ) Disconnect from the mySQL server when you done will query processing