When executing dynamic MySQL prepared statements to INSERT or UPDATE, leading zeros (such as 0
in 0213123
) disappear. How can I prevent this?
public function update($tablo, array $column, array $form)
{
global $db;
$sutun = implode(' = ?, ', array_keys($column)) . ' = ?';
$where = implode(' = ?, ', array_keys($form)) . ' = ?';
$stmt = $this->db->prepare("UPDATE $tablo SET $sutun WHERE $where") or die($this->db->error);
$form = array_merge($column, $form);
call_user_func_array(array($stmt,'bind_param'), $this->params($form));
return $stmt->execute() or die($this->db->error);
}
public function params($params, $types = '', $input = array())
{
foreach ($params as $key => $val) {
${$key} = $val;
$input[] =& ${$key};
if (is_numeric($val) AND fmod($val, 1) === 0.00) {
$types .= 'i';
} elseif (is_float($val)) {
$types .= 'd';
} elseif (is_string($val) OR fmod($val, 1) !== 0.00) {
$types .= 's';
} else {
$types .= 'b';
}
}
array_unshift($input, $types);
return $input;
}
This appears to be the behavior of the database. The column is likely a datatype that doesn't allow leading zeros, such as INT
. Try changing that column to VARCHAR
.