retrieve variable from another php file

Question

i wanted to display the output of the query, but i cant retrieve my variable $result mainly because it is on a different file but i used the require to get it but i still get the error variable not defined,i wanted to know how can i retrieve the $result that's been on function.php and used it on the search.php to display.

search.php

<?php

include "db.php";
include "function.php";

if(isset($_GET['keywords'])){
global $connection;
$keyword = ($_GET['keywords']);
 searchData($keyword);
}

?>

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form action="search.php" method="GET">
    <label>
        Search
        <input type="text" name="keywords">
    </label>

    <input type="submit" name="search">

    <div class="form-group">

    <div class="result-count">
        Found <?php echo $query->num_rows; ?>result
    </div>
    <?php
        if($query->num_rows){
            while($r = $query->fetch_rows()){
            }
        }   
    ?>

    </div>

  </form>
</body>
</html>

function.php

<?php require_once "db.php";?>
<?php
  function searchData($keyword){
global $connection;

$query = ("
          SELECT username
          FROM users
          WHERE username LIKE '%{$keyword}%'
          ");
$result = mysqli_query($connection, $query);

echo "$result->num_rows". "found";
}   
?>

db.php

<?php

$connection = new mysqli('localhost', 'root', '',
    'loginapp');

    if(!isset($connection)){
        die("Database connection failed!");
    }

You're establishing $result in a function searchData() so it will be out of scope to use elsewhere. Try having searchData() return your result instead then set it like so $result = searchData(); — Aaron W.
– Aaron W., Commented Sep 28, 2017 at 2:14
@AaronW. I'm getting error like Fatal error: Uncaught Error: Call to undefined method mysqli_result::fetch_rows() in C:\xampp\htdocs\udemy\mysql\search.php:33 Stack trace: #0 {main} thrown in C:\xampp\htdocs\udemy\mysql\search.php on line 33 — Josel Parayno
– Josel Parayno, Commented Sep 28, 2017 at 2:48
First try to call the function searchData() then try to see your query — Herry Potei
– Herry Potei, Commented Sep 28, 2017 at 3:02

shortchng · Accepted Answer · 2017-09-28 03:24:28Z

1

To expand on Arron W.'s comment, In your function.php file, you will need to return $result, then in search.php you will use load the return into a variable, then use that variable to access the data.

function.php

$result = mysqli_query($connection, $query);

echo "$result->num_rows". "found";
return $result
}   
?>

search.php

    if(isset($_GET['keywords'])){
    global $connection;
    $keyword = ($_GET['keywords']);
     $result = searchData($keyword);
    }

...

<div class="result-count">
        Found <?php echo $result->num_rows; ?>result
    </div>
    <?php
        if($result->num_rows){
            while($r = $result->fetch_row()){
            }
        }   
    ?>

edited Sep 28, 2017 at 3:24

answered Sep 28, 2017 at 2:31

shortchng

665 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

shortchng Over a year ago

According to the comment-formatting page, by surrounding the code in backticks (`)

shortchng Over a year ago

You probably have a $query left in your search.php.... replace them all with the $result

Josel Parayno Over a year ago

yeah my bad, and now this is the error that i'm getting Fatal error: Uncaught Error: Call to undefined method mysqli_result::fetch_rows() in C:\xampp\htdocs\udemy\mysql\search.php:33 Stack trace: #0 {main} thrown in C:\xampp\htdocs\udemy\mysql\search.php on line 33

shortchng Over a year ago

Ahh yes... use fetch_row() instead of fetch_rows() FetchRow

Collectives™ on Stack Overflow

retrieve variable from another php file

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related