We help IT Professionals succeed at work.

Insert Record - for Specific User

florendine
florendine asked
on
233 Views
Last Modified: 2010-04-25
I'm sure this is very easy but i keep hitting a brick wall;

Using Dreamweaver MX2004

I have 2 tables : Athlete and performance

athlete; athlete_id, athlete_name, athlete_email, athlete_password, athlete_no
performance; log_id. athlete_id, log_date, log_event, log_perf, log_venue

So far I have created a login page that creates a session variable that holds the athlete email, I have created a update user page, change password page etc. I used the php login suit extension to do this.

I problem I am having is when I try to build a page that inserts data into the performace table. I want the page designed so when the user login's in they simply enter[log_date, log_event, log_perf, log_venue]. I don't want the athlete to enter their athlete_id every time they input a new performance.  Can the athlete_id be held in a session variable when they login and used when they enter a new performance.

The login page created the following code to create the sesion variable>
else {
            mysql_free_result($rsLogin);
            session_register("login_sac");
            $HTTP_SESSION_VARS['login_sac'] = $HTTP_POST_VARS['textfield'];
            header("Location: Index.php");


Any help would be great, this is frying my head has i'm sure the solution is easy...

Thanks in Advance


Comment
Watch Question

Saqib KhanSenior Developer

Commented:
so why dont to generate another session variable same as you generated with the email?

Author

Commented:
Sure sounds a good idea, thou how would i code the page to create the new session variable. Surly with the pervious code the session variable is created from data inputted in the textfield. I would need to retrieve the athlete_id from the database. Sorry if the answer is obvious!!!. I have included the code for the page:

<?php
// Buzz inet PHPLS01 - Login & Set Session
// Enable Session Support for page
session_start();
?>
<?php require_once('Connections/training.php'); ?>
<?php
// Buzz inet PHPLS01 - Login & Set Session - Recordset
$myUsername_rsLogin = "0";
if (isset($HTTP_POST_VARS['textfield'])) {
  $myUsername_rsLogin = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['textfield'] : addslashes($HTTP_POST_VARS['textfield']);
}
$myPassword_rsLogin = "0";
if (isset($HTTP_POST_VARS['textfield2'])) {
  $myPassword_rsLogin = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['textfield2'] : addslashes($HTTP_POST_VARS['textfield2']);
}
mysql_select_db($database_training, $training);
// Verify Login is correct
$query_rsLogin = sprintf("SELECT athlete_email, athlete_password FROM athlete WHERE athlete_email = '%s' AND athlete_password = '%s'", $myUsername_rsLogin,$myPassword_rsLogin);
$rsLogin = mysql_query($query_rsLogin, $training) or die(mysql_error());
$row_rsLogin = mysql_fetch_assoc($rsLogin);
$totalRows_rsLogin = mysql_num_rows($rsLogin);

// Buzz inet PHPLS01 - Login & Set Session - Main
if($HTTP_POST_VARS['action']=="login"){
      if($totalRows_rsLogin==0){
            $errorMessage = "Please Re-Enter Details";
            mysql_free_result($rsLogin);
      } else {
            mysql_free_result($rsLogin);
            session_register("login_sac");
            $HTTP_SESSION_VARS['login_sac'] = $HTTP_POST_VARS['textfield'];
            header("Location: Index.php");
      }
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<div align="center">
  <?php echo "$errorMessage"; ?>
  <form name="form1" method="post" action="<?php echo "$PHP_SELF"; ?>">
    <table width="50%"  border="0" align="center">
      <tr>
        <td> <div align="center">User Name </div></td>
        <td><div align="center">
          <input type="text" name="textfield">
        </div></td>
      </tr>
      <tr>
        <td><div align="center">Password</div></td>
        <td><div align="center">
          <input type="text" name="textfield2">
        </div></td>
      </tr>
      <tr>
        <td><div align="center"></div></td>
        <td><div align="center">
          <input type="submit" name="Submit" value="Submit">
        </div></td>
      </tr>
    </table>
    <input name="action" type="hidden" id="action" value="login">
  </form>
</div>
</body>
</html>
Senior Developer
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Saqib KhanSenior Developer

Commented:
Did that answer you question?

Author

Commented:
I've not tried it yet, but it does makes sense to me. Thanks

Author

Commented:
I've just inserted the sql statement into the page; However u mentioned generating the session variable, i wondered if you could elaborate on the specific code required. Thanks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.