What is Medoo? The lightest PHP database framework to accelerate development! Accelerate the development of the lightest PHP database framework! Medoo's powerful and sophisticated API not only fits your most basic needs, but is also very simple to use. Even if you have to develop two times, there is no problem. The first translation is Medoo's introductory article, first of all to talk about the installation and configuration of
Medoo is a lightweight PHP database framework class that accelerates website development! Medoo can greatly speed up the development of your PHP project. In web development, a large part of the enterprise or individual will choose to use the PHP language, and Medoo can play a icing on the cake. Shorten your development cycle. Medoo's powerful and sophisticated AP
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 cl
Medoo Introduction
Medoo is an ultra-lightweight PHP SQL database framework developed by Li Yan, founder of the social networking site Catfan and the Open source project Qatrix. Provides a simple, easy-to-learn, flexible API that improves the efficiency and performance of developing Web applications, and is less than 8KB in volume.
Characteristics
Lightweight, with only one file
Easy to learn, data structu
Medoo Introduction
Medoo is a lightweight PHP SQL database framework developed by the founder Li Yan of the social networking site Catfan and the Open-source project Qatrix. Provides a simple, easy to learn, flexible API to enhance the efficiency and performance of Web application development, and the volume is only 8KB.
Characteristics
Lightweight, only one file
Simple and easy to learn, data structure
There is no easy-to-use open source PHP MySQL class, similar to Medoo
There is no easy-to-use open source PHP MySQL class, similar to the kind of Medoo
But Medoo does not have the function of limit
The DB class in the CI framework is good, but I want to use his DB class from CI, and I can't do it now.
There is no other good MySQL class to know, preferably ope
At the beginning, I learned how to insert multiple data records in the insert file of medoo in PHP: {code...}. How can I insert post data into the database? Can you give a simple DEMO? Thank you! The data from post is roughly as follows: {code ...} I tried it many times... at the beginning, I learned how to insert multiple data entries in the medoo file insert:
$last_user_id = $database->insert("account",
Label:Introduction to the official website:
The most lightweight PHP database framework that can speed up development
Why choose Medoo and its main features:
Lightweight – Single file, only 20KB
Easy to use – very easy to learn and work with
powerful – supports a variety of common and complex SQL queries
Compatibility – support for very many database types such as MySQL, MSSQL, SQLite, MariaDB, Sybase, Oracle, Pos
The following MD () is my encapsulated method of extracting Medoo
MD()->debug()->get('items_want',['id'],[ 'uid'=>74, 'item_id'=>28, ]);
For example above, the output of SQL is actually:SELECT "id" FROM "items_want" WHERE "uid" = 74 "item_id" = 28 LIMIT 1
and
MD()->debug()->get('items_want',['id'],[ 'AND'=>[ 'uid'=>74, 'item_id'=>28, ] ])
will be able to outputSELECT "id" FROM "items_wan
select * from `items` where `id` in (select `uid` where `is_test`=1)
How can Medoo be written like this if you want to check the data?
Reply content:
select * from `items` where `id` in (select `uid` where `is_test`=1)
How can Medoo be written like this if you want to check the data?
$database->query('select * from `items` where `id` in (select `uid` where `is_test`=1)')->fetchAll();
$db->select
{Code...} sometimes needs to look up the uid in a table like the one above, and use the count method of medoo. how can we achieve the functionality of the above statement?
Select count (distinct (uid) FROM nazou. items_want
Sometimes you need to check what is in a table like the one above.Uid, UseMedooOfCountMethod, how to implement the above statement as a function?
Reply content:
Select count (distinct (uid) FROM nazou. items_want
Sometimes you
Label:The last Query method: Api-medoo using the last query method of Medoo to obtain the final information of DB. As the last article of Medoo, this article will show how to use the Info method to obtain database information. Database Information method: info API Obtain database information. Info () return value: [string]: String. Tip: It returns a large amount
Label:Today encountered disease Strider classmate proposed Medoo insert method can not insert database problem, I tested the discovery is possible and insert INTO "T_user" (username) VALUES (' Test '); This statement is always impossible to execute, and Medoo always helps you to enclose the database's table with double quotes but cannot execute on the command line. And then I couldn't figure out why
Why Choose Medoo?-Very light weightOnly 15KB, just include.-SimpleVery easy to learn, quick to get started.-Powerfulsupports a variety of common SQL queries.-compatiblesupports a variety of data: MySQL, MSSQL, SQLite, MariaDB, Oracle, Sybase, PostgreSQL.-SafetyPrevent SQL injection-FreeMIT protocol, you can make any changes.Must be PHP 5.1 or more, very, very special, extremely, highly recommended: Use PHP 5.4 or later and turn on PDO support. You can
Medoo Introduction
Medoo is a lightweight php SQL database framework developed by Li yanzhuo, a social networking website Catfan and founder of Qatrix, an open-source project. It provides simple, easy to learn, and flexible APIs to improve the efficiency and performance of Web application development, and the size is less than 8 KB.
Features
Lightweight, with only one file
Easy to learn and clear Data Struc
ORM Object Relational mappings, O (object) objects, are entities in a project, more precisely the data model, or persistent classes. R (Relation) relational data, M (Mapping) mapping, the process of mapping an object to relational data, and mapping relational data to an object. More intuitive to understand is that ORM is the idea of OOP, generating additions and deletions to change the SQL statement.
It's better to develop projects faster than pdo,orm rather than write SQL statements. Here are
, exception handling, and debugging and simple configuration.
Official website: http://www.slimframework.com/
11, Fuel PHP
Fuel PHP is a simple, extensible PHP Framework, based on the design concept of other frameworks, Fuel is already a V2.0 version and currently knows the beta version.
Fuel fully supports HMVC, which is also part of the fuel architecture. In addition, the fuel powerful routing feature gives you the flexibility to handle the correspondence between the Controller and the view.
O
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.