PHP选择具有相同id的不同列

Question

我正在尝试获取所有议程项目。首先，我有一个包含开始日期 $start 的输入，但是当我有输出(post_id 6 和 14)post_id 时，我想获取其他 meta_value 具有相同的 post_id Database .

这里我想获取post_id 6. current output

$start = $_GET["startDate"];
$end = $_GET["endDate"];
/* Template Name: Example Template */
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

$conn = mysqli_connect($servername, $username, $password, $dbname);
$sql = "SELECT post_id FROM wp_postmeta WHERE meta_key='eap_from_day' AND '$start' <= DATE(meta_value)";
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$all = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($all)) {
    foreach ($row as $r){
        var_dump($r) ;
    }
} 

如何在 Json 中获取具有相同 post_id 的 meta_value？

Answer 1

$sql = "SELECT * FROM wp_postmeta WHERE meta_key='eap_from_day' AND '$start' <= DATE(meta_value) AND post_id='6' ";

这就是你想要的吗？