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.

	Submit Your Code
	SEO Monitor
	UpTime Monitor
	PHP Code Contest
	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 Index
	Web Development Resources
	Web Development Content

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
	Mobile Dev World


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 :	2 of 5 (graded 3 times)
Viewed :	25443
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

	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	DDN FFA Network Script Categories : PHP, MySQL, Complete Programs, HTML and PHP, Databases
	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
	Create and restore backup of MySQL databases Categories : MySQL, Databases, PHP, PHP Classes, Complete Programs
	Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL, Complete Programs, General SQL, PHP, Databases
	Example voting script. Lets people enter suggestions and vote for existing ones. Categories : MySQL, PHP, Cookies, Complete Programs, Databases
	This is a very simple BBS that uses MySQL Categories : MySQL, Databases, Complete Programs, PHP
	AITSH Guestbook Categories : Complete Programs, HTML and PHP, Databases, MySQL
	Message of the Day - Random Message (Needs MySQL!) Categories : Databases, HTML and PHP, PHP, MySQL
	Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases, PHP, MySQL, Complete Programs
	phpAds, a complete banner and ad management system with detailled tracking and stats. Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases
	free, search engine, indexing, system, information, web, ftp, http, free, software, cgi, php, MySQL, database, php3, FreeBSD, Linux, Unix, UdmSearch Categories : MySQL, Complete Programs, PHP, Databases, Search
	Required form fields that pull from MySQL database Categories : PHP, HTML and PHP, Databases, MySQL
	phpCards - PHP/mySQL postcard script with web based admin to add, edit, and delete cards and categories. Very easy to install. Categories : PHP, Complete Programs, HTML and PHP, MySQL
	mySQL/PHP/search with multientry form and table output with colored rows Categories : PHP, Beginner Guides, MySQL, HTML and 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...