formvalidation

Question

How to validate form (created using html) and include it data to database? I want validate using jscript and insert data using php.

Sachin Mukherjee · Answer

include(config.php); if($_SESSION['user_type'] != admin){ header(location:index.php); } if($_POST['hd_add']==yes) { $insert_query = mysql_query(insert into user set name='.$_POST['name'].' address='.$_POST['address'].' email='.$_POST['email'].' phone='.$_POST['phone'].' sex='.$_POST['sex'].' country_id='.$_POST['country_id'].' ) or die(mysql_error()); header(location:index.php); } ?> function validation(){ var x= document.getElementById(name).value; if(x == ) { alert(Name is mandatory.); document.getElementById(name).focus(); document.getElementById(name).style.backgroundColor='red'; return false; } else if(document.getElementById(address).value == ) { alert(Address is mandatory.); document.getElementById(address).focus(); document.getElementById(address).style.backgroundColor='red'; return false; } else if(document.getElementById(email).value == ) { alert(Email is mandatory.); document.getElementById(email).focus(); document.getElementById(email).style.backgroundColor='red'; return false; } else if(document.getElementById(email).value != ) { var email = document.getElementById('email'); var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{24})+$/; if (!filter.test(email.value)) { alert('Please provide a valid email address'); document.getElementById(email).style.backgroundColor='red'; return false; } }else{ return true; } }  method=post enctype=multipart/form-data onsubmit=return validation();> Name Address Email Phone Sex country_id image

Shashank Srivastava · Answer

index.html insert.php $user = $_POST['user']; $pass = $_POST['pass']; $email = $_POST['email']; $host = localhost; $username = root; $password = ; $db = database_name; $connect = mysqli_connect($host $username $password $db); if(!$connect) echo could not connect; else { $query = INSERT INTO table_name (username_column password_column email_column) VALUES ($user $pass $email); $result = mysqli_query($connect $query); if(!$result) echo could not insert; else echo record inserted; } mysqli_close($connect); ?> I hope it helps.

Srikanth Reddy · Answer

write code to clear textboxes which is having false data in the form

ishan fernando · Answer

After validation How insert correct data to database

Srikanth Reddy · Answer

http://www.w3resource.com/javascript/form/javascript-sample-registration-form-validation.php http://stackoverflow.com/questions/8192355/javascript-validation-with-php-sample-1