Check Fields are filled otherwise display error in php

Question

in this i have to check if in fields data is fields then it submit otherwise it can display error with if statements

   <?php
include("config.php");
    $name=$_POST["name"];
    $email=$_POST["email"];
    $phone=$_POST["phone"];
    $budget=$_POST['budget'];
        $insert_query="insert into form(name,email,phone,budget) values ('$name','$email','$phone','$budget')";
        $con=mysql_query($insert_query);

   ?>

this code have Sqlinjection bug.!!! :) – Mahmoud.Eskandari Feb 18 '14 at 13:13 — Mahmoud.Eskandari, Feb 18 '14 at 13:13

score 2 · Answer 1 · answered Feb 18 '14 at 13:14

2

take a look at empty() function http://php.net/empty

if (empty($_POST["name"])) {
     die('name is empty');
}

answered Feb 18 '14 at 13:14

Amir Bar

3,007
2
29
47

i have to do this for all fields – user3292597 Feb 18 '14 at 13:18
each field you dont want to be empty you need to check if its empty.. very simple – Amir Bar Feb 18 '14 at 13:24

score 0 · Answer 2 · answered Feb 18 '14 at 13:20

Consider the following...

thispage.php

<?php

$name = (empty($_GET['name'])) ? "Fred" : $_GET['name'];

echo $name;

?>

thispage.php = 'Fred'

thispage.php?Wilma = 'Wilma'

And usual caveats about sql injection, prepared statements, deprecated methods, etc.

score -1 · Answer 3 · answered Feb 18 '14 at 13:16

-1

First you MUST clean post fields before writing in db. Use function mysql_real_escape_string($var) And second, you can check field data with function empty, for example:

if (!empty($_POST["name"])) {
    $name = mysql_real_escape_string($_POST["name"]);
    // your query
} else {
    echo 'Name is empty!';
}

answered Feb 18 '14 at 13:16

LONGMAN

980
1
14
24

i have to do this for all fields – user3292597 Feb 18 '14 at 13:20
mysql_ methods are deprecated. We probably should not be promoting their use! – Strawberry Feb 18 '14 at 13:22
We must promote mysqli functions, but mysqli support is not exists on some servers – LONGMAN Feb 18 '14 at 13:24

Check Fields are filled otherwise display error in php

3 Answers3