PHP coding got an error

Question

 <?php
$conn=mysql_connect(`localhost'," root","") or die("Could not connect");
mysql_select_db("bng_nov",$conn) or die("could not connect database");
?>

Parse error: syntax error, unexpected end of file, expecting '`' in C:\xampp\htdocs\display\db.php on line 4

Just replace the qoutes on localhost, like $conn=mysql_connect("localhost", " root", "") or die("Could not connect"); — Ankur Tiwari, Dec 27 '17 at 07:45
You should also try looking into myssqli_ or PDO as mysql_ has been deprecated for some time and removed from the latest versions of PHP. — Nigel Ren, Dec 27 '17 at 07:58

Bilal Ahmed · Accepted Answer · 2017-12-27T08:01:12.103

1

Error in this line replace (`) with (') single quote. also remove space before root

$conn=mysql_connect('localhost',"root","") or die("Could not connect");

and best solution is use double quotes like this

$conn=mysql_connect("localhost","root","") or die("Could not connect");

also i mention that don't use mysql_*. you should used mysqli_*

i have add some DB connectivity codes. used this code

<?php
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";
?>

edited Dec 27 '17 at 08:01

answered Dec 27 '17 at 07:45

Bilal Ahmed

4,005
3
22
42

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\display\db.php:2 Stack trace: #0 C:\xampp\htdocs\display\index.php(3): include() #1 {main} thrown in C:\xampp\htdocs\display\db.php on line 2 – Scotty Yong Dec 27 '17 at 07:50
have that error huhu – Scotty Yong Dec 27 '17 at 07:51
what is your PHP version? – Bilal Ahmed Dec 27 '17 at 07:52
i used notepad+ to do php coding – Scotty Yong Dec 27 '17 at 07:53
buddy my question is what's your PHP version? notepad++ is your text editor – Bilal Ahmed Dec 27 '17 at 07:55
read this article to check php version https://www.wikihow.com/Check-PHP-Version – Bilal Ahmed Dec 27 '17 at 07:56
@ScottyYong i have add some code in my answer used this code to connect your data base – Bilal Ahmed Dec 27 '17 at 08:01
ok i try it later .. will give you feedback while i tried it .. thank – Scotty Yong Dec 27 '17 at 08:22
can already bro .. – Scotty Yong Dec 28 '17 at 02:34

Moby M · Answer 2 · 2017-12-27T08:57:18.427

0

error in the below line

$conn=mysql_connect(`localhost'," root","")

please try like below

<?php
if (!$link = mysql_connect('localhost', 'root', '')) {
    echo 'Could not connect to mysql';
    exit;
}

if (!mysql_select_db('bng_nov', $link)) {
    echo 'Could not select database';
    exit;

}
?>

edited Dec 27 '17 at 08:57

answered Dec 27 '17 at 07:53

Moby M

910
2
7
26

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\display\db.php:2 Stack trace: #0 C:\xampp\htdocs\display\index.php(3): include() #1 {main} thrown in C:\xampp\htdocs\display\db.php on line 2 – Scotty Yong Dec 27 '17 at 07:56
@ScottyYong updated code plz try – Moby M Dec 27 '17 at 08:07
ok will try now .. will give you feedback later – Scotty Yong Dec 27 '17 at 08:23

PHP coding got an error

2 Answers2