A8 : iMe

New Skills

Description

This form collects the users data and processes it.

The processed data is then entered into a mysql database via another php file called mysql_connect.php

Code

```
<?php
```
```
$page_title = 'Register';
```
```
if (isset($_POST['submit'])){
```
```
require_once ('mysql_connect.php');
```
```
function escape_data ($data){
```
```
global $dbc;
```
```
if (ini_get('magic_quotes_gpc')){
```
```
$data = stripslashes($data);}
```

return mysql_real_escape_string($data, $dbc);}

```
$message = null;
```
```
if (empty($_POST['first_name'])){
```
```
$fn = false;
```

$message .= '<p>Please enter your first name.</p>';}

```
else{
```

$fn = escape_data($_POST['first_name']);}

```
if (empty($_POST['last_name'])){
```
```
$ln = false;
```

$message .= '<p>Please enter your last name.</p>';}

```
else{
```

$ln = escape_data($_POST['last_name']);}

```
if (empty($_POST['user_name'])){
```
```
$u = false;
```

$message .= '<p>Please enter your username.</p>';}

```
else{
```
```
$u = escape_data($_POST['user_name']);}
```
```
if (empty($_POST['password1'])){
```
```
$p = false;
```

$message .= '<p>Please enter a password.</p>';}

```
else{
```

if ($_POST['password1'] == $_POST['password2']){

```
$p = escape_data($_POST['password1']);}
```
```
else{
```
```
$p = false;
```

$message .= '<p>Your password did not match the confirmed password.</p>';}

```
}
```
```
if (empty($_POST['email'])){
```
```
$e = false;
```

$message .= '<p>Please enter your email address.</p>';}

```
else{
```
```
$e = escape_data($_POST['email']);}
```
```
if ($fn && $ln && $u && $p && $e){
```
```
require_once ('mysql_connect.php');
```

$query = "SELECT user_id FROM users WHERE username='$u'";

```
$result = @mysql_query ($query);
```
```
if (@mysql_num_rows($result) == 0){
```

$query = "INSERT INTO users (first_name, last_name, user_name, password, email, reg_date)

VALUES ('$fn', '$ln', '$u', '$p', '$e', NOW() )";

```
$result = @mysql_query ($query);
```
```
if ($result){
```

echo '<p><b>You have been registered.</b></p>';

```
exit();}
```
```
else{
```

$message = '<p>You could not be registered due to a...

...system error.</p><p>' . mysql_error() . '</p>';}

```
}
```
```
else{
```

$message = '<p>That username is already taken.</p>';}

```
mysql_close();}
```
```
else{
```

$message .= '<p>Please try again.</p>';}

```
}
```
```
if (isset($message)){
```

echo '<font color="red">', $message, '</font>';}

```
?>
```

```
//Start PHP protocol
```
```
//Name the page
```
```
//When submit is clicked
```
```
//Connect to the database
```

//Create a function for escaping the data

```
//database connect
```
```
//Use magic quotes to...
```
```
//...strip slashes
```
```
//Return new data
```
```
//Create an empty variable
```
```
//Check for a first name
```
```
//If varible is false
```
```
//Print message
```
```
//Otherwise
```
```
//Set variable
```
```
//Check for a last name
```
```
//If varible is false
```
```
//Print message
```
```
//Otherwise
```
```
//Set variable
```
```
//Check for a username
```
```
//If varible is false
```
```
//Print message
```
```
//Set variable
```
```
//Check for a password
```
```
//If varible is false
```
```
//Print message
```
```
//Otherwise
```

//Check password against the confirmed password

```
//Set variable
```
```
//Otherwise
```
```
//If varible is false
```
```
//Print message
```
```
//End else
```
```
//Check for an email address
```
```
//If varible is false
```
```
//Print message
```
```
//Otherwise
```
```
//Set variable
```
```
//If all fields are present
```
```
//Connect to database
```
```
//Set variable
```
```
//Set variable
```
```
//Had to add an @ due to line error
```
```
//Password protect = PASSWORD('$p')
```
```
//Make the query
```
```
//If data base success
```
```
//Print message
```
```
//Exit
```
```
//If it did not run	print message
```
```
//End database query
```
```
//Otherwise
```
```
//Print message
```
```
//Close the database connection
```
```
//Otherwise
```
```
//Print message
```
```
//End sumbit
```
```
//If error occurs
```
```
//Print the message
```
```
//End PHP protocol
```