RESET SEARCH BACK TO OVERVIEW
Search Results
= $min_length){ // if query length is more or equal minimum length then $query = htmlspecialchars($query); // changes characters used in html to their equivalents, for example: < to > $query = mysql_real_escape_string($query); // makes sure nobody uses SQL injection $raw_results = mysql_query("SELECT * FROM milling WHERE (`Z_TIMESTAMP` LIKE '%".$year."%'-'%".$month."%'-'%".$day."%' '%".$hour."%':'%".$minute."%':'%".$second."%')") or die(mysql_error()); // * means that it selects all fields, you can also write: `id`, `title`, `text` // articles is the name of our table // '%$query%' is what we're looking for, % means anything, for example if $query is Hello // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query' // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query' if(mysql_num_rows($raw_results) > 0){ // if one or more resultss are returned do following while($results = mysql_fetch_array($raw_results)){ // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // posts results gotten from database(title and text) you can also show id ($results['id']) } } else{ // if there is no matching resultss do following echo "No results"; } } else{ // if query length is less than minimum echo "Minimum length is ".$min_length; } ?>
Timestamp PPH/Ton Prev Tons Prev Run MCC Spd K1 Spd K2 Spd K3 Spd M1 Spd M2 Spd M3 Spd M4 Spd M5 Spd M6 Spd M1 Lvl M2 Lvl M3 Lvl M4 Lvl M5 Lvl M6 Lvl
".$results [ 'Z_TIMESTAMP' ]."".$results [ 'LBSPERHR' ]."".$results [ 'PREVTONS' ]."".$results [ 'PREVTIME' ]."".$results [ 'MAINSPD' ]."".$results [ 'KNIFE1SPD' ]."".$results [ 'KNIFE2SPD' ]."".$results [ 'KNIFE3SPD' ]."".$results [ 'MILL1SPD' ]."".$results [ 'MILL2SPD' ]."".$results [ 'MILL3SPD' ]."".$results [ 'MILL4SPD' ]."".$results [ 'MILL5SPD' ]."".$results [ 'MILL6SPD' ]."".$results [ 'MILL1LVL' ]."".$results [ 'MILL2LVL' ]."".$results [ 'MILL3LVL' ]."".$results [ 'MILL4LVL' ]."".$results [ 'MILL5LVL' ]."".$results [ 'MILL6LVL' ]."