about php mysql using wamp server

Question

i am using wamp server.i supposed to create one website.i created one registration form in php with my sql connection now i have a problem with validation code how to valid the registration form i dont know i tried it but its not valid.i did download the validation scripts form many sites but its not working.

Satyapriya Nayak · Answer

config.php $sDbHost = 'localhost'; $sDbName = 'onlinetest'; $sDbUser = 'root'; $sDbPwd = ''; $dbConn = mysql_connect ($sDbHost $sDbUser $sDbPwd) or die ('MySQL connect failed. ' . mysql_error()); mysql_select_db($sDbName$dbConn) or die('Cannot select database. ' . mysql_error()); ?> registration.php session_start(); include(config.php); if($_POST[Submit]==Register) { $name=$_POST[text_name]; $address=$_POST[text_address]; $area=$_POST[text_area]; $city=$_POST[text_city]; $pin=$_POST[text_pin]; $state=$_POST[text_state]; $country=$_POST[text_country]; $mobile=$_POST[text_mobile]; $email=$_POST[text_email]; $user=$_POST[text_user]; $password=$_POST[text_pass]; $_SESSION[username]=$_POST[text_name]; //echo $_SESSION[username]; //exit; $str=insert into user(nameaddressareacitypinstatecountrymobileemailuserpassword)values('.$name.''.$address.''.$area.''.$city.''.$pin.''.$state.''.$country.''.$mobile.''.$email.''.$user.''.$password.'); //echo $str; //exit; mysql_query($str); echo  location.href='welcome.php' ; } ?> Registration function validate() { if(document.getElementById(text_name).value==) { alert(Please Enter Your Name); document.getElementById(text_name).focus(); return false; } if(!(isNaN(document.registration.text_name.value))) { alert(Name has character only!); return false; } if(document.getElementById(text_address).value==) { alert(Please Enter Your Address); document.getElementById(text_address).focus(); return false; } if(!(isNaN(document.registration.text_address.value))) { alert(Address has character only!); return false; } if(document.getElementById(text_area).value==) { alert(Please Enter Your Area); document.getElementById(text_area).focus(); return false; } if(!(isNaN(document.registration.text_area.value))) { alert(Area has character only!); return false; } if(document.getElementById(text_city).value==) { alert(Please Enter Your City); document.getElementById(text_city).focus(); return false; } if(!(isNaN(document.registration.text_city.value))) { alert(City has character only!); return false; } if(document.getElementById(text_pin).value==) { alert(Please Enter Your Pin); document.getElementById(text_pin).focus(); return false; } if((isNaN(document.registration.text_pin.value))) { alert(Pin has numeric only!); return false; } if(document.getElementById(text_state).value==) { alert(Please Enter Your State); document.getElementById(text_state).focus(); return false; } if(!(isNaN(document.registration.text_state.value))) { alert(State has character only!); return false; } if(document.getElementById(text_country).value==) { alert(Please Enter Your Country); document.getElementById(text_country).focus(); return false; } if(!(isNaN(document.registration.text_country.value))) { alert(Country has character only!); return false; } if(document.getElementById(text_mobile).value==) { alert(Please Enter Your Mobile Number); document.getElementById(text_mobile).focus(); return false; } if((isNaN(document.registration.text_mobile.value))) { alert(Mobile has numeric only!); return false; } var emailPat=/^([\w-]+(?:\.[\w-]+)*)@((?:[\w-]+\.)*\w[\w-]{066})\.([a-z]{26}(?:\.[a-z]{2})?)$/i var emailid=document.getElementById(text_email).value; var matchArray = emailid.match(emailPat); if (matchArray == null) { alert(Your email address seems incorrect. Please try again.); document.getElementById(text_email).focus(); return false; } if(document.getElementById(text_user).value==) { alert(Please Enter User Name); document.getElementById(text_user).focus(); return false; } if(document.getElementById(text_pass).value==) { alert(Please Enter Your Password); document.getElementById(text_pass).focus(); return false; } if(document.getElementById(text_repass).value==) { alert(Please ReEnter Your Password); document.getElementById(text_repass).focus(); return false; } if(document.getElementById(text_repass).value!=) { if(document.getElementById(text_repass).value != document.getElementById(text_pass).value) { alert(Confirm Password doesnot match!); document.getElementById(text_repass).focus(); return false; } } return true; } User Registration Form Name * Address * Area * City * Pin * State * Country * Phone/Mobile * Email address * User Name * Password * Confirm Password * welcome.php session_start(); ?> Welcome Welcome::: '.$_SESSION[username]; ?>