edoo is an ultra-lightweight PHP SQL database framework developed by the founders of the social networking site Catfan and the open-source project Qatrix. It provides a simple, easy-to-learn, and flexible API to improve the efficiency and performance of developing web applications, and the size is less than 22KB.
Compatible: Supports various data: MySQL, MSSQL, SQLite, MariaDB, Oracle, Sybase, PostgreSQL, etc
Secure: Prevent SQL injection
Free: MIT Agreement, you can make any modifications.
We know that in C#, there is a ado.net we encapsulate commonly used operations into a DbHelper class, edoo is dbhelp in php
Official website: https://medoo.in/
Today, when I was writing the PHP interface, I introduced the db object operation that came with dz, and it would prompt me that it contained illegal characters. (Actually, it's a json string, it's intercepted by dz and can't be inserted into the database)
So, found edoo from the internet to access the database.
1: Download and install first
https://github.com/catfan/Medoo/archive/master.zip
Medoo-master.zip
(11.41 KB, Number of downloads: 0, 售价: 1 粒MB)
2: Install the PHP extension
MySQL, MariaDB -> php_pdo_mysql
MSSQL (Windows) -> php_pdo_sqlsrv
MSSQL (Linux/UNIX) -> php_pdo_dblib
Oracle -> php_pdo_oci
Oracle version 8 -> php_pdo_oci8
SQLite -> php_pdo_sqlite
PostgreSQL -> php_pdo_pgsql
Sybase -> php_pdo_dblib
Find the php.ini configuration file under linux and uncomment extension=php_pdo_mysql.dll or extension=php_pdo_mysql.so
3: Initialize the configuration
Upload Medoo.php to the directory of your interface
4: Simple query to add update code:
--Inquire
--increase
--update
|
Posted on 7/16/2017 5:15:25 PM
|
|
|
|
