-
Notifications
You must be signed in to change notification settings - Fork 1
Data Directory
Youmy001 edited this page Feb 4, 2018
·
9 revisions
This a draft for our future module for database connection which may replace the Database class. Nothing of this is actual documentation of an existing module. This new module will bring better security and remove the necessity to know *SQL to fetch, insert, update, and delete data from the database.
The goal of this module is to make access to database data easier. Its gonna represent a higher level version of the current Database class. It's gonna support the five most commun request types : SELECT, INSERT, REPLACE, UPDATE and DELETE.
The first versions will support MySQL. The following versions will gradually include support for SQLite, PosgreSQL and SQLServer.
$result=(new DataDirectory())->Select('apine_users')->Where(array(
"register_date"=>"2015-08"
),SQL_SYMBOL_GREATER);
$result=(new DataDirectroy())->Insert('apine_users')->Values(array(
"username"=>"Youmy001",
"password"=>"HASHEDPASSWORD",
"email"=>"teasdale.t@kitaiweb.ca"
));
$result=(new DataDirectroy())->Replace('apine_users')->Values(array(
"username"=>"Youmy001",
"password"=>"HASHEDPASSWORD",
"email"=>"teasdale.t@kitaiweb.ca"
));
$result=(new DataDirectory())->Update('apine_users')->Where(array(
"ID"=>5
))->Values(array(
"email"=>"teasdale.t@kitaiweb.ca"
));
$result=(new DataDirectory())->Delete('apine_users')->Where(array(
"ID"=>5
));
- Introduction
- Getting Started
- Requirements & Installation
- Application Configuration
- Database Connection
- How to use Controllers
- How to use Views
- How to Manage Session
- How to use the api (Coming Soon)
- Utilities
- Entity Manager
- File Manager
- Access and Save File (Coming Soon)
- Image Methods (Coming Soon)
- XML Manager
- XML Class (Coming Soon)
- Parser (Coming Soon)
- Writer (Coming Soon)
- Advanced Topics
- Extended Users
- Routes
- Templating (Coming Soon)
- Translations and Locales