通过URL中的特定ID从MySQL数据库获取数据 [英] Get data from MySQL database by specific id in url

问题描述

我是PHP MySQL的新手.我正在开发一个歌本网站.

Im new to PHP MySQL. Im developing a songbook site.

我正在尝试从URL site/publicsong.php?id=12中的ID中提取数据库中的数据.

I'm trying to pull data in a database from the ID in the URL site/publicsong.php?id=12.

    <?php


// Create connection
$conn = new mysqli($servername = "localhost";$username = "dansdlpe_dan";$password = "g+GbMr}DU4E@";$db_name = "dansdlpe_lyrics";);

// Check connection
$db_name = "dansdlpe_lyrics";
mysqli_select_db($conn,$db_name);

$id = $_GET['id'];
$id = mysqli__real_escape_string($conn,$id);
$query = "SELECT * FROM `lyrics_a` WHERE `id`='" . $id . "'";
$result = mysqli__query($conn,$query);

echo $row['id']; while($row = mysqli__fetch_array( $result )) {

echo "<br><br>";
echo $row['eng_title'];
echo $row['eng_lyrics'];
echo $row['alphabet'];
}
?>

我将mysql_更改为mysqli_并添加了$ conn.

I changed mysql_ to mysqli_ and added $conn.

仍然我的结果是空白.请帮助大家.预先感谢.

And still i result is blank. Please help guys. Thanks in advance.

推荐答案

因此，我将通过一些修复来坚持您已经拥有的内容.

So I will stick to what you already have with some fixes.

<?php
error_reporting(E_ALL); 
ini_set('display_errors', 1);
$servername = "localhost";
$username = "xxxx";
$password = "xxxxxx";
$db_name = "xxxxxxxxx";

// Create connection
$conn = new mysqli($servername, $username, $password, $db_name);
// Check connection
if ($conn->connect_error){
  die("Connection failed: " . $conn->connect_error);
} 
$id = $_GET['id'];
$id = mysqli_real_escape_string($conn,$id);
$query = "SELECT * FROM `lyrics_a` WHERE `id`='" . $id . "'";
$result = mysqli_query($conn,$query);

while($row = mysqli_fetch_array($result)) {
echo "<br><br>";
echo $row['id'];
echo $row['eng_title'];
echo $row['eng_lyrics'];
echo $row['alphabet'];
}
?>

这篇关于通过URL中的特定ID从MySQL数据库获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！