我做了研究,但我就是不明白。一旦我搜索并选择所有用户的ID为"5"。它是如何存储的?
$sql = "SELECT * ID FROM Users WHERE Username = '" . $username . "'";
谢谢。我想要的是将这些存储到一个数组中然后在我的IOS程序中使用。非常感谢你的帮助!
两件事
-
查询是错误的,您所要求的,好的查询将是
SELECT * FROM Users WHERE ID = 5
-
如何获得它取决于你使用什么连接到db:
mysql:
$qry = "SELECT * FROM Users WHERE ID = 5";
$res = mysql_query($qry);
$results = array();
while( $row = mysql_fetch_assoc($res) ){
$results[] = $row;
}
With PDO its:
$qry = "SELECT * FROM Users WHERE ID = 5";
$res = $PDO->query($qry);
$results = $res->fetchAll(PDO::FETCH_ASSOC);
在这两种情况下,查询的结果是一个可以使用var_dump($results);
查看PHP手册获取更多帮助:
- MySQL API (start with mysql_connect())
- 类PDO(从构造函数开始)
首先,我不是百分之百确定,但我认为你不需要附加用户名,我认为你可以直接使用Where Username = '$username'"
$query = "SELECT * FROM Users WHERE ID = 5"; //is to select all the ids equaling 5
$allRows = $db->mysql_query($query );
while($res = $allRows->mysql_fetch_array()){
$res[0]; // can now be var_dumped or whatever
// zero is the first column in the sql row. you can replace with whatever
//column you are trying to access
}