|
我试图在网页上提取和显示,只有mysql数据库中的非零列.哪个列的日期是0000-00-00,我不想在网页上显示那些列.
下面分别是HTML代码和PHP脚本
<form action="search.PHP" method="post">
<p>
<lable>ENTER SO NUMBER</lable>
<input type="text" name="soid" id="soid" >
</p>
<p><button><img src="http://icons.iconarchive.com/icons/harwen/pleasant/256/Search-icon.png" height="50" />SEARCH</button></p>
</form>
</html>
PHP脚本,
<?PHP
$userinput1 = $_POST['soid'];
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "status";
$conn = new MysqLi($servername, $username, $password, $dbname);
if ($conn->connect_errno) {
printf("Connect Failed: %sn", $conn->connect_error);
exit();
}
$result = MysqLi_query($conn, "SELECT * FROM $dbname.statusinfo WHERE soid = '$userinput1' ") or die(MysqLi_error
($conn));
echo "<p><font size= 4>SO_NUMBER:$userinput1";
echo "<table border='1'>
<tr>
<style>
th{
color: blue;
}
td{
color: black;
}
</style>
<th>Sample Recived</th>
<th>Mol-Bio Extraction</th>
<th>Extraction QC</th>
<th>Library Prep</th>
<th>Library QC</th>
<th>Sequencing</th>
<th>Data Check</th>
<th>RE Sequencing</th>
<th>QC Check</th>
<th>Analysis Started</th>
<th>Analysis Completed</th>
<th>Report</th>
<th>Outbound</th>
</tr>";
while($row = MysqLi_fetch_assoc($result))
{
echo "<tr>";
echo "<br />";
echo "Department:".$row['dept'] ;
echo "<td>" . $row['samplerecived'] . "</td>";
echo "<td>" . $row['molbioextraction'] . "</td>";
echo "<td>" . $row['molbioextractionqc'] . "</td>";
echo "<td>" . $row['libraryprep'] . "</td>";
echo "<td>" . $row['libraryqc'] . "</td>";
echo "<td>" . $row['sequencing'] . "</td>";
echo "<td>" . $row['datacheck'] . "</td>";
echo "<td>" . $row['resequencing'] . "</td>";
echo "<td>" . $row['qccheck'] . "</td>";
echo "<td>" . $row['analysisstarted'] . "</td>";
echo "<td>" . $row['analysiscompleted'] . "</td>";
echo "<td>" . $row['report'] . "</td>";
echo "<td>" . $row['outbound'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>
现在我正在网页上显示所有列,我只需要那些日期记录未记录的列列.
这是MysqL表.
?我得到的输出是
我想只显示非零列.
提前致谢 解决方法: 尝试这个：
$result = MysqLi_query($conn, "SELECT * FROM $dbname.statusinfo WHERE soid = '$userinput1' AND date_column <> '0000-00-00' ") or die(MysqLi_error($conn));
虽然,使用MysqL你甚至可以这样做：
$result = MysqLi_query($conn, "SELECT * FROM $dbname.statusinfo WHERE soid = '$userinput1' AND date_column > '0000-00-00' ") or die(MysqLi_error($conn));
希望这可以帮助
编辑
我现在可以看到你想修改问题了:)
不幸的是,我不知道如何使用sql(有人可能).
您正在输出列标题,因此不输出特定列将导致它们出现在错误的列中,因此您只需要输出任何内容
这就是我在PHP中如何做到这一点. (如果我再次错过了你的观点,我可能会自己开枪:))
<?PHP
$userinput1 = $_POST['soid'];
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "status";
$conn = new MysqLi($servername, $username, $password, $dbname);
if ($conn->connect_errno) {
printf("Connect Failed: %sn", $conn->connect_error);
exit();
}
$result = MysqLi_query($conn, "SELECT * FROM $dbname.statusinfo WHERE soid = '$userinput1' ") or die(MysqLi_error($conn));
$arrayHeadings = array(
"dept" => "Department",
"samplerecived" => "Sample Recived",
"molbioextraction" => "Mol-Bio Extraction",
"molbioextractionqc" => "Extraction QC",
"libraryprep" => "Library Prep",
"libraryqc" => "Library QC",
"sequencing" => "Sequencing",
"datacheck" => "Data Check",
"resequencing" => "RE Sequencing",
"qccheck" => "QC Check",
"analysisstarted" => "Analysis Started",
"analysiscompleted" => "Analysis Completed",
"report" => "Report",
"outbound" => "Outbound",
);
?>
<style>
th{
color: blue;
}
td{
color: black;
}
</style>
<table border='1'>
<tr>
<?PHP foreach($arrayHeadings as $key => $name): ?>
<th><?= $name; ?></th>
<?PHP endforeach; ?>
</tr>
<tr>
<?PHP while($row = MysqLi_fetch_assoc($result)): ?>
<?PHP foreach($arrayHeadings as $key => $name): ?>
<?PHP if($row[$key] != "0000-00-00"): ?>
<td><?= $row[$key]; ?></td>
<?PHP else: ?>
<td></td>
<?PHP endif; ?>
<?PHP endforeach; ?>
<?PHP endwhile; ?>
</tr>
</table>
编辑
如果字段包含0000-00-00,则不输出表标题.
这依赖于一次仅输出一个元素.
<?PHP
$userinput1 = $_POST['soid'];
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "status";
$conn = new MysqLi($servername, $username, $password, $dbname);
if ($conn->connect_errno) {
printf("Connect Failed: %sn", $conn->connect_error);
exit();
}
$result = MysqLi_query($conn, "SELECT * FROM $dbname.statusinfo WHERE soid = '$userinput1' ") or die(MysqLi_error($conn));
$arrayHeadings = array(
"dept" => "Department",
"samplerecived" => "Sample Recived",
"molbioextraction" => "Mol-Bio Extraction",
"molbioextractionqc" => "Extraction QC",
"libraryprep" => "Library Prep",
"libraryqc" => "Library QC",
"sequencing" => "Sequencing",
"datacheck" => "Data Check",
"resequencing" => "RE Sequencing",
"qccheck" => "QC Check",
"analysisstarted" => "Analysis Started",
"analysiscompleted" => "Analysis Completed",
"report" => "Report",
"outbound" => "Outbound",
);
?>
<style>
th{
color: blue;
}
td{
color: black;
}
</style>
<table border='1'>
<tr>
<?PHP foreach($arrayHeadings as $key => $name): ?>
<?PHP if($row[$key] != "0000-00-00"): ?>
<th><?= $name; ?></th>
<?PHP endif; ?>
<?PHP endforeach; ?>
</tr>
<tr>
<?PHP while($row = MysqLi_fetch_assoc($result)): ?>
<?PHP foreach($arrayHeadings as $key => $name): ?>
<?PHP if($row[$key] != "0000-00-00"): ?>
<td><?= $row[$key]; ?></td>
<?PHP endif; ?>
<?PHP endforeach; ?>
<?PHP endwhile; ?>
</tr>
</table>
（编辑：北几岛）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
