Database error, please help!

[mark103]

Hey guys,

I am using this script to connect to mysql database.

Here it is the code:

<?php
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydatabase');

session_start();
$errmsg_arr = array();
$errflag = false;

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

$db = mysql_select_db(DB_DATABASE);
if(!$db) {
  die("Unable to select database");
    }

function clean($str) {
  $str = @trim($str);
  if(get_magic_quotes_gpc()) {
    $str = stripslashes($str);
  }
  return mysql_real_escape_string($str);
  }
    $login = clean($_GET['login']);
    $password = clean($_GET['password']);
    if($login == '') {
  $errmsg_arr[] = 'Login ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PS ID missing';
  $errflag = true;
    }

if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  session_write_close();
  echo "ERROR";
  exit();
    }

  $qry="SELECT level FROM users WHERE login='$login' AND passwd='$password'";

if($result) {
  $result=mysql_query($qry);
    echo $result;
  exit();
    }else {
  die("Query failed");
    }
?>

However, I have received an error which I catch from this line:

echo "ERROR";

I have input the correct username, password and the name of the database.

Do you have any idea why I have received an error, guess if I have missing something?

[dagon]

mark103;10964449 wrote:

Do you have any idea why I have received an error

it's because $_SESSION['ERRMSG_ARR'] = $errmsg_arr;

no where in your code is $_SESSION['ERRMSG_ARR'] set, so i suspect both are empty hence the same ergo the error.

[mark103]

I have removed the prints "ERROR" and replaced with ERRMSG_ARR. however, I have prints out and catch the error:

Parse error: syntax error, unexpected T_EXIT in /home/myusername/public_html/mysite.com/config.php on line 43

The error came from this line:

exit();

The exit call I am referring to are none. So what should I do about it, should I remove the exit call?