Is there a good open-source phpmysqlclass, similar to whether medoo has a good open-source php & nbsp; mysql & nbsp; class, similar to medoo, but medoo does not have & nbsp; orderby & nbsp; limit & nbsp; and other functions the db class in the CI framework is relatively easy to use, but I want to use its db class out of the ci, is there a good open-source php mysql class, similar to medoo?
Is there a good open-source php mysql class, similar to medoo?
However, medoo does not have functions such as orderby limit.
The db class in the CI framework is relatively easy to use, but I want to use its db class out of the ci, but I still can't do it now
Do you know other useful mysql classes, preferably open-source and mature ones?
------ Solution --------------------
Isn't medoo good?
Medoo has order by (http://medoo.in/api/where)
$ Database-> select ("account", "user_id ",[
"GROUP" => "type ",
// "ORDER" => "age DESC"
"ORDER" => "age ",
// Must have to use it with ORDER together
"HAVING" => [
"User_id [& gt;]" = & gt; 500
],
// LIMIT => 20
"LIMIT" => [20,100]
]);
// SELECT user_id FROM account
// Group by type
// Order by age
// HAVING user_id> 500
// The LIMIT 20,100
