---

Connecting to the MySQL DB server with PHP

---

• Connecting to a MySQL Database Server
  • The mysqli_connect() function is used to make a network connection to the MySQL database server.

    ---

  • Syntax:

    $var = mysqli_connect (host, user, passwd [, dname [, port [, socket] ] ] ) Use: (in the CS377 course) host = "holland.mathcs.emory.edu" user = "cs377" passwd = "abc123" return value: $var = an mysqli "object" which represents the connection to a MySQL Server.

    ---

  • Example:

    $conn = mysqli_connect("holland.mathcs.emory.edu", "cs377", "abc123", "companyDB"); /* ------------------------------------ check for connection error ------------------------------------ */ if ( mysqli_connect_errno( ) != 0 ) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }

  Comment:

  Unlike in JDBC, in PHP, you do not need to reserve memory space We will (only) use a function that fetch tuples one at a time from the SQL server as needed PHP has other functions that fetches all tuples at once -- this function will allocate buffers