Hi Joe, The record has other information as well, names, phone, and etc. I like to store everything in an array and reference to it later. That way I don't have to do another mysql_xxx() later for the subsequent pages...that should save sometime, right? The problem has gone away once I switched back to good old Linux. The same code works now for both Linux and Windows...I still don't know why it didn't work in the first place...probably the 'reliable' Windows has something to do with it. :-)
Thanks, Peter "Joe Van Meer" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi Peter, are you limited to using arrays? If not, try msql_fetch_row() > since you are only looking for the one record, ie: the corresponding > username and password record for the username and password that was passed. > > Hope this helps, Joe :) > > <?php > session_start(); > > include("config.php"); > mysql_connect($host_name, $user_name, $passwd) > or die("Unable to connect to $hostname."); > // select database on MySQL server > mysql_select_db($db_name) or die("Unable to select databse."); > > // formulate the query > $sql_statement = "SELECT user_id, password FROM $table_name WHERE > user_id = '$user_id' AND > password = '$password'"; > > $result = mysql_query($sql_statement) or die("Unable to execute > query."); > > //if there is a corresponding record > if(mysql_fetch_row($result)) { > > > $usid = mysql_result($result,0); > $pswd = mysql_result($result, 1); > > > //create session variables > > session_register("password"); > $password = $pswd; > > session_register("user_id"); > $username = $usid; > > > //echo a friendly message or use header() function to redirect the user to > the appropriate page > echo "Succesful login!"; > } > else > { > //the user is not a registered member so redirect them to a sign up page or > another page to try and login again > header("Location: signup.php"); > > } > > ?> > > > > > > Peter Ruan <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi, > > I am running into a problem that I can't figure out the solution to. So > > I'm hoping that someone can give me some pointers here. I have two files > > (see below): verify.php and edit.php > > The job of verify.php is basically to verify that a user is in the > > database before allowing him/her to edit the information. The information > > retrieved is saved to arrary varaiable $row. I do a session_register() to > > $row and that information should be passed to subsequent pages that has > > session_start(), right? However, when I tried to print out the > information > > again in edit.php, it doesn't seem to register it in. At first I thought > it > > was the array problem, so I put the array variable $dummy to test it out > and > > that can be reigstered and retrieved correctly. What am I doing wrong??? > > Also, how do I redirect to a page automatically once the user is verfied > > (right now I have to ask the user to click on a link to redirect). > > > > Thanks in advance, > > Peter > > > > /******* verify.php ********/ > > <?php > > session_start(); > > > > include("config.php"); > > mysql_connect($host_name, $user_name, $passwd) > > or die("Unable to connect to $hostname."); > > // select database on MySQL server > > mysql_select_db($db_name) or die("Unable to select databse."); > > > > // formulate the query > > $sql_statement = "SELECT * FROM $table_name WHERE > > user_id = '$user_id' AND > > password = '$password'"; > > > > $result = mysql_query($sql_statement) or die("Unable to execute > > query."); > > > > $num_of_rows = mysql_num_rows($result); > > /* XXX: test array variable...take out later */ > > $dummy = array("one", "two", "three"); > > session_register(dummy); > > > > if (!$num_of_rows) { > > echo "<h3>User ID and password missmatch, try again!</h3>"; > > } else { > > while ($row = mysql_fetch_array($result)) { > > session_register(row); // register information retrieved from > > MySQL > > } > > printf("Successfully Logged In! <a href=\"edit.php\">Click > > Here</a>"); > > echo "<br>"; > > } > > ?> > > > > > > /************* edit.php *****************/ > > <?php > > session_start(); > > foreach ($dummy as $val) { > > echo $val . "<br>"; > > } > > > > foreach ($row as $data) { > > echo $data . "<br>"; > > } > > ?> > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
