duanjiushu5063 2014-06-02 14:49
浏览 22
已采纳

使用php从mysql数据库中提取信息[关闭]

I'm attempting to search a mysql database based on criteria entered by the user. The script here is attempting to pull an entry based on the product key. But, when I search for a key that I know exists in the table, nothing is returned. I am extremely new to php so this code could be completely wrong. This is my code:

<!DOCTYPE html PUBLIC "-//w3c//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="../css/style.css">

<title>
Inventory Home Page
</title>

<body>
<?php
    $link = mysqli_connect("localhost", "myaccount", "mypass", "Inventory");
    mysql_select_db("db_test", $link);
if(!$link){
    die ("Could not connect: " . mysql_error($link));
}

    $productKey = %product_key_search%;
    $query = mysql_query("select * from PC where pk=$productKey") or die(mysql_error($link));

    while($row=mysql_fetch_array($query)){
        echo 'Product Key: ' .$row['pk'];
        echo 'Make: ' .$row['make'];
        echo 'Model: ' .$row['model'];
        echo 'Type: ' .$row['type'];
        echo 'Content: ' .$row['content'];
        echo 'Status: ' .$row['status'];
        echo 'Workstation: ' .$row['asset'];
        echo 'Steam Account Number: ' .$row['steam_acct_num'];

    }

?>
</body>
</html> 

Please help..

  • 写回答

3条回答 默认 最新

  • dongxing6802 2014-06-02 14:55
    关注

    Try like this.

    <!DOCTYPE html PUBLIC "-//w3c//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <link rel="stylesheet" type="text/css" href="../css/style.css">
    
    <title>
    Inventory Home Page
    </title>
    
    <body>
    <?php
        $link = mysql_connect("localhost", "myaccount", "mypass", "Inventory");
        mysql_select_db("db_test", $link);
    if(!$link){
        die ("Could not connect: " . mysql_error($link));
    }
    
       $statement = "select * from PC where pk LIKE %".$productKey."%";
        $query = mysql_query( $statement) or die(mysql_error($link));
    
        while($row=mysql_fetch_array($query)){
            echo 'Product Key: ' .$row['pk'];
            echo 'Make: ' .$row['make'];
            echo 'Model: ' .$row['model'];
            echo 'Type: ' .$row['type'];
            echo 'Content: ' .$row['content'];
            echo 'Status: ' .$row['status'];
            echo 'Workstation: ' .$row['asset'];
            echo 'Steam Account Number: ' .$row['steam_acct_num'];
    
        }
    
    ?>
    
    </body>
    </html> 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题