Problem inserting data to DB

I tried to insert data into the DB

Here is a screenshot of error message

Here is the report:

Here is the table structure:

And here is the result:

And here is the code where the error is


$stmt = $db->prepare('INSERT INTO `data`
			(username, ticket, o_time, type, size, item, o_price, s_l, t_p, c_time, c_price, profit)
			(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');


}//End for loop

And this is the code where the data is created:

if((isset($o_time) && $keywords[4]<$o_time) || !isset($o_time)===true){
			//Insert row content into array.
				//Insert relevant data into array

				$ticket =$keywords[2];
				$o_time = $keywords[4];
				$type = $keywords[6];
			    $c_time = $o_time;

				$line[$count] = array($username, $ticket, $o_time, $type, NULL, NULL, NULL, NULL, NULL, $c_time, NULL, NULL );

How do I calculate and define the size of the float number?
The code stopped where the profit is -100000.00

What is the solution ?

2 posts were merged into an existing topic: Problem when inserting data to DB