dongpu6141 2016-06-25 00:47
浏览 40
已采纳

PHP MYSQL OOP打印从外部变量调用的表行的值以进行打印

My PHP class function looks something like as when fetching data from database table:

class my {
   public $a;

   public function myFunc(){
       $query = mysql_query("select name,loc,info from stores");
       while ($row = mysql_fetch_array($query)) {
           extract($row);
            echo $this->a;
       }
   }
}

I want that it should print the result of that rows of table which are called when creating object of the class and calling class method as:

$class = new my();
$class->a = '<h1>$name</h1>';
$class->a .= '<p>$loc</p>';
$class->myFunc();

But it did't gives proper result and print as:

$name
$loc
$name
$loc
$name
$loc
...

I want it should print the values of these variable which are actually rows of table and result should be something looking like as:

london store
london near the big mall, england
PK world wide store
F-5 street near the new G-T road london
...

How it can be possible?

Thank You.

  • 写回答

1条回答 默认 最新

  • dstnlhhv791576 2016-06-25 01:17
    关注

    '<h1>$name</h1>' and '<p>$loc</p>' are just a plain strings. The variable references inside them won't get evaluated by echo.

    You can return the items and render them outside of the function:

    class my {
       public function myFunc(){
           $query = mysql_query("select name,loc,info from stores");
    
           $items = array();
           while ($row = mysql_fetch_array($query)) {
                $items[] = $row;
           }
    
           return $items;
       }
    }
    
    $class = new my();
    $items = $class->myFunc();
    
    foreach ($items as $item) {
        echo "<h1>{$item['name']}</h1><p>{$item['loc']}</p>";
    }
    

    If you insist on rendering from within the function you can pass in an anonymous function:

    class my {
        public $renderer; 
    
        public function myFunc(){
            $query = mysql_query("select name,loc,info from stores");
    
            while ($row = mysql_fetch_array($query)) {
                 call_user_func($this->renderer, $row);
            }
        }
    }
    
    $class = new my();
    
    $class->renderer = function ($row) {
        extract($row);
        echo "<h1>$name</h1><p>$loc</p>";
    };
    
    $class->myFunc();
    

    I've used double quoted strings in the code. See PHP docs to learn the difference or see What is the difference between single-quoted and double-quoted strings in PHP?

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 给出完整的python代码并解释
  • ¥15 有人懂怎么做大模型的客服系统吗?卡住了卡住了
  • ¥20 firefly-rk3399上启动卡住了
  • ¥15 如何删除这个虚拟音频
  • ¥50 hyper默认的default switch
  • ¥15 网站打不开,提示502 Bad Gateway
  • ¥20 基于MATLAB的绝热压缩空气储能系统代码咨询
  • ¥15 R语言建立随机森林模型出现的问题
  • ¥15 关于#wpf#的问题:怎么更改LayoutGroup组件的标签页的字体颜色
  • ¥15 中级微观经济学,生产可能性边界问题