查询在mysql中运行良好，但在PHP中运行不好 - Query is working well in mysql but not in PHP

Query is working well in mysql but not in PHP

本文关键字：运行但在 PHP mysql 查询 | 更新日期: 2023-09-27

查询在mysql中运行良好，但在php中运行不好。在php中实现内部联接后，我只得到了星期二的值。星期一和星期二有两张桌子。从星期一选择lab1，从星期二选择lab1时，只显示星期二的lab1。

附言：查询在mysql中运行。

<form action="lab.php" method="POST">
    Check routine for : <select name="new">
        <option name="lab1">LAB1</option>
        <option name="lab2">LAB2</option>
        <option name="lab3">LAB3</option>
        <option name="lab4">LAB4</option>
    </select>&nbsp&nbsp
    <input type="submit" value="Submit">
</form>

<?php
require 'conn.php';
if(isset($_POST['new'])&& !empty($_POST['new']))
{
        $lab=$_POST['new'];
        $lab=strtolower($lab);
        $result = mysql_query("select  monday.time,
        monday.$lab,tuesday.$lab from monday inner join 
        tuesday where monday.time=tuesday.time");
        echo "<table BORDER='1' width='50%' cellpadding='3'>
        <tr> 
            <th colspan='7'><h2>$lab</h2></th> 
        </tr>
        <tr> 
            <th>TIME</th>
            <th>MONDAY</th>
            <th>TUESDAY</th>
        </tr>";
        while($row = mysql_fetch_array($result))
        {   echo "<tr>";
                    echo "<td>" .$row['time']. "</td>";
                    echo "<td>" .$row[$lab]. "</td>";
                    echo "<td>" .$row[$lab]. "</td>";
            echo "</tr>";
        }
    echo "</table>";

}
?>

试试这个就行了。

 <?php
    require 'conn.php';
    if(isset($_POST['new'])&& !empty($_POST['new']))
    {
            $lab=$_POST['new']; 
            $lab=strtolower($lab);
            $result = mysql_query("select  monday.time,
            monday.$lab,tuesday.$lab as labval from monday inner join 
            tuesday where monday.time=tuesday.time") or die(mysql_error());
            echo "<table BORDER='1' width='50%' cellpadding='3'>
            <tr> 
                <th colspan='7'><h2>$lab</h2></th> 
            </tr>
            <tr> 
                <th>TIME</th>
                <th>MONDAY</th>
                <th>TUESDAY</th>
            </tr>";
            while($row = mysql_fetch_array($result))
            {   echo "<tr>";
                        echo "<td>" .$row['time']. "</td>";
                        echo "<td>" .$row[$lab]. "</td>";
                        echo "<td>" .$row['labval']. "</td>";
                echo "</tr>";
            }
        echo "</table>";

    }
    ?>