BaguettePHP / Tetosql
Licence: mpl-2.0
Labels
Projects that are alternatives of or similar to Tetosql
crud-mvc-php
Projeto de aplicação simples em php utilizando autoload e PDO.
Stars: ✭ 12 (+50%)
Mutual labels: pdo
FineCMS
PHP application using my own MVC architecture and PDO database interface.
Stars: ✭ 14 (+75%)
Mutual labels: pdo
Aura.SqlSchema
Independent schema discovery tools for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
Stars: ✭ 39 (+387.5%)
Mutual labels: pdo
stefano-tree
Framework agnostic Nested Set (MPTT) implementation for PHP
Stars: ✭ 24 (+200%)
Mutual labels: pdo
Simple-Social-Network
Micro Social Network developed in PHP, MySQL, BOOTSTRAP 3 and VUE.JS 2
Stars: ✭ 18 (+125%)
Mutual labels: pdo
Php Sql Query Builder
An elegant lightweight and efficient SQL Query Builder with fluid interface SQL syntax supporting bindings and complicated query generation.
Stars: ✭ 313 (+3812.5%)
Mutual labels: pdo
spe
A series of PHP8 examples based around a super simple MVC framework (WIP)
Stars: ✭ 14 (+75%)
Mutual labels: pdo
model-orm-php
PHP ORM Model class which provides table column/property mapping, CRUD, and dynamic finders/counters on a database table using PDO
Stars: ✭ 18 (+125%)
Mutual labels: pdo
Ezsql
PHP class to make interacting with a database ridiculusly easy
Stars: ✭ 804 (+9950%)
Mutual labels: pdo
Php Mysql Class
Simple MySQL class written in PHP, for interfacing with a MySQL database.
Stars: ✭ 349 (+4262.5%)
Mutual labels: pdo
TetoSQL
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;
const find = '
SELECT * FROM `users`
WHERE `status` IN (:[email protected][])
LIMIT :[email protected], :[email protected]
';
$conn = new \PDO('sqlite:/tmp/db.sq3', null, null, [PDO::ATTR_PERSISTENT => true]);
$data = Query::execute($conn, find, [
':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 <[email protected]>
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/.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].