Can someone have a look at my codes and let me know how I can get them to be used on Chrome and IE. On Chrome is was at first adding to my database but now it gets an error message on line 27 to do with the $results when it goes to the next page login.php. This stopped adding to the database ??? Then I tried in IE and it actually adds to database but does not go to the next page.:queasy:
<?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>
Next page: 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>\n";
?>
<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>
Any help from the pros would be really appreciated.
