ezsql下载 - ezsql源码下载

ezsql

一个使处理数据库连接变得非常容易的类。通用可互换CRUD系统。

这是版本 5 ，它将破坏版本 4的用户。

主要通过：

在global函数ezFunctions.php文件中使用namespace 。使用全局函数将要求用户启动一个.php文件，如下所示：

 use function ezsql  functions  where ;
// Or
use function ezsql  functions {
    getInstance ,
    selecting ,
    inserting ,
};

可以通过魔术方法get/set访问的类属性，现在是 PSR 1 驼峰命名法。
将ez_mysqli的select重命名为dbSelect 。
将selecting类方法和行为重命名为select 。
selecting和新的inserting方法，可以在没有表名的情况下调用，只有其他必要的参数：
- 带有prefix的表名，可以通过tableSetup(name, prefix), or setTable(name), setPrefix(append)方法预设/存储，如果没有预设则返回false 。
- 此功能将添加到所有数据库CRUD访问方法中，每个方法名称都会添加ing结尾。
删除了传入table名的全局函数，使用使用预设表名以ing结尾的函数。
将 cleanInput 重命名为 clean_string
将 createCertificate 重命名为 create_certificate
添加全局 get_results 以返回不同格式的结果集

版本 4有许多现代编程实践，这些实践会破坏版本 3 的用户。

版本 3在一个主要方面打破了版本 2.1.7，它需要PHP 5.6 。其中删除了 mysql 扩展支持，除此之外，使用该库没有任何改变，只有附加功能。

该库有一个Database类，它是工厂模式与依赖注入容器托管的组合。该库现在遵循许多 OOP 原则，其中之一是删除了方法属性公共访问。该库还遵循 PSR-2、PSR-4、PSR-11 约定，并且主要遵循 PSR-1，这仍在进行中。

更多托多...

有关完整概述，请参阅 Wiki 文档，该文档尚未完全完成。

安装

 composer require ezsql/ezsql

用法

 require ' vendor/autoload.php ' ;

// **** is one of mysqli, pgsql, sqlsrv, sqlite3, or Pdo.
use ezsql  Database ;

$ db = Database:: initialize ( ' **** ' , [ $ dsn_path_user , $ password , $ database , $ other_settings ], $ optional_tag );

// Is same as:
use ezsql  Config ;
use ezsql  Database  ez_ ****;

$ settings = new Config ( ' **** ' , [ $ dsn_path_user , $ password , $ database , $ other_settings ]);

$ db = new ez_ ****( $ settings );

该库假设开发人员正在使用某种启用了智能感知的 IDE。评论/文档块区域将保存任何丢失的文档。有关其他示例，请参阅phpunit测试，这些测试是功能齐全的集成测试，这意味着它们是实时数据库测试，没有模拟。

自 2.1.7 版本以来添加了以下内容。

一般方法

 to_string($arrays, $separation = ',');
clean($string);
create_cache(string $path = null);
secureSetup(string $key = 'certificate.key',
    string $cert = 'certificate.crt',
    string $ca = 'cacert.pem',
    string $path = '.'._DS
);
secureReset();
create_certificate(string $privatekeyFile = certificate.key,
    string $certificateFile = certificate.crt,
    string $signingFile = certificate.csr,
    string $ssl_path = null, array $details = [commonName => localhost]
);

快捷方式表方法

 create(string $table = null, ...$schemas);// $schemas requires... column()
column(string $column = null, string $type = null, ...$args);
primary(string $primaryName, ...$primaryKeys);
index(string $indexName, ...$indexKeys);
drop(string $table);

例子

 // Creates an database table
create ( ' profile ' ,
    // and with database column name, datatype
    // data types are global CONSTANTS
    // SEQUENCE|AUTO is placeholder tag, to be replaced with the proper SQL drivers auto number sequencer word.
    column ( ' id ' , INTR , 11 , AUTO , PRIMARY ), // mysqli
    column ( ' name ' , VARCHAR , 50 , notNULL),
    column ( ' email ' , CHAR , 25 , NULLS ),
    column ( ' phone ' , TINYINT )
);

 innerJoin(string $leftTable = null, string $rightTable = null,
    string $leftColumn = null, string $rightColumn = null, string $tableAs = null, $condition = EQ);

