Ratings | | Unique User Downloads | | Download Rankings |
Not yet rated by the users | | Total: 62 | | All time: 10,455 This week: 39 |
|
Description | | Author |
This package can execute common SQL queries using object functions.
It provides classes with a fluent interface that allows developers to compose common queries using functions to set query parameters like table names, fields, field values, and condition clauses.
Currently, the main classes provide functions to execute SQL SELECT, INSERT, UPDATE AND DELETE queries.
It also provides functions that can:
- Return the count of table records
- Get the last table record identifier that results from the last insert query
- The last query execution error
- The number of table rows affected by the last query | |
|
|
Innovation award
Nominee: 5x |
|
Recommendations
Example
<?php
$db=$db??[];
$field = [
"userid" => 1,
"message" => "hello from wepesi",
"datecreated" => date('Y-m-d H:i:s',strtotime("now"))
];
try {
$db->insert("message")->field($field)->result();
if($db->error()){
throw new \Exception($db->error());
}
var_dump(["last insert ID : "=>$db->lastId()]);
} catch (Exception $e) {
var_dump($e->getMessage());
}
|
Details
Wepesi-ORM
this is a simple model of an ORM
writeen in php. it can ben modified as you want.
OVERVIEW
this module as been develloped under this configuration.
- server :wampserver 3.2.4 64bit
- apache :2.3.33
- php :7.3.13
- phpmyadmin:5.0.4
- mysql :5.7.21
in case some solution and method are not available be sure to use a version clause to this setup.
INTRODUCTION
this model is just a simple wait you can implement your own ORM and design according to your need.
hope it wiil be helpfull
INTEGRATION
METHODE
-
SELECT
`get` method is corresponding to `SELECT` in sql. with this method you can request your database,
to do a `select * from table_name` also you can add somme method to make it power as you are using `sql`.
you can see and example bellow.
$db=DB::getInstance();
$req=$db->get('message')->result();
-
first of all, we creat an instance of the database by using our `DB` class. withc will allow us to interact with the `mySQL` database.
-
in the `get` method we have the first parameter witch is the table_name, call the `result()` methode to execute your `query`.
the result can be store into a variable for other purpose.
the coresponding sql is:
SELECT * FROM message
to be precise with your request
$req=$db->get("message")->fields(['userid','message'])->where(['userid',"=",1])->result();
var_dump($req);
the corresponding `SQL`
SELECT userid,message FROM message WHERE userid=1
this is not all, you can `LIMIT`, `OFFSET`,`groupBY`,`orderBy`,`ASC`,`DESC`
for more detail, checkout the examole file on the test folder.
-
INSERT
`insert` is used to record data. its can be used has you are using an an sql commande.
checkout the example bellow
$data = [
"userid" => 2,
"message" => "hello from wepesi",
"datecreated" => Date('Y-m-d H:i:s')
];
try {
$db->insert("message")->fields($data)->result();
if ($this->db->error()) {
throw new Exception("operation failed. check the error description");
}
var_dump($this->db->lastId());
} catch (Exception $ex) {
echo $ex->getMessage();
}
-
before insert data, we create an data object with index key value.
you will realised that, the object `data` we define the `key` correspond to the table fields and it value.
-
call the insert method, we define the table name, and we call the fields method where we pass the data object to perdom the query.
the corresponding sql look like
INSERT INTO message (`userid`,`message`,`datecreated`) VALUES (?,?,?)
from that request you can request for the last id record on call the `lastId()` method.
-
DELETE
`delete` when you need to delete a record, this is the module to use.
try {
$db->delete("message")->where(["id","=",16])->result();
if ($this->db->error()) {
throw new Exception("failed to delete data");
}
return true;
} catch (Exception $ex) {
echo $ex->getMessage();
}
corespondig sql is
DELETE `message` WHERE `id`='16'
-
call where method to define the condition to delete a record.
-
QUERY
the `query` method is used in case you have specific query you want to execute, then you can use it.
try{
$req = $this->db->query("select * from message join users on users.id=message.userid");
if($req->error()){
throw new Exception($req->error());
}
return $req->result();
}catch(Exception $ex){
echo $ex->getMessage();
}
the example bellow describe how it can be used. with the `query` method use the `result()` method to get the result.
- hope you enjoy.
|
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.