<div class="panel-body">
<?php
if (isset($_POST['submit'])) {
$caseType = $_POST['caseType'];
$typeOfReport = $_POST['typeOfReport'];
$agegroup = $_POST['agegroup'];
$sex = $_POST['sex'];
$ethnic = $_POST['ethnic'];
$adrTerminology = wildConvert($_POST['adrTerminology']);
$seriousness = $_POST['seriousness'];
$actvIngredient = wildConvert($_POST['actvIngredient']);
$prdctName = wildConvert($_POST['prdctName']);
$primRptrQuali = $_POST['primRptrQuali'];
$insType = $_POST['insType'];
$rptrState = $_POST['rptrState'];
$org = wildConvert($_POST['org']);
$Pharmacological = $_POST['Pharmacological'];
$socMeddra = $_POST['socMeddra'];
$dataSource = $_POST['dataSource'];
$source = "";
if ($dataSource == "q2") {
$source = " AND adata.dataSource = 'QUEST2' ";
} else {
if ($dataSource == "q3+") {
$source = " AND adata.dataSource IS NULL ";
}
}
$sql = "SELECT DISTINCT adata.adrFormID, adata.Adrno, adata.Source, adata.State, adata.reporter_org, adata.report_type, adata.age, adata.age_unit, adata.sex, adata.ethnic, adata.desig, adata.reporter_org\n\t\t\t\t\t\t\t\t\t\tFROM adrdata adata, adrdetail adetail, adr_druglist adruglist \n\t\t\t\t\t\t\t\t\t\tWHERE adata.adrFormID = adetail.adrFormID \n\t\t\t\t\t\t\t\t\t\tAND adata.adrFormID = adruglist.adrFormID \n\t\t\t\t\t\t\t\t\t\t{$source} ";
// SQL Input
if (!empty($caseType)) {
$sql .= " AND adata.caseType = '{$caseType}' ";
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Test</title> </head> <body> <?php include 'function.php'; $str = "gaban liao lai de"; echo(wildConvert($str)); ?> </body> </html>