Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

MySQL Connect


Since PHP 5.5, mysql_connect() extension is deprecated. Now it is recommended to use one of the 2 alternatives.

  • mysqli_connect()
  • PDO::__construct()

PHP mysqli_connect()

PHP mysqli_connect() function is used to connect with MySQL database. It returns resource if connection is established or null.

Syntax

  1. resource mysqli_connect (server, username, password)

PHP mysqli_close()

PHP mysqli_close() function is used to disconnect with MySQL database. It returns true if connection is closed or false.

Syntax

  1. bool mysqli_close(resource $resource_link)

PHP MySQL Connect Example

Example

  1. <?php
  2. $host = ‘localhost:3306’;
  3. $user = ;
  4. $pass = ;
  5. $conn = mysqli_connect($host$user$pass);
  6. if(! $conn )
  7. {
  8.   die(‘Could not connect: ‘ . mysqli_error());
  9. }
  10. echo ‘Connected successfully’;
  11. mysqli_close($conn);
  12. ?>

Output:

Connected successfully

Comments

comments