File manager - Edit - /home/autoph/public_html/connect/home/ASA_UPDATE_PROMO_TABLE.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(0); $MyCurrentDate = date_create() ->format("Y-m-d"); //echo $MyCurrentDate; $getUnitDescription=mysql_query("SELECT * FROM `promo_list` WHERE `promo_brand`= '$brandName' AND `promo_end` > '$MyCurrentDate' AND `added_by`='$MyUserID' ORDER BY date_added DESC"); echo "<table id='mainModel' style='width:100%;margin:00px'>"; echo "<thead>"; echo "<th style='width:5%;padding:5px'>NO</th>"; echo "<th style='width:5%;padding:5px'>PROMO ID</th>"; echo "<th style='width:25%;padding:5px'>TITLE</th>"; echo "<th style='width:10%;padding:5px'>START DATE</th>"; echo "<th style='width:10%;padding:5px'>END DATE</th>"; echo "<th style='width:5%;padding:5px'>DISCOUNT</th>"; echo "<th style='width:25%;padding:5px'>IMAGE LINK</th>"; echo "</thead>"; while($row=mysql_fetch_array($getUnitDescription)){ $count = $count + 1; ?><tr onclick="javascript:showClearanceInfo(this);"><?php echo "<td style='text-align:left;padding:8px;font-family:Arial;font-size:14px'>".$count."</td>"; echo "<td style='text-align:left;padding:8px'>".$row['id']."</td>"; echo "<td style='text-align:left;padding:8px'>".$row['promo_title']."</td>"; echo "<td style='text-align:left;padding:8px'>".$row['promo_start']."</td>"; echo "<td style='text-align:left;padding:8px'>".$row['promo_end']."</td>"; echo "<td style='text-align:left;padding:8px'>".$row['promo_discount']."</td>"; echo "<td style='text-align:left;padding:8px'>"; if($row['image_link']==""){ echo "<a href='#' style='display:block;padding:3px;font-family:Arial;font-size:14px;color:red;text-align:center' id='uploadImage' onclick='showFileUpload()'>Upload Image</a>"; }else{ echo "<a href='#' style='display:block;padding:3px;font-family:Arial;font-size:14px;color:red;text-align:left' id='uploadImage' onclick='showFileUpload()'>".$row['image_link']."</a>"; } echo"</td>"; echo "</tr>"; } echo "</table>"; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings