Download the PHP package optiwariindia/database without Composer
On this page you can find all versions of the php package optiwariindia/database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download optiwariindia/database
More information about optiwariindia/database
Files in optiwariindia/database
Package database
Short Description A library to connect database and use basic activities in database like create,select,insert,update,delete and drop using predefined methods
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package database
database : A library to make database interactions easier
Supported Databases:
- MariaDB
- MySQL
Getting Started
Installation
composer require optiwariindia/database
Geting Started
Prerequsites:
- Database Hostname, generally localhost if database is installed on webserver.
- Database Username, usually root for local installations
- Database Password, usually blank for local installations
- Database Name, Generally same as hosting account name
create object of database class
use optiwariindia\database
$db=new database([ "host"=>"localhost", "user"=>"root", //Your Database user "pass"=>"", // Your database password "name"=>"{Database Name}" //Your Database Name ])
Basic Operations
Insert
Create an array of the data you want to store in database, set keys as name of fields for example Table auth, contains username and password only, then it shall be written like :
$data=[
"user"=>{Username},
"pass"=>{Password}
];
And then it can be inserted into auth table like:
$db->insert("auth",$data);
Select
The database class is providing 4 modes for selecting data as follows:
- mode 0 returns array with following keys:
- fields: Array showing list of fields
- rows: number of rows
- touples with numeric indicies i.e. $data[0] shows first row.
- mode 1 returns rows as array containing filed names as key for each row.
- mode 2 returns id as row index and each row as collection of fields where field names are keys
- mode 3 returns same as mode 1 but parses all json arrays and eliminates all blobs.
By default mode 0 is selected in the object. To change mode you can use following:
$db->mode({mode number})To select Data from any table you can use following:$data= $db->select({table name},{filelds (optional, * by default)},{clauses})Update
The update function can be used to update data in a table. to update data create an array with filedname as keys like:
$data=["{field to be updated}"=>"{filed value}"];and then$db->update({table name},$data,{clause if any (Optional)});Delete
$db->delete({tablename},{clause if any (optional)});
