javascript - Trying to make a submit button in another file update a table in another file without refreshing the page -
here 3 classes: class combine other 2 classes. when press submit table on right update without refreshing.
<!doctype html> <html> <head> <title>bugdisplayandreport</title> <script src = "jquery.js"></script> <script> $(document).ready(function(){ $.post('bugreport.html',{},function(data){ $("#bugreport").html(data); }); }); $(document).ready(function(){ $.post('bugdisplay.php',{},function(data){ $("#bugdisplay").html(data); }); }); </script> </head> <body> <div id = "bugreport"></div> <div id = "bugdisplay"></div> </body> </html> here issue report code, not going use "location.reload(true)" want because the page update without refreshing: <!doctype html> <html> <head> <title>issuereport</title> <script src = "jquery.js"></script> <style> body{ padding:0; margin:0; } #box { padding: 5px; color:black; margin: 0 auto; border-style: solid; border-color: black; border-width: 1px; width: 162px; float: left; } </style> <script> $(document).ready(function(){ $("#sub").click(function(){ var user_issue = $("#issue").val(); var user_priority = $("#priority").val(); var user_type = $("#type1").val(); $.post("bugreport.php",{issue:user_issue,priority:user_priority,type1:user_type},function(data){ $("#result").html(data); //location.reload(true); }); }); }); </script> </head> <body> <div id="box"> <h3 style = "margin:10px 30px 30px 30px">issue report</h3> <form action="bugreport.html" method="post"> <textarea cols="20" rows="18" name="issue" id = "issue" placeholder = "enter issue here" "></textarea></form><br> <div style = "width: 100px; margin-left: auto; margin-right: auto">type of issue:</div> <div style = "width: 150px; margin-left: auto; margin-right: auto; padding: 2px"> <form action="bugreport.html" method="post"> <select name = "type1" id = "type1"> <option value = "listing discrepancy">listing discrepancy</option> <option value = "po discrepancy">po discrepancy</option> <option value = "pricing discrepancy">pricing discrepancy</option> <option value = "program glitch">program glitch</option> <option value = "receiving discrepancy">receiving discrepancy</option> <option value = "rma discrepancy">rma discrepancy</option> <option value = "sales discrepancy">sales discrepancy</option> <option value = "shipping discrepancy">shipping discrepancy</option> </select> </form></div> <div style = "width: 50px; margin-left: auto; margin-right: auto">priority:</div> <div style = "width: 70px; margin-left: auto; margin-right: auto; padding: 2px"> <form action="bugreport.html" method="post"> <select name = "priority" id = "priority"> <option value = "low">low</option> <option value = "regular" selected>regular</option> <option value = "high">high</option> <option value = "urgent">urgent</option> </select> </form></div> <div style = "width: 50px; margin-left: auto; margin-right: auto; padding: 2px"> <input type ="submit" name = "sub" value = "submit" id = "sub"></div> <div id="result"></div> </div> </body> </html> here code creates table on right:
<?php $servername = "localhost"; $username = "username"; $password = "password"; $database = "database"; $con = mysqli_connect($servername,$username,$password,$database); if($con->connect_error){ die("connection failed " . $con->connect_error); } $strsql = "select * bugreport priority = 'urgent'"; $strsql1 = "select * bugreport priority = 'high'"; $strsql2 = "select * bugreport priority = 'regular'"; $strsql3 = "select * bugreport priority = 'low'"; $rs = mysqli_query($con,$strsql); $rs1 = mysqli_query($con,$strsql1); $rs2 = mysqli_query($con,$strsql2); $rs3 = mysqli_query($con,$strsql3); $i = 0; echo "<table style = 'float: left; position: relative; left:160px; border: 1px; border-style:solid; border-collapse: collapse;'><tr> <th style = 'border: 1px; border-style:solid; border-collapse: collapse;'>priority</th> <th style = 'border: 1px; border-style:solid; border-collapse: collapse'>issue category</th> <th style = 'border: 1px; border-style:solid; border-collapse: collapse;width: 300px'>issue</th> <th style = 'border: 1px; border-style:solid; border-collapse: collapse;'>date</th></tr>"; while($row = mysqli_fetch_array($rs)){ if(($i % 2) == 0){ echo '<tr style="border: 1px; background:#ccff33; color: black">'; }else {echo '<tr style="border: 1px; background:white; color: black">';} echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['priority'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['type1'] . "</td>"; echo "<td style = 'word-break:keep-all;width: 300px; border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['issue'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['date'] . "</td>"; echo '</tr>'; $i = $i + 1; } while($row = mysqli_fetch_array($rs1)){ if(($i % 2) == 0){ echo '<tr style="border: 1px; background:#ccff33; color: black">'; }else {echo '<tr style="border: 1px; background:white; color: black">';} echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['priority'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['type1'] . "</td>"; echo "<td style = 'word-break:keep-all;width: 300px; border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['issue'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['date'] . "</td>"; echo '</tr>'; $i = $i + 1; } while($row = mysqli_fetch_array($rs2)){ if(($i % 2) == 0){ echo '<tr style="border: 1px; background: #ccff33; color: black">'; }else {echo '<tr style="border: 1px; background:white; color: black">';} echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['priority'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['type1'] . "</td>"; echo "<td style = 'word-break:keep-all;width: 300px; border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['issue'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['date'] . "</td>"; echo '</tr>'; $i = $i + 1; } while($row = mysqli_fetch_array($rs3)){ if(($i % 2) == 0){ echo '<tr style="border: 1px; background:#ccff33; color: black">'; }else {echo '<tr style="border: 1px; background:white; color: black">';} echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['priority'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['type1'] . "</td>"; echo "<td style = 'word-break:keep-all;width: 300px; border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['issue'] . "</td>"; echo "<td style = 'border: 1px; border-style:solid; border-collapse: collapse;'>" . $row['date'] . "</td>"; echo '</tr>'; $i = $i + 1; } echo "</table>"; ?>
Comments
Post a Comment