如何在PHP -mysql中显示select查询结果 [英] How to display result of select where query in PHP -mysql

问题描述

我想在数据库mysql的表名中获取sombody的密码

I want to get password of sombody in table name in database mysql

<form action="GetPassword.php" method="post">
         <legend>
              <h3>Get Password by name</h3>
        </legend>
        <fieldset>
           <p>
             <label>Name : </label>
             <input type="text" name="nameofpass" placeholder="Enter name to get password">   
           </p>
           <p>
              <input type="submit" name="getpass" value="Go"> 
           </p>    
        </fieldset>
    </form>

我的尝试：

What I have tried:

<?php
if(isset$_POST['getpass'])
{
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "testdb";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
$name=$_POST['nameofpass'];
$query ="SELECT password from names where name='$name'";
   $result = mysql_query($query); 
    while ($row = mysql_fetch_array($result)) {
        echo $row['password'];
    }
    mysqli_close($conn);  
}
?>

推荐答案

_POST [' getpass']）
{

_POST['getpass']) {

servername = localhost;

servername = "localhost";

用户名 = 根;

username = "root";

这篇关于如何在PHP -mysql中显示select查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！