Error while connecting mysql database

Question

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\oes3\exam\includes\config.php:13

"     <?php

    //START THE SESSION 
    session_start();

    //GLOBAL VARIABLES 
    define('DB_HOST','localhost');
    define('DB_USER','root');
    define('DB_PASS','');
    define('DB_NAME','exam');

    //FUNCTION TO CONNECT  DATABASE
    if(!mysql_connect(DB_HOST,DB_USER,DB_PASS))
        die('Could not connect : '.mysql_error());

    //FUNCTION TO SELECT THE DATABASE
    if(!mysql_select_db(DB_NAME))
        die('Could not select database : '.mysql_error());
?>"

`mysql_*` is deprecated and removed library now-a-days. Move toward `php 7` along with `mysqli_*` or `PDO` library for db management — Anant Kumar Singh, Feb 21 '18 at 05:33

score 0 · Answer 1 · edited Aug 17 '18 at 06:03

0

Try to use

$con = mysqli_connect("localhost","root","","test");

edited Aug 17 '18 at 06:03

Rob

26,483
15
80
92

answered Feb 21 '18 at 05:34

shishir sharma

40
5

score 0 · Answer 2 · answered Feb 21 '18 at 05:40

0

Try mysqli_connect instead of mysql_connect. And also update other methods with mysqli. Try the code below

$con=mysqli_connect(DB_HOST,DB_USER,DB_PASS);
if(!$con)
        die('Could not connect : '.mysqli_connect_error());  

//FUNCTION TO SELECT THE DATABASE
    if(!mysqli_select_db($con,DB_NAME))
        die('Could not select database');

answered Feb 21 '18 at 05:40

ARUNBALAN NV

1,615
4
15
38

Yes, it works for me. Thanks – kumar217 Feb 21 '18 at 05:48
If the answer was useful, please upvote – ARUNBALAN NV Feb 21 '18 at 06:36

score -1 · Answer 3 · answered Feb 21 '18 at 05:36

Install mysql package in xammp servre.Otherwise you can use mysqli for database connection. Below code for connection in mysqli oops and procedure both.

$conn = new mysqli (HOSTNAME,USERNAME,PASSWORD,DATABASE);

OR 

$conn = mysqli_connect(HOSTNAME,USERNAME,PASSWORD);

Error while connecting mysql database

3 Answers3