Code Examples -> This program will take data from a user via a web based form, validate it, show it to the user for re-validation, and finally insert it into the database. Plenty of sanity checking on the fields in the form.

	Join us on FaceBook
	Submit Your Code
	Poker Tournaments
	Poker Guide for Developers
	SEO Monitor
	UpTime Monitor
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Resources
	Web Development Content
	Internet Security Software

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	פרייסז - הכח לקנות עובר לידיים שלך
	Texas Holdem Poker Evangelists


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	This program will take data from a user via a web based form, validate it, show it to the user for re-validation, and finally insert it into the database. Plenty of sanity checking on the fields in the form.
Categories :	MySQL, HTML and PHP, PHP, Complete Programs, Databases	Swift Griggs
Date :	Nov 22nd 1998
Grade :	3 of 5 (graded 4 times)
Viewed :	28395
File :	No file for this code example.
Images :	No Images for this code example.

Search :	More code by Swift Griggs
Action :	Grade This Code Example
Tools :	My Examples List

Code

<html>
<body bgcolor="AAAAAA" text="000000"></body>
<title>Web and Email registration</title>

<center><table border=1 bgcolor="#086b5a" bordercolor="086b5a">
<tr><td><center><img src="reg.gif"><IMG SRC="logot.gif"></center></TD>
</tr>
</table></center>
<?
if (!$namef && !$insertval && !$submit) {
echo "<form action=\"/reg.php3\" method=\"post\">";
echo "<center>";
echo "<table align=\"center\" border=1 bordercolordark=\"#777777\" width=\"60%
\" bordercolorlight=\"#dddddd\" bgcolor=\"BBBBBB\">";
echo "<tr><td colspan=2 bgcolor=\"#000000\"><center><font color=\"#aaddaa\"> Jap
an Communication Inc.</font></center></td></td>" ;
echo "<tr><td>Your first name<br>";
echo "<td><input type=\"text\" name=\"namef\" maxlength=40
length=40><br></tr></td>";
echo "<tr><td>Your last name<br></td>";echo "<td><input type=\"text\" name=
\"namel\" maxlength=40 length=40><br></tr></td>";
echo "<tr><td>Your company name</td>";
echo "<td><input type=\"text\" name=\"coname\" maxlength=120 length=40><br></tr>
</td>";
echo "<tr><td>Your email address<br>";
echo "<A4><A4><A1><CB></td>";
echo "<td><input type=\"text\" name=\"email\" maxlength=60 length=40><br></tr></
td>";
echo "<tr><td>Your cell phone's number (numbers only please)";
echo "";
echo "<td><input type=\"text\" name=\"mobileset\" maxlength=15
length=40></tr></td>";
echo "<tr><td>A personal password<br>";
echo "</td>";
echo "<td><input type=\"password\" name=\"pass\" maxlength=40
length=40></tr></td>";
echo "<tr><td>A personal password (again)";
echo "</td>";
echo "<td><input type=\"password\" name=\"pass2\" maxlength=40 length=40></tr></
td>";
echo "<tr><td>Finish and submit data<br><BD><AA><CE><BB></td>";
echo "<td><center><input type=\"submit\" name=\"submit\" value=\"<C5><D0><CF>
<BF>\"></center></tr></td>";
echo "<tr><td colspan=2 bgcolor=\"#000000\"><center><font color=\"#aaddaa\">
Copyright 1998</font></center></td></td>" ;
echo "</table></center></form>";
} ?>
<?
if($pass != $pass2){
echo "<br><br><hr>You mispelled your password<hr><br><br>";
echo "Please <a href=\"/reg.php3\">go back</a> to correct this";
die;
}

