Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $hostname = "localhost";
- $username = "name";
- $password = "pass";
- $databaseName = "dbName";
- $connect = new mysqli($hostname, $username, $password, $databaseName);
- $fsearch = $_POST['fsearch'];
- if(!empty($_POST["fsearch"])) {
- $req = $connect->prepare("SELECT * FROM food_data_bg WHERE title LIKE '".$fsearch."%'");
- $req->execute(array(
- 'title'=>'%'.$_POST['fsearch'].'%'
- ));
- if($req->rowCount()==0){
- echo 'Не бяха намерени резултати!';
- }
- else{
- while($row=$req->fetch_array()){
- ?>
- <div class="search-result">
- <img src="<?php echo $data['fimage']; ?>" class="fimage"/>
- <span class="result-title"><?php echo $data['title'] ;?></span>
- <br>
- <span class="calories-total"><?php echo $data['calories total'] ;?></span>
- <br>
- </div>
- <?php
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement