empty page

[mangtas_ka]

Hello everybody,

 

I am new to php, I have a question for you guys.

why I've got an empty page.

 

<?php

//MySQL database connection

//connect_db.php

$host="localhost"; // Host name 

$username="root"; // Mysql username 

$password="logans1966"; // Mysql password 

$db_name="Inventory"; // Database name

$conn = mysql_connect("$host","$username","$password")  or die(mysql_error());

mysql_select_db("$db_name")or die("cannot select DB");

if ($conn) {

   echo ("Connection is succeed");

} else {

   echo ("Connection is fail");

}

?>

thanks in advance

cris

 

[mangtas_ka]

I've also try $conn = mysql_connect($host,$username,$password)  or die(mysql_error("Unable to Connect"));

same result

[mac_gyver]

what do you get when you do a 'view source' of the empty page in your browser?

[cyberRobot]

Do you know if PHP is set to display all errors and warnings? Note that you can add the following to the top of your script to show them:

<?php
//REPORT ALL PHP ERRORS
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>

 

 

Side note:

Perhaps you are already aware of this, but the mysql_* functions have been deprecated. At some point in the near future, you'll need to switch to PDO or MySQLi. More information can be found here:

http://php.net/manual/en/mysqlinfo.api.choosing.php

[mogosselin]

What you want to do when you develop (meaning on your computer or a test server or whatever) is to display ALL of the messages PHP can send to you so that you can fix them as soon as possible.

 

When your code is 'live' (accessible from the Internet), you want to display a nice custom error page. You certainly don't want to show to your users error messages coming from PHP. It's not secure, it's ugly and it won't help your users anyway. But, you want to be able to see the errors, that's why you should at least log them.

 

To try what's happening on your server (either it's on your production or development server), you can create a single PHP file with only this content:

<?php
foo();

The function 'foo()' shouldn't exist, so when you call that page, you should see an error message. If you see a white page, it's because your PHP error settings tells PHP not to output any error.

 

If you actually want to see the errors, you could change your settings in php.ini to:

display_errors=On
error_reporting=E_ALL
log_errors=1

Or, if you want to (but it's not the cleanest way), you can add this to your code:

 

 

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

 

If you want to know more, I wrote an article about Error settings with PHP. If you read it, I'd love to have your comments!

[gristoi]

ALSO MYSQL_* IS DEPRECATED, USE PDO