php stop passing null values tp mysql

Question

i am using following code to add values

$debdes = $_POST['debdes'];
$debamt = $_POST['debamt'];
$crdes  = $_POST['crdes'];
$cramt  = $_POST['cramt'];
$date   = $_POST['date'];
include_once ("db.php");

$ucbook = "INSERT INTO cbook(debdes,debamt,crdes,cramt,date) VALUES ('$debdes','$debamt','$crdes','$cramt','$date');";

now i want that if "debamt" is filled "debdes" should not be empty and like this if "cramt" is filled then "crdes" should not be empty while pressing submit button so if some one press submit button it displays a message that say fill "debdes" first.

Tatu Ulmanen · Accepted Answer · 2010-01-03 13:55:09Z

3

What you're looking for is some basic form validation:

$debdes = $_POST['debdes'];
$debamt = $_POST['debamt'];
$crdes  = $_POST['crdes'];
$cramt  = $_POST['cramt'];
$date   = $_POST['date'];
include_once ("db.php");

$errors = array();

// Check for error conditions
if(!empty($debamt) && empty($debdes)) {
    $errors[] = 'Fill also debdes';
}

if(!empty($cramt) && empty($crdes)) {
    $errors[] = 'Fill also crdes';
}

// If no errors were found, execute the query
if(count($errors) == 0) {
    $ucbook = "INSERT INTO cbook(debdes,debamt,crdes,cramt,date) VALUES     ('$debdes','$debamt','$crdes','$cramt','$date');";
} else {
    // If there are errors, display them:
    echo implode('<br />', $errors);
}

answered Jan 3, 2010 at 13:55

Tatu Ulmanen

125k34 gold badges190 silver badges185 bronze badges

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

Comments

missingfaktor · Accepted Answer · 2010-01-05 15:34:00Z

2

On the previous form itself you can have the "submit" button trigger a javascript function as follows:-

function validate(){
    var debamt=document.*form_name*.debamt.value;
    var debdes=document.*form_name*.debdes.value;
    var error_message;
    if(debamt!=null && debdes==null){      
        error_message = 'Please fill debdes value first!!!';
    }
    var cramt=document.*form_name*.cramt.value;
    var crdes=document.*form_name*.crdes.value;
    if(cramt!=null && crdes==null){      
        error_message = '\nPlease fill crdes value first!!!';
    }
    alert(error_message);
}

edited Jan 5, 2010 at 15:34

missingfaktor

92.3k62 gold badges290 silver badges370 bronze badges

answered Jan 3, 2010 at 14:19

Nikit Batale

1,8002 gold badges15 silver badges20 bronze badges

1 Comment

Rob Over a year ago

Yes, but only in addition to server-side checking. Never rely on the client to do anything important.

antpaw · Accepted Answer · 2010-01-03 13:57:25Z

1

 if( ! empty($_POST['debdes']) && empty($_POST['debdes']))
     die('fill "debdes" first');

the same goes for cramt and crdes.

answered Jan 3, 2010 at 13:57

antpaw

16.1k11 gold badges63 silver badges94 bronze badges

Comments

Matteo Riva · Accepted Answer · 2010-01-03 14:00:00Z

1

$debdes = $_POST['debdes'];
$debamt = $_POST['debamt'];
$crdes  = $_POST['crdes'];
$cramt  = $_POST['cramt'];
$date   = $_POST['date'];

if ( !empty($debamt) && empty($debdes) ) {
    show_error('debdes');
}

if ( !empty($cramt) && empty($crdes) ) {
    show_error('drdes');
}

function show_error($string) {
    echo "Value '$string' must be filled.";
    exit;
}

include_once ("db.php");

$ucbook = "INSERT INTO cbook(debdes,debamt,crdes,cramt,date)
           VALUES ('$debdes','$debamt','$crdes','$cramt','$date');";

answered Jan 3, 2010 at 14:00

Matteo Riva

25.1k13 gold badges75 silver badges105 bronze badges

Collectives™ on Stack Overflow

php stop passing null values tp mysql

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related