zzcx_line/coding/api1.0/all_run_x.php

<?php
require_once '../st-xm/Common/Mysql.php';
header("Access-Control-Allow-Origin:*");

$current_day = date("Y-m-d");

$pdo=conn1();
$sql = "SELECT * FROM run_main WHERE RUN_DATE >= '{$current_day}' ";
$result = $pdo->query($sql);
$rowset = $result->fetchAll(PDO::FETCH_ASSOC);
$result->closeCursor();

$run_array = array();
foreach( $rowset as $row_info ) {
    $run_id = $row_info["RUN_ID"];
    $sql_txt = " SELECT count(*) as err_num FROM run_{$run_id} WHERE SEAT_STATUS=1 ";
    $result = $pdo->query($sql_txt);
    $rowset_result = $result->fetchAll(PDO::FETCH_ASSOC);
    $result->closeCursor();
    if( $rowset_result[0]["err_num"] > 0 ) {
        echo "RUN_".$run_id."<hr />";
    }

}

echo "success";
exit();