将查询放入php include中 - Putting queries in a php include

Putting queries in a php include

本文关键字：include php 查询 | 更新日期: 2023-12-12

好的，所以我有一个php include，它包含一些查询，并且希望能够在需要时通过运行一个函数来调用它们。当运行函数时，我没有得到返回的查询。不确定是否需要使用return（）；是否包含。

<?php
// include file with queries
function displayQueryOne(){
$q = "SELECT * FROM culturegrams.new_to WHERE edition = '$url' ORDER BY placement ASC";     
$results= mysql_query($q) or die('could not run Query '.mysql_error());
return($results);
}
?>

<?php
//PAGE # 2 page to display query results
require('queryfile.php');
//running function from the include file
$results = displayQueryOne()
//running indpendent php while loop that will generate hmtl

    while ($r = mysql_fetch_assoc($results)){
?>
    <div class="top_menu"><p class="menu_text"><?php echo $r['title'];?></p></div>
    <div class="mid_menu">      
        <p class="explore_text">
            <?php echo $r['text'];?>
        </p>
    </div>

是的，你需要让它像一样返回

function displayQueryOne(){
  $q = "SELECT * FROM culturegrams.new_to WHERE edition = '$url' ORDER BY placement ASC";     
  $results= mysql_query($q) or die('could not run Query '.mysql_error());
  return $results;
}

然后你需要这样称呼它

$results = displayQueryOne();

如果函数返回一个数组会更好，因为这是你真正想要的。

function displayQueryOne(){
$q = "SELECT * FROM culturegrams.new_to WHERE edition = '$url' ORDER BY placement ASC";     
$query = mysql_query($q) or die(mysql_error());
     if($query)
     {
        while($row = mysql_fetch_array($query))
        {
             $array[] = $row;
        }
        return $array;
     }else{ return 'Nothing';}
}