Home arrow PHP arrow Page 3 - Website Database Basics With PHP and MySQL

Verifying form data - PHP

The World Wide Web (WWW) does only one thing - provide information. If you have information about something, you can share it with the world by building a website. As your website grows you may run into two problems: Your website has so much information that visitors can't quickly find what they want and visitors want to give you information. Both of these problems can be solved by building a database on a website. This introductory article shows you how to do this using basic PHP-MySQL interaction.

TABLE OF CONTENTS:
  1. Website Database Basics With PHP and MySQL
  2. HTML talks to PHP talks to MySQL
  3. Verifying form data
  4. Using cookies to identify and track visitors
  5. Weird SQL: What The Books Don't Tell You
  6. Checkboxes and other HTML form processing
By: Thomas Kehoe
Rating: starstarstarstarstar / 100
January 11, 2000

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
Some visitors to your website will try to enter invalid data into your database. You'll want to write a verification script to clean up entered data.
  1. Trimming white space
  2. Required fields
  3. Checking e-mail addresses
  4. Checking that the username is unique

Trimming white space

trim will remove white spaces from the beginning and end of the data:

trim ($first_name);


Required fields

Some of your fields will be required. In other words, visitors have to enter something in the field. The following script checks that a first name was entered:



if (ereg(".", $first_name) == 1) { echo "First name: ", "$first_name"; $verify = "OK"; } else { print ("<b>Error:</b> A first name is required."); $verify = "bad"; }



ereg means "evaluate regular expression". "Regular expressions" are the UNIX function for finding patterns in strings of letters and numbers. ereg is followed by parentheses, and you can put three arguments in the parentheses. The arguments are separated by commas. The first argument is the pattern to search for, usually surrounded by quotation marks. The second argument is where ereg is to search, usually a variable. The third, optional, argument is an array to put matches into. This argument is a variable.

ereg returns either a "0" (false) or a "1" (true).

The dot . or period is a regular expression wild card meaning "any character."

(ereg(".", $first_name) == 1) means "the variable '$first_name' contains anything". If this expression is true, then the first name is printed, and the variable $verify is set to "OK".

The else argument executes when ereg returns "0" (false).

There are three other versions of the ereg function.

  1. ereg_replace uses three arguments: the first is the pattern to search for, the second is the pattern to replace the first pattern, and the third is where to search (a variable).
  2. eregi is the same as ereg, except that it's not case-sensitive (i.e., it doesn't differentiate upper- and lower-case letters).
  3. eregi_replace is not case sensitive
Alternative means to the same end

The line if (ereg(".", $first_name) == 1) can be simplified to if ($first_name). I used the longer form to show how to use ereg in a simple example.

Checking e-mail addresses

The following ereg arguments test validity of e-mail addresses:

"\@"Must include @
"^\@"Can't begin with @
"\@.*.\."Must have characters between @ and .
"\....*"At least two characters after the .
" "No spaces permitted
"<" ">"No angle brackets permitted

Checking that the username is unique

You may need to make sure no two visitors try to use the same name:



mysql_connect (localhost, username, password); mysql_select_db (dbname); $result = mysql_query ("SELECT * FROM tablename WHERE USER_NAME = '$USER_NAME' "); if ($row = mysql_fetch_array($result)) { print ("<b>Error:</b> The user name <b>"); print ("$USER_NAME"); print ("</b> has been taken. Go back and enter a new user name."); print ("<p>"); $verify = "bad"; } else { print ("User name: "); print ("$USER_NAME"); }



This code connects to MySQL, then searches the database for the entered username. Note that the = equals sign is used for an exact search, when previously we used LIKE to do wildcard searches. If any result is found, the visitor is told to enter a new username.


 
 
>>> More PHP Articles          >>> More By Thomas Kehoe
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

PHP ARTICLES

- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: