Connection to MySQL server in PHP & Database Selection

mysql_connect( ) function is used for MySQL connection and mysql_select_db( ) is used to select database.


Syntax 

mysql_connect(host name,user name,password)

mysql_select_db(database name)



<?php
 $con = mysql_connect("localhost","root","admin");
 if(!$con){
    die(mysql_error());
 }
 else{
      mysql_select_db("test");
 }
?> 

NOTE : mysql_connect is now deprecated . So mysqli_connect should be used.



Connection through mysqli_connect



Syntax 

 mysqli_connect(host name,user name,password,database)


<?php
 
  $con = mysqli_connect('localhost','root','admin','test');
  if(!$con){
    die(mysqli_error());
 }


?>