Hi experts,
Please see the code below, working fine on mysql 4.1.22 but not on mysql 5.0
displaying the following error for all session variables.
Please note register_globals is Off and want to keep it Off.
Notice: Use of undefined constant first_name - assumed 'first_name' in calllog.php on line 38
--------------------------
<?
2 /* Check User Script */
3 session_start(); // Start Session
4
5 include 'db.php';
6 // Conver to simple variables
7 $username = $_POST['username'];
8 $password = $_POST['password'];
9
10 if((!$username) || (!$password)){
11 $msg2 = "Please enter ALL of the information! <br />";
12 include 'left.html';
13 exit();
14 }
15
16 // Convert password to md5 hash
17 $password = md5($password);
18
19 // check if the user info validates the db
20 $sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' AND activated='1'");
21 $login_check = mysql_num_rows($sql);
22
23 if($login_check > 0){
24 while($row = mysql_fetch_array($sql)){
25
26 foreach( $row AS $key => $val ){
27 $key = stripslashes($val);
28 }
29 // Register some session variables!
30 session_is_registered('fir
st_name');
31 $_SESSION['first_name'] = $row[first_name];
32 session_register('last_nam
e');
33 $_SESSION['last_name'] = $row[last_name];
34 session_register('email_ad
dress');
35 $_SESSION['email_address']
= $row[email_address];
36 session_register("user_lev
el");
37 $_SESSION['user_level'] = $row[user_level];
38 session_register('username
');
39 $_SESSION['username'] = $row[username];
40
41 mysql_query("UPDATE users SET last_login=now() WHERE userid='$row[userid]'");
42 $msg1 = "";
43 $msg2 = "";
44 $msg3 = "";
45
46 if($user_level==0) {
47 include 'indexlevel0.html';
48 }
--------------------------
----------
----------
----
Start Free Trial
