Posted in PHP, SQL

PHP – The switch statement

switch ($event) {

case “TAK”:
$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ AND _FINAL = ” “;

$db = new MysqliDb(‘CES’);

$selectStatus = $db->rawQuery($sql);

break;

case “FIN”:
$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ AND _FINAL = ‘Y’ “;

$db = new MysqliDb(‘CES’);

$selectStatus = $db->rawQuery($sql);

break;

default:
echo “Fout / Fault”;

}