File manager - Edit - /home/autoph/public_html/voc/home/save_new_role.php
Back
<?php include 'core/init.php'; $apicode="TR-MARJO331334_NN66J"; //$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); $dealID= $user_data['dealer']; $compID= $user_data['company']; //if submit/ save to databasevar if(isset($_POST['done'])){ exit(); } //display from database if(isset($_POST['display'])){ $newRole = mysql_escape_string($_POST['newRole']); $checkIfExist = mysql_result(mysql_query("SELECT COUNT('a_id') FROM `vts_access_privilege` WHERE `a_desc`='$newRole'"),0); if($checkIfExist != 0){ echo "<p style='padding:5px;font-family:Calibri;font-size:16px;color:red;font-weight:bold;background:yellow;border:1px solid orange;border-radius:5px;text-align:center'> This ROLE ".$newRole." already Exist or inused. </p>"; }else{ $newRole = mysql_escape_string($_POST['newRole']); $tCapacity = mysql_escape_string($_POST['tCapacity']); $sCompID = mysql_escape_string($_POST['sCompID']); $sDealID = mysql_escape_string($_POST['sDealID']); $svDate = mysql_escape_string($_POST['svDate']); $svTime = mysql_escape_string($_POST['svTime']); $svUserID = mysql_escape_string($_POST['svUserID']); $roleStatus = mysql_escape_string($_POST['roleStatus']); $roleCategory = mysql_escape_string($_POST['roleCategory']); mysql_query("INSERT INTO vts_access_privilege (`a_desc`,`a_status`,`date_created`,`category`,`by`) VALUES('{$newRole}','{$roleStatus}','{$svDate}','{$roleCategory}','{$svUserID}')"); //itexmo('09269172111', 'Hell Arnel E', $apicode); $result = mysql_query("SELECT * FROM vts_access_privilege WHERE `a_status`=1 ORDER BY `a_desc` ASC"); ?> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:14px;color:#043062'> ✛ Active Roles: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=003' class='hideClick hidden' style='font-weight:bold'> ✕ </a> </div> </div> <?php echo "<table id='table' style='width:100%;border:0px solid red;border-collapse:collapse'>"; echo "<thead> <tr> <th>NO</th> <th>ROLE DESCRIPTION</th> <th>STATUS</th> <th>DATE CREATED</th> <th style='text-align:center'>-</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ $no=$no + 1 ; echo "<tr>"; echo "<td style='padding-left:15px'>".$no."</td>"; echo "<td style='padding-left:10px'>".$row['a_desc']."</td>"; echo "<td style='text-align:center;'>"; if($row['a_status']==1){ echo 'Active'; }else{ echo 'InActive'; } echo"</td>"; echo "<td style='padding-left:10px'>".$row['date_created']."</td>"; echo "<td style='text-align:center;'><a href='mainindex.php?id=002&d=10&x=true&xID=".$row['a_id']."' style='font-size:12px;color:red'>⚏</a></td>"; echo "</tr>"; } echo "</table>"; } exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings