Skip to content
jozefcipaPublic

About

Loads SQL queries from files to your code.

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Latest commit

 

History

8 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

SQLQuery

Loads SQL queries from files to your code.

Just define queries with logical context in separate files, add @SQLName name to each part and simply import your query to code.

It's making your code shorter, cleaner and maintainable for you and your collaborators.

How to use it ?

//index.php

require "SQLQuery.php";

//set dir where your sql files are located
//default is ./sql
SQLQuery::setSqlDir("./your_sql_dir");

//DB connection...
$db = "your db object";

$db->query(SQLQuery::import('getById')->from('user'));
//bind :id param as usually
//execute query
//...
--user.sql

--@SQLName getById
SELECT * FROM users WHERE id=:id

--@SQLName otherQueries
...
Directory tree:
.
+--your_sql_dir
|  +--user.sql
|
+--index.php
+--SQLQuery.php

About

Loads SQL queries from files to your code.

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages