Struggling with inherited PHP MVC code for a website, I encounter an issue on a specific page where unwanted code is echoed out. To prevent this, I aim to skip the echoing when a specific templateID (which I set as default) is selected. However, I'm unsure of how to construct the necessary conditional statement. As a novice developer, understanding the structure of an elseif statement proves challenging.
In my attempted solution, I created an else if statement using this query:
SELECT * FROM `template` WHERE `templateID` = 112 ORDER BY `templateID` ASC if($_GET['e']) {
$query2 = "SELECT DISTINCT templateID, name
FROM template
INNER JOIN exam ON examID = ".$_GET['e']."
WHERE active = 'Yes'
AND FIND_IN_SET(exam.type,template.templateType) > 0
ORDER BY rank ASC, name ASC;";
}
else {
$query2 = "SELECT * FROM template WHERE active = 'Yes' AND templateType LIKE '%General%' ORDER BY rank ASC, name ASC;";
}
$rows2 = $db->fetchAll($query2);
foreach($rows2 as $row2)
{
$templates .= "<option value=".$row2['templateID'].">".$row2['name']."</option>\n";
}
echo
"
<form method=POST name=Record>
<input type=hidden name=tempContents id=tempContents>
</form>
<form method=POST name=Comm id=CommForm>
<input type=hidden name=e value=\"".(int)$_GET['e']."\">
<div id=\"sendIds\"></div>
";
echo '
<table style="width:100%">
<tr>
<td style="padding-bottom: 10px;"><b>Template: </b></td>
<td style="padding-bottom: 10px;"><select name=template onChange="changeTemplate(this)">'.$templates.'</select></td>
</tr>
<tr>
<td style="padding-bottom: 10px;"><b>Subject:</b></td>
<td style="padding-bottom: 10px;"><input type=text size=50 name=subject id=subject style="width:400px"></td>
</tr>
<tr>
<td style="padding-bottom: 10px;" valign=top><b>Attachments: </b><br><br><input type=button class=button value=Add onClick="newAttachment()"></td>
<td style="padding-bottom: 10px;" valign=top><div id=fileUploads></div></td>
</tr>
<tr>
<td style="padding-bottom: 10px;"><b>Message:</b></td>
<td></td>
<tr>
<td style="padding-bottom: 10px;" colspan=2>
<textarea id="msg" name="msg" class="tinymce">
</textarea>
</td>
</tr>
</table>
';
To achieve my goal, it seems I need another conditional statement. Do I require two separate conditionals, one for the query and one for the echo? If so, how should I proceed in writing them?