<p>我已从 MSSQL 服务器表中检索数据。 由于查询，我能够显示它们。 我希望能够在不接触表格的情况下修改这些数据</p> <p>例如，enc_paye 的值为 1 时将显示（“订单准备中”）和 enc_prepared（订单准备就绪）</p> <p>我还想知道是否可以从表中删除文本并仅恢复数据。</p> <pre class="brush:php;toolbar:false;">&lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; &lt;meta charset=&quot;utf-8&quot;&gt; &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot;&gt; &lt;title&gt;Espace Client&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;center&gt;&lt;div class=&quot;Informations&quot;&gt; &lt;?php //CONNEXION ODBC SERVER// $dsn=&quot;&quot;; $user=&quot;&quot;; $password=&quot;&quot;; $conn=odbc_connect($dsn,$user, $password); //REQUETES $sql = &lt;&lt;&lt;EOF SELECT top 10 [enc_cmd_num], [enc_paye], enc_prepared, enc_emporte, enc_heure_fab_fin, enc_ext_ref FROM [encaissement] WHERE enc_date= '20221130' EOF; $results = odbc_exec($conn,$sql); odbc_result_all($results); //CONDITION echo &quot;&lt;table&gt;&quot;; while($resultrow = odbc_fetch_array($results)) { switch($resultrow['enc_paye']){ case 0: echo &quot;Commande en attente paiement&quot;; break; case 1: echo &quot;Commande en cours de préparation&quot;; break; default: echo &quot;&lt;td&gt;Unknown&lt;/td&gt;&quot;; } } echo &quot;&lt;/table&gt;&quot;; ?&gt; &lt;/div&gt;&lt;/center&gt;</pre>

$ODBCcontent = odbc_fetch_array($results);

0 - "Order received"
1 - "Order in preparation"
2 - "Order ready"
3 - "Order dispatched"

echo "<table>";
while($resultrow = odbc_fetch_array($results)) {
    echo "<tr>";
    switch($resultrow['enc_paye']){
        case 0:
            echo "<td>Order received</td>";
            break;
        case 1:
            echo "<td>Order in preparation</td>";
            break;
        case 2:
            echo "<td>Order completed</td>";
            break;
        case 3:
            echo "<td>Order dispatched</td>";
            break;
        default: echo "<td>Unknown</td>";
    }
    // print some other fields in table data fields
   echo "</tr>";
}
echo "</table>";