asked on
PHP Redirect on Database Connection Error
I'm new to PHP - after doing a lot of ASP and I'm stumbling on a few issues.
The first issue I have is redirecting to a new page during error handling.
I have the following code:
<?php
session_start();
$error_text = $_SESSION['dberror'];
include 'inc/dbconnect.php';
include 'inc/session_handle.php';
?>
dbconnect.php establishes the connection to the database.
If there's an error, I'd like to redirect to a friendly error page, since the code can't continue.
my dbconnect.php page looks like this:
<?php
$conn = mysql_connect("localjost",
if (!$conn)
{
$_SESSION['dberror'] = mysql_error();
/* Redirect browser */
header("Location: dberror.php");
exit;
}
$dbname = 'myown_db';
mysql_select_db($dbname);
?>
This is the result I get:
Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'localjost' (1) in /Applications/XAMPP/xamppf
Warning: Cannot modify header information - headers already sent by (output started at /Applications/XAMPP/xamppf
In ASP this was pretty easy to code. i could redirect people to however many pages I needed to based on what error was triggered. It doesn't appear that I can do that in PHP.
(or, at least it appears I need to do it in a much different way.)
Any help you can provide would be appreciated.
Thanks!!!
The first issue I have is redirecting to a new page during error handling.
I have the following code:
<?php
session_start();
$error_text = $_SESSION['dberror'];
include 'inc/dbconnect.php';
include 'inc/session_handle.php';
?>
dbconnect.php establishes the connection to the database.
If there's an error, I'd like to redirect to a friendly error page, since the code can't continue.
my dbconnect.php page looks like this:
<?php
$conn = mysql_connect("localjost",
if (!$conn)
{
$_SESSION['dberror'] = mysql_error();
/* Redirect browser */
header("Location: dberror.php");
exit;
}
$dbname = 'myown_db';
mysql_select_db($dbname);
?>
This is the result I get:
Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'localjost' (1) in /Applications/XAMPP/xamppf
Warning: Cannot modify header information - headers already sent by (output started at /Applications/XAMPP/xamppf
In ASP this was pretty easy to code. i could redirect people to however many pages I needed to based on what error was triggered. It doesn't appear that I can do that in PHP.
(or, at least it appears I need to do it in a much different way.)
Any help you can provide would be appreciated.
Thanks!!!
PHPMySQL Server
Last Comment
Ray Paseur
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thanks for the points. You'll love the SitePoint book. Very readable with great examples. ~Ray
There are a lot of things I like about PHP - and although I dabbled in ASP.NET, it seems PHP does what I need. If I can get around the strange things :)
Thanks for the link - I'll read up on that!