leftJoin(string $leftTable = null, string $rightTable = null,
    string $leftColumn = null, string $rightColumn = null, string $tableAs = null, $condition = EQ);

rightJoin(string $leftTable = null, string $rightTable = null,
    string $leftColumn = null, string $rightColumn = null, string $tableAs = null, $condition = EQ);

fullJoin(string $leftTable = null, string $rightTable = null,
    string $leftColumn = null, string $rightColumn = null, string $tableAs = null, $condition = EQ);

 prepareOn (); // When activated will use prepare statements for all shortcut SQL Methods calls.
prepareOff (); // When off shortcut SQL Methods calls will use vendors escape routine instead. This is the default behavior.

快捷 SQL 方法

having(...$having);
groupBy($groupBy);
union(string $table = null, $columnFields = '*', ...$conditions);
unionAll(string $table = null, $columnFields = '*', ...$conditions);
orderBy($orderBy, $order);
limit($numberOf, $offset = null)
where( ...$whereConditions);
select(string $table = null, $columnFields = '*', ...$conditions);
create_select(string $newTable, $fromColumns, $oldTable = null, ...$conditions);
select_into(string $newTable, $fromColumns, $oldTable = null, ...$conditions);
update(string $table = null, $keyAndValue, ...$whereConditions);
delete(string $table = null, ...$whereConditions);
replace(string $table = null, $keyAndValue);
insert(string $table = null, $keyAndValue);
create(string $table = null, ...$schemas);
drop(string $table = null);
alter(string $table = null, ...$alteringSchema);
insert_select(string $toTable = null, $toColumns = '*', $fromTable = null, $fromColumns = '*', ...$conditions);

 // The variadic ...$whereConditions, and ...$conditions parameters,
//  represent the following global functions.
// They are comparison expressions returning an array with the given arguments,
//  the last arguments of _AND, _OR, _NOT, _andNOT will combine expressions
eq ( ' column ' , $ value , _AND ), // combine next expression
neq ( ' column ' , $ value , _OR ), // will combine next expression again
ne ( ' column ' , $ value ), // the default is _AND so will combine next expression
lt ( ' column ' , $ value )
lte ( ' column ' , $ value )
gt ( ' column ' , $ value )
gte ( ' column ' , $ value )
isNull ( ' column ' )
isNotNull ( ' column ' )
like ( ' column ' , ' _%? ' )
notLike ( ' column ' , ' _%? ' )
in ( ' column ' , ... $ value )
notIn ( ' column ' , ... $ value )
between ( ' column ' , $ value , $ value2 )
notBetween ( ' column ' , $ value , $ value2 )
// The above should be used within the where( ...$whereConditions) clause
// $value will protected by either using escape or prepare statement

 // To allow simple grouping of basic $whereConditions,
// wrap the following around a group of the above comparison
// expressions within the where( ...$whereConditions) clause
grouping ( eq (key, value, combiner ), eq (key, value, combiner ) )
// The above will wrap beginning and end grouping in a where statement
// where required to break down your where clause.

 // Note: The usage of this method will require the user/developer to check
// if `query_string` or `param_array` is valid.
//
// This is really an `private` internal method for other shortcut methods,
// it's made public for `class development` usage only.
//
//
// Supply the the whole `query` string, and placing '?' within, with the same number of arguments in an array.
// It will then determine arguments type, execute, and return results.
query_prepared (string $ query_string , array $ param_array );
// You will need to call this method to get last successful query result.
// It wll return an object array.
queryResult ();

通过上述快捷 SQL 方法间接使用准备语句的示例

 // To get all shortcut SQL methods calls to use prepare statements
$ db -> prepareOn (); // This needs to be called at least once at instance creation

