How to arrange the table using php, javascript -
this php , javascript. have row consist of classcode, coursenumber,coursedescription,units,time,days,room problem not arrange it. displays data in column of coursedescription. below picture looks , how want be.
$(document).ready(function() { $("#faq_search_input").watermark("begin typing search"); $("#faq_search_input").keyup(function() { var faq_search_input = $(this).val(); var datastring = 'keyword='+ faq_search_input; if(faq_search_input.length>3) { $.ajax({ type: "get", url: "search.php", data: datastring, beforesend: function() { $('input#faq_search_input').addclass('loading'); }, success: function(server_response) { $('#searchresultdata').html(server_response).show(); $('span#faq_category_title').html(faq_search_input); if ($('input#faq_search_input').hasclass("loading")) { $("input#faq_search_input").removeclass("loading"); } } }); }return false; }); }); home.php
<div id="subjectoffering" class = "listtable" > <p><h3> subject offering </h3> </p> <p> <div class = "searchbar"> <form id="searchbox" action="#" onsubmit="return false;"> <!-- searchbox starts here --> <input name="query" type="text" id="faq_search_input" /> <!-- searchbox ends here --> </form> </div> </p> <p> <table> <tr> <td>class code</td> <td>course number</td> <td>course description</td> <td>time</td> <td>days</td> <td>room</td> </tr> <tr> <td></div></td> <td></td> <td><div id="searchresultdata" class="faq-articles"> </td> <td> </td> <td> </td> <td></td> <td> </td> </tr> </table> search.php
<?php include_once ('connections.php'); if(isset($_get['keyword'])){ $keyword = trim($_get['keyword']) ; $keyword = mysqli_real_escape_string($dbc, $keyword); $query = "select coursecode,classcode,coursedescription,time,day,room class classcode '%$keyword%' or coursedescription '%$keyword%' or coursecode '%$keyword%' or time '%$keyword%' or day '%$keyword%' or room '%$keyword%'"; //echo $query; $result = mysqli_query($dbc,$query); if($result){ if(mysqli_affected_rows($dbc)!=0){ while($row = mysqli_fetch_array($result,mysqli_assoc)){ echo '<p> <b>'.$row['classcode'].'</b> '.$row['coursecode']. '</b>'.$row['coursedescription'].'</b> '.$row['time'].'</b> '.$row['day'].'</b> '.$row['room'].'</p>'; } }else { echo 'no results :"'.$_get['keyword'].'"'; } } }else { echo 'parameter missing'; } ?>
your code has few html tag errors unused tags there. revised code. please verify if found errors still let me know.
your javascript / jquery code should following:
/** * @description: update result when user searches. * @author vivek keviv * @params none * @return none */ $ (document).ready(function() { $("#faq_search_input").watermark("begin typing search"); $("#faq_search_input").keyup(function() { var faq_search_input = $(this).val(); var datastring = 'keyword='+ faq_search_input; if (faq_search_input.length>3) { $.ajax({ type: "get", url: "search.php", data: datastring, beforesend: function() { $('input#faq_search_input').addclass('loading'); }, success: function(server_response) { $('#searchresultdata').html(server_response).show(); $('span#faq_category_title').html(faq_search_input); if ($('input#faq_search_input').hasclass("loading")) { $("input#faq_search_input").removeclass("loading"); } } }); } return false; }); }); your html code should following:
<div id="subjectoffering" class="listtable"> <p> <h3>subject offering</h3> </p> <div class="searchbar"> <form id="searchbox" action="#" onsubmit="return false;"> <!-- searchbox starts here --> <input name="query" type="text" id="faq_search_input" /> <!-- searchbox ends here --> </form> </div> <div id="searchresultdata" class="faq-articles"> <table> <tr> <th>class code</th> <th>course number</th> <th>course description</th> <th>time</th> <th>days</th> <th>room</th> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> </table> </div> </div> your php code should following:
<?php include_once ('connections.php'); if (isset($_get['keyword'])) { $keyword = trim($_get['keyword']) ; $keyword = mysqli_real_escape_string($dbc, $keyword); $query = "select coursecode,classcode,coursedescription,time,day,room class classcode '%$keyword%' or coursedescription '%$keyword%' or coursecode '%$keyword%' or time '%$keyword%' or day '%$keyword%' or room '%$keyword%'"; //echo $query; $result = mysqli_query($dbc,$query); if ($result) { if (mysqli_affected_rows($dbc)!=0) { ?> <table> <tr> <th>class code</th> <th>course number</th> <th>course description</th> <th>time</th> <th>days</th> <th>room</th> </tr> <?php while ($row = mysqli_fetch_array($result,mysqli_assoc)) { ?> <tr> <td><?php echo $row['classcode']; ?></td> <td><?php echo $row['coursecode']; ?></td> <td><?php echo $row['coursedescription']; ?></td> <td><?php echo $row['time']; ?></td> <td><?php echo $row['day']; ?></td> <td><?php echo $row['room']; ?></td> </tr> <?php } ?> </table> <?php } else { echo 'no results :"'.$_get['keyword'].'"'; } } } else { echo 'parameter missing'; } ?> thanks & regards,
vivek
Comments
Post a Comment