YA: Form Processing 20130516075928AAd3wht

<?php
// In response to: http://answers.yahoo.com/question/index?qid=20130516075928AAd3wht
$host     = "localhost:8889"; // Host name
$username = "root"; // Mysql username
$password = "*******"; // Mysql password
$db_name  = "*********"; // Database name
$tbl_name = "**********"; // Table name

function formData( $varName , $condition = NULL){
    Global $errors,$errorMsgs;
    $value = (isset( $_POST[$varName] ))? trim($_POST[$varName]) : '';
    if( !isset($value{0}) && isset( $errorMsgs[$varName] )){
        $errors[] = $errorsMsgs[$varName];
        return '';
    }else if( !is_null($condition) && $value == $condition && isset( $errorMsgs[$varName] )){
        $errors[] = $errorsMsgs[$varName];
        return '';
    }else{
        return $value;
    }
}


if( isset( $_POST['submit'] ) ){ // Request Method is POST if $_POST['submit'] is set
    $errors = Array(); // Will Hold the Error Messages, to be displayed on errors.
    $errorMsgs = Array(
        'fname' => 'Name is missing',
        'sname' => 'Surname is missing',
        'email' => 'Email is missing',
        'hometown' => 'Hometown is missing',
        'gender' => 'Gender is missing',
        'course' => 'You must select a course',
        'college' => 'You must select a college'
    );

    $fname = formData('fname');
    $email = formData('email');
    $sname = formData('sname');
    $regnumber = formData('regnumber'); // ???
    $college = formData('college','-1');
    $course = formData('course', '-1');
    $gradyear = formData('gradyear'); // ???
    $gender = formData('gender');
    $username = formData('username'); // ???
    $password = formData('password'); // ???
    $confirm_password = formData('confirm_password'); // ???
    $hometown = formData('hometown');

    if( count( $errors ) === 0 ){
        $vars = Array('fname', 'email', 'sname', 'regnumber', 'college', 'course', 'gradyear', 'gender', 'username', 'password', 'confirm_password', 'hometown');

        // Connect to server and select databse.
        //-- No Need to waste resources connecting if the page isn't ready to process data --
        //-- You Should also be using MySQLi Functions (at the least) --
        $conn = mysql_connect($host, $username, $password) or die("cannot connect<hr />" . mysql_error() );
        mysql_select_db($db_name, $conn) or die("cannot select DB<hr />" . mysql_error($conn) );

        $stmt = 'INSERT INTO Registration(' . implode(',',$vars) . ") VALUES(";
        foreach($vars as $var){
            // MySQL Injection Protection
            $stmt .= "'" . mysql_real_escape_string( $$var ) . "',";
        }
        $stmt = rtrim($stmt, ",") . ')';

        $result = mysql_query($stmt);

        if( $result ){ // Success
            echo 'All Good';
        }else{ // Error
            echo '<h1>Error</h1><hr />' . $stmt . '<hr /><pre>' . mysql_error($conn) . '</pre>';
        }

    }else{
        echo '<h2>The Following Errors Were Discovered</h2>';
        echo '<ul><li>' . implode('</li><li>', $errors) . '</li></ul>';
    }
}

?>