You can easily change any table field name in MySQL using the “ALTER” command by specifying the “CHANGE” option.

Lets assume we have the following database table.

If we wanted to change the name of the Date field to StartDate, we would use the following command. Remember to backup your database, or copy the /var/lib/mysql source files to a safe location before attempting to utilize commands that may change the structure of your database.

Using these simple commands will allow you to fix problems and clean up any naming mistakes made early on in the programming process.

The below example makes use of PHP and Regular Expressions to breakdown what someone might type into an email field and make sure that it fits the general format.

$email = "test@test.com";

if(eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$", $email))
{
// echo "Valid email address.";
return(1); // true
}
else
{
// echo "Invalid email address.";
return(0); // false
}

This post is designed to encourage the use of separate and specific web page titles using PHP, without the need for a database. While this is not the only way, or best way to accomplish page titling, it is nonetheless a useful and easy to work with.

Lets assume you have a website with 5 pages.

Home
About
Products
Services
Contact

The goal is to present the visitor with unique titles for each page.

If you are using a scripting language like PHP to construct your documents then you might have made a simple page like the following.

You essentially have six files.

index.php
/includes/home.php
/includes/about.php
/includes/products.php
/includes/services.php
/includes/contact.php

Begin with creating an array of the titles. For simplicity we will just use basic titles. You should conduct the proper marketing research to determine what will work best for your company.

$pages = array('home','about','products','services','contact');

$select_page = array_search($_GET['page'], $pages);

$new_title = array('Home Page', 'About Area', 'Product Pages', 'Our Services', 'Contact Us');

$call_title = $new_title[$select_page];

The code above would be placed at the top of index.php, above any html.

The finished version would look like this: