Adding records to database with php using form

Question

I have made a form in which i am able to enter records into the database. But the form enters the records even if i enter nothing in them and hit 'Submit'.

Here is my code:

$sql = "INSERT INTO blog_posts (title, body) VALUES ('$post_title', '$post_body')";
if(mysqli_query($link, $sql)){
echo '<p class="sucessful">Post Added Successfully.</p>';

} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

So is it possible to make it require to fill in the forms before submitting? or show an error if submitted when the form is not filled?

Have you added any validations??

Sougata Bose
– Sougata Bose

2014-11-28 06:09:01 +00:00
Commented Nov 28, 2014 at 6:09 — Sougata Bose
– Sougata Bose, Commented Nov 28, 2014 at 6:09
@sgt i have added validation

Dark King
– Dark King

2014-11-28 06:21:06 +00:00
Commented Nov 28, 2014 at 6:21 — Dark King
– Dark King, Commented Nov 28, 2014 at 6:21

Manish Jangir · Accepted Answer · 2014-11-28 06:28:03Z

2

You can use

<?php 
    $errors = array();
    if(empty($post_title)) {
        $errors[] = "Post Title is empty";
    } else if(empty($post_body)) {
        $errors[] = "Post Body is empty";
    }

    if(!empty($errors)) {
        $sql = "INSERT INTO blog_posts (title, body) VALUES ('$post_title', '$post_body')";
        if(mysqli_query($link, $sql)){
            $errors[] = '<p class="sucessful">Post Added Successfully.</p>';
        } else{
            $errors[] = "ERROR: Could not able to execute $sql. " . mysqli_error($link);
        }
        if(!empty($mysqlErrors)) {
           foreach($mysqlErrors as $error) {
            echo $error."<br/>";
           }
        }
    } else {
        foreach($errors as $error) {
            echo $error."<br/>";
        }
    }
 ?>

edited Nov 28, 2014 at 6:28

answered Nov 28, 2014 at 6:09

Manish Jangir

5,4576 gold badges49 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dark King Over a year ago

Thank You. It works. But is there a way in which it could tell which one is empty?

Dark King Over a year ago

When i tested it without anything written, it shows an empty page. No error shown.

Collectives™ on Stack Overflow

Adding records to database with php using form

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related