You need to add the MySQL query inside the foreach() function, as well: foreach ($qurum as $value) { $query2 = “INSERT INTO test (data_id, col2) VALUES ($id, $value)”; mysqlExecute($query2); } Note that mysqlExecute() does not exist, you need to use your own function to execute the query. Also note that executing SQL statements in a … Read more
You should use joins. Your query will look like : SELECT t3.name FROM table3 t3 LEFT JOIN table2 t2 ON t3.id = t2.id2 LEFT JOIN table1 t1 ON t2.id2 = t1.id WHERE t1.id = <your_number> 1 solved SELECT * FROM table1, table2, table3 [duplicate]
session_id(): Get and/or set the current session id session_regenerate_id(): Update the current session id with a newly generated one session_create_id(): Create new session id Here is a link to the PHP sessions doc and PHP docs 6 solved What is the difference between session_id(), session_create_id() and session_regenerate_id() in php?
I dont want to use other method You should use whatever provides the required functionality, not the method that you like more over others! Also you should never access superglobals directly in CakePHP, this will only bring you in trouble, especially in unit tests. User the proper abstracted methodes provided by the request object, that … Read more
COMPLETE GUIDE TO EXCERPTS I’ve recently answered a few questions regarding excerpts, so I’m going to give a detailed explanation covering as much as I can. PREFACE There seems to be a couple of questions arising from this answer on where the code should go, and the answer is, it is really up to you … Read more
the solution is given in your error itself “use the WP_Query->is_main_query() method”– try this – if($query->is_main_query() && !empty($selected_sort_types) && empty($orderby)) { $_sort_types = array_keys($selected_sort_types); $orderby = $_sort_types[0]; $query->set(‘orderby’, $orderby); } instead of this – if(is_main_query() && !empty($selected_sort_types) && empty($orderby)) { $_sort_types = array_keys($selected_sort_types); $orderby = $_sort_types[0]; $query->set(‘orderby’, $orderby); } 2 solved Notice: is_main_query was called … Read more
Try SELECT TIME_FORMAT(’10:20:00′, ‘%h:%i %p’) Here is the SQLFiddel Demo 0 solved changing the time format from HH:MM:SS to HH:MM AM/PM [duplicate]
<pre><?php $n = $i = 5; while ($i–) echo str_repeat(‘ ‘, $i).str_repeat(‘* ‘, $n – $i).”\n”; ?></pre> 3 solved Pyramid of asterisks in php [duplicate]
Use date(“W”) echo date(“W”, strtotime(‘2013-06-06’)); See it in action solved calculating calendar week php [duplicate]
First error: field names should be enclosed in backticks, not quotes. (and even then, the backticks are only necessary if the field name is a reserved SQL word or contains special characters. Generally it’s a good idea to have backticks, but in your example you can get away without them) Second error: missing closing bracked … Read more
Please use “post-types-order” plugin https://wordpress.org/plugins/post-types-order/ solved Disable ordering of post with drag and drop
I solved it , below code work fine $countryArray = array( ‘AD’ => array( ‘country_name’ => ‘ANDORRA’, ‘dial_code’ => ‘376’ ), ‘AE’ => array( ‘country_name’ => ‘UNITED ARAB EMIRATES’, ‘dial_code’ => ‘971’ ), ‘AF’ => array( ‘country_name’ => ‘AFGHANISTAN’, ‘dial_code’ => ’93’ )); foreach ($countryArray as $keys=> $arraycountry){ foreach($arraycountry as $key => $value) { if($value … Read more
right code for this <? // http://huddak.net/bbs/board.php?bo_table=cm_free&wr_id=3629 function remove_nr($str) { $reg_e = array(‘/\n/’, ‘/\r/’, ‘/\”https://stackoverflow.com/”, “/<\/script>/i”); $reg_p = array(‘ ‘, ‘ ‘, ‘\\”‘, “<\/SCRIPT>”); return preg_replace($reg_e, $reg_p, $str); } ?> <script type=”text/javascript”> $(“#test1″).html( ” <? echo remove_nr( trim( db_cache(“main_top_naver_cache”, 300, “naver_popular(‘naver_popular’, 4)”)))?> ” ); </script> you can do time consuming php code to jquery loading. … Read more
Query need to be like:- $sql = “INSERT INTO prodb.simplex_list (code, description, manufacturer, cost_per_unit, weight_per_unit, bar_code, ingredients_list, allergens_contains, allergens_may_contain) VALUES (‘$proCode’, ‘$proDescr’, ‘$proManu’, ‘$proCPU’,’$proWPU’, ‘$proBarCode’, ‘$proIngredients’, ‘$proAllergens’, ‘$proMayAllergens’)”; Note:- please stop using mysql_*. Use mysqli_* or PDO. Also this will work only when id field must be auto incremented. 8 solved Stuck at this error: … Read more
This code is maybe the solution you wanted: function countdown() { var i = document.getElementById(‘counter’); if (parseInt(i.innerHTML)<=0) { $(“#counter”).fadeout(); i.innerHTML =10; i.style.width=”100%”; $(“#counter”).fadein(10); } else { i.innerHTML = parseInt(i.innerHTML)-1; setTimeout(function(){ var i = document.getElementById(‘counter’); i.style.width=”10%”; i.innerHTML=”1″; },5000) } var msg = window.open(“”, “Window name”, “width=200, height=100”); msg.document.write(“Some HTML”); } You have to add jquery in … Read more