Write an example to establish MySQL database connection using PHP script?

We can use following PHP script to make a MySQL database connection having user ‘guest’ and password ‘guest123’.

<html>
   <head>
      <title>Connecting MySQL Server</title>
   </head>
   <body>
      <?php
         $dbhost = 'localhost:3306';
         $dbuser = 'guest';
         $dbpass = 'guest123';
         $conn = mysql_connect($dbhost, $dbuser, $dbpass);
         
         if(! $conn ) {
            die('Could not connect: ' . mysql_error());
         }
         echo 'Connected successfully';
         mysql_close($conn);
      ?>
   </body>
</html>

Krantik Chavan

Published on 22-Feb-2018 10:06:13

Related Questions & Answers
Which PHP function is used to establish MySQL database connection using PHP script?
How to establish a connection with the database using the properties file in JDBC?
How to establish connection with JDBC?
How to write PHP script to update an existing MySQL table?
How can we write PHP script to get the list of MySQL database?
How to write PHP script to delete data from an existing MySQL table?
How can we delete a MySQL database by using PHP script?
How can we select a MySQL database by using PHP script?
Which PHP function is used to disconnect from MySQL database connection?
How can we establish MySQL database by using MySQL binary at command prompt?
How to write PHP script by using MySQL JOINS inside it to join two MySQL tables?
How can we create a new database by using PHP script?
How can we delete an existing MySQL table by using PHP script?
Write an example program on structure using C language
How to write PHP script by using LIKE clause inside it to match the data from MySQL table?

Previous Page Print Page