对象数组（getYieldObjects）

更新时间：2025年6月13日 08:41 浏览：1148

普通查询

 $db = Be::getDb(); 
 
$sql = 'SELECT * FROM user WHERE age<18 AND sex=\'女\'';
$users = $db->getYieldObjects($sql);
 
foreach ($users as $user) {
    // $user->name;
}

占位符查询

 $db = Be::getDb(); 
 
$sql = 'SELECT * FROM user WHERE age<? AND sex=?';
$users = $db->getYieldObjects($sql,  [18, '女']);

	$db = Be::getDb();

	$sql = 'SELECT * FROM user WHERE age<18 AND sex=\'女\'';
	$users = $db->getYieldObjects($sql);

	foreach ($users as $user) {
	// $user->name;
	}

	$db = Be::getDb();

	$sql = 'SELECT * FROM user WHERE age<? AND sex=?';
	$users = $db->getYieldObjects($sql, [18, '女']);