如何从特定 id 的 sql 中正确获取国家和其他信息 [英] how correctly get country and other info from sql for specific id

问题描述

我试图从特定 id 的 sql 获取国家和其他信息，在这两种情况下，只有id"正确显示.

和

 0) {while($rows = mysql_fetch_assoc($result)) {回声 $id;回声$国家；}}?>

解决方案

我认为您有一个名为 id 的列和另一个命名的国家/地区，您希望从中收集某个记录的国家/地区行中的数据.我对一些评论有类似的想法，并想在这个答案中强调我的想法.

1. $_GET superglobal 用于从 URL 参数中提取数据.如果它用于从记录中获取数据，您可能需要使用 mysql_fetch_assoc($result)[country"].更多信息请查看https://www.php.net/manual/en/function.mysql-fetch-assoc.php和 https://www.w3schools.com/php/php_superglobals_get.asp>

2. 要根据某些输入 id 过滤某些记录，您需要使用 WHERE 子句.更多信息链接:- https://www.w3schools.com/sql/sql_where.asp可能的代码可能是:-

<?php$id = $_GET["id"]$sql = "SELECT * FROM `list` WHERE id='$id' ORDER BY category ASC";$result = mysql_query($sql);如果 (mysql_num_rows($result) > 0) {while($rows = mysql_fetch_assoc($result)) {回声 $rows['id'];回声 $rows['country'];}}?>

PS:如果提供的信息较少，我已尽力回答所提出的问题.希望有帮助

I am trying to get country and other info from sql for specific id, only "id" displays correctly in both cases.

<?php
    $sql = "SELECT * FROM `list`  ORDER BY category ASC";
    $result = mysql_query($sql);
    $rows = mysql_fetch_assoc($result);      
    $id = $_GET['id'];
    $country = $_GET['country'];

    echo $id;
    echo $country;  
?>

and

<?php
    $sql = "SELECT * FROM `list`  ORDER BY category ASC";
    $result = mysql_query($sql);
    $id = $_GET['id'];
    $country = $_GET['country'];

    if (mysql_num_rows($result) > 0) {
    while($rows = mysql_fetch_assoc($result)) {

    echo $id;
    echo $country;  
    }
    } 
?>

解决方案

I think you have a column named id and another named country from which you want to collect the data in the country row of a certain record. I have similar ideas to some of the comments and would like to highlight my thoughts in this answer.

1. $_GET superglobal is used to extract data form a URL parameter. If it is used to get the data from the record, you might want to use mysql_fetch_assoc($result)["country"]. For more information, please take a look at https://www.php.net/manual/en/function.mysql-fetch-assoc.php and https://www.w3schools.com/php/php_superglobals_get.asp

2. To filter certain records according to some input id, you would want to use the WHERE clause. Link for more information:- https://www.w3schools.com/sql/sql_where.asp The possible code might be:-

<?php
$id = $_GET["id"]
$sql = "SELECT * FROM `list` WHERE id='$id' ORDER BY category ASC";
$result = mysql_query($sql);

if (mysql_num_rows($result) > 0) {
    while($rows = mysql_fetch_assoc($result)) {
        echo $rows['id'];
        echo $rows['country'];  
    }
} 
?>

PS: I have tried my best to answer the asked question provided the less information given. Hope it helps

这篇关于如何从特定 id 的 sql 中正确获取国家和其他信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！