php - display element in search result page, then the details in another page -


the result of search comes database, on result page when click on name of searched element, want redirected page viewing more information element database!

here insert company code:

<?php      $db = new mysqli('localhost', 'root', '', 'search');      if(isset($_post["submit"]))     {         $comname = addslashes($_post["comname"]);         $comcountry = addslashes($_post["comcountry"]);         $comkey = addslashes($_post["comkey"]);         $comdes = addslashes($_post["comdes"]);         $comlink = addslashes($_post["comlink"]);         $comlogo = $_files["comlogo"]["name"];         $comlogo_tmp = $_files['comlogo']['tmp_name'];          move_uploaded_file($comlogo_tmp, "images/$comlogo");         {             $sql = "insert tshirt (comname, comcountry, comkey, comdes, comlink, comlogo) values ('$comname', '$comcountry', '$comkey', '$comdes', '$comlink', '$comlogo')";              $rs = mysqli_query($db, $sql);              if($rs)             {                 echo "<script> alert('company uploaded successfully') </script>";             }              else              {                 echo "<script> alert('uploading failed, please try again.') </script>";             }          }     } ?>

result page 

<?php                              $mysqli = new mysqli("localhost", "root", "", "search");                             if(isset($_get['search_button']))                              {                                 $search = $_get['search'];                                 if($search=="")                                  {                                 echo "<center> <b> please write in search box </b> </center>";                                 exit();                                 }                                 $sql = "select * tshirt comkey '%$search%' limit 0, 5";                                 $rs =  mysqli_query($mysqli, $sql);                                 if (mysqli_num_rows($rs) < 1)                                  {                                     echo "<center> <h4> <b> oops !!! sorry, there no result found, try again. </b> </h4> </center>";                                     exit();                                 }                              echo "<font size='+1' color='#1a1aff'> images $search</font>";                              while ($row = mysqli_fetch_array($rs)) {                                 echo   "<td>                                             <table style='margin-top: 10px'>                                                 <tr>                                                     <td>                                                         <a target='_blank' href='images.php?id=$search'><img src='img/$row[5]' height='100px'></a>                                                     </td>                                                 </tr>                                             </table>                                         </td>";                                 }                             }                         ?>                     </tr>                 </table>                 <?php                 echo "<a target='_blank' href='images.php?id=$search'><font size='+1' color='#1a1aff'> more images $search </font></a>";                  echo "<hr>";                     $sql1 = "select * tshirt comkey '%$search%' limit 0, 10";                     $rs1 =  mysqli_query($mysqli, $sql1);                     while ($row1 = mysqli_fetch_array($rs1))                     {                           echo "<a href='$row1[2]'><font size='4' color='#0000cc'> $row1[1] </font></a><br>";                         echo "<font size='3' color='#006400'> $row1[2] </font><br>";                         echo "<font size='3' color='#666666'> $row1[4] </font><br><br>";                     }                 ?>

help!

all answers welcome. thanks!


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more