dongshi2836 2014-11-16 10:13
浏览 24
已采纳

通过php上的文本字段为用户提供数据？ [关闭]

I'm tryig to create a text input on my page to be able to receive a username which is on my database and return another information of himself, how can i do it? For example entering a name and returning his telephone number. i have just no idea how to start. Thanks

  • 写回答

2条回答 默认 最新

  • dongmo9996 2014-11-16 11:16
    关注

    Here's the working code. But learn the basics first.

    index.html

    <!DOCTYPE html>
<html>
<head>
    <title>Index page</title>
</head>

<body>

<form method="POST" action="retrieve.php">

    Enter your name : <input type="text" name='username'><br><br>
    <input type="submit" name="submit">

</form>

</body>
</html>

    retrieve.php

    <?php

//Database connection
$connection = mysqli_connect("localhost","username","password","database_name");

if (isset($_POST['submit'])) {

    $uname = $_POST['username'];

    // sql query and user is the table name
    $query = "SELECT * FROM `user` WHERE user_name='$uname'";

    // query to execute
    $result = mysqli_query($connection,$query);

    if (!$result) {
        echo "fails";
    }


    while($row = mysqli_fetch_array($result)) {

        $telephone_no = $row['phoneno'];
        $country_name = $row['country'];

        echo "Your results for name - " . $uname;
        echo "<br><br>";

        echo "Telelephone is : " . $telephone_no;
        echo "<br>";
        echo "Country name is : " . $country_name;   
    }  
}
?>

    Database structure : (User table)

    enter image description here

    To test the code, insert a person details in PHPMyadmin insert tab.(Leave id alone as it was set to an auto-increment).

    enter image description here



    enter image description here

    enter image description here

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目，支持注册表等
  • ¥15 matlab 用yalmip搭建模型，cplex求解，线性化处理的方法
  • ¥15 qt6.6.3 基于百度云的语音识别 不会改
  • ¥15 关于#目标检测#的问题：大概就是类似后台自动检测某下架商品的库存，在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
  • ¥15 神经网络怎么把隐含层变量融合到损失函数中？
  • ¥15 lingo18勾选global solver求解使用的算法
  • ¥15 全部备份安卓app数据包括密码，可以复制到另一手机上运行
  • ¥20 测距传感器数据手册i2c