时间戳

首页 > 解决方案 > PHP如何从两个表中获取数据

php - PHP如何从两个表中获取数据

问题描述

你好，我想这样做我有一个名为用户的表，我的用户可以登录，我也有表配置文件。那么我如何将它合并到一个 php 脚本中，例如我的意思是我正在使用来自用户的数据登录到页面，并在它向我显示 Profile 的详细信息之后。请帮助我，抱歉我的英语不好，我希望你能理解我。

 <html>
<body>
<form method="POST">
<input type="text" name="username" placeholder="Username">
<br/>
<input type="password" name="password" value="Password">

<input type="submit" name="submit" value="Login">
</form>
</body>
</html>

<?php

require "connection.php";

$username=$_POST ['username'];
$password=$_POST ['password'];

$sqlselect="SELECT * FROM `Users` WHERE `username`='".$username."' AND `password`='".$password."';";
$result=mysqli_query ($con,$sqlselect);

$response=array();

echo "<table border='3'>";
    echo "<tr>";
        echo "<th> Username</th>";
        echo "<th> Password </th>";
        echo "<th> Email </th>";
echo "</tr>";

while ($row=mysqli_fetch_array ($result))
{
    $response=array ("username"=>$row[0],"password"=>$row[1],"email"=>$row[2]);
       echo "<tr>";
           echo "<td>". $row ['username'] ."</td>";
           echo "<td>". $row ['password'] ."</td>";
           echo "<td>". $row ['email'] ."</td>";
       echo "</tr>";
}
echo "</table>";



$sqlselect="SELECT * FROM `Profile` WHERE `location`='".$location."' AND `ssid`='".$ssid."';";
$result=mysqli_query ($con,$sqlselect);

$rows=array();

echo "<table border='3'>";
    echo "<tr>";
        echo "<th> Username</th>";
        echo "<th> Password </th>";
        echo "<th> Email </th>";
echo "</tr>";

while ($row=mysqli_fetch_array ($result))
{
    $rows=array ("location"=>$row[0],"test"=>$row[1],"country"=>$row[2]);
       echo "<tr>";
           echo "<td>". $row ['username'] ."</td>";
           echo "<td>". $row ['password'] ."</td>";
           echo "<td>". $row ['email'] ."</td>";
       echo "</tr>";
}
echo "</table>";




  echo json_encode($rows,JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_PRETTY_PRINT | JSON_UNESCAPED_LINE_TERMINATORS);

?>

标签： phpmysql

解决方案

像这样？（别忘了改名）

$sqlselect="
SELECT 
usu.id_user_table_here, 
usu.username, 
usu.email,
prof.ssid,
prof.location
FROM Users AS usu
INNER JOIN profile AS prof ON prof.ssid=usu.id_user_table_here
WHERE 
username = '".$username."' 
AND 
password = '".$password."'";

推荐阅读