多表联合查询的sql语句

最新推荐文章于 2025-06-16 10:00:28 发布

原创最新推荐文章于 2025-06-16 10:00:28 发布 · 4k 阅读

1 ·

CC 4.0 BY-SA版权

php 专栏收录该内容

40 篇文章

订阅专栏

header("Content-Type:application/json;charset=utf-8");
require("conn.inc.php");

@$hid = $_REQUEST['hid'] or die('{"msg":"hid is required"}');

$sql = "SELECT * FROM kkf_community WHERE cid=(SELECT cid FROM kkf_house_con WHERE hid=$hid)";
$result = mysqli_query($conn,$sql);

$row = mysqli_fetch_assoc($result);

echo(json_encode($row));