formvalidation

ishan fernando

12y1.7kPHP

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Mukherjee12y ago
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");
}

?>

Name
Address
Email
Phone
Sex
country_id
image
Shashank Srivastava12y ago
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 Reddy12y ago
write code to clear textboxes which is having false data in the form
ishan fernando12y ago
After validation, How insert correct data to database
Srikanth Reddy12y ago
http://www.w3resource.com/javascript/form/javascript-sample-registration-form-validation.php

http://stackoverflow.com/questions/8192355/javascript-validation-with-php-sample-1