F1 = $f1; $this->F2 = $f2; } }; function loadsome($xf2) { $con = new mysqli('localhost', 'root', '', 'Test'); if(mysqli_connect_errno()) die(mysqli_connect_error()); $res = array(); if($stmt = $con->prepare('SELECT f1,f2 FROM t1 WHERE f2 = IFNULL(?,f2) ')) { $stmt->bind_param('s', $xf2); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($f1, $f2); while ($stmt->fetch()) { $res[] = new T1($f1, $f2); } $stmt->close(); } else { die($con->error); } $con->close(); return $res; } function loadall() { return loadsome(null); } function display($list) { echo "\r\n"; echo "\r\n"; echo "\r\n"; echo "\r\n"; echo "\r\n"; foreach($list as $elm) { echo "\r\n"; echo "\r\n"; echo "\r\n"; echo "\r\n"; } echo "

F1	F2
" . $elm->F1 . "	" . $elm->F2 . "

\r\n"; } $list = loadsome('BB'); display($list); $list = loadall(); display($list); ?>