Advertisement
Guest User

Untitled

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