Ad:

PHP Discussion Thread
Unsolved
Views: 904

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jul 24th, 2010

Cannot connect to MySQL from PHP. No error message is displayed

Expand Post »

Hi,

I am trying to connect to mysql from php Below is the sample code i used.

<?php
<?php
$username = "root";
$password = "pwd";
$hostname = "localhost";

$dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
mysql_close($dbh);

?>

The problem here is I am not getting any error message. The page does not display anything. But when i comment the mysql_coonect() line i can see the prints and echo's. I tried checking if $dbh is valid and also tried putting the code in an exception block. But nothing helps. I have tried many variations of the above code to no effect.

Please help me to identify the problem.

I am able to execute php scripts which shows that my php install is fine.
I am also able to login to mysql db using (locaalhost, root,pwd) in command prompt and using mysql workbench.

Php version = php-5.2.13-win32-
MySql version = mysql-essential-5.1.48-win32

Thanks
Richtofen

Last edited by Richtofen345; Jul 24th, 2010 at 10:45 am.

Similar Threads

PHP Error message in PHP
mysql and php - some clarity please in PHP
cannot connect to mysql server error 10060 on sqlyog in MySQL
unable to connect to MYSQL via PHP in PHP
please help really strange mysql/php error! in PHP

Richtofen345

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2010

Permalink

Jul 24th, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

if you have two <?PHP commands at the start as shown, get rid of one of them and see what you get.

chrishea

Reputation Points: 210

Solved Threads: 228

Nearly a Posting Virtuoso

Offline

1,389 posts
since Sep 2008

Permalink

Jul 24th, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

Its a type. There is only one <?php command actually.

Richtofen345

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2010

Permalink

Jul 24th, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

Maybe the PHP configuration on the server running your script tells PHP not to display any errors (although I don't see any errors in your script.) Try adding the following line to the beginning of your script:
ini_set('display_errors', 1);
http://www.wallpaperama.com/forums/h...bled-t453.html

Last edited by d5e5; Jul 24th, 2010 at 3:56 pm.

d5e5

Reputation Points: 153

Solved Threads: 140

Master Poster

Offline

735 posts
since Sep 2009

Permalink

Jul 24th, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

You can also add:

PHP Syntax (Toggle Plain Text)
error_reporting (E_ALL);
error_reporting (E_ALL);

Which is similar but a little different.

chrishea

Reputation Points: 210

Solved Threads: 228

Nearly a Posting Virtuoso

Offline

1,389 posts
since Sep 2008

Permalink

Aug 2nd, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

After adding the lines mentioned by d5e5 & Chrishea i can see the error message. Thanks both of you.
I am getting this error message
Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\loginValid.php on line 10

Looks like php cannot recognize my sql. My php install is php-5.2.13-win32-installer.msi.

After googling i found that i need to uncomment the following line from php.ini
;extension=php_mysql.dll

But i dont have the above line in my php.ini. It means something is missing even if i put the line i will not be able to get it to work.

I also do not have the extension_dir in my php home ( the line extension_dir is not there in php.ini)

Richtofen345

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2010

Permalink

Aug 3rd, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

Use the code below to connect to the datsbase. It looks like you dont have mysql_select_db("dataBase_Name",$con); in your code.

PHP Syntax (Toggle Plain Text)
<?php
 
$con = mysql_connect("localhost","user_Name","passWord") or die("Check connection");
 
mysql_select_db("dataBase_Name",$con);
?>
<?php

$con = mysql_connect("localhost","user_Name","passWord") or die("Check connection");

mysql_select_db("dataBase_Name",$con);
?>

Last edited by Chi-Town; Aug 3rd, 2010 at 3:16 pm.

Chi-Town

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2010

Permalink

Aug 3rd, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

u r missing the mysql_select_db()

ijazkhattak

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

5 posts
since Nov 2009

Permalink

Aug 3rd, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

create a short test this will tell you errors atleast, unless it is infact your php not installed.

PHP Syntax (Toggle Plain Text)
//connect to server
$link = mysqli_connect('localhost', 'user', 'pass');
if (!$link)
{
 $error = 'Unable to connect to the database server.';
 include 'error.html.php';
 exit();
}
 
//set database encoding
if (!mysqli_set_charset($link, 'utf8'))
{
 $output = 'Unable to set database connection encoding.';
 include 'output.html.php';
 exit();
}
 
//select database
if (!mysqli_select_db($link, 'tools'))
{
 $error = 'Unable to locate the tools database.';
 include 'error.html.php';
 exit();
}
//connect to server
$link = mysqli_connect('localhost', 'user', 'pass');
if (!$link)
{
 $error = 'Unable to connect to the database server.';
 include 'error.html.php';
 exit();
}

//set database encoding
if (!mysqli_set_charset($link, 'utf8'))
{
 $output = 'Unable to set database connection encoding.';
 include 'output.html.php';
 exit();
}

//select database
if (!mysqli_select_db($link, 'tools'))
{
 $error = 'Unable to locate the tools database.';
 include 'error.html.php';
 exit();
}

atrueresistance

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

30 posts
since Aug 2010

Permalink

Aug 3rd, 2010

Re: Cannot connect to MySQL from PHP. No error message is displayed

Your code looks fine.
It appears your php or mysql has not been installed correctly.
try using a differen connect function such as mysql_pconnect
and re-install your php or mysql.
f it is only that file just download that particular file and see if it works better.
perhaps try a different version of that file.

metalix

Reputation Points: 13

Solved Threads: 34

Posting Whiz in Training

Offline

218 posts
since Mar 2010

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Join my sql-urgent

Next Thread in PHP Forum Timeline: How insert image into mysql database and retrieve

DaniWeb Message

Cancel Changes

User Name
Password