can not get id

rdkd1970 · May 9, 2011

Help. When I add data to database it does not upload to the next welcome page. Can someone check my codes and let me know what I am doing wrong. I get this message when it goes to welcome page.

can not get id

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ebermy5/public_html/login.php on line 34

Welcome,

This is my first codes for them to fill out then it should go to the next welcome page below codes.

<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);
include_once ("Connections/connect_to_mysql.php"); 

  $err='';
  $id='';
  $firstname='';
  $lastname='';
  $country='';
  $email='';

  if(isset($_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

      $results = mysql_query("SELECT id FROM `Members` WHERE firstname='".addslashes($_POST["firstname"])."' and Email='".addslashes($_POST["email"])."'");
      if($row = mysql_fetch_array($results)){
        $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
   if($results){
         header("Location: login.php");
}else
die(mysql_error());

      }
    }
  }

?>
<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>

<input type="submit" name="submit" value=" Submit! ">

</form>

</body>
</html>

WELCOME PAGE

<?php
session_start();
session_id(); 
?>

<!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: login.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.
*/
error_reporting(E_ALL);
ini_set("display_errors", 1); 
$firstname = '';
$id = '';

if (isset($_SESSION['id'])) {

 $id = $_SESSION['id'];
} else {
echo "can not get id";
}

include('Connections/connect_to_mysql.php');
$result = mysql_query("SELECT firstname FROM `Members` WHERE id=$id");
$row = mysql_fetch_array($result);			

if ($firstname == ''){ //condition, is name equal to lower case firstname notice we use == and not =
echo "Welcome, $firstname";
} else { //so incase the condition is not as expected
echo "Sorry you are not $firstname";
}

?>
<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 from 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 Main Page">
</form>		
	</div>
</body>
</html>

Maq · May 9, 2011

In the future, please use

tags around your code.

PFMaBiSmAd · May 9, 2011

For each page of code...

rdkd1970 · May 9, 2011

I put the codes at the top with the codes open and close around them like below still get the same error message.

<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
?>
<?php
session_start();
session_id(); 
?>

<!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: login.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.
*/ 
$firstname = '';
$id = '';

if (isset($_SESSION['id'])) {

 $id = $_SESSION['id'];
} else {
echo "can not get id";
}

include('Connections/connect_to_mysql.php');
$result = mysql_query("SELECT firstname FROM `Members` WHERE id=$id");
$row = mysql_fetch_array($result);			

if ($firstname == ''){ //condition, is name equal to lower case firstname notice we use == and not =
echo "Welcome, $firstname";
} else { //so incase the condition is not as expected
echo "Sorry you are not $firstname";
}

?>
<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 from 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 Main Page">
</form>		
	</div>
</body>
</html>

:'(

Sign In

can not get id

Recommended Posts

rdkd1970

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

rdkd1970

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information