javascript - Cannot display Mysql search results from search in a different div -
i trying display mysql results (with , without search) using 3 divisions. div 1 has radio buttons selecting viewing results. div 2 has text states members displayed, text search box name, , drop-down menu type. results of search displayed in div 3.
when members selected text "display members" shows in div 2 , correct data displayed in div 3 (works correctly). when name radio button selected correct text search box displays in div 2 receive following errors in div 3:
warning: mysqli_query(): couldn't fetch mysqli in /home/desgar20/elrenochamber.com/member_dir_test2.php on line 171
warning: mysqli_error() expects 1 parameter, 0 given in /home/desgar20/elrenochamber.com/member_dir_test2.php on line 173 not access database:
if enter text search box , submit, div 2 , div 3 go blank
i using javascript show/hide divisions , php search.
i have searched answers have not found resolve issue. don't know missing. help- -need advice.
<style type="text/css"> .box { display: none; } </style> <script type="text/javascript"> //show or application part based on selection $(document).ready(function(){ $('input[type="radio"]').click(function(){ if($(this).attr("value")=="all"){ $(".box").not(".all").hide(); $(".all").show(); $(".all_listing").show(); } if($(this).attr("value")=="name"){ $(".box").not(".name").hide(); $(".name").show(); $(".all_name").show(); } if($(this).attr("value")=="type"){ $(".box").not(".type").hide(); $(".type").show(); $(".all_type").show(); } }); }); </script> </head> <body> <?php require_once 'php/dbconnect.php'; // connect database $connection = db_connect(); ?> <div id="container"> <div id="service"> <div id="web"> <img width="150px" src="images/search1.png" /> <h3>member <strong><span class="green">directory</span></strong></h3> <strong>view members by:</strong><br /><br /> <div id="sortoptions"> <label><input type="radio" name="sortradio" value="all"> members</label><br /> <label><input type="radio" name="sortradio" value="name"> name</label><br /> <label><input type="radio" name="sortradio" value="type"> type</label> </div><!-- sortoptions --> </div><!-- end web --> <div id="vector"> <div class="all box"> <h3>display <strong><span class="green">all members</span></strong></h3> <p>all members displayed</p> </div><!-- box --> <div class="name box"> <h3>display <strong><span class="green">member name</span></strong></h3> <p><form name="namesearch" method="post" action="<?php echo htmlentities($_server['php_self']);?>"> name: <input type="text" name="find"> <input type="submit" name="search" value="search names"> </form></p> </div><!-- name box --> <div class="type box"> <h3>display <strong><span class="green">member type</span></strong></h3> <p><form action="<?php echo htmlentities($_server['php_self']);?>" method="post"> type: <select name="type" id="type"> <option value="">-- select type --</option> <?php $query = "select * select_type"; //create type drop-down menu $result = mysqli_query($connection, $query); while ($line = mysqli_fetch_array($result)) { echo "<option value='". $line['type'] ."'>". $line['type']."</option>"; } ?> </select> <input type="submit" name="searchtype" value="search types"> </form> </div><!-- type box --> </div><!-- end vector --> </div><!-- end service--> <div id="media" class="group"> <div class="all_listing box"> <p>directory listing</p> <!-- start directory listing --> <?php $sql = "select * members order name"; // database query , results $result = mysqli_query($connection, $sql); while($row = mysqli_fetch_array($result)) { // check record website if ($row['web']!== "") { echo "<a target=blank href=". $row['web'] . ">" .$row["name"] . "</a><br> " . "". $row["type"] . "<br>" . "address: " . $row["physicaladdress"] . "<br>" . "phone: " . $row["phone"] . "<br>" . "<hr>"; } else { echo $row["name"]. "<br> " . "". $row["type"] . "<br>" . "address: " . $row["physicaladdress"] . "<br>" . "phone: " . $row["phone"] . "<br>" . "<hr>"; } } $connection->close(); ?> </div><!-- all_listing box --> <div class="all_name box"> <p>results based on name search</p> <?php if (isset($_post['search'])) { // has "select names button ben pushed $find = $_post['find']; $sql = "select * members name '%" . $find . "%' "; $result = mysqli_query($connection, $sql); if(! $result) { die ('could not access database: ' . mysqli_error()); } while($row = mysqli_fetch_array($result)) { // check record website if ($row['web']!== "") { echo "<a target=blank href=". $row['web'] . ">" .$row["name"] . "</a><br> " . "". $row["type"] . "<br>" . "address: " . $row["physicaladdress"] . "<br>" . "phone: " . $row["phone"] . "<br>" . "<hr>"; } else { echo $row["name"]. "<br> " . "". $row["type"] . "<br>" . "address: " . $row["physicaladdress"] . "<br>" . "phone: " . $row["phone"] . "<br>" . "<hr>"; } } } ?> </div><!-- all_name box --> </body> </html> i modified code recommendation still receive same errors mention above. here area having difficulty with:
this division (div 1) display search option in div 2:
<div id="web"> <div id="sort_options"> <label><input type="radio" name="sortradio" value="name"> name</label><br /> </div><!-- sort_options --> </div><!-- end web --> this search feature div 2:
<div class="name box"> <form name="namesearch" method="post" action="<?php echo htmlentities($_server['php_self']);?>"> name: <input type="text" name="find"> <input type="submit" name="search" value="search names"> </form></p> </div> this php code in div 3 run query input div 2:
<div class="all_name box"> <?php if (isset($_post['search'])) { $find = $_post['find']; $sql = "select * members name '%" . $find . "%' "; $result = mysqli_query($connection, $sql); if ( $result == false ) { echo ("error description: " . mysqli_error($connection)); } else { while($row = mysqli_fetch_array($result)) { // check record website if ($row['web']!== "") { echo "<a target=blank href=". $row['web'] .">" .$row["name"] . "</a><br> " . "". $row["type"] . "<br>" . "address: " . $row["physicaladdress"] . "<br>" . "phone: " . $row["phone"] . "<br>" . "<hr>"; } else { echo $row["name"]. "<br> " . "". $row["type"] . "<br>" . "address: " . $row["physicaladdress"] . "<br>" . "phone: " . $row["phone"] . "<br>" . "<hr>"; } } } } ?> </div> what doing wrong here?
change snippet:
$sql = "select * members order name"; // database query , results $result = mysqli_query($connection, $sql); while($row = mysqli_fetch_array($result)) { to at least
$sql = "select * members order name"; // database query , results $result = mysqli_query($connection, $sql); while($result !== false && $row = mysqli_fetch_array($result)) { reason: if query faulty, $result have value false cause given error.
better code this:
$sql = "select * members order name"; // database query , results $result = mysqli_query($connection, $sql); if ( $result == false ) { // handle error mysqli_... functions } else { while($row = mysqli_fetch_array($result)) { ... as always: take error standard, success exception!
Comments
Post a Comment