Advertisement
Guest User

Untitled

a guest
Jan 8th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. <?php
  2.  
  3. $hostname = "localhost";
  4. $username = "name";
  5. $password = "pass";
  6. $databaseName = "shreddin_nation";
  7.  
  8. $connect = mysqli_connect($hostname, $username, $password, $databaseName);
  9. if(isset($_POST['fsearch']) && $_POST['fsearch']!=""){
  10. $fsearch = $connect->prepare("SELECT * FROM food_data_bg WHERE search_term LIKE :title");
  11. $fsearch->execute(array(
  12. 'title'=>'%'.$_POST['title'].'%'
  13. ));
  14. if($fsearch->rowCount()==0){
  15. echo 'Не бяха намерени резултати!';
  16. }
  17. else{
  18. while($data=$fsearch->fetch()){
  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