PHP，我该如何让它工作 [英] PHP, how do I get this to work

问题描述

<td>
        <h4>To view discounts, simply select from a category below.</h4><br />
        <!-- List Category Box -->

        <?php
        $db = new mysqli('50.62.209.81:3306','user','password','MassWarVetsADM');
        $query="SELECT Category FROM Category";
        $result = mysql_query ($query);
        echo "<select name='categoriesSelect' class='e1'><option value='0'>Please Select A Category</option>";

        // printing the list box select command
        while($categoryinfo=mysql_fetch_array($result)){//Array or records stored in $nt
        echo "<option value=\"".htmlspecialchars($categoryinfo['category'])."\">".$categoryinfo['category']."</option>";
        }
        echo"</select>";
        ?>

当我在firefox中查看我的页面时，我得到了这个：http://i62.tinypic.com/2eqc22v.png [ ^ ]



出于安全原因，我删除了用户名& pw。我究竟做错了什么？



这应打印选择框内MassWarVetsADM数据库内类别表中类别列中列出的业务类别。大约有30个类别。

When I look at my page in firefox I get this: http://i62.tinypic.com/2eqc22v.png[^]

I removed the username&pw for security reasons. What am I doing wrong?

This should print the business categories listed in the "Category" column within the "Category" table inside the "MassWarVetsADM" database inside a select box. There is about 30 categories.

推荐答案

db = new mysqli（'50 .62.209.81：3306'，'user'，'password'，'MassWarVetsADM'）;

db = new mysqli('50.62.209.81:3306','user','password','MassWarVetsADM');

query =SELECT Category FROM Category;

query="SELECT Category FROM Category";

result = mysql_query（

result = mysql_query (

这篇关于PHP，我该如何让它工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！