Incorrect integer value:error

Question

I do have two check boxes named as Active and Require and i do have a grid as well in which i have to insert the data of this two check boxes.for that i have written the Insert statement as follows:

$myVals=$_POST;     
$fields ="question,active,req,sort_order,dtype";
$myVals["sort_order"]="";
$myVals["dtype"]="";
$sql=makeSQL($myVals,$fields,
    "INSERT INTO s_additional_data(kunnr,$fields)values("."'".$_SESSION['kunnr']."',",

but i am getting an error as Incorrect integer value: '' for column error. suggest me on this.

It might be necessary to paste at least your entire query rather than just half of it. — George
– George, Commented Nov 28, 2012 at 13:51
9 out of ten times I get that error, it is due to an empty string being handeled as an integer, but as the others say, it is not possible to help you without some more info — MortenSickel
– MortenSickel, Commented Nov 28, 2012 at 13:56

Andy Ecca · Accepted Answer · 2012-11-28 14:04:14Z

3

try

 $_POST['active'] = ($_POST['active'] == 'on') ? 1 : 0; 
 $_POST['req]' = ($_POST['req'] == 'on') ? 1 : 0;

 $myVals=$_POST;
 ////
 etc

answered Nov 28, 2012 at 14:04

Andy Ecca

1,98914 silver badges14 bronze badges

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

3 Comments

Luca Over a year ago

welcome to SO, as a generic matter - could you add some explanation to your code?

Andy Ecca Over a year ago

Hi @Luca, the reason for the previous conditional is because checkbox return "on" if is check, but no return a number.

Luca Over a year ago

thanks, my comment was just generic - it is normally better to add some explanation for anyone that might be reading your answer in the future :) you can also edit your own post rather than add it as a comment. Enjoy SO!

jeroen · Accepted Answer · 2012-11-28 13:58:50Z

0

It is hard to tell without seeing the complete sql statement and a var_dump($_POST), but most likely the problem is that there are non-checked checkboxes.

A checkbox is only sent to the server when it is checked, so if you do not check either Active or Require, you will end up with with a $myVals variable that is incomplete.

To avoid that, you can do for example (for all checkboxes, if they are supposed to be integers...):

$myVals["Active"] = isset($_POST['Active']) ? (int) $_POST['Active'] : 0;
// etc.

answered Nov 28, 2012 at 13:58

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

Comments

MrCode · Accepted Answer · 2012-11-28 14:01:11Z

0

You are hard coding sort_order as a blank string:

$myVals["sort_order"]="";

I think this is the problem, I think your sort_order column is an int, so it's trying to put a blank string into the int column, as the error suggests.

Set it to 0 or some other integer:

$myVals["sort_order"] = 0;

answered Nov 28, 2012 at 14:01

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

Collectives™ on Stack Overflow

Incorrect integer value:error

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related