I have recently tried this coding to update to my database it works differently in two browsers IE and Chrome. In chrome it just goes to the next page (before it was adding data to DB) and not going to next page. Now IE just adds data to DB and does not go to next page. Can someone take a look and let me know what I have to do to fix this. thanks
<?php
@include('Connections/connect_to_mysql.php');
$err='';
if($_POST["submit"]){
// Validate form data
if($_POST["firstname"]=='') $err.='Please enter First Name<br>';
if($_POST["email"]=='') $err.='Please enter Email<br>';
if($err==''){
// Check if there are duplicate entries in the 'contacts' table
$r=mysql_query("SELECT ID FROM Members WHERE firstname='".addslashes($_POST["firstname"])."' and Email='".addslashes($_POST["email"])."'");
if(mysql_num_rows($r)){
$err.='Can not add duplicate entry<br>';
}
else{
// adding new record to 'contacts' table
mysql_query("INSERT INTO Members (firstname,lastname,country,Email)
values ('".addslashes($_POST["firstname"])."','".addslashes($_POST["lastname"])."','".addslashes($_POST["country"])."','".addslashes($_POST["email"])."')");
// redirecting to success screen
exit;
}
}
}
?>
<html>
<head>
<title>Add New Contact</title>
</head>
<body>
<h2>Register with us</h2>
<?php echo $err==''?'''<p style="color:red;">'.$err.'</p>') ?>
<form method="post" action="form.php">
<table border="0">
<tr>
<td valign="middle">First Name:</td>
<td><input type="text" name="firstname" size="30" value="<?php echo htmlspecialchars($firstname) ?>"></td>
</tr>
<tr>
<td valign="middle">Last Name:</td>
<td><input type="text" name="lastname" size="30" value="<?php echo htmlspecialchars($lastname) ?>"></td>
</tr>
<tr>
<td valign="middle">Country:</td>
<td><input type="text" name="country" size="30" value="<?php echo htmlspecialchars($country) ?>"></td>
</tr>
<tr>
<td valign="middle">Email:</td>
<td><input type="text" name="email" size="30" value="<?php echo htmlspecialchars($email) ?>"></td>
</tr>
</table><br>
<a href="http://www.ebermylove.com/login.php"><input type="submit" name="submit" value=" Submit! "></a>
</form>
</body>
</html>
login.php
<?php
session_id();
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome</title>
</head>
<body>
<?php
/* Program: New_member.php
* Desc: Displays the new member welcome page. Greets
* member by name and gives a choice to enter
* restricted section or go back to main page.
*/
if (@$_SESSION['auth'] != "yes")
@include('Connections/connect_to_mysql.php');
$link = mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
$link = mysql_select_db("$db_name") or die ("Query died:");
$query = "SELECT firstName, lastName FROM `Members`
WHERE email='{$_SESSION['id']}'";
$result = @mysql_result($query,$link)
or die("Could not execute query");
echo "<html>
<head><title>New Member Welcome</title></head>
<body>
<h2 style='margin-top: .7in; text-align: center'>
Welcome $firstName </h2>\
";
?>
<p>Your new Member accounts lets you enter the members only section
of our web site. You'll find special discounts, a profile of matches,
live advise for experts, and much more.</p>
<p>Your new Member ID and password were emailed to you. Store them
carefully for future use.</p>
<div style="text-align: center">
<p style="margin-top: .5in; font-weight: bold">
Glad you could join us!</p>
<form action="profile.php" method="post">
<input type="submit"
value="Enter the Members Only Section">
</form>
<form action="index.php" method="post">
<input type="submit" value="Go to eBermylove Main Page">
</form>
</div>
</body>
</html>