hi,
i have been trying to figure out this end tag but couldn't figure can anyone
take a look at this code.
<?php
session_start();
$db = mysql_connect('localhost', 'user', 'pass') or
die ('Unable to connect. Check your connection parameters.');
mysql_select_db('max', $db) or die(mysql_error($db));
// filter incoming values
$password = (isset($_POST['password'])) ? $_POST['password'] : '';
$first_name = (isset($_POST['first_name'])) ? trim($_POST['first_name']) : '';
$last_name = (isset($_POST['last_name'])) ? trim($_POST['last_name']) : '';
$email = (isset($_POST['email'])) ? trim($_POST['email']) : '';
if (isset($_POST['submit']) && $_POST['submit'] == 'Register') {
$errors = array();
// make sure manditory already have been entered
if (empty($email)) {
$error[] = 'Email cannot be blank.';
}
// check if email already is registered
$query = 'SELECT email FROM max_mian_info WHERE email = "' . $email . '"';
$result = mysql_query($query, $db) or die (mysql_error());
if (mysql_num_rows($result) > 0) {
$errors[] = 'Email ' . $email . ' is already registered.';
$email = '';
}
mysql_free_result($result);
// check if first_name already is registered
$query = 'SELECT first_name FROM max_user_info WHERE first_name = "' . $first_name . '"';
$result = mysql_query($query, $db) or die (mysql_error());
if (mysql_num_rows($result) > 0) {
$errors[] = 'First Name ' . $first_name . ' is already registered.';
$first_name = '';
}
mysql_free_result($result);
if (empty($password)) {
$errors[] = 'Password cannot be blank.';
}
if (empty($first_name)) {
$errors[] = 'First name cannot be blank.';
}
if (empty($last_name)) {
$errors[] = 'Last name cannot be blank.';
}
if (count($errors) > 0) {
echo '<p><strong style="color:#FF000;">Unable to process your ' .
'registration.</strong></p>';
echo '<p>Please fix the following:</p>';
echo '<ul>';
foreach ($errors as $error) {
echo '<li>' . $error . '</li>';
}
echo '</ul>';
} else {
// No errors so enter the information into the database.
$query = 'INSERT INTO max_mian_info
(user_id, email, password)
VALUES
(NULL, "' . mysql_real_escape_string($username, $db) . '", ' .
'PASSWORD("' . mysql_real_escape_string($password,
$db) . '"))';
$result = mysql_query($query, $db) or die(mysql_error());
$user_id = mysql_insert_id($db);
$query = 'INSERT INTO max_user_info
(user_id, first_name, last_name)
VALUES
(' . $user_id . ', ' .
'"' . mysql_real_escape_string($first_name, $db) . '", ' .
'"' . mysql_real_escape_string($last_name, $db) . '")';
$result = mysql_query($query, $db) or die(mysql_error());
$_SESSION['logged'] = 1;
$_SESSION['email'] = $email;
header('Refresh: 5; URL= login.php');
?>
