我需要转换此代码

//This creates an array from the database and allows us to use it later in the jquery
//CREATE SQL STATEMENT
$sql_locations = "SELECT * FROM tbllocations";

//EXECUTE SQL STATEMENT
$rs_locations = mysqli_query($vconnection, $sql_locations);
$rs_locations_rows = mysqli_fetch_assoc($rs_locations);



foreach( $rs_locations as $rs_location ) {
  $markers[] = array(
      "{$rs_location[\'place\']}, {$rs_location[\'city\']}",
     $rs_location[\'long\'],
      $rs_location[\'lat\']
  );
}

至wordpress。我创建了一个自定义帖子类型，可以保存经度和纬度输入。我需要查找哪个数据库表来获取这些输入，然后为每个循环运行它们？

这样行吗？

D

foreach ($markers as $marker){
    $post_id = wp_insert_post(array(
        "post_title" => "something",
        "post_type" => "your-type",
        "post_status" => "publish", //by default they are drafts
        // etc.
    ));
    update_post_meta($post_id, "latitude", $marker[\'lat\']);
    update_post_meta($post_id, "longitude", $marker[\'long\']);
}