Insert Database MySQL with PHP form.

INSERT DATABASE MYSQL WITH PHP FORM

After installed PHP , MySQL and phpmyadmin now you must try how to insert database
through PHP as API. It's a basic for web programmer to create form for user login , sign up, make comments and other user's activity on your website.

First create php form using HTML form assume it named contact_form.php and put it into htdocs folder on apache server.
Note : I assume you had understood about HTML5 and CSS/CSS3.

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8"/>
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <meta name="description" content="php,form"/>

    <title>Insert Database MySQL with PHP form</title>

 <!-- CSS -->
 <style>
  body {
   font-family : arial;
  }
  
  form {
   margin : 0 auto;
   padding-top : 15px;
   max-width : 300px;
  }
  
  .form-space {
   margin-bottom : 15px;
  }
  
  input {
   border : 1px solid #999;
   height : 30px;
   width : 100%;
  }
  
  button {
   padding : 10px;
  }
  
  .error {
   color : red;
  }
 </style>
  </head>
  <body>
  
 <form method="post" action="contact-form-save.php">
      <div class="form-space">
  <div>
Your Name</div>
<input type="text" name="yourname" />
      </div>
<div class="form-space">
                <div>
Your Phone</div>
<input type="text" name="message" />
     </div>
<div class="form-space">
         <div>
Your Email</div>
<input type="text" name="yourmail" />
    </div>
<button>Submit</button>
 </form>
</body>
</html>

Then open you browser and then type 127.0.0.1/contact_form.php and it will shown like this :

Create connect_db.php file to connect between PHP and MySQL :

<?php
 $servername = "127.0.0.1";
 $username = "your_username";
 $password = "your_password";
 $db = "testingsql";
 
 $connect = new mysqli($servername, $username, $password,$db);
 
 if($connect->connect_error){
  die("Unable to connect: " . $connect->connect_error);
 } 
?>

After create the form now you should make the form work, then create contact-form-save.php.

<?php 
 include('connect_db.php');

 $name = $_POST['yourname'];
 $mail = $_POST['yourmail'];
 $message = $_POST['message'];

 $insert = $connect->query("INSERT INTO my_table_1(name,phone,email) 
  VALUES ('".$name."','".$mail."','".$message."')");
 
 if($insert){
  echo 'Your data has been stored succesfully';
 } else {
  echo 'Your data has failed to store into database';
 }
?>

Before you fill and submit your form, open your phpmyadmin and then see your previous table data on table my_table_1

Now we will fill it through PHP form :

And if you successful to insert your data into database the result will be like this :

If you open your phpmyadmin there is new record on your table :

CREATE SIMPLE FORM VALIDATION

To avoid invalid data come into our database, we need to make filter / form validation,

back to your code (contact-form-save.php) and then use this code :

<?php 
 include('connect_db.php');
 
 global $insert;
 $valid = false;
 $name = $_POST['yourname'];
 $mail = $_POST['yourmail'];
 $message = $_POST['message'];
 
 if(empty($name) && empty($mail) && empty($message)){
     echo 'Column cannot be empty';
 } else if(empty($name)){
     echo 'Column name cannot be empty';
 } else if(empty($mail)) {
            echo 'Column Email cannot be empty';
 } else if(empty($message)){
     echo 'Column Message cannot be empty';
 } else {
   $valid = true;
   $insert = $connect->query("INSERT INTO my_table_1(name,phone,email) 
  VALUES ('".$name."','".$mail."','".$message."')");
 }

 if($valid == true && $insert == true){
  echo 'Your data has been stored succesfully';
 } else if($valid == true && $insert == false) {
  echo 'Your data failed to store into database';
 }
?>

Now open contact_form.php (127.0.0.1/contact_form.php) leave it all inputs blank and then click submit here the result:

MAKE DYNAMIC FORM

Usually user won't spent their time to back into page form to make correction on incorrect form, so you need to make dynamic form so that when there is error user doesn't need to back into page form.

First back into contact_form.php and then add these codes on each label like these :

<input type="text" name="yourname" value="<?php if(isset($name)) {echo $name;} ?>" />
<div class="error" align="center">
  <?php if(isset($err_name)) {echo $err_name;} ?>
</div>
<input type="text" name="yourphone" value="<?php if(isset($phone)) {echo $phone;} ?>" />
<div class="error" align="center">
  <?php if(isset($err_phone)) {echo $err_phone;} ?>
</div>
<input type="text" name="yourmail" value="<?php if(isset($mail)) {echo $mail;} ?>" />
<div class="error" align="center">
  <?php if(isset($err_mail)) {echo $err_mail;} ?>
</div>

And on contact-form-save.php update your code like these :

<?php 
 include('connect_db.php');
 
 global $insert;
 $valid = false;
 $name = $_POST['yourname'];
 $phone = $_POST['yourphone'];
 $mail = $_POST['yourmail'];
  
 if(empty($name) && empty($phone) && empty($mail)){
  $err_name = 'Column name cannot be empty';
  $err_phone = 'Column phone cannot be empty';
  $err_mail = 'Column email cannot be empty';
  include('contact_form.php');
 } else if(empty($name) && empty($phone)){
  $err_name = 'Column name cannot be empty';
  $err_phone = 'Column phone cannot be empty';
  include('contact_form.php');
 } else if(empty($name) && empty($mail)){
  $err_name = 'Column name cannot be empty';
  $err_mail = 'Column email cannot be empty';
  include('contact_form.php');
 } else if(empty($phone) && empty($mail)){
  $err_phone = 'Column phone cannot be empty';
  $err_mail = 'Column email cannot be empty';
  include('contact_form.php');
 } else if(empty($name)){
  $err_name = 'Column name cannot be empty';
  include('contact_form.php');
 } else if(empty($phone)){
  $err_phone = 'Column phone cannot be empty';
  include('contact_form.php');
 } else if(empty($mail)){
  $err_mail = 'Column email cannot be empty';
  include('contact_form.php');
 } else {
   $valid = true;
   $insert = $connect->query("INSERT INTO my_table_1(name,email,phone) 
  VALUES ('".$name."','".$mail."','".$phone."')");
 }

 if($valid == true && $insert == true){
  echo 'Your data has been stored succesfully';
 } else if($valid == true && $insert == false) {
  echo 'Your data failed to store into database';
 }
?>

- include : to put another file in current page so that can be use / displayed other file on current page.
- global : sign / key to make your variable can be use to entire the part of file.
- $_POST : to take value from input according on name.

other documentation you can see on : https://www.w3schools.com/php/

Now, if you leave entire columns blank or one of it blank it will result :

or like this :

Next article I will show you how to display data from database, update and delete.

Insert Database MySQL with PHP form.

Comments

Post a Comment

Blog Pages List

Search This Blog

Blog Archive

Share Donation Link