File manager - Edit - /home/autoph/public_html/connect/home/PRF_LoadItemMaster.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'])){ $itemClassID = mysql_escape_string($_POST['itemClassID']); $itemTypeID = mysql_escape_string($_POST['itemTypeID']); $itemTypeName = mysql_escape_string($_POST['itemTypeName']); if($itemTypeName ==""){ //Expense ID Only $getMatrixData = mysql_query("SELECT * FROM `prf_items` WHERE `deleted`=0 AND `asset_cat`='$itemClassID' ORDER BY `item_description` ASC"); }else{ $getMatrixData = mysql_query("SELECT * FROM `prf_items` WHERE `deleted`=0 AND `asset_cat`='$itemClassID' AND `item_class`='$itemTypeName' ORDER BY `item_description` ASC"); } echo "<table id='loadItemCategory' style='width:100%'>"; while($row=mysql_fetch_array($getMatrixData)){ ?><tr onclick="javascript:getCategoryID(this);"><?php echo "<td style='width:5%;text-align:center;font-family:Yu Gothic Light;font-size:11px'>".strtoupper($row['id'])."</td>"; echo "<td style='width:10%;text-align:left;font-family:Yu Gothic Light;font-size:11px'>"; $expID = $row['expense_id']; $expName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$expID'"),0); echo strtoupper($expName); echo "</td>"; echo "<td style='width:10%;text-align:left;font-family:Yu Gothic Light;font-size:11px'>"; $expCat = $row['asset_cat']; $expCatName = mysql_result(mysql_query("SELECT `description` FROM `prf_expenseitems` WHERE `id`='$expCat'"),0); echo strtoupper($expCatName); echo "</td>"; echo "<td style='width:15%;text-align:left;font-family:Yu Gothic Light;font-size:11px'>"; echo $row['item_class']; echo "</td>"; echo "<td style='width:55%;text-align:left;font-family:Yu Gothic Light;font-size:11px'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:5%;text-align:left;font-family:Yu Gothic Light;font-size:11px'>".strtoupper($row['uom'])."</td>"; echo "</tr>"; } echo "</table>"; } exit(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings