Skip insert query if a value is null Mysql

Question

Hi i have a table with different fields and i make an insert query and i want to skip the insert query if a value is null in one of the fields. Example

Table
id    name    surname    kids
1     john      doe       2
2     mary      jones     3

and i want if the new insert has no value in the field kids to skip that entry. is there a possible way to check that?` the code i have is this

INSERT INTO `clients`.`kids` (`id`, `name`,`surname`,`kids`) VALUES (NULL,'".$data['name']."','".$data['surname']."','".$data['kids']."');";`

Please make kids field NOT NULL in DB

Kailash Yadav
– Kailash Yadav

2015-04-21 06:54:02 +00:00
Commented Apr 21, 2015 at 6:54 — Kailash Yadav
– Kailash Yadav, Commented Apr 21, 2015 at 6:54
Try if(!empty($data['kids'])){//your code}

Narendrasingh Sisodia
– Narendrasingh Sisodia

2015-04-21 06:54:50 +00:00
Commented Apr 21, 2015 at 6:54 — Narendrasingh Sisodia
– Narendrasingh Sisodia, Commented Apr 21, 2015 at 6:54

Sougata Bose · Accepted Answer · 2015-04-21 06:59:51Z

2

Just add a check -

if (!empty($data['kids'])) {
    // run the query
}

edited Apr 21, 2015 at 6:59

answered Apr 21, 2015 at 6:54

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

Comments

Umair Ayub · Accepted Answer · 2015-04-21 06:55:47Z

0

You asked to skip only if there is no Kids entered

if (!empty($data['kids'])) {
    //  query
}

answered Apr 21, 2015 at 6:55

Umair Ayub

21.7k14 gold badges82 silver badges154 bronze badges

Comments

Benjamin · Accepted Answer · 2015-04-21 06:58:37Z

0

You can check like This :

if(!empty($data['kids']) && isset($data['kids']))
 {
       // Write your code here 
 }

answered Apr 21, 2015 at 6:58

Benjamin

2,3061 gold badge17 silver badges24 bronze badges

1 Comment

Narendrasingh Sisodia Over a year ago

If I'm not wrong then Please Correct me. !empty itself check both conditions is variable set or not and is variable is not empty. So within your code does isset function make any difference

Collectives™ on Stack Overflow

Skip insert query if a value is null Mysql

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related