logged_in) { $URL="../snug/login.php"; header ("Location: $URL"); } include($_SERVER['DOCUMENT_ROOT']."/SpryAssets/db_con_snug.php"); $tb = "register_webinars"; $tb_backup = "register_webinars_deleted"; if($_REQUEST['action']=='delete') { $query_backup = "INSERT INTO ".$tb_backup." SELECT d.* FROM ".$tb." d WHERE d.id = '".$_REQUEST['rec_id']."'"; $result = @mysqli_query($connection,$query_backup); $query = "DELETE FROM ".$tb." WHERE id = ".$_REQUEST['rec_id']." LIMIT 1"; $result = @mysqli_query($connection,$query); //header("location: ".$_SERVER['PHP_SELF']."?webinar_series=".$_REQUEST['webinar_series']); } if($_REQUEST['action']=='edit_record') { $query = "UPDATE ".$tb." SET site_id = '".$_REQUEST['site_id']."', fac_name = '".$_REQUEST['fac_name']."', first_name = '".$_REQUEST['first_name']."', last_name = '".$_REQUEST['last_name']."', title = '".$_REQUEST['title']."', phone = '".$_REQUEST['phone']."', email = '".$_REQUEST['email']."', address = '".$_REQUEST['address']."', city = '".$_REQUEST['city']."', state = '".$_REQUEST['state']."', zip = '".$_REQUEST['zip']."', country = '".$_REQUEST['country']."' WHERE id = '".$_REQUEST['rec_id']."' LIMIT 1"; $result = @mysqli_query($connection,$query); //header("location: ".$_SERVER['PHP_SELF']."?webinar_series=".$_REQUEST['webinar_series']); } if($_REQUEST['action']=='payment_update') { if (!empty($_REQUEST['payment_date'])) { $pay_date = date("Y-m-d",strtotime($_REQUEST['payment_date'])); } else { $pay_date = ""; } $pay_notes = $_REQUEST['payment_notes']; $webinar_fee = $_REQUEST['webinar_fee']; $webinar_fee_description = $_REQUEST['webinar_fee_description']; $pay_method = $_REQUEST['pay_method']; $query = "UPDATE ".$tb." SET payment_date = '".$pay_date."', payment_description = '".$pay_notes."', webinar_fee = '".$webinar_fee."', webinar_fee_description = '".$webinar_fee_description."', pay = '".$pay_method."' WHERE id = '".$_REQUEST['rec_id']."' LIMIT 1"; $result = @mysqli_query($connection,$query); //header("location: ".$_SERVER['PHP_SELF']."?webinar_series=".$_REQUEST['webinar_series']); } ?> SNUG Protected - View Webinar Attendees
   
   

View Webinar Series attendees: