|
Project Information
Featured
Links
|
This is a library coded by PHP for MySQL manipulation, and use it like Ruby on Rails.Example:require 'php_mysql_like_ror.php';
$mysql = new MySQL("localhost", "cfc", "cfc", "wtf"); // Default encoding is UTF-8
$mysql->Conn();
$mysql->Exec(find_all_by_field("id", 10, "users")); // Same as: mysql_query("SELECT * FROM `users` WHERE id = 10");
// Same as: mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE id BETWEEN 10 AND 20 LIMIT 5"));
$mysql->fetch_assoc(find_all("users", array("conditions" => "id BETWEEN 10 AND 20", "limit" => 5)));
$mysql->getCount(find_all("users", array("select" => "id"))); // Same as: mysql_num_rows(mysql_query("SELECT id FROM `users`"));
$mysql->Close();
$mysql = null;
|