zonuexe / tetosql
Simple and secure SQL templating
Installs: 34 414
Dependents: 0
Suggesters: 0
Security: 0
Stars: 15
Watchers: 4
Forks: 0
Open Issues: 1
Requires
- php: >=5.4
Requires (Dev)
- php-coveralls/php-coveralls: ^2.1 || ^1.1
- phpunit/phpunit: ^8.5 || ^7.5 || ^4.8
- yoast/phpunit-polyfills: ^1.0
Suggests
- ext-mysql: MySQL support
README
PHP Data Objects(PDO) wrapper and SQL Template for PHP
Features
- PDO Wrapper
- Query Template
- Type safe
- Sequence of values
Manual
Japanese: 憂鬱なSQLのためのアレ、またはPDOと仲良くして枕を高くしてねむる
Syntax
type
@int
- Integer value (-9223372036854775808 <= n <=9223372036854775807
)@int[]
- Sequence of integers@string
- String@string[]
- Sequence of strings@lob
- Large OBject@ascdesc
-"ASC"
or"DESC"
or"asc"
or"desc"
Example
<?php namespace MyApp; use Teto\SQL\Query; $conn = new \PDO('sqlite:/tmp/db.sq3', null, null, [\PDO::ATTR_PERSISTENT => true]); $data = Query::execute( $conn, <<<'SQL' SELECT * FROM `users` WHERE `status` IN (:statuses@int[]) LIMIT :offset@int, :limit@int SQL, [ ':statuses' => [1, 3], ':offset' => 60, ':limit' => 30, ] )->fetch(\PDO::FETCH_ASSOC);
Copyright
TetoSQL is licensed under Mozilla Public License Version 2.0.
Simple and secure SQL templating
Copyright (c) 2019 USAMI Kenta <tadsan@zonu.me>
PxvSql
TetoSQL is forked (and detuned) from private library of pixiv Inc. that is called PxvSql
.
PHP Manual
PDOInterface.php
and PDOStatementInterface.php
is based on PHP Manual (en).
Copyright © 1997 - 2016 by the PHP Documentation Group. This material may be distributed only subject to the terms and conditions set forth in the Creative Commons Attribution 3.0 License or later. A copy of the Creative Commons Attribution 3.0 license is distributed with this manual. The latest version is presently available at » http://creativecommons.org/licenses/by/3.0/.