File manager - Edit - /home/autoph/public_html/connect/home/prf_itemReIndex.php
Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $getItems = mysql_query("SELECT * FROM `prf_items` WHERE `deleted` = 0 AND `item_description`!=''"); while($row=mysql_fetch_array($getItems)){ $itemID = $row['id']; $itemDesc = TRIM($row['item_description']); //echo '<script>alert("WARNING: '.$itemID.'.")</script>'; $getIndexCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `item_description`='$itemDesc'"),0); $indexTotalCount = $indexTotalCount + 1; mysql_query("UPDATE `prf_request_detl` SET `sku_id`='$itemID' WHERE `item_description`='$itemDesc'"); $getIndexCount = 0; } echo '<script>alert("There are '.$indexTotalCount.' items has been re-index in PRF request detail table.")</script>'; exit; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings