File manager - Edit - /home/autoph/public_html/voc/home/add_new_group.php
Back
<?php include 'core/init.php'; error_reporting(0); //if submit/ save to databasevar ` if(isset($_POST['done'])){ $newGroupHead = mysql_escape_string($_POST['newGroupHead']); $newGroupName = mysql_escape_string($_POST['newGroupName']); $sDealID = mysql_escape_string($_POST['sDealID']); $checkIfExist = mysql_result(mysql_query("SELECT COUNT('gid') FROM `db_sales_group` WHERE `Group_name` ='$newGroupName'"),0); mysql_query("INSERT INTO db_sales_group (group_name, group_head, active, dealer_id) VALUES('{$newGroupName}','{$newGroupHead}','1','{$sDealID}')"); $getSalesGroup = mysql_query("SELECT * From `db_sales_group` WHERE `active`=1 ORDER BY `group_name` ASC"); echo "<table style='width:100%'>"; echo "<thead>"; echo "<th style='width:10%'>GROUP ID</th>"; echo "<th style='width:35%'>GROUP NAME</th>"; echo "<th style='width:35%'>GROUP HEAD</th>"; echo "<th style='width:10%'>MEMBERS</th>"; echo "</thead>"; while($row=mysql_fetch_array($getSalesGroup)){ $gHead = $row['group_head']; $gID= $row['gid']; $gFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $gLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?><tr onclick="javascript:showMembers(this);" ondblclick="popUpShowDisplayAddMembers()"><?php echo "<td style='text-align:left;padding:10px;'>".$row['gid']."</td>"; echo "<td style='text-align:left;padding:10px;'>".$row['group_name']."</td>"; echo "<td style='text-align:left;padding:10px;'>".$gLname. ", ".$gFname."</td>"; echo "<td style='text-align:center;padding:10px;'>".number_format($getMember,0,'.',',')."</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings