查询单行数据
返回结果集第一行数据
$tfdo->fetchOne("select * from users where userName = @s1",
[["name"=>"@s1", "type"=>\PDO::PARAM_STR, "value"=>"鬼谷子叔叔"]]);
$tfdo->fetchOne2("select * from users where userName = ?",
["鬼谷子叔叔"]);
$tfdo->fetchOne3("select * from users where userName = @str",
["鬼谷子叔叔"]);查询多行数据
返回结果集从seekBegin位置开始获取fetchNums行数据
$tfdo->fetchMany("select * from users where userName = @s1",
[["name"=>"@s1", "type"=>\PDO::PARAM_STR, "value"=>"鬼谷子叔叔"]], 0, 10);
$tfdo->fetchMany2("select * from users where userName = ?",
["鬼谷子叔叔"], 0, 10);
$tfdo->fetchMany3("select * from users where userName = @str",
["鬼谷子叔叔"], 0, 10);查询全部数据
返回结果集全部数据
$tfdo->fetchAll("select * from users where userName = @s1",
[["name"=>"@s1", "type"=>\PDO::PARAM_STR, "value"=>"鬼谷子叔叔"]]);
$tfdo->fetchAll2("select * from users where userName = ?",
["鬼谷子叔叔"]);
$tfdo->fetchAll3("select * from users where userName = @str",
["鬼谷子叔叔"]);待续。。。
