unable to insert values into mysql table, only showing blank page. but after commenting mysql query code it's displaying echo $success part and not throwing any error message.

code:

if(!empty($_POST)) {
// keep track validation errors
$first_nameError = null;
$last_nameError = null;
$mobile_number1Error = null; 
$addressError = null;
$magent_cityError = null;

  // collect all input and trim to remove leading and trailing whitespaces
  $first_name = $_POST['first_name'];
  $last_name = $_POST['last_name'];
  $mobile_number1 = $_POST['mobile_number1'];
  $mobile_number2 = $_POST['mobile_number2'];  
  $address = $_POST['address'];
  $magent_city = $_POST['magent_city'];

        // validate input
        $valid = true;
        if (empty($first_name)) {
            $first_nameError = 'Please enter First Name';
            $valid = false;
        }

        if (empty($last_name)) {
            $last_nameError = 'Please enter Last name';
            $valid = false;
                }

        if (empty($mobile_number1)) {
            $mobile_number1Error = 'Please enter Mobile Number 1';
            $valid = false;
        }

        if (empty($address)) {
            $addressError = 'Please enter Address';
            $valid = false;
                }

        if (empty($magent_city)) {
            $magent_cityError = 'Please enter City Name';
            $valid = false;
        }                

        // insert data
        if($valid){


         include 'include/db.php'; // include the library for database connection
                  $pdo = Database::connect();

                 $sql = "INSERT INTO agentreg(firstname,lastname,mobno1,mobno2,address,city) values(?, ?, ?, ?, ?, ?)";
         $q = $pdo->prepare($sql);
         $q->execute(array($first_name,$last_name,$mobile_number1,$mobile_number2,$address,$magent_city));
         Database::disconnect();
         $success = 'Successfully Inserted';
                 }
    }

Recommended Answers

All 2 Replies

table fields
firstname,lastname,mobno1,mobno2,address,city
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.