Erykai / database

src/Database.php

<?php

namespace Erykai\Database;

use PDO;
use stdClass;

/**
 * CLASS CRUD
 * @property string
 */
class Database extends Resource

The type Erykai\Database\Resource was not found. Maybe you did not declare it correctly or list all dependencies?

{
    /**
     * @var string|null
     */
    private null|string $returnColumns = null;
    /**
     * @param $name
     * @param $value
     */
    public function __set($name, $value)
    {
        if (empty($this->data)) {
            $this->data = new stdClass();

The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        }
        $this->data->$name = $value;
    }

    /**
     * @param $name
     * @return mixed
     */
    public function __get($name)
    {
        return $this->data->$name;
    }

    /**
     * @param $name
     * @return bool
     */
    public function __isset($name)
    {
        return isset($this->data->$name);
    }

    /**
     * @param string|null $columns
     */
    public function columns(?string $columns = null): void
    {
        if($columns){
            $this->returnColumns = $columns;
        }
    }

    /**
     * @param string $columns
     * @param string|null $condition
     * @param ?array $params
     * @return $this
     */
    public function find(string $columns = '*', string $condition = null, array $params = null): static
    {
        if($this->returnColumns){
            $columns = $this->returnColumns . $columns;
        }

        $this->query = "SELECT $columns FROM $this->table";

The property query does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

The property table does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        $this->params = $params;

The property params does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        if ($condition) {
            $this->query .= " WHERE $condition ";
        }

        return $this;
    }

    /**
     * @param string $inner
     * @return $this
     */
    public function inner(string $inner): static
    {
        if (str_contains($this->query, 'WHERE')) {
            $query  = explode("WHERE", $this->query);
            $this->query = $query[0];

The property query does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        }
        $this->query .= " $inner ";
        if (isset($query[1])){
            $this->query .= "WHERE $query[1] ";
        }
        return $this;
    }

    /**
     * @param ?string $order
     * @return $this
     */
    public function order(string $order = null): static
    {
        if($order){
            $this->queryEnd .= " ORDER BY $order ";

The property queryEnd does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        }
        return $this;
    }

    /**
     * @param string $column
     * @return $this
     */
    public function group(string $column): static
    {
        $this->queryEnd .= " GROUP BY $column ";

The property queryEnd does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        return $this;
    }

    /**
     * @param int $limit
     * @return $this
     */
    public function limit(int $limit): static
    {
        $this->queryEnd .= " LIMIT $limit ";

The property queryEnd does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        return $this;
    }

    /**
     * @param int $offset
     * @return $this
     */
    public function offset(int $offset): static
    {
        $this->queryEnd .= " OFFSET $offset ";

The property queryEnd does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        return $this;
    }

    /**
     * @param bool $all
     *
     */
    public function fetch(bool $all = false): mixed
    {
        if($this->queryEnd){

The property queryEnd does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

            $this->query .= $this->queryEnd;
        }
        $this->data = null;

The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->stmt = $this->conn->prepare($this->query);

The property conn does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

The property stmt does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        if(!$this->params){
            $this->params = [];

The property params does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        }
        $this->bind($this->params);
        $this->stmt->execute();

        if ($all) {
            if ($this->stmt->rowCount()) {
                $this->data = $this->stmt->fetchAll(PDO::FETCH_OBJ);
            } else {
                $this->setResponse(200, "error", "no results found", "database");
            }
        } else if ($this->stmt->rowCount()) {
            $this->data = (object)$this->stmt->fetch();
        } else {
            $this->setResponse(200, "error", "no results found", "database");
        }

        return $this->data;
    }

    /**
     * @param int $id
     * @return bool
     */
    public function delete(int $id): bool
    {
        $dynamic = $this->nameId . " " . $id;

The property nameId does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        $stmt = $this->conn->prepare("DELETE FROM $this->table WHERE $this->nameId = :$this->nameId");

The property table does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

The property conn does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        $stmt->bindParam(":$this->nameId", $id, PDO::PARAM_INT);

        if ($stmt->execute()) {
            $this->setResponse(200, "success", "$dynamic was successfully removed", "database", dynamic: $dynamic);
            return true;
        }
        $this->setResponse(400, "error", "failed to delete $dynamic","database", dynamic: $dynamic);
        return false;
    }

    /**
     * @param string $columns
     * @return object|null
     */
    public function data(string $columns = "*"): ?object
    {

        if (!empty($this->data->{0})) {
            return $this->data;
        }

        $id = $this->nameId;

The property nameId does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        if (!isset($this->data->$id)) {

            $this->find($columns, "$id=:$id", [$id => $this->conn->lastInsertId()])->fetch();

The property conn does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

            return $this->data;
        }
        $this->find($columns, "$id=:$id", [$id => $this->data->$id])->fetch();
        return $this->data;
    }

    public function count()
    {
        $this->data = null;

The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->stmt = $this->conn->prepare($this->query);

The property conn does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

The property stmt does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        if(!$this->params){
            $this->params = [];

The property params does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        }
        $this->bind($this->params);
        $this->stmt->execute();
        return $this->stmt->rowCount();
    }

    /**
     * @return bool
     */
    public function save(): bool
    {
        $id = $this->nameId;

The property nameId does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

        if (!isset($this->data->$id)) {

            if ($this->create()) {
                $this->stmt->execute();
                $this->data->$id = $this->conn->lastInsertId();

The property conn does not exist on Erykai\Database\Database. Since you implemented __get, consider adding a @property annotation.

                $this->setResponse(200, "success", "registration successful","database", $this->data);
                return true;
            }
            return false;
        }

        if ($this->update()) {
            $this->stmt->execute();
            $this->setResponse(200, "success", "updated successful","database", $this->data);
            return true;
        }
        return false;
    }
    /**
     * @return object
     */
    public function response(): object
    {
        return $this->getResponse();
    }

}