<?php $link = mysql_connect('127.0.0.1', 'root', 'root'); if (!$link) { die('Could not connect: ' . mysql_error()); } ?>
<?php include('conn.php'); $checkdb = 'drop database if exists woniu'; $createdb = 'create database woniu'; $createtb = 'create table woniu.wuser(id int(3),user varchar(20),pass varchar(20))'; $createdata = "insert into woniu.wuser (id,user,pass) value (1,'admin','admin'),(2,'root','root'),(3,'user','user')"; mysql_query($checkdb); mysql_query($createdb); mysql_query($createtb); mysql_query($createdata); ?>
<html>
<body>
<from action = # method = "GET">
親,請輸入你的ID:<input type="text" name="id">
<input type="submit" name="submit" value="https://www.cnblogs.com/gx991010/p/查詢">
<?php
error_reporting(0);
include('conn.php');
mysql_select_db('woniu',$link);
$id=$_GET['id'];
$query="select * from wuser where id = $id";
$result=mysql_query($query);
$output=mysql_fetch_array($result);
echo "<br>";
var_dump($output);
echo "您的用戶名是123:".$output['user']."<br>";
echo "您的密碼是:".$output['pass'];
?>
</body>
</html>
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/30831.html
標籤:PHP
上一篇:這個結果和我分析的不一樣
