<?php
print_r($_POST);
ini_set('display_errors','1');
$conn=mysql_connect("********************","*******","**************") or die(mysql_error());
mysql_select_db("db33717_gradsurvey") or die(mysql_error());

$query=("SELECT * FROM grads") or die(mysql_error());

$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result)){

$userid=$row['user_id'];
$password=$row['password'];
$sql="update grads set password"or die(mysql_error());
mysql_query($sql) or die(mysql_error());
}

function generatePassword ($length = 8)
{

  // start with a blank password
  $password = "";

  // define possible characters
  $possible = "0123456789bcdfghjkmnpqrstvwxyz"; 
    
  // set up a counter
  $i = 0; 
    
  // add random characters to $password until $length is reached
  while ($i < $length) { 

    // pick a random character from the possible ones
    $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
        
    // we don't want this character if it's already in the password
    if (!strstr($password, $char)) { 
      $password .= $char;
      $i++;
    }

  }
  
  // done!
  return $password;

}

$password=generatePassword(8);

?>

<? 
echo $user_id;
echo $password;
?>

$sql="update grads set password"or die(mysql_error());

<?php
$conn=mysql_connect("********************","*******","**************") or die(mysql_error());
mysql_select_db("db33717_gradsurvey") or die(mysql_error());
 
 
function generatePassword ($length = 8)
{
 
  // start with a blank password
  $password = "";
 
  // define possible characters
  $possible = "0123456789bcdfghjkmnpqrstvwxyz"; 
 
  // set up a counter
  $i = 0; 
 
  // add random characters to $password until $length is reached
  while ($i < $length) { 
 
    // pick a random character from the possible ones
    $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
 
    // we don't want this character if it's already in the password
    if (!strstr($password, $char)) { 
      $password .= $char;
      $i++;
    }
 
  }
 
  // done!
  return $password;
 
}
 
$query=("SELECT * FROM grads") or die(mysql_error());
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result)){
$userid=$row['user_id'];
$password=generatePassword(8);
$sql="update grads set password='$password' where user_id='$userid'";
mysql_query($sql) or die(mysql_error());
echo $user_id." : ".$password; //remove this if you dont want to see the user id and password on the screen
}
?>

<?php    //page1.php
session_start();
$_SESSION['name']="testuser"; //user name
?>
 
<?php //page2.php
session_start();
echo $_SESSION['name']; //prints testuser
?>