Never seen it before, you learn something new every day! The reason I asked is because I personally find self look cleaner, but that's just personal preference (as is a lot in coding). Thanks for explaining and including a source with more in-depth information!
use Siberia\Database\DB;
// Select the table
$user = DB::allocate('users');
$user->username = "Sentinel";
$user->password = Auth::hash('Sentinel');
// Upon finish this will return a boolean
$user->store();INSERT INTO `users` (`username`,`password`) VALUES (:username,:password)namespace Siberia\Database;
use Siberia\Database\ORM;
class DB
{
protected static $orm;
public static function allocate($table)
{
return static::$orm = new ORM($table);
}
}namespace Siberia\Database;
use Siberia\Database\PDO;
class ORM extends PDO
{
protected $tableName, $capsule;
public function __construct($table)
{
$this->tableName = $table;
return $this->capsule = new \stdClass;
}
public function __get($key)
{
return $this->capsule->{$key};
}
public function __set($key, $value)
{
$this->capsule->{$key} = $value;
}
public function splitCapsule()
{
foreach($this->capsule as $key => $value) {
$params[$key] = $value;
$rows[] = "`" . $key . "`";
$ids[] = ":" . $key;
}
return (object) [
'params' => $params,
'name' => $this->tableName,
'rows' => implode(",", $rows),
'ids' => implode(",", $ids)
];
}
/**
* Insert information into the chosen database table
*/
public function store()
{
$capsule = $this->splitCapsule();
$sql = "INSERT INTO `{$capsule->name}` ({$capsule->rows}) VALUES ({$capsule->ids})";
return $this->query($sql)->bind($capsule->params)->run();
}
}Nothing hehe, I just liked the
$user = DB::allocate('users');
$user->username = "Sentinel";
die(var_dump($user->get(['password', 'id'])));object(stdClass)#16 (2) { ["password"]=> string(60) "$2y$10$6RlXpgFg3wr5DWprAeCZRuCmEKGD2pm728LjbjoQjrPgoGpSp57Ti" ["id"]=> int(2) }public function get(array $val = [])
{
if(empty($val)) {
$val = '*';
} else {
foreach($val as $key) {
$keys[] = "`" . $key . "`";
}
$val = implode(",", $keys);
}
$capsule = $this->splitCapsule();
$sql = "SELECT {$val} FROM `{$capsule->name}`";
if(count($capsule->rows) > 0) {
$sql .= " WHERE " . current($capsule->rows) . " = " . current($capsule->values);
// Unset the first row as it has been used
$this->array_unset($capsule->rows);
// Unset the first value as it has been used
$this->array_unset($capsule->values);
}
if(count($capsule->rows) >= 1) {
for($i = 0; $i < count($capsule->rows); $i++) {
$sql .= " AND " . current($capsule->rows) . " = " . current($capsule->values);
$this->array_unset($capsule->rows);
$this->array_unset($capsule->values);
}
}
return $this->query($sql)->bind($capsule->params)->run()->fetchAll();
}
public function array_unset(array &$array)
{
unset($array[key($array)]);
}$user = DB::allocate('users');
$user->id = 2;
// Creates a duplicate of the instance
$set = DB::duplicate();
$set->username = "Delight";
// Updates the table
$set->update($user);UPDATE `users` SET `username` = "Delight" WHERE `id` = 2 public function update(ORM $instance)
{
$instance = $this->splitInstance($instance->capsule);
$capsule = $this->splitCapsule();
$sql = "UPDATE `{$capsule->name->table}`";
$sql .= " SET " . current($capsule->rows) . " = " . current($capsule->values);
// Unset the first row as it has been used
$this->array_unset($capsule->rows);
// Unset the first value as it has been used
$this->array_unset($capsule->values);
if(count($capsule->rows) >= 1) {
for($i = 0; $i < count($capsule->rows); $i++) {
$sql .= ", " . current($capsule->rows) . " = " . current($capsule->values);
$this->array_unset($capsule->rows);
$this->array_unset($capsule->values);
}
}
$sql .= $this->mergeWhereSQL($instance);
$params = array_merge($instance->params, $capsule->params);
return $this->query($sql)->bind($params)->run();
}
public function mergeWhereSQL($object)
{
$sql = "";
if(count($object->rows) > 0) {
$sql .= " WHERE " . current($object->rows) . " = " . current($object->values);
// Unset the first row as it has been used
$this->array_unset($object->rows);
// Unset the first value as it has been used
$this->array_unset($object->values);
}
if(count($object->rows) >= 1) {
for($i = 0; $i < count($object->rows); $i++) {
$sql .= " AND " . current($object->rows) . " = " . current($object->values);
$this->array_unset($object->rows);
$this->array_unset($object->values);
}
}
return $sql;
}
public function splitInstance($instance)
{
foreach($instance as $key => $value) {
$params[":i_{$key}"] = $value;
$rows[] = "`{$key}`";
$vals[] = ":i_" . $key;
}
return (object) [
'params' => $params,
'rows' => $rows,
'values' => $vals
];
}
Good luck installing a framework whereas the dist haven't been added.
Alright if this project is not supported this thread should be closed. Man quiting PHP what made you do that.
Nice REACT JS is good for its speed,
I am sticking with Angular, I plan on making an admin panel with the new angular js with a number of features suck as a lock screen, login, remember me, forgot password, two factor authentication, message system between other users logged in, unlimited roles, and much more, but that is far from completion i am constructing the main components such as the php session, i am using every security action their is, by enabling strict mode that is recommended by
Ah. That's unfortunate.If you read the earlier posts being commented, it's no longer under development
Thanks for the feedback though.
Waiting on a moderator to close the thread.
