时间戳

首页 > 解决方案 > 我已经在 wordpress/php 中成功查询了我的数据库，但是当我尝试在表格中显示结果时它只是显示为空白

php - 我已经在 wordpress/php 中成功查询了我的数据库，但是当我尝试在表格中显示结果时它只是显示为空白

问题描述

对于我的网站，我正在进行参数搜索以过滤 100 个电源、按电压过滤等。当我在本地执行此操作时，它工作得很好，但是在将它实施到 wordpress 时我正在苦苦挣扎，这是我下面的代码输出/查询，我知道它有很多 if 语句来构建查询，任何改进也非常感谢。

<html>
<?php
$voltage=$_POST["MaxVoltage"];
    $sql = "SELECT * FROM powersupplies WHERE MaxVoltage >= '".$voltage."'";
    
    if (!empty($_POST["MaxCurrent"])){
        $current=$_POST["MaxCurrent"];
        $currentquery = " AND MaxCurrent >= '".$current."'";
        $sql = $sql.$currentquery;
    } 
    if (!empty($_POST["Make"]) && ($_POST["Make"] != "Any")){
        $make=$_POST["Make"];
        $makequery = " AND Make = '".$make."'";
        $sql = $sql.$makequery;
    } 
    if (!empty($_POST["MaxPower"])){
        $power =$_POST["MaxPower"];
        $powerquery = " AND MaxPower >= '".$power."'";
        $sql = $sql.$powerquery;
    } 
    if (isset($_POST["Programmable"]) && ($_POST["Programmable"] != "Any")){
        $programmable =$_POST["Programmable"];
        $programmablequery = " AND Programmable = '".$programmable."'";
        $sql = $sql.$programmablequery;
    } 
    if (isset($_POST["Negative"])&& ($_POST["Negative"] != "Any")){
        $negative =$_POST["Negative"];
        $negativequery = " AND Negative = '".$negative."'";
        $sql = $sql.$negativequery;
    } 
    if (isset($_POST["Positive"])&& ($_POST["Positive"] != "Any")){
        $positive =$_POST["Positive"];
        $positivequery = " AND Positive = '".$positive."'";
        $sql = $sql.$positivequery;
    } 
    if (isset($_POST["Bipolar"])&& ($_POST["Bipolar"] != "Any")){
        $bipolar =$_POST["Bipolar"];
        $bipolarquery = " AND Bipolar = '".$bipolar."'";
        $sql = $sql.$bipolarquery;
    } 
    if (isset($_POST["Floating"])&& ($_POST["Floating"] != "Any")){
        $floating =$_POST["Floating"];
        $floatingquery = " AND Floating = '".$floating."'";
        $sql = $sql.$floatingquery;
    } 
    if (isset($_POST["Topology"])&& ($_POST["Topology"] != "Any")){
        $topology =$_POST["Topology"];
        $topologyquery = " AND Topology = '".$topology."'";
        $sql = $sql.$topologyquery;
    } 
        $sql = $sql.";";
        $result = $wpdb->get_results($sql, ARRAY_A);
    if ($wpdb->last_error) {
      echo 'You done bad! ' . $wpdb->last_error;
    }
    echo count($result)." results have been found";
    echo "<table>"
    foreach ($result as $row){
        echo "<tr><td>" . $row["PartNumber"]. 
                "</td><td>" . $row["MaxVoltage"] . 
                "</td><td>" . $row["MaxPower"]. 
                "</td><td>". $row["MaxCurrent"] . 
                "</td><td>". $row["Programmable"] . 
                "</td><td>". $row["Negative"] . 
                "</td><td>". $row["Positive"] . 
                "</td><td>". $row["Bipolar"] . 
                "</td><td>". $row["Floating"] . 
                "</td><td>". $row["Topology"] . 
                "</td><td>". $row["Make"] . 
                "</td></tr>";
    }
    echo "</table>"
?>
</html>

标签： phphtmlwordpress

解决方案

推荐阅读