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]{2,4})+$/; 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