Need to connect my mysql database using wamp

Question

Need some help please. My my site isn't connecting with the database.

Here my code:

<?php
$serverName="localhost";
$dbusername="root";
$dbpassword="";
$dbname="bank_db";
mysql_connect($serverName,$dbusername,$dbpassword)/* or die('the website 
is down for maintainance')*/;
mysql_select_db($dbname) or die(mysql_error());
?>

Would really appreciate the help.

Thanks!

Possible duplicate of [Undefined function mysql\_connect()](https://stackoverflow.com/questions/13825108/undefined-function-mysql-connect) — Rotimi, Dec 01 '17 at 04:18
Try to use latest php version 7 and use `mysqli_*` or `PDO` library for db management. — Anant Kumar Singh, Dec 01 '17 at 04:22
@Eddie the error message is:Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp64\www\banking\_inc\dbconn.php on line 6 — John-Paul Adekunle, Dec 01 '17 at 12:39
@panther the error message is:Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp64\www\banking_inc\dbconn.php on line 6 – — John-Paul Adekunle, Dec 01 '17 at 12:40

score 2 · Answer 1 · answered Dec 01 '17 at 04:44

2

I have also came across the same situation and the following code block worked fine for me:

<?php
// URL Connection
$host='localhost';
$uname='root';
$pwd='';
$db='databasename';
//I created a connection object here to establish the connection with my database 
$con = mysql_connect($host,$uname,$pwd) or die("connection failed/");
mysql_select_db($db,$con) or die("db selection failed");
?>

Hope it works, Thanks.

answered Dec 01 '17 at 04:44

shubham dahibhate

69
1
8

1

Never suggest `mysql_` it was deprecated. Use `mysqli_`. – Raghav Dec 01 '17 at 05:07
I just answered according to the above stated query, but will keep that in mind, thanks... – shubham dahibhate Dec 01 '17 at 06:25
@Raghav tried using the mysqli_ as that was what was suggested in the error message, but i still have no luck. – John-Paul Adekunle Dec 01 '17 at 12:42

score 0 · Answer 2 · answered Dec 01 '17 at 04:56

0

The latest verson of php will through the depricated error for mysql_connect function. so you can use better mysqli function. This below link will give you more details about mysqli function.
https://www.w3schools.com/php/func_mysqli_select_db.asp

answered Dec 01 '17 at 04:56

manikandan k

82
2

score 0 · Answer 3 · answered Dec 01 '17 at 05:38

Use mysqli_ because mysql_ is deprecated.

You can ref this link for in detail for connection the database https://www.w3schools.com/php/php_mysql_connect.asp

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

Need to connect my mysql database using wamp

3 Answers3