目录

query 查询

优质
小牛编辑
131浏览
2023-12-01

query

执行sql语句

query($query)
  • query [string]

    The SQL query.

Return: [object] The PDOStatement object.此方法用于使用复杂的SQL语句,SQL注入问题请参考quote方法
$database->query("CREATE TABLE table (	c1 INT STORAGE DISK,	c2 INT STORAGE MEMORY) ENGINE NDB;");$data = $database->query("SELECT email FROM account")->fetchAll();print_r($data);// Prepared statement// Medoo will auto-detect the data type for input parameters$data = $database->query(	"SELECT * FROM account WHERE user_name = :user_name AND age = :age", [		":user_name" => "John Smite",		":age" => 20	])->fetchAll();print_r($data);