$ values = [];
$ values [ ' name ' ] = $ user ;
$ values [ ' email ' ] = $ address ;
$ values [ ' phone ' ] = $ number ;
$ db -> insert ( ' profile ' , $ values );
$ db -> insert ( ' profile ' , [ ' name ' => ' john john ' , ' email ' => ' john@email ' , ' phone ' => 123456 ]);

// returns result set given the table name, column fields, and ...conditions
$ result = $ db -> select ( ' profile ' , ' phone ' , eq ( ' email ' , $ email ), between ( ' id ' , 1 , $ values ));

foreach ( $ result as $ row ) {
    echo $ row -> phone ;
}

$ result = $ db -> select ( ' profile ' , ' name, email ' ,
    // Conditionals can also be called, stacked with other functions like:
    //  innerJoin(), leftJoin(), rightJoin(), fullJoin()
    //      as (leftTable, rightTable, leftColumn, rightColumn, tableAs, equal condition),
    //  where( eq( columns, values, _AND ), like( columns, _d ) ),
    //  groupBy( columns ),
    //  having( between( columns, values1, values2 ) ),
    //  orderBy( columns, desc ),
    //  limit( numberOfRecords, offset ),
    //  union(table, columnFields, conditions),
    //  unionAll(table, columnFields, conditions)
    $ db -> where ( eq ( ' phone ' , $ number , _OR ), neq ( ' id ' , 5 ) ),
    //  another way: where( array(key, operator, value, combine, combineShifted) );
    //  or as strings double spaced: where( "key  operator  value  combine  combineShifted" );
    $ db -> orderBy ( ' name ' ),
    $ db -> limit ( 1 )
);

foreach ( $ result as $ row ) {
    echo $ row -> name . ' ' . $ row -> email ;
}

// To get results in `JSON` format
$ json = get_results ( JSON , $ db );

直接使用prepare语句的示例，未使用快捷SQL方法

 $ db -> query_prepared ( ' INSERT INTO profile( name, email, phone) VALUES( ?, ?, ? ); ' , [ $ user , $ address , $ number ]);

$ db -> query_prepared ( ' SELECT name, email FROM profile WHERE phone = ? OR id != ? ' , [ $ number , 5 ]);
$ result = $ db -> queryResult (); // the last query that has results are stored in `lastResult` protected property
// Or for results in other formats use the global function, will use global database instance if no `$db` supplied
$ result = get_results ( / * OBJECT | ARRAY _ A | ARRAY _ N | JSON */ , $ db ); // Defaults to `OBJECT`

foreach ( $ result as $ row ) {
    echo $ row -> name . ' ' . $ row -> email ;
}

大多数快捷方法都具有可用的计数器全局函数。它们只能通过.php文件开头来访问，例如：

 use function ezsql  functions  functionBelow ;
// Or as here, a complete list.
use function ezsql  functions {
    database ,
    mysqlInstance ,
    pgsqlInstance ,
    mssqlInstance ,
    sqliteInstance ,
    pdoInstance ,
    tagInstance ,
    setInstance ,
    getInstance ,
    clearInstance ,
    get_vendor ,
///
    to_string ,
    clean_string ,
    is_traversal ,
    sanitize_path ,
    create_certificate ,
///
    column ,
    primary ,
    foreign ,
    unique ,
    index ,
    addColumn ,
    dropColumn ,
    changingColumn ,
///
    eq ,
    neq ,
    ne ,
    lt ,
    lte ,
    gt ,
    gte ,
    isNull ,
    isNotNull ,
    like ,
    in ,
    notLike ,
    notIn ,
    between ,
    notBetween ,
///
    where ,
    grouping ,
    groupBy ,
    having ,
    orderBy ,
    limit ,
    innerJoin ,
    leftJoin ,
    rightJoin ,
    fullJoin ,
    union ,
    unionAll ,
///
    creating ,
    deleting ,
    dropping ,
    replacing ,
    selecting ,
    inserting ,
    altering ,
    get_results ,
    table_setup ,
    set_table ,
    set_prefix ,
    select_into ,
    insert_select ,
    create_select ,
};