I have a field (‘done’) in the Database which is boolean. The function which GET/ the rows doesn’t return a json with that field as boolean but it returns 1 or 0.
JavaScript
x
function getTasks() {
$sql = "SELECT id,task_name,done FROM tarea ORDER BY id";
try {
$db = getConnection();
$stmt = $db->query($sql);
$tasks= $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo json_encode($tasks);
} catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
How can I get THAT column (‘done’ column) as boolean? I mean, Is posible to cast a column with PDO::PARAM_BOOL ??
Here is my sample of UPDATE that inserts booleans in the database and it works perfectly:
JavaScript
function updateTask($id) {
$request = Slim::getInstance()->request();
$body = $request->getBody();
$task = json_decode($body);
$sql = "UPDATE tarea SET task_name=:task_name, done=:done WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->bindParam("task_name", $task->task_name);
$stmt->bindParam("done", $task->done,PDO::PARAM_BOOL); // cast before execute
$stmt->bindParam("id", $id);
$stmt->execute();
$db = null;
echo json_encode($task);
} catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
Advertisement
Answer
In SQL there are no booleans really, as you notice the 1
and 0
.
The right terminology is BIT
field. you should not try to modify it, if you retrieve it as 1
and 0
then you should insert it as 1
or 0
.
Also note that the JSON in the catch will produce is not valid, never build json manually. So change :
JavaScript
echo '{"error":{"text":'. $e->getMessage() .'}}';
to
JavaScript
echo json_encode(array('error'=>$e->getMessage()));