can not get id

rdkd1970

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.

Code: [Select]

<?phperror_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");}elsedie(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

Code: [Select]

<?phpsession_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 sectionof 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 themcarefully 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>

😕

bradgrafelman

I think the first thing we'll need from you before we can help is a readable version of your code (e.g. with proper spacing/indentation). Also, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

NogDog

Please re-post using the forum's [noparse]

...

[/noparse] tags around your code, and with newlines instead of as one long line, so that we can actually read it. (I added the php tags, but that didn't help much since each code sample was one long line!)

rdkd1970

I know this may sound like I am backwards but where are the

 tags is it like what I just did or is there somewhere in the post that I find them. I wondered how it was done.

rdkd1970

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.

Code:


PHP Code:
<?phperror_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>

 Code:

WELCOME PAGE

Code:


PHP Code:
<?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 sectionof 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>
Code:

bradgrafelman

If you're on the "Reply to Thread" screen, click the icon that looks like a white-blueish piece of paper with the letters 'php' on it (it's the last icon in the row that begins with the Bold, Italicize, and Underline formatting icons). You'll see a pair of bbcode tags appear in the message box; you can also type these tags in manually when posting.

See this page in the vBulletin FAQ for more info/examples on bbcode tags.

EDIT: @: Hah! I'm glad I'm finally on the other end of the stupid wow-I-keep-repeating-others-while-I'm-typing scenario. :p

NogDog

You can just type [noparse]"

" at the start of your code snippet and "

"[/noparse] at the end (without the quotes). See all of this boards BBCode options at http://phpbuilder.com/board/misc.php?do=bbcode.

LOL: We really do need a "someone else has replied" notice on this forum. 🙂

rdkd1970

Okay I think I perfected the

 coding layout now to my other situations Can someone help me.

I get above message when I add data to the db and it goes to the next page the session is not recognizing the member that logged in. what am I missing in my coding. Thanks all everyone helping is okay with me.

bradgrafelman

Where do you ever define $_SESSION['id']?

rdkd1970

should it be

$firstname = ''; 
$id = $_SESSION['id'];

rdkd1970

I changed the $id to go like

$_SESSION['$id']=$id

and it now seems to have this which means I am getting closer it left out the 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 36

Any idea what I need to do? Should I do a $row=mysql_fetch_array($result,$row());

rdkd1970

Instead of $row should it be $column for the $row=mysql_fetch_array($results);