if(!$insertval && $namef && $email && $namel && $pass && $coname) {
echo "<center><table border=1 bgcolor=\"#CCCCCC\"><tr><td colspan=6>" ;
echo "<br><center>You entered these values </center></td></tr>";
echo "<tr><td>First Name</td><td>Last Name</td><td>Company
Name</td><td>Email Address</td><td>";
echo "Phone Number</td><td>Password</td></tr>";
echo "<tr><td>$namef</td><td>$namel</td><td>$coname</td><td>
$email</td><td>mobileset</td><td>NOT SHOWN</td></tr>";
echo "</td></tr>";
echo "<form action=\"reg.php3\" method=\"post\">";
echo "<td colspan=3>Is all this data Correct?</td><td colspan=3>";
echo "<center><input type=\"submit\" value=\"Yes\" name=\"insertval\">";
echo "<input type=\"submit\" value=\"No\" name=\"insertval\">";
echo "<input type=\"hidden\" name=\"namef\" value=\"$namef\">";
echo "<input type=\"hidden\" name=\"namel\" value=\"$namel\">";
echo "<input type=\"hidden\" name=\"coname\" value=\"$coname\">";
echo "<input type=\"hidden\" name=\"email\" value=\"$email\">";
echo "<input type=\"hidden\" name=\"mobileset\" value=\"$mobileset\">";
echo "<input type=\"hidden\" name=\"pass\" value=\"$pass\">";
echo "<input type=\"hidden\" name=\"pass2\" value=\"$pass2\">";
echo "</form></table></center></center>";
} elseif($insertval == "No") {
echo "<font size=+2><center><br><br><hr>If you made a mistake, ";
echo "Click <a href=\"/reg.php3\">here</a> to start
over<hr></font></center><br><br>";
}
if((!$namef || !$email || !$namel || !$pass || !$coname || $insertval) &&
$submit) {
echo "<font size=+1><center><br><br><hr>";
echo "You <font color=\"#FF0000\"><b>must</b></font> enter data in the
following fields:<br>";
echo "First name, Last Name, email, Company Name, and password";
echo "Click <a href=\"/reg.php3\">here</a> to start over";
echo "</font></center><hr><br><br>";
}
if($insertval == "Yes"){
mysql_connect("localhost","root","mypassword")
or die("Unable to connect to MySQL server");
mysql_select_db("register") or die("Unable to select database");
$insert = mysql_query("insert into users VALUES(
'$namef','$namel','$coname','$email','$mobileset',password
('$pass'),NULL)");
echo "<br><br><b><font size=+4><font color=\"66FF66\"><center>Your data has
been successfully entered.";
echo "</b></center></font></font>";
}
?>
<center><table border=1 width="90%"
bgcolor="#086b5a"><tr><td><FORM><center><font color="FFFFFF">
<INPUT bgcolor="#AAFFAA"type="button" value="Main Menu"
OnClick="location='./index.html'"></font></form></td>
</center>
<TD><font color="DD5555"><center><h1>Widget
Inc.</h1>company name here</center></td></tr></table></center>

</html>

Related Code Examples

	This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases
	DDN FFA Network Script Categories : PHP, MySQL, Complete Programs, HTML and PHP, Databases
	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	phpAddQuote v1.2 - UPDATED! Lets users add their own quotes to your website. You specify how many quotes appear on the page at a time. Easier install! Categories : HTML and PHP, Complete Programs, PHP, Databases, Personalization and Membership
	AITSH Download Categories : PHP, Complete Programs, MySQL, Databases
	Paginating the mySQL data Categories : PHP, Algorithms, Databases, MySQL, HTML and PHP
	Web Self Service Resource Scheduler Using Session Variables under php4 includes Calendar building code - requires MySQL Categories : PHP, Complete Programs, Calendar, MySQL, Databases
	This is a redirection program which is as good as the come.to v3 url redirection, complete with admin interface all clients stored in mysql Categories : PHP, MySQL, Ecommerce, HTML and PHP, Complete Programs
	DirtSearch Version 3.5 full function robust PHP and MySQL (and other databases) Site or Web Wide Search Engine Categories : PHP, MySQL, Complete Programs, Search, Databases
	Simple Mini Poll class library (SimPoll) Categories : PHP, PHP Classes, Databases, MySQL, Complete Programs
	Shopping Basket On-Line Ordering System. Categories : Complete Programs, MySQL, PHP, Ecommerce, Databases
	PHP and MySQL scripting for Muyltiple CheckBoxes Categories : HTML and PHP, MySQL, Databases, PHP
	Browse a MySQL database & draw a tree view & load final items into a template page. Categories : MySQL, Complete Programs, Algorithms, PHP, Databases
	A PHP useradmin for MySQL. Uploading is easy. The only thing you need is PHP and MySQL installed! Categories : MySQL, Databases, PHP, HTML and PHP
	BBS system for easy customization. Utilizes mySQL. Categories : Complete Programs, MySQL, PHP, Databases

User Comments

	Jo�o Oliveria wrote : 14 `Very well. Your contribution for my learning. Thenk you.`
	Varinder Tandon wrote : 131 `Where is your reg.php3, i just want to see how u connact the databse with html for.`
	Andras Jokuti wrote : 211 `Tandon: You should name THIS file reg.php3! Yoko`
	Raja Komkom Siregar wrote : 217 `What about the table of register database?`
	Vulinh Nguyen wrote : 303 The block code: Visitors should be informed which field(s) they forgot to fill out. You program displays the messages which indicates that the visitor has left out all the required fields. But in reality, they just left out one required field only. I have added the short code to your program to catch up the empty fields: In the code block: if((!$namef \|\| !$email \|\| !$namel .......) { echo "<font size=+1><center><br><br><hr>"; echo "You <font color=\"#FF0000 \"><b>must</b></font>enter data in the following fields:<br>" if(!$namef) echo "First name, "; if(!$namel) echo "Last name, "; //and so on..... } This would inform visitors which fields were actually left empty!
	tonto kea wrote :598 Well, table structure would be nice. Couse i didn`t get it work...