Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //=========== Update code ===============
- $msgl='';
- if(isset($_REQUEST['edit_x']) && $_REQUEST['edit_x']=='Edit Ticket') {
- //echo "fddffdsfd"; exit;
- //echo "<pre>";print_r($_REQUEST);exit;
- if($_REQUEST['name']==''){
- $msgl="Cust Name can not be blank";
- echo '<b><font color="red">'.$msgl.'</font></b>';
- }elseif($_REQUEST['email']==''){
- $msgl="Cust Email can not be blank";
- echo '<b><font color="red">'.$msgl.'</font></b>';
- }elseif($_REQUEST['topicId']==''){
- $msgl="Topic Id can not be blank";
- echo '<font color=red>'.$msgl.'</font>';
- }elseif($_REQUEST['subject']==''){
- $msgl="Subject can not be blank";
- echo '<font color=red>'.$msgl.'</font>';
- }
- if ($msgl==''){
- update_cust(query_type($_REQUEST['topicId']));
- header('Location: viewticket.php?msg=3');
- }
- }
- function query_type($k)
- {
- switch ($k) {
- case "1":
- return "Billing";
- break;
- case "2":
- return "Sales";
- break;
- case "3":
- return "Resp...";
- break;
- default:
- return "Invalid Option";
- break;
- }
- }
- function update_cust($topicId){
- //echo "In Update"; exit;
- //echo "<pre>";print_r($_REQUEST);exit;
- $con=mysql_connect("localhost","root","");
- mysql_select_db('supportsystem',$con);
- $qry="update newticket set fname='".$_REQUEST['name']."', email='".$_REQUEST['email']."', phno='".$_REQUEST['phone']."', ext='".$_REQUEST['phone_ext']."',help='".$topicId."',subject='".$_REQUEST['subject']."', username='".$_REQUEST['username']."',vehicleno='".$_REQUEST['veh_name']."',msg='".$_REQUEST['message']."' where id ='".$_REQUEST['hideid']."'";
- mysql_query($qry,$con);
- }
Advertisement
Add Comment
Please, Sign In to add comment