admin管理员组文章数量:1130349
<?php
foreach ( $posts_array as $post ) {
$post_id = wp_insert_post($post,true);
//var_dump($post);
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueLongitude = '$VenueLongitude' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueLatitude = '$VenueLatitude' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET Tag = '$Tag' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET IsDeleted = '$IsDeleted' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET AdminID = '$AdminID' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET CreatedAt = '$CreatedAt' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueStreet = '$VenueStreet' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueNumber = '$VenueNumber' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueDistrict = '$VenueDistrict' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueCity = '$VenueCity' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueWard = '$VenueWard' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET PriceAverage = '$PriceAverage' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET Near = '$Near' WHERE ID=$post_id"));
}
?>
I attached the code in which I run mutli wpdb->query in a foreach loop. But after the loop run 1 time it stopped immediately, it just runs only 1 time. It is ok if I just run 1 wpdb->query in the loop. How can I fix this problem? Anybody can help me?
Thanks a lot.
<?php
foreach ( $posts_array as $post ) {
$post_id = wp_insert_post($post,true);
//var_dump($post);
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueLongitude = '$VenueLongitude' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueLatitude = '$VenueLatitude' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET Tag = '$Tag' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET IsDeleted = '$IsDeleted' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET AdminID = '$AdminID' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET CreatedAt = '$CreatedAt' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueStreet = '$VenueStreet' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueNumber = '$VenueNumber' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueDistrict = '$VenueDistrict' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueCity = '$VenueCity' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET VenueWard = '$VenueWard' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET PriceAverage = '$PriceAverage' WHERE ID=$post_id"));
$wpdb->query($wpdb->prepare("UPDATE wp_posts SET Near = '$Near' WHERE ID=$post_id"));
}
?>
I attached the code in which I run mutli wpdb->query in a foreach loop. But after the loop run 1 time it stopped immediately, it just runs only 1 time. It is ok if I just run 1 wpdb->query in the loop. How can I fix this problem? Anybody can help me?
Thanks a lot.
本文标签: customizationMulti line of wpdbgtquery just run 1 time and end the loop right after
版权声明:本文标题:customization - Multi line of $wpdb->query just run 1 time and end the loop right after 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://it.en369.cn/questions/1749177928a2328112.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。


发表评论