应用Medoo长短常简略的事!
Medoo1.2开端没有支持PHP5.4或如下,若你应用的是1.2之前的版本,请抉择菜单 中文文档(<1.2)
要求
一、PHP>=5.4, 必需支持PDO
二、支持 MySQL, MSSQL, SQLite 等数据库.
三、确保php_pdo_xxx (xxx = 数据库类型) 的xxx数据扩大曾经正确装置并启用.
四、需求懂一些SQL常识.
PHP PDO扩大列表
MySQL, MariaDB -> php_pdo_mysql
MSSQL (Windows) -> php_pdo_sqlsrv
MSSQL (Liunx/UNIX) -> php_pdo_dblib / php_pdo_sqlsrv
Oracle -> php_pdo_oci
Oracle version 8 -> php_pdo_oci8
SQLite -> php_pdo_sqlite
PostgreSQL -> php_pdo_pgsql
Sybase -> php_pdo_dblib
PHP PDO装置
medoo需求PHP支持PDO扩大,请正在装置相干扩大后持续如下操作
// 关上php.ini找到你想要的相应扩大,去掉后面的;号便可 // 将 ;extension=php_pdo_mysql.dll // 修正成 extension=php_pdo_mysql.dll // 保留,重启你的PHP或许效劳器 //假如PDO装置胜利,你能够经过phpinfo()查看到它.
假如你经过终端(linux)饬令行装置,零碎会主动装置设置装备摆设相应扩大
$ sudo apt-get install php5-mysql
应用 PHP Composer 装置
假如你经过php自带的依赖扩大装置它,能够应用上面的饬令,或许你依据本人的需求修正便可。
$ composer require catfan/Medoo
源文件装置
这是最简略的办法,下载medoo源文件,放到你的PHP开发目次里,载入便可
require 'medoo.php';
Medoo设置装备摆设
这儿提供三种数据库的衔接演示.
// If you installed via composer, just use this code to requrie autoloader on the top of your projects. require 'vendor/autoload.php'; // Using Medoo namespace use Medoo\Medoo; $database = new Medoo([ // required 'database_type' => 'mysql', 'database_name' => 'name', 'server' => 'localhost', 'username' => 'your_username', 'password' => 'your_password', // [optional] 'charset' => 'utf8', 'port' => 3306, // [optional] Table prefix 'prefix' => 'PREFIX_', // [optional] Enable logging (Logging is disabled by default for better performance) 'logging' => true, // [optional] MySQL socket (shouldn't be used with server and port) 'socket' => '/tmp/mysql.sock', // [optional] driver_option for connection, read more from http://www.php.net/manual/en/pdo.setattribute.php 'option' => [ PDO::ATTR_CASE => PDO::CASE_NATURAL ], // [optional] Medoo will execute those co妹妹ands after connected to the database for initialization 'co妹妹and' => [ 'SET SQL_MODE=ANSI_QUOTES' ] ]); $database->insert("account", [ "user_name" => "foo", "email" => "foo@bar.com" ]);
定制DSN链接
缺省状况下Medoo没有支持的数据库您还能够应用自界说DSN衔接,特地是一些新数据库,DSN参数比拟非凡,或许假如要为衔接增加更多的DSN参数值。
衔接格局.
{driver}:{key}={value};{key}={value}
$database = new Medoo([ // Started using customized DSN connection 'dsn' => [ // The PDO driver name for DSN driver parameter 'driver' => 'mydb', // The parameters with key and value for DSN 'server' => '12.23.34.45', 'port' => '8886' ], // [optional] Medoo will have different handle method according to different database type 'database_type' => 'mysql', 'username' => 'your_username', 'password' => 'your_password' ]); // The final DSN connection string will be generated like this mydb:server=12.23.34.45;port=8886
衔接 SQLite
假如你要应用Medoo衔接你的MSSQL数据库,你需求装置相干扩大:Windows装置pdo_sqlsrv、Linux/UNIX装置pdo_dblib. pdo_mssql 扩大已被PHP烧毁,没有倡议应用.
$database = new Medoo([ 'database_type' => 'mysql', 'database_name' => 'name', 'server' => 'localhost', 'username' => 'your_username', 'password' => 'your_password', // [optional] The application name 'appname' => 'test', // [optional] If you want to force Medoo to use dblib driver for connecting MSSQL database 'driver' => 'dblib' ]);
如今Medoo能够应用sqlsrv来驱动MSSQL,详见微软民间文档 https://docs.microsoft.com/en-us/sql/connect/php/connection-options?view=sql-server-2017.
$database = new Medoo([ 'database_type' => 'mysql', 'database_name' => 'name', 'server' => 'localhost', 'username' => 'your_username', 'password' => 'your_password', // [optional] MSSQL connection options 'application_intent' => 'ReadOnly', 'attach_db_file_name' => './database.sql', 'authentication' => 'SqlPassword', 'column_encryption' => 'Enabled', 'connection_pooling' => 1, 'encrypt' => 1, 'failover_partner' => 'MultiSubnetFailover', 'key_store_authentication' => 'KeyVaultPassword', 'key_store_principal_id' => 'AzureName', 'key_store_secret' => 'AzurePass', 'login_timeout' => '20', 'multiple_active_result_sets' => 1, 'multi_subnet_failover' => 'Yes', 'scrollable' => 'buffered', 'trace_file' => './path', 'trace_on' => 1, 'transaction_isolation' => PDO::SQLSRV_TXN_SNAPSHOT, 'transparent_network_ip_resolution' => 'Enabled', 'trust_server_certificate' => 1, 'wsid' => 'Computer1' ]);
衔接 SQLite
$database = new medoo([ 'database_type' => 'sqlite', 'database_file' => 'my/database/path/database.db' ]); $database->insert("account", [ "user_name" => "foo", "email" => "foo@bar.com" ]);
以上就是PHP数据库框架Medoo1.6装置教程的具体内容,更多请存眷资源魔其它相干文章!
标签: php php开发教程 php开发资料 php开发自学 medoo
抱歉,评论功能暂时关闭!