如何从数据库获取数据并在PHP中显示它？ [英] How to fetch data from database and display it in PHP?

问题描述

如何使用php从数据库获取数据并显示？

How do I get data from a database using php and show it?

数据库表有列，标记为 ID & Number 。 ID是唯一&固定，而Number只是一个非唯一的数字。如果有人访问
http://example.com/show.php?ID=32 和 show.php 应该获取 Number &显示您的号码为XXX

The database table has columns, labeled as ID & Number. ID is unique & fixed whereas Number is just a non-unique number. If someone visits http://example.com/show.php?ID=32, and show.php should fetch the Number & display "Your number is XXX"

请提供代码示例。

推荐答案

<?php
//Connect to DB
$db = mysql_connect("localhst","user","pass") or die("Database Error");
mysql_select_db("db_name",$db);

//Get ID from request
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

//Check id is valid
if($id > 0)
{
    //Query the DB
    $resource = mysql_query("SELECT * FROM table WHERE id = " . $id);
    if($resource === false)
    {
        die("Database Error");
    }

    if(mysql_num_rows($resource) == 0)
    {
        die("No User Exists");
    }

    $user = mysql_fetch_assoc($resource);

    echo "Hello User, your number is" . $user['number'];
}

应该可以看到你。

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