File manager

File manager - Edit - /home/autoph/public_html/voc/home/search_load_found_customer.php

Back
<?php include 'core/init.php'; //$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); ?> <script language="javascript" type="text/javascript"> function showCustDetails(row) { var x=row.cells; document.getElementById("loadCustData").value = x[0].innerHTML; //document.getElementById("customerID").value = x[0].innerHTML; document.getElementById("loadCDFName").value = x[1].innerHTML; document.getElementById("loadCDLName").value = x[2].innerHTML; document.getElementById("loadCDMName").value = x[3].innerHTML; document.getElementById("loadCDGender").value = x[4].innerHTML; document.getElementById("loadCDBirthDate").value = x[5].innerHTML; document.getElementById("loadCDMobile").value = x[6].innerHTML; document.getElementById("loadCDEmail").value = x[7].innerHTML; document.getElementById("loadCDFBAccnt").value = x[8].innerHTML; document.getElementById("loadCDTWAccnt").value = x[9].innerHTML; document.getElementById("loadCDIGAccnt").value = x[10].innerHTML; document.getElementById("loadViberAccnt").value = x[11].innerHTML; document.getElementById("loadCDHomeAddress").value = x[12].innerHTML; document.getElementById("svEditRegion").value = x[13].innerHTML; document.getElementById("svEditMunicipality").value = x[14].innerHTML; document.getElementById("svEditCity").value = x[15].innerHTML; document.getElementById("svEditBrgy").value = x[16].innerHTML; document.getElementById("svEditBusinessName").value = x[17].innerHTML; document.getElementById("svEditSector").value = x[18].innerHTML; //document.getElementById("svEditBusinessName").value = x[13].innerHTML; //document.getElementById("svEditSector").value = x[14].innerHTML; } function viewCustTable() { var div = document.getElementById("custMoreInfo"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = ''; } } function viewCustTableHide() { var div = document.getElementById("custMoreInfo"); if (div.style.display == 'none') { div.style.display = 'none'; } else { div.style.display = 'none'; } } function viewPicLoader() { var div = document.getElementById("picLoader"); if (div.style.display == '') { div.style.display = 'none'; } else { div.style.display = ''; } } </script> <!--SHOW MUNICIPATILITES BASED ON SELECTED REGION--> <script> //show municipalities based onselected region_code` function showMunicipalityList(str) { if (str == "") { document.getElementById("svEditMunicipality").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("svEditMunicipality").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","add_new_load_municipality_based_on_selected_region.php?q="+str,true); xmlhttp.send(); } } //show municipalities based onselected region_code` function showCityList(str) { if (str == "") { document.getElementById("svEditCity").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("svEditCity").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","add_new_load_city_based_on_selected_municipality_editMode.php?q="+str,true); xmlhttp.send(); } } //show Brangays function showBrgyLists(str) { if (str == "") { document.getElementById("svEditBrgy").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("svEditBrgy").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","add_new_load_barangays_based_on_selected_city_editMode.php?q="+str,true); xmlhttp.send(); } } </script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:69px;height:89px;border:0px solid red;position:absolute;top:50%;left:50%;padding:2px;"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Loading..</div> <!-- add jquery --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //loading gif animator during query or page load $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //UPDATING Record $("#updateCustInfo").click(function(){ var loadCustData= $("#loadCustData").val(); var loadCDFName= $("#loadCDFName").val(); var loadCDLName= $("#loadCDLName").val(); var loadCDMName= $("#loadCDMName").val(); var loadCDGender= $("#loadCDGender").val(); var loadCDBirthDate= $("#loadCDBirthDate").val(); var loadCDMobile= $("#loadCDMobile").val(); var loadCDEmail= $("#loadCDEmail").val(); var loadCDHomeAddress= $("#loadCDHomeAddress").val(); var svSalesAgent= $("#svSalesAgent").val(); var loadCDFBAccnt= $("#loadCDFBAccnt").val(); var loadCDIGAccnt= $("#loadCDIGAccnt").val(); var loadCDTWAccnt= $("#loadCDTWAccnt").val(); var svEditBrgy= $("#svEditBrgy").val(); var svEditCity= $("#svEditCity").val(); var svEditMunicipality= $("#svEditMunicipality").val(); var svEditRegion= $("#svEditRegion").val(); var svEditBusinessName= $("#svEditBusinessName").val(); var svEditSector= $("#svEditSector").val(); if (loadCDLName == "") { alert("Error: Please input Lastname"); return false; } if (loadCDFName == "") { alert("Error: Please input Firsname"); return false; } if (loadCDMobile == "") { alert("Error: Please input Mobile Number"); return false; } if (loadCDEmail == "") { alert("Error: Please input E-mail Address"); return false; } $.ajax({ url: "sub_save_edited_customer_data.php", type: "POST", async: false, data: { "done": 1, "loadCustData" : loadCustData, "svEditBusinessName" : svEditBusinessName, "svEditCity" : svEditCity, "svEditBrgy" : svEditBrgy, "svEditSector" : svEditSector, "svEditMunicipality" : svEditMunicipality, "svEditRegion" : svEditRegion, "loadCDFName" : loadCDFName, "loadCDLName" : loadCDLName, "loadCDMName" : loadCDMName, "loadCDGender" : loadCDGender, "loadCDBirthDate" : loadCDBirthDate, "loadCDMobile" : loadCDMobile, "loadCDEmail" : loadCDEmail, "loadCDHomeAddress" : loadCDHomeAddress, "loadCDFBAccnt" : loadCDFBAccnt, "svSalesAgent" : svSalesAgent, "loadCDIGAccnt" : loadCDIGAccnt, "loadCDTWAccnt" : loadCDTWAccnt }, success: function(data){ alert("Update complete..."); } }) }); //START OF FUNCTION=========Saving IMAGE============================================================================ $('#pic').on('change', function() { var customerID = $("#customerID").val(); var file_data = $('#pic').prop('files')[0]; var form_data = new FormData(); // Create a FormData object form_data.append('file', file_data); // Append all element in FormData object form_data.append('customerID', customerID); $.ajax({ url : 'upload_profile_picture.php', // point to server-side PHP script dataType : 'text', // what to expect back from the PHP script, if anything cache : false, contentType : false, processData : false, data : form_data, type : 'post', success : function(output){ alert("New Picture has been Uploaded."); //alert(output); // display response from the PHP script, if any viewNewAddedPicture(); } }); $('#pic').val(''); /* Clear the file container / }); function viewNewAddedPicture(){ var customerID = $("#customerID").val(); var file_data = $('#pic').prop('files')[0]; var form_data = new FormData(); // Create a FormData object form_data.append('file', file_data); // Append all element in FormData object form_data.append('customerID', customerID); $.ajax({ url : 'upload_profile_picture_view.php', // point to server-side PHP script dataType : 'text', // what to expect back from the PHP script, if anything cache : false, contentType : false, async : false, processData : false, data : form_data, type : 'post', success : function(output){ //alert("New Picture has been Uploaded."); //alert(output); // display response from the PHP script, if any $("#loadProPic").html(d); } }); } //START OF FUNCTION=========Saving IMAGE============================================================================ //START OF FUNCTION=========btLoadSelData btLoadSelData======== SAVING NEW RECORD $("#btLoadSelData").click(function(){ var loadCustData = $("#loadCustData").val(); if (loadCustData == "") { alert("Error: Required information is Missing..."); return false; } $.ajax({ url: "sub_add_new_customer_load_view_data.php", type: "POST", async: false, data: { "done": 1, "loadCustData" : loadCustData }, success: function(data){ //alert("New Record Saved."); viewSearchSelCustInfo(); } }) }); //END OF FUNCTION================= function viewSearchSelCustInfo(){ var loadCustData = $("#loadCustData").val(); $.ajax({ url: "sub_add_new_customer_load_view_data.php", type: "POST", async: false, data: { "loadCustData": loadCustData, "display": 1 }, success: function(d){ $("#display_personal_cust_info_history").html(d); viewLoadPicture(); } }); } function viewLoadPicture(){ var loadCustData = $("#loadCustData").val(); $.ajax({ url: "sub_add_new_customer_load_view_data.php", type: "POST", async: false, data: { "loadCustData": loadCustData, "picture": 1 }, success: function(d){ $("#loadProPic").html(d); } }); } }); </script> <SCRIPT LANGUAGE="JavaScript"> <!-- myPopup = ''; function openPopup(url) { myPopup = window.open('upload_profile_pic.php?cid=','popupWindow','width=550,height=320','menubar=no, toolbar=no, location=no, directories=no, status=no, scrollbars=no, resizable=no, dependent, width=550, height=320, left=0, top=0'); if (!myPopup.opener) myPopup.opener = self; } //--></SCRIPT> <div id="custMoreInfo" class="menu" style='display:none;position:absolute;width:98%;min-width:400px;height:700px;background:white;border:1px solid black;top:10px;left:10px;z-index:99999'> <!--------------------------PICTURE LOADER----------------------------> <!--------------------------PICTURE LOADER----------------------------> <div class='bgColor' style='vertical-align:top;height:25px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:12px;color:#043062'>☳ Customer Details: <div style='float:right;font-family:Verdana;font-size:12px;margin-top:-3px'> <a href='#' onclick="viewCustTableHide()" style='font-weight:bold;background:transparent'> ✕</a> </div> </div> <div style='padding:5px;width:40%;float:left;border:0px solid lightgray;border-right:1px solid lightgray;;background:#eef1f1;height:95.5%'> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:right;font-family:Verdana;color:blue;padding-right:10px'></div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:right'> <input type='text' id='loadCustData' readonly name='loadCustData' style='display:block;width:30%;float:left;font-family:Calibri;font-size:12px;margin:0px;padding:3px;background:transparent;color:black;font-size:14px;font-weight:bold;border:0px solid red'> <button style="width:45%;float:right;padding:5px;text-align:right " id="btLoadSelData" > MORE INFORMATION       ❯❯❯</button> </div> <div id="display_personal_cust_info" style='padding:5px;width:100%;float:left;border:1px solid lightgray;background:#fff;height:93%;margin-top:10px'> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>First Name:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDFName' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>Last Name:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDLName' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>Middle Name:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDMName' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>Gender:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDGender' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>Birth Date:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDBirthDate' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>Mobile Numb3er:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDMobile' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>E-Mail Address:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <input type='text' id='loadCDEmail' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'> </div> <div style='float:left;border:0px solid red; background:transparent;width:25%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:2px;'>Home Address:</div> <div style='float:left;border:0px solid red; background:transparent;width:70%;padding:0px;text-align:left'> <textarea rows='1' id='loadCDHomeAddress' style='width:100%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black'></textarea> </div> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:3px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:10px;border-bottom:1px solid gray;'></div> <div style='float:left;border:0px solid red; background: #fff ;width:100%;padding:0px;text-align:left;height:270px;border:1px solid #aed6f1 '> <div style="float:left;width:40%;border:0px solid gray;height:30px;padding:5px;font-size:14px;color:black;background:#a2d9ce;border-right:1px dashed #16a085">SOCIAL MEDIA:</div> <div style="float:left;width:60%;border:0px solid gray;height:30px;padding:5px;font-size:14px;color:black;background:#a2d9ce">LOCATION MAPPING:</div> <div style="float:left;width:40%;border:0px solid gray;height:230px;border-right:1px dashed #16a085 "> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:0px;text-align:left;padding:5px;font-size:12px;color:black'> Facebook: <input type='text' id='loadCDFBAccnt' style='width:95%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black;border:1px solid gray'> </div> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:0px;text-align:left;padding:5px;font-size:12px;color:black'> Tweeter: <input type='text' id='loadCDTWAccnt' style='width:95%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black;border:1px solid gray'> </div> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:0px;text-align:left;padding:5px;font-size:12px;color:black'> InstaGram: <input type='text' id='loadCDIGAccnt' style='width:95%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black;border:1px solid gray'> </div> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:0px;text-align:left;padding:5px;font-size:12px;color:black'> Viber: <input type='text' id='loadViberAccnt' style='width:95%;float:left;font-family:Calibri;font-size:12px;margin:2px;padding:3px;color:black;border:1px solid gray'> </div> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:0px;text-align:left;padding:5px;font-size:12px;color:black'> <b style='font-family:Verdana;font-size:12px;color:#727373;margin-left:5px;font-weight:normal;background:#fcf5ce;padding:2px'>SALES AGENT:</b><br> <select id='svSalesAgent' style='border:1px solid gray;padding:3px;width:100%;min-width:150px;float:left;margin:2px' onchange="showRegion(this.value)"> <?php $getCity = mysql_query("SELECT from `vts_users` WHERE `u_position` LIKE '%sales%' ORDER BY `u_lname` ASC"); echo "<option id=".$row['u_id'].">N/A</option>"; while($row=mysql_fetch_array($getCity)){ echo "<option id=".$row['u_id'].">".$row['u_lname'].", ".$row['u_fname']."</option>"; } ?> </select> </div> </div> <div style="float:left;width:60%;border:0px solid gray;height:230px;padding-left:10px"> <div style="width:100%;border:0px solid red;height:60px"> <div style='float:left;border:0px solid red; background:white;width:48%;padding:5px;text-align:left; font-size:10px;color:black'> Select Region: <select id='svEditRegion' style='font-size:10px;border:1px solid gray;padding:5px;width:98%; margin:2px' onchange="showMunicipalityList(this.value)">> <?php $getCity = mysql_query("SELECT DISTINCT(`region_code`) from `loc_region` WHERE `municipality`!='' ORDER BY `municipality` ASC"); while($row=mysql_fetch_array($getCity)){ echo "<option id=".$row['region_code'].">".$row['region_code']."</option>"; } ?> </select> </div> <div style='float:left;border:0px solid red; background:white;width:48%;padding:5px;text-align:left; font-size:12px;color:black'> Select Municipality: <select id='svEditMunicipality' style='font-size:10px;border:1px solid gray;padding:2px;width:98%; margin:2px' onchange="showCityList(this.value)"> <?php $getCity = mysql_query("SELECT DISTINCT(`municipality`) from `loc_region` WHERE `municipality`!='' ORDER BY `municipality` ASC"); while($row=mysql_fetch_array($getCity)){ echo "<option id=".$row['municipality'].">".$row['municipality']."</option>"; } ?> </select> </div> </div><br> <div style="width:100%;border:0px solid red;height:60px"> <div style='position:relative;float:left;border:0px solid red; background:white;width:48%;padding:5px;text-align:left;font-size:12px;color:black'> Select City: <select id='svEditCity' style='font-size:12px;border:1px solid gray;padding:2px;width:98%; margin:2px' onchange="showBrgyLists(this.value)"> <?php $getCity = mysql_query("SELECT DISTINCT(`city_name`) from `loc_region` WHERE `city_name`!='' ORDER BY `city_name` ASC"); while($row=mysql_fetch_array($getCity)){ echo "<option id=".$row['city_name'].">".$row['city_name']."</option>"; } ?> </select> </div> <div style='float:left;border:0px solid red; background:white;width:48%;padding:5px;text-align:left;font-size:12px;color:black'> Select Barangay: <select id='svEditBrgy' style='font-size:12px;border:1px solid gray;padding:2px;width:98%; margin:2px' > <?php $getCity = mysql_query("SELECT DISTINCT(`barangay_name`) from `db_barangays` WHERE `barangay_name`!='' ORDER BY `barangay_name` ASC"); while($row=mysql_fetch_array($getCity)){ echo "<option id=".$row['barangay_name'].">".$row['barangay_name']."</option>"; } ?> </select> </div> </div> <div style="width:100%;border:0px solid red;height:60px"> <div style='position:relative;float:left;border:0px solid red; background:white;width:97%;padding:5px;text-align:left;font-size:12px;color:black'> Company / Business Information: <select id='svEditBusinessName' style='height:30px;font-size:12px;color:black;border:1px solid gray;padding:2px;width:98%; margin:2px'> <?php $getCompList = mysql_query("SELECT * FROM `businesses_names` WHERE status = 1 ORDER BY business_name ASC"); while($row=mysql_fetch_array($getCompList)){ echo "<option id=".$row['bid'].">".$row['business_name']."</option>"; } ?> </select> </div> <div style='float:left;border:0px solid red; background:white;width:97%;padding:5px;text-align:left;font-size:12px;color:black'> Type / Sector: <select id='svEditSector' style="height:30px;font-size:12px; color:black;border:1px solid gray;padding:2px;width:98%; margin:2px"> <?php $getCompList = mysql_query("SELECT * FROM `db_sectors` WHERE status = 1 ORDER BY sectors_name ASC"); while($row=mysql_fetch_array($getCompList)){ echo "<option id=".$row['sid'].">".$row['sectors_name']."</option>"; } ?> </select> </div> </div> </div> </div> <div style='float:left;border:0px solid red; background:transparent;width:100%;padding:5px;text-align:left;font-family:Verdana;color:blue;font-size:11px;padding-right:10px;margin:0px;border-top:1px solid lightgray;margin-top:15px;height:30px'> <input type="submit" id="updateCustInfo" value="Update Information" style="margin:2px;margin-right:15px;float:right;padding:1px;width:140px;height:30px;font-family:Calibri;font-size:14px;border-radius:0px"> </div> </div> </div> <!--############################## <img src='MyProfilePicture/sample.png' width='100%' height='230px'></img> ############################################--> <div id="display_personal_cust_info_history" style='padding:0px;width:60%;float:left;border:0px solid lightgray;background:#fff;height:95.5%'> </div> <!--########################################################################## svEditSector svEditBusinessName --> </div> <?php //if submit/ save to databasevar if(isset($_POST['done'])){ $searchString = mysql_escape_string($_POST['searchString']); exit(); } //display from database if(isset($_POST['display'])){ $searchString = mysql_escape_string($_POST['searchString']); $result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_fname` LIKE '%$searchString%' \|\| `cust_lname` LIKE '%$searchString%' \|\| `cust_mobile` LIKE '%$searchString%' \|\| `cust_email` LIKE '%$searchString%' ORDER BY `cust_lname` ASC"); if(mysql_num_rows($result) > 1){ $textMsg = "Search Results"; }else{ $textMsg = "Search Result"; } echo "<div class='bgColor' style='background:lightgray;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'> ✛ ".$textMsg." (".mysql_num_rows($result).") <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=23&d=4' class='hideClick hidden' > ♲ </a><!--REFRESH/RELOAD WINDOW--> <a href='#' onclick='showAddXXX()' style='font-weight:bold'> ✕ </a> </div> </div>"; echo "<div style='width:100%;height:580px;border:0px solid red;overflow:auto'>"; echo "<div style='width:2000px;height:440px;border:0px solid red'>"; echo "<table style='width:100%;'>"; echo "<thead> <tr> <th>CUST. ID</th> <th>FIRST NAME</th> <th>LAST NAME</th> <th>M. I</th> <th>GENDER</th> <th>BIRTH DATE</th> <th>MOBILE</th> <th>E-MAIL</th> <th>Facebook</th> <th>Tweeter</th> <th>InstaGram</th> <th>Viber</th> <th>Address</th> <th>Region</th> <th>Municipality</th> <th>City/Locality</th> <th>Barangay</th> <th>Company/Business</th> <th>Sector</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ ?><tr onclick="javascript:showCustDetails(this);" ondblclick="viewCustTable()"><?php echo "<td>".$row['c_id']."</td>"; echo "<td>".$row['cust_fname']."</td>"; echo "<td>".$row['cust_lname']."</td>"; echo "<td>".$row['cust_middle_name']."</td>"; echo "<td>".$row['cust_gender']."</td>"; echo "<td>".$row['cust_bday']."</td>"; echo "<td>".$row['cust_mobile']."</td>"; echo "<td>".$row['cust_email']."</td>"; echo "<td>".$row['cust_fb']."</td>"; echo "<td>".$row['cust_tweet']."</td>"; echo "<td>".$row['cust_InstaG']."</td>"; echo "<td>".$row['cust_viber']."</td>"; echo "<td>".$row['cust_home_add']."</td>"; echo "<td>".$row['cust_region']."</td>"; echo "<td>".$row['cust_municipality']."</td>"; echo "<td>".$row['cust_city']."</td>"; echo "<td>".$row['brgy_name']."</td>"; echo "<td>"; $getCName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='".$row['cust_business_id']."'"),0); echo $getCName; echo "</td>"; echo "<td>"; $getSName = mysql_result(mysql_query("SELECT `sectors_name` FROM `db_sectors` WHERE `sid`='".$row['sector_id']."'"),0); echo $getSName; echo "</td>"; //echo "<td style='padding:5px;'> //<a href='#' onclick='viewCustTable()'><b style='padding:3px;border:1px solid gray;background: #defbfc;margin:2px;'>✎</b></a> //</td>"; echo "</tr>"; } echo "</table>"; echo"</div>"; echo"</div>"; exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings