File manager - Edit - /home/autoph/public_html/connect/home/add_new_group_member.php
Back
<?php include 'core/init.php'; error_reporting(0); //if submit/ save to databasevar ` if(isset($_POST['done'])){ $done = $_POST['done']; $selGroupNameID = mysql_escape_string($_POST['selGroupNameID']); $addSelectedMember = mysql_escape_string($_POST['addSelectedMember']); $sDealID = mysql_escape_string($_POST['sDealID']); mysql_query("UPDATE `vts_users` SET `sales_group` ='$selGroupNameID' WHERE `u_id`='$addNewMember'"); $getLstofMembers = mysql_query("SELECT * From `vts_users` WHERE `sales_group`='$selGroupNameID' ORDER BY `u_lname` ASC"); echo "<table style='width:100%'>"; echo "<thead>"; echo "<th>Rec. NO</th>"; echo "<th>Group Name</th>"; echo "<th>Name of Members</th>"; echo "<th>Group Head</th>"; echo "</thead>"; while($row=mysql_fetch_array($getLstofMembers)){ $gHead = mysql_result(mysql_query("SELECT `group_head` FROM `db_sales_group` WHERE `gid`='$selGroupNameID'"),0); $uID= $row['u_id']; $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); $mFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $mLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?><tr><?php echo "<td >".$row['u_id']."</td>"; echo "<td style='text-align:center;padding:10px'>Group #".$row['sales_group']."</td>"; echo "<td style='text-align:left;padding:10px'>".$mLname. ", ".$mFname."</td>"; echo "<td style='text-align:left;padding:10px'>".$gLname. ", ".$gFname."</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings