php - The unstopable Loop X( -

-

this first code. im trying add new posts wordpress site.
mysql query return 4035 rows have details insert new post.
problem : loop wont ever stop! it reach 4035 row , start on 1st row

things tried make stop:

  1. added - if ($loopstimes > 4400) {break;}
  2. limited mysql query 4050 rows

the weird parts:

  1. when limit mysql query limit 900, works perfectly. loop stops when 900 post added, if add 950, script add 943 posts , give me fatal error "maximum execution time reached". script stops.
  2. i increase "maximum execution time" 300 sec , increase memory 128 256mb, use query without limit , loop wont ever stop.

is code problematic? or server issue?

<?php  $username = "xxxx"; $password = "xxxx"; $hostname = "localhost";   $loopstimes = 0;  //connection database $dbhandle = mysql_connect($hostname, $username, $password)  or die("unable connect mysql");  //select database work $selected = mysql_select_db("xxxx_xxxx",$dbhandle)  or die("could not select examples");  //execute sql query , return records // query names $result = mysql_query("select distinct names_list.* ... limit 4050");  if($result === false) {      die(mysql_error()); // todo: better error handling }  //fetch data database while ($row = mysql_fetch_array($result)) {     $p_name= $row["p_name"];     $category= $row["gcategory"];     $subcategory= $row["subcategory"];     $ase_date= $row["ase_date"];      //fix (') prepare mysql query      $pp_name = $p_name;      $newp_name = str_replace("'","''",$p_name);      //query count results     $minprice = mysql_query("select ... product_p_name = '$newp_name' , order product_price_usd");     $countss = mysql_num_rows($minprice);      if($minprice === false) {          die(mysql_error()); // todo: better error handling     }      $rowm = mysql_fetch_array($minprice);     $minprice = '$'.$rowm["product_price_usd"];      // create post object     $my_post = array(         'post_title' => 'my title...',         'post_status' => 'publish',         'post_author' => 1     );      // insert post database     $post_id = wp_insert_post( $my_post );      // add advanced custom field values     update_field( "field_552fc3f84b43r", $p_name, $post_id );       //regex date keep year     if (preg_match("/20.*/", $ase_date, $matches)) {         $ase_year = $matches[0];     }      //insert tags custom taxonomies      wp_set_post_terms( $post_id, $audio_subcategory, 'subcategory-cpt', false );     wp_set_post_terms( $post_id, $fex_pro_rg, 'fex-pro-cpt', false );      $loopstimes++;      if ($loopstimes > 4400) {break;}     echo 'post added!, '.$post_id.'<br>';     echo $loopstimes; }  //close connection mysql_close($dbhandle); echo 'finish'; ?>

sure know shouldn't use mysql_* functions anymore.

but pass on issue right now:

//query count results $minprice_query_result = mysql_query("select ... product_p_name = '$newp_name' , order product_price_usd"); $countss = mysql_num_rows($minprice_query_result);  if($minprice_query_result === false) {      die(mysql_error()); // todo: better error handling }  $rowm = mysql_fetch_array($minprice_query_result); $minprice = '$'.$rowm["product_price_usd"];  mysql_free_result ( $minprice_query_result );

and way, why need subquery? $minprice = '$'.$rowm["product_price_usd"]; ? never use variable in code!


Comments

Post a Comment

Popular posts from this blog

c++ - No viable overloaded operator for references a map -

-
i trying use map can make tag names reference number. when try , use it, in code error (6 in total every time reference map): src/main.cpp:25:45: error: no viable overloaded operator[] type 'std::map<std::string, std::string>' const char* idcs = node.child_value(tagmap[3]); this code: #include "pugi/pugixml.hpp" #include <iostream> #include <string> #include <map> int main() { pugi::xml_document doca, docb; std::map<std::string, pugi::xml_node> mapa, mapb; std::map<std::string, std::string> tagmap {{"1", "data"}, {"2", "entry"}, {"3", "id"}, {"4", "content"}}; if (!doca.load_file("a.xml") || !docb.load_file("b.xml")) { std::cout << "can't find input files"; return 1; } (auto& node: doca.child(tagmap[1]).children(tagmap[2])) { co
Read more

java - Custom OutputStreamAppender not run: LOGBACK: No context given for <MYAPPENDER> -

-
i wish write custom appender on basis of outputstreamappender . wrote following class package tests; import java.io.ioexception; import java.io.outputstream; import ch.qos.logback.core.outputstreamappender; public class myappender<e> extends outputstreamappender<e> { public myappender() { system.out.println("myappender created"); setoutputstream(new outputstream() { @override public void write(int b) throws ioexception { throw new unsupportedoperationexception(); } }); } } then wrote following runner: package tests; import org.slf4j.loggerfactory; import ch.qos.logback.classic.logger; public class runner { private static final logger log = (logger) loggerfactory.getlogger(runner.class); public static void main(string[] args) { //log.addappender(new myappender<iloggingevent>()); log.info("hello world"); } } finall
Read more

java - Cannot secure connection using TLS -

-
i'm trying establish secure socket connection between java client applet (built jdk 1.7.0_75-b13) , vc++ server application. as test vehicle, used vc++ client/server sample found in msdn forums, modified use schannel , able establish socket using cipher suite tls_rsa_with_aes_128_cbc_sha. works of tls 1.0/1.1/1.2. when try opening socket java applet same server application, connection rejected server reporting following: tls 1.0 acceptsecuritycontext failed: 0x80090327 tls 1.1 acceptsecuritycontext failed: 0x80090331 tls 1.2 acceptsecuritycontext failed: 0x80090331 this java code used create socket: debugprint("setting secure connection"); sslsocketfactory sslsocketfactory = (sslsocketfactory) sslsocketfactory.getdefault(); sslsocket sslsocket = (sslsocket) sslsocketfactory.createsocket("127.0.0.1", socketnumber); debugprint("starting handshake"); sslsocket.settcpnodelay(true); sslsocket.setsolinger(false, 0); sslsocket.s
Read more