Decimal Value not accepted on MySQL insert

Question

When trying to do a simple insert in PHP to MySQL database, a value of '.5' is entered into the hours variable and is being ignored and set to 0 in the database. I've tried with the db datatype set to float or decimal. Neither work.

Here is my insert code:

$sql ="INSERT INTO timecarddetails (timecardId, tdate, hours, ot, ticketNumber, km, details) 
            VALUES (?,?,?,?,?,?,?)";
$stmt = $conn->prepare($sql);
if($stmt === false){
    trigger_error('Wrong SQL: ' .$sql. ' Error: ' . $conn->error, E_USER_ERROR);
}
$stmt->bind_param('isiisis',$tcId,$JOBDATE[$key],$HOURS[$key],$OT[$key],$TICKET[$key],$KM[$key],$DETAILS[$key]);
$stmt->execute();

When I do a print of the sql statement it comes out like this:

INSERT INTO timecarddetails (timecardId, tdate, hours, ot, ticketNumber, km, details) VALUES (24,2019-11-04,.5, , 2019450202,,Dispatched ticket)

Below is my table structure:

Is there anything wrong with my syntax? If you need any further information, please let me know. Thanks in advance for helping!

GMB · Accepted Answer · 2019-11-20 21:09:47Z

3

$stmt->bind_param('isiisis', ...

i stands for integer values. For decimals, you need d.

Considering your table structure, you likely want:

$stmt->bind_param(
    'isddsds',
    $tcId,
    $JOBDATE[$key],
    $HOURS[$key],
    $OT[$key],
    $TICKET[$key],
    $KM[$key],
    $DETAILS[$key]
);

answered Nov 20, 2019 at 21:09

GMB

224k25 gold badges103 silver badges151 bronze badges

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

2 Comments

jd0117 Over a year ago

Thank you...quite the simple oversight!

GMB Over a year ago

Welcome @jd0117! Glad that it helped.

Collectives™ on Stack Overflow

Decimal Value not accepted on MySQL insert

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related