New member to sign up

Sep 25, 2009 Author: Developer

The following example program allows a new member to sign up; upon submitting the form, a new record is created for him in the database.

<?php
/* ch13ex05.php – member signup form demonstration 
*//* CONSTANT DECLARATIONS */
define(‘MYSQL_HOST’, ‘mysql.example.com’);
define(‘MYSQL_USER’, ‘admin’);
define(‘MYSQL_PASS’, ‘abc123’);
define(‘MYSQL_DB’, ‘PHPByExample’);
/* MAIN PROGRAM HERE */
if (! isset($action) )
{
$action = NULL;
}
switch($action)
{
default:displayForm();
break;
case ‘
signup’:signUp($HTTP_POST_VARS);
displaySuccess();
break;
}
/* DEFINITIONS ARE BELOW THIS POINT */
function displayForm()
{
head();
?><form action="”<?php">” method=”POST”>
<input name="”action”" type="”hidden”" value="”signup”" />
Name: <input type=”text” name=”name”><br>
E-mail: <input type=”text” name=”email”><br>
Age: <input type=”text” name=”age”><br>
<input type=”submit”>
</form>
<?php
foot();
}
function signUp($input)
{
// If we fail to connect, we can’t keep going, so we exit 
if (! mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS) )
{
echo ‘Failed to connect to host “‘ . MYSQL_HOST . ‘“.’;
exit;
}
mysql_select_db(MYSQL_DB);
mysql_query(“INSERT INTO members SET name=’{$input[‘name’]}’,
email=’{$input[‘email’]}’, “ .
“age={$input[‘age’]}”);
}
function displaySuccess()
{
head();
?>
Your submission has been completed!
<?php
foot();
}
function head()
{
echo “<html><body>”;
}
function foot()
{
echo “</body></html>”;
}
?>
Upon entering the correct information, this program completes the insertionand displays a success message.

tags: New member to sign up

views 4896
  1. Add New Comment