if ($stmtMoreInformations->execute()) {
$stmtUpdateMoreInformations = $conn->prepare("UPDATE menu SET only_delivery = :delivery, card_on_delivery = :delivery,
wifi = :wifi, live_music = :music, open_holiday = :holiday,
acessible = :acessible
WHERE menu_id = :menu");
$stmtUpdateMoreInformations->bindValue(":menu", $menu);
}
I have this update and my variables are returning 1 or 2, I want to force them to return true or false , can I use cast ? How could I use it?
$menu = $_POST['menu'];
$delivery = null;
if (isset($_POST['delivery'])) {
$delivery = $_POST['delivery'];
}
$cards = null;
if (isset($_POST['cards'])) {
$cards = $_POST['cards'];
}
$wifi = null;
if (isset($_POST['wifi'])) {
$wifi = $_POST['wifi'];
}
$music = null;
if (isset($_POST['music'])) {
$music = $_POST['music'];
}
$holiday = null;
if (isset($_POST['holiday'])) {
$holiday = $_POST['holiday'];
}
$acessible = null;
if (isset($_POST['acessible'])) {
$acessible = $_POST['acessible'];
}
$stmtMoreInformations = $conn->prepare("SELECT only_delivery, card_on_delivery, wifi, live_music,
open_holiday, acessible FROM public.menu
WHERE menu_id = :menu");
$stmtMoreInformations->bindValue(":menu", $menu);
if ($stmtMoreInformations->execute()) {
$stmtUpdateMoreInformations = $conn->prepare("UPDATE menu SET only_delivery = :delivery, card_on_delivery = :card,
wifi = :wifi, live_music = :music, open_holiday = :holiday,
acessible = :acessible
WHERE menu_id = :menu");
$stmtUpdateMoreInformations->bindValue(':menu', $menu);
$stmtUpdateMoreInformations->bindValue(':delivery', $delivery);
$stmtUpdateMoreInformations->bindValue(':card', $cards);
$stmtUpdateMoreInformations->bindValue(':wifi', $wifi);
$stmtUpdateMoreInformations->bindValue(':music', $music);
$stmtUpdateMoreInformations->bindValue(':holiday', $holiday);
$stmtUpdateMoreInformations->bindValue(':acessible', $acessible);
$stmtUpdateMoreInformations->execute();
echo'delivery: '.$delivery;
echo'card: '.$cards;
echo'wifi: '.$wifi;
echo'music: '.$music;
echo'd: '.$holiday;
}