php - Make the results from a mysql database search selectable -

-

i have database containing stock items , webpage allows search through database item type or specific item number. results returned , displayed in table under search form.

currently saving results of mysql query array, , printing results of array table.

how can make result selectable , have button such 'add' allow me retrieve information database based on selected item.

edit -

<?php require("header.php"); if(isset($_request['searching'])){ //check if form has been submitted connect('final');//connect db //set values search form $field = $_post['field']; $query = $_post['query'];       $query = htmlspecialchars($query); // stop html characters     $query = mysql_real_escape_string($query); //stop sql injection       $data = mysql_query("select *      stock       stock.part_number in (select stock.part_number      stock      upper(stock.$field) like'%$query%')") ;//query db search field in colleumn selected//       //$data = mysql_query("select * customer inner join address on customer.id = address.customer_id left outer join sites on address.id = sites.address_id upper(customer.$field) like'%$query%'") ;      if($data === false) {     $error = 'query error:'.mysql_error();     echo $error;     }     else     {      $test = array();     $colnames = array();     while($results = mysql_fetch_assoc($data)){// puts data database array, loops until no more      $test[] = $results;          }     $colnames = array_keys(reset($test));           $anymatches=mysql_num_rows($data); //checks if querys returned results             if ($anymatches == 0)                      {                          echo "sorry, can not find entry match query<br><br>";                      }       }

then below in html form create table , have 

<?php    //print header    foreach($colnames $colname)    {       echo "<th>$colname</th>";    } ?>

and

<?php    //print rows    foreach($test $results)    {       echo "<tr>";       foreach($colnames $colname)       {          echo "<td>".$results[$colname]."</td>";       }       echo "</tr>";    } ?>

i wasn't sure start try checkbox method.

well, there many ways adjust search user's liking.

the basic solution requires php , html have checkboxes @ cells want use filter.

then can add new parts old mysql-command and-connection. e.g. checkbox "name"-column next search show entries checked names.

<input type="checkbox" name="names[]" id="chwalter" value="walter" /> <label for="chwalter">chwalter</label>

when posted run through checkbox-array loop , add like

" , name '".$_get['names'][$i]."'".

note using groups checkboxes give array of activated element's values.

of course modify how checked checkbox alters request... removing filters, use regular expressions on request-string.

a nicer solution using javascript. e.g. use hidden checkboxes checked click on table-cells.

or use javascript filter elements! using classes ,

document.getelementsbyclassname['class']

will lighten server-traffic , speed request. that, recommend use class each row (row1, row2, etc.) , 1 each column (name, id, etc. ). when click on field, elements of same column class , loop through them.

if content mismatches, go through row-class , set css-attribtue "display:none"... if use table-layout can replace use of row-classes 

this.parentnode.style.display="none"

to disable row (<tr>-tag).

otherwise remove css again show them.

the disadvantage is, reduced result shown user, using reduced version again on server site, need map result again checkboxes or maybe hidden fields , send again.


Popular posts from this blog

How to calculate SNR of signals in MATLAB? -

-
i've encountered simple, yet fundamental problem on calculating snr: there several signals : s1 = original , pure clean signal without noise. n1 = white gaussian noise going added s1. s2 = s1 + n1 (the noisy signal before performing noise-reduction algorithm) s3 = noise-reduced signal (after performing noise reduction algorithm) n2 = s3 - s1 (the amount of noise after performing noise-reduction algorithm) now want compare snr before , after performing noise-reduction algorithm. which signals should consider snr_before!? s1/n1 or s2/n1 ? which signals should consider snr_after!? s3/n1 or s3/n2 ? which commands or functions should use in matlab in order compute snr_before , snr_after? thanks billion putting time on helping me. what know calculating snr before : snrbeforenoise = mean( signal .^ 2 ) / mean( noise .^ 2 ); and snr after : residual_noise = signal - noise_reduced_signal; snr_after = mean( signal .^ 2 ) / mean( residual_noise .^ 2...
Read more

c# - Attempting to upload to FTP: System.Net.WebException: System error -

-
i have api takes in xml , uploads files based on information in xml. uploads on schedule (also xml), , have tested surrounding , know works. i getting error 40% of time on first file attempt upload in each time cycle (time cycle = 45 minutes files, 30 minutes others). here code upload: try { loggerftp.log("uploading file: " + filename, false); // create request. ftpwebrequest request = (ftpwebrequest)webrequest.create(appsettingsftp.ftpurl + @"/" + filename); request.method = webrequestmethods.ftp.uploadfile; request.timeout = 6000000; //set 100 minutes //request.timeout = -1; //set infinite // add login credentials. request.credentials = new networkcredential(appsettingsftp.ftplogin, appsettingsftp.ftppassword); // grab file contents. streamreader sourcestream = new streamreader(appsettingsftp.uploadfiledirectory + filename); byte[] filecontents = encoding.utf8.getbytes(sourcestream.readtoend()); sourcest...
Read more

ios - UISlider customization: how to properly add shadow to custom knob image -

-
Image
i need place custom knob image shadow uislider. far have image of 38x38, of there region defines shadow of knob. now while using image, when slide knob extreme ends actual knob not able cover end points, hence end points visible under transparent region of knob image this code using customize uislider uiimage *slidebtimg = [uiimage imagenamed:sliderknobimg]; [self.ratingslider setthumbimage:slidebtimg forstate:uicontrolstatenormal]; [self.ratingslider setthumbimage:slidebtimg forstate:uicontrolstatehighlighted]; how can implement custom knob shadow beneath it, covering end points?? look inside uislider.h , there methods let customize slider knob , track needed. (ios 2.0 , above) // lets subclass lay out track , thumb needed - (cgrect)minimumvalueimagerectforbounds:(cgrect)bounds; - (cgrect)maximumvalueimagerectforbounds:(cgrect)bounds; - (cgrect)trackrectforbounds:(cgrect)bounds; - (cgrect)thumbrectforbounds:(cgrect)bounds trackrect:(cgrect)rect value:...
Read more