如何显示数据库中的数据 [英] How to display data from a database

问题描述

我已成功创建了一个连接到我的数据库的PHP脚本。当用户输入他们的电子邮件地址时，我想在数据库的相同页面上显示与该电子邮件地址相关的一些信息。我想要显示的数据库字段是：名称，跟踪，状态。

I have successfully created a PHP script which connects to my database. When the user types in their email address I want to display some information on the same page from the database relating to that email address. The database fields that I want to display are: name, tracking, status.

我的问题是如何显示这些信息。我知道我有底部的代码，如果登录成功，我不再需要重定向到页面。

My question is how can I display this information. I know I have code at the bottom which redirects to a page if login successful which iI no longer want.

PHP脚本：

PHP Script:

<?php

$host="######"; // Host name 
$username="######"; // Mysql username 
$password="######"; // Mysql password 
$db_name="######"; // Database name 
$tbl_name="orders"; // Table name 


mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form 
$myusername=$_POST['myusername']; 


$myusername = stripslashes($myusername);
$myusername = mysql_real_escape_string($myusername);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
header("location:trackyourorder.html"); //DO NOT WANT TO REDIRECT
}
else {
echo "Wrong Username";
}
?>

推荐答案

从头到尾的传统方式可能如下。

A traditional way from start to finish could be as follows.

<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT * FROM Persons");

while($row = mysqli_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName']; //**Put all your formatting in here!**
  echo "<br />";
  }

mysqli_close($con);
?> 

这篇关于如何显示数据库中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！