dpwuvfpu52502 2015-04-21 06:51
浏览 228
已采纳

如果值为null,则跳过插入查询Mysql

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']."');";`
  • 写回答

3条回答 默认 最新

  • dsakktdog498483070 2015-04-21 06:54
    关注

    Just add a check -

    if (!empty($data['kids'])) {
        // run the query
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?