如何从MYSQL数据库中检索特定ID的详细信息 [英] How to retrieve details for a particular id from MYSQL database

问题描述

根据URL中id的值从数据库中获取数据。

Getting data from the database depending on the value of the id in the URL.

$id= $_GET['id'];
$strSQL = "SELECT * FROM people WHERE id='$id'";
$rs = mysql_query($strSQL);

这是可行的，但它显示的是空白页面。

This is working, But it's displaying a blank page.

我该如何解决？

推荐答案

正如我在原始评论中提到的：

As I mentioned in my original comment:

您需要使用循环才能获取数据，然后回显它。

其他人给了您示例，但不使用您现在的方法，这是PDO方法：

Others have given you examples and not to use your present method, here is a PDO method:

<?php
$mysql_hostname = 'xxx';
$mysql_username = 'xxx';
$mysql_password = 'xxx';
$mysql_dbname = 'xxx';

$id = $_GET['id'];

try {

$pdo= new PDO("mysql:host=$mysql_hostname;dbname=$mysql_dbname", $mysql_username, $mysql_password); 
     $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
     exit( $e->getMessage() );
}


try {

$stmt = $pdo->prepare('SELECT * FROM people WHERE id = :id');
$stmt->bindParam(':id', $id);
$stmt->execute();

} catch (PDOException $e) {
     echo $e->getMessage();
}

/* optional method
foreach($stmt as $row) {
      echo $row['id'] . ' ' . $row['name'] . ' ' . $row['email'];
}
*/

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  $id = $row['id'];
  $n = $row['name'];
  $e = $row['email'];
}

echo $id;
echo "<br>";
echo $n;
echo "<br>";
echo $e;

?>

---

另一种PDO方法：

---

Another PDO method:

<?php
$mysql_hostname = 'xxx';
$mysql_username = 'xxx';
$mysql_password = 'xxx';
$mysql_dbname = 'xxx';

$id = $_GET['id'];

// $id= 4; // my own test id number

try {

$pdo= new PDO("mysql:host=$mysql_hostname;dbname=$mysql_dbname", $mysql_username, $mysql_password); 
     $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
     exit( $e->getMessage() );
}

try {
     $sql = "SELECT * FROM people WHERE id='$id'";
     $results = $pdo->query($sql);

} catch (PDOException $e) {
     echo $e->getMessage();
}

/* optional method
foreach($results as $row) {
      echo $row['id'] . ' ' . $row['name'] . ' ' . $row['email'];
}
*/

while ($row = $results->fetch(PDO::FETCH_ASSOC)) {
  $id = $row['id'];
  $n = $row['name'];
  $e = $row['email'];
}

echo $id;
echo "<br>";
echo $n;
echo "<br>";
echo $e;

?>

这篇关于如何从MYSQL数据库中检索特定ID的详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！