<?php
require 'config.php';
if(!empty ($_POST)){
$nameError = null;
$emailError = null;
$mobileError = null;
$addressError = null;
$name = $_POST['name'];
$email_address = $_POST['email_address'];
$mobile_no = $_POST['mobile_no'];
$address = $_POST['address'];
$valid = true;
if(empty($name)){
$nameError = 'Provide Name.'
$valid = false;
}
if(empty($email_address)){
$emailError = 'Provide Email Address.'
$valid = false;
}else if(!filter_var($email_address, FILTER_VALIDATE_EMAIL)){
$emailError = 'Provide a valid Email Address.'
$valid = false;
}
if(empty($mobile_no)){
$mobileError = 'Provide Mobile Number.'
$valid = false;
}
if(empty($address)){
$addressError = 'Provide Address.'
$valid = false;
}
if($valid){
$connection=Database::connect();
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query="INSERT INTO Customers(name,email_address,mobile_no,address) values(?,?,?,?)";
$exe_query->$connection->prepare($query);
$exe_query->execute(array,($name,$email_address,$mobile_no,$address));
Database::disconnect();
}
}
?>
Asked
Active
Viewed 1,114 times
-1
-
1`$emailError = 'Provide Email Address.'` has missing `;` – viral Jun 02 '15 at 06:04
-
1as well as at the line of `$mobileError`, `$addressError`... – Raptor Jun 02 '15 at 06:05
-
Thanks you save me... – Nick Jun 02 '15 at 06:06
2 Answers
0
; is missing in most of statement
$nameError = 'Provide Name.' $emailError = 'Provide a valid Email Address.'
and more, check it

Ashwani
- 692
- 2
- 6
- 16
0
There is lots of selicolum
mistake and execute
commane mistake
The correct way
<?php
require 'config.php';
if(!empty ($_POST)){
$nameError = null;
$emailError = null;
$mobileError = null;
$addressError = null;
$name = $_POST['name'];
$email_address = $_POST['email_address'];
$mobile_no = $_POST['mobile_no'];
$address = $_POST['address'];
$valid = true;
if(empty($name)){
$nameError = 'Provide Name.';// missing selicolum
$valid = false;
}
if(empty($email_address)){
$emailError = 'Provide Email Address.';// missing selicolum
$valid = false;
}else if(!filter_var($email_address, FILTER_VALIDATE_EMAIL)){
$emailError = 'Provide a valid Email Address.';
$valid = false;
}
if(empty($mobile_no)){
$mobileError = 'Provide Mobile Number.';// missing selicolum
$valid = false;
}
if(empty($address)){
$addressError = 'Provide Address.';// missing selicolum
$valid = false;
}
if($valid){
$connection=Database::connect();
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query="INSERT INTO Customers(name,email_address,mobile_no,address) values(?,?,?,?)";
$exe_query->$connection->prepare($query);
$exe_query->execute(array($name,$email_address,$mobile_no,$address));// execute command mistake
Database::disconnect();
}
}
?>

Saty
- 22,443
- 7
- 33
- 51