if ($fda_num != 0) {
$fda_label = "(FDA pharmacogenomic biomarker)";
}
$drug_info = $row3['info'];
if ($file_code == "example") {
$split_drug_s = strpos(str_replace(array("\"", "\\'"), "", $row3['Drug']), "--");
//获取drug的长度
$drug_name = substr(str_replace(array("\"", "\\'"), "", $row3['Drug']), 0, $split_drug_s);
} else {
$drug_name = $row3['Drug'];
}
$drug_name1 = strtolower($drug_name);
$drug_name2 = ucfirst($drug_name1);
//$pdf->AddPage();
$pdf->Bookmark($drug_name2 . $fda_label, 2, 0, '', 'I', array(0, 128, 0));
$pdf->writeHTML('<h1>' . $drug_name2 . $fda_label . '</h1>', true, false, true, false, '');
$pdf->writeHTML('' . '<br>' . $drug_info . '<br>', true, false, true, false, '');
$sql4 = "select * from {$file_code} where System like '%{$tmp_system_name}%' and subSystem like '%{$tmp_subsystem_name}%' and Drug LIKE '%{$tmp_drug_name}%'";
$res4 = mysql_query($sql4);
$pdf->writeHTML('
<h3>Your genetic data</h3>
<table cellpadding="0" cellspacing="0">
<hr size="590" color="#999999">
<tr>
<td width="80" align="center">SNPs ID</td>
<td width="110" align="center">Evidence level</td>
<td width="80" align="center">Gene</td>
<td width="110" align="center">Your genotype</td>
<td width="70" align="center">Efficacy</td>
<td width="70" align="center">Dosage</td>
<td width="70" align="center">Toxicity</td>
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
// set font
$pdf->SetFont('helvetica', '', 10);
$tmp_system_name = "tmp";
$tmp_subsystem_name = "tmp";
$tmp_drug_name = "tmp";
$sql1 = "select * from example order by System";
$res1 = mysql_query($sql1) or die(mysql_error());
while ($row1 = mysql_fetch_array($res1)) {
if ($tmp_system_name != $row1['System']) {
$tmp_system_name = $row1['System'];
$pdf->AddPage();
$pdf->Bookmark(ucfirst(strtolower($tmp_system_name)), 0, 0, '', 'B', array(0, 64, 128));
$pdf->writeHTML('<h1>' . ucfirst(strtolower($tmp_system_name)) . '</h1>', true, false, true, false, '');
$sql2 = "select * from example where System like '%{$tmp_system_name}%' order by subSystem";
$res2 = mysql_query($sql2);
while ($row2 = mysql_fetch_array($res2)) {
if ($tmp_subsystem_name != $row2['subSystem']) {
$tmp_subsystem_name1 = $row2['subSystem'];
if ($row2['subSystem'] == "") {
$tmp_subsystem_name1 = "Unclassified";
}
//$pdf->AddPage();
$tmp_subsystem_name = $row2['subSystem'];
$pdf->Bookmark(ucfirst(strtolower($tmp_subsystem_name1)), 1, 0, '', '', array(128, 0, 0));
$pdf->writeHTML('<h2>' . ucfirst(strtolower($tmp_subsystem_name1)) . '</h2>', true, false, true, false, '');
$sql3 = "select * from example where System like '%{$tmp_system_name}%' and subSystem like '%{$tmp_subsystem_name}%' order by Drug";
$res3 = mysql_query($sql3);
while ($row3 = mysql_fetch_array($res3)) {
