Advertisement
Guest User

Untitled

a guest
Jan 8th, 2017
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. <?php
  2. $hostname = "localhost";
  3. $username = "name";
  4. $password = "pass";
  5. $databaseName = "shreddin_nation";
  6. $titleSafe = mysqli_escape_string($_POST['title']);
  7. $connect = mysqli_connect($hostname, $username, $password, $databaseName);
  8.  
  9. if(isset($_POST['fsearch']) || $_POST['fsearch']!=""){
  10.     $fsearch = $connect->query("SELECT * FROM food_data_bg WHERE search_term LIKE %".$titleSafe."%");
  11.  
  12.    
  13.     if($fsearch->rowCount()==0)
  14.     {
  15.         echo 'Не бяха намерени резултати!';
  16.     }else{
  17.         while($data=$fsearch->fetch_assoc())
  18.         {
  19.             ?>
  20.             <div class="search-result">
  21.                 <img src="<?php echo $data['fimage']; ?>" class="fimage"/>
  22.                 <span class="result-title"><?php echo $data['title'];?></span><br>
  23.                 <span class="calories-total"><?php echo $data['calories total'];?></span><br>
  24.  
  25.             </div>
  26.             <?php
  27.         }
  28.     }
  29. }
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement