mysql_connect not working with php?

Question

My code only shows a blank page with no text. Why could the mysql_connect not connect to the database?

I am using MySQL version is 5.0.77 and PHP version is 5.1.6

$user = "user";
$password = "user";
#$database = "database";

$con = mysql_connect("localhost",$user,$password);

if (!con) {
    echo "could not connect";
} else {
    echo "connected";
}

if (mysql_query("CREATE DATABASE my_db",$con)) {
     echo "databse created";
}

#@mysql_select_db($database) or die( "Unable to select database");
#$query="CREATE TABLE tablename(id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,field1-name varchar(20) NOT NULL,field2-name varchar(20) NOT NULL,field3-name varchar(20) NOT NULL,field4-name varchar(30) NOT NULL,field5-name varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
#mysql_query($query);
mysql_close($con);

Solution 1

Well i wold like to point out one by one

1. you are using !con which is invalid and generate error

Notice: Use of undefined constant con - assumed 'con' in blabla on line bla connected

to use like this you need to declare constant which i think you don't want so use

if(!$con){

---

2. The entire ext/mysql PHP extension, which provides all functions named with the prefix mysql_, is officially deprecated as of PHP v5.5.0 and will be removed in the future. So use either PDO or MySQLi

Good read

1. The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
2. PDO Tutorial for MySQL Developers
3. Pdo Tutorial For Beginners

---

3. as i saw in comment you have not turned on error reporting you can do this by in php.ini file

ini_set('display_errors', 1);
error_reporting(E_ALL);

---

4. do not use # for comment however its same as // comment and cause no problem till 5.5.0alpha3 live result . however its(#) deprecated Comments starting with '#' are now deprecated in .INI files. so its better to use

1. For single line comment // this is single line comment
2. For multiline comment /* this is multiline comment */

Solution 2

First try Following code only

<?php
$user="user";
$password="user";
$con=mysqli_connect("localhost",$user,$password);
if(!$con)
{
echo "could not connect" ;
}
else
{
echo "connected";
}
?>

Then see the result and update here

Solution 3

This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. Check here for detailed information

Comments

[gks]

Add $con in condition @user1601000

[Rikesh]

Replace if(!con) by if(!$con) & check again

[NullPoiиteя]

@Usman however its completely irrelevant to gave code of mysqli .. OP may not familiar with mysqli

[عثمان غني]

there is not a big challenge in using mysqli in place of mysql @NullPointer i think...

[user1601000]

the result is still the same... blank page... :(

[عثمان غني]

how u save this file @user1601000

[Hamed Al-Khabaz]

try to echo something before anything, because there might a problem with your php or sql configuration.

[عثمان غني]

@user1601000 just use <?php echo "Hello";?>

[user1601000]

@Wololo yeah.. its echoing what i have echoed before connecting

[عثمان غني]

which operating system and server you are using??

[Hamed Al-Khabaz]

that means your mysql database is not responding. Its still lagging somewhere, because your if statement must of landed to true or false and ultimately echo something.

[user1601000]

its doing nothing on $con=mysqli_connect("localhost",$user,$password);

[user1601000]

the code hangs on that statement $con=mysqli_connect("localhost",$user,$password);

[عثمان غني]

have you restarted your mysql and apache server? try restarting