通过URL中的特定ID从MySQL数据库获取数据

本文介绍了通过URL中的特定ID从MySQL数据库获取数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我是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']; } ?>