PHP Traversing Result Set Why can t I get a value

db->get_results('select * from '.tb_prefix.'product where categoryid=10');

Is TB prefix a variable? There is no $ symbol.

Manual query foreach a.

queried out of the array.

arr = array(

array(id=>1,name=>'aa'),array(id=>2,name=>'bb'),array(id=>3,name=>'cc'),)foreach ($arr as $v)--name= ";}

Assign a variable to query the result!

Such as $sql ='select statement';

query = mysql_query($sql);

var_dump($query);

Generally speaking, the data is read at the model layer, and then the logical operation is done in the service layer, and then the data is returned to the controller, and then the corresponding interface in the controller, this->assign('order',$ord);

this->display();

This is the MVC layer in TP, and you shouldn't have such a fine division here.

So if you go this way, it's because you don't assign variables, you don't return.

If you don't mind spending money, you can go to the actual TP on the MOOC to buy it, it should help you.

Also, it is recommended to read the documentation and demo well.

Traversing the store there should be.

ord[$k]['storename']=m('store')->field('storename')->where("id=".$v['sid'])-find();

or $result=m('store')->where("id=".$v['sid'])-find();

ord[$k]['storename']=$result['storename'];

That's it. direct ->field(); That's not right, right?

Get all the data from the result set.

function getall($sql)return $temp;Define an empty array to store the received data}else

Get a piece of data.

function getone($sql)else}

PHP can pass values when traversing arrays, and if you want to change the value of the array, you can use subscripts or references.