bakeiro/light-php

Easy, Lightweight, open source and magic-free PHP framework

light-php's Issues

Auto initializa db before the first sql query it's executed

test issue # 02

this is a test issue

Be able to use composer create-project with this project

PHP Fatal error: Uncaught Error: Class 'ZipArchive' when `composer create-project bakeiro/light-php-site`

Hi, I found Uncaught Error: Class 'ZipArchive' when trying to install light-php-site

$ composer create-project bakeiro/light-php-site

...

PHP Fatal error:  Uncaught Error: Class 'ZipArchive' not found in /home/user/light-php-site/get-source-code.php:6
Stack trace:
#0 Command line code(1): require_once()
#1 {main}
  thrown in /home/user/light-php-site/get-source-code.php on line 6
Script php -r "require_once('./get-source-code.php'); " handling the post-create-project-cmd event returned with error code 255

edit: I run Ubuntu 20.04 LTS

Database don't fetch results sometimes

Describe the bug
Basically, Library\Database::query sometimes don't work, only in specific cases

To Reproduce
Bug description:
Database::query don't fetch result sometimes

example:

public function thisDontWork($agenda, $start, $end)
{
        $param = array(":agenda" => $agenda, ":dia_inicio" => $start, ":dia_fin" => $end);
        return Database::query("SELECT id_tarea, datos, cast(f_inicio AS DATETIME) AS f_inicio, cast(f_fin AS DATETIME) AS f_fin, id_agenda, cita_title, id_persona FROM crm_citas WHERE id_agenda LIKE '%:agenda%' AND presente != 5 AND cita_tipo != 'BG_CIERRE' AND cita_tipo != 'NO_DAR_CITA' AND (date(f_inicio) BETWEEN ':dia_inicio' AND ':dia_fin') ORDER BY f_inicio ASC", $param);
}

public function thisOneWorks($agenda, $start, $end)
{
        return Database::$CONN->query("SELECT id_tarea, datos, cast(f_inicio AS DATETIME) AS f_inicio, cast(f_fin AS DATETIME) AS f_fin, id_agenda, cita_title, id_persona FROM crm_citas WHERE id_agenda LIKE '%".$agenda."%' AND presente != 5 AND cita_tipo != 'BG_CIERRE' AND cita_tipo != 'NO_DAR_CITA' AND (date(f_inicio) BETWEEN '".$start."' AND '".$end."') ORDER BY f_inicio ASC")->fetchAll(PDO::FETCH_ASSOC);
}

Params in the functions:
$agenda => Dra. Tuya
$start & $end => "2020-01-29"

Expected behavior
It should fetch the results, since the only difference is how I send the parameters.

Enviroment

• OS: WIN
• PHP 7.2

Error when command 'composer create-project bakeiro/light-php-site'

Describe the bug
Here below is the error.

---

---

Creating a "bakeiro/light-php-site" project at "./light-php-site"
Info from https://repo.packagist.org: #StandWithUkraine
Cannot use bakeiro/light-php-site's latest version 0.96 as it requires php ^7.0 which is not satisfied by your platform.
Installing bakeiro/light-php-site (0.9)

• Installing bakeiro/light-php-site (0.9): Extracting archive
  Created project in C:\xampp\htdocs\naoki\php\112022-light\light-php-site
  Loading composer repositories with package information
  Updating dependencies
  Your requirements could not be resolved to an installable set of packages.

Problem 1
- Root composer.json requires bakeiro/micro_php_template_engine, it could not be found in any version, there may be a typo in the package name.

Potential causes:

• A typo in the package name
• The package is not available in a stable-enough version according to your minimum-stability setting
  see https://getcomposer.org/doc/04-schema.md#minimum-stability for more details.
• It's a private package and you forgot to add a custom repository to find it

Read https://getcomposer.org/doc/articles/troubleshooting.md for further common problems.

---

---

Enviroment

• OS:windows

Additional context
it looks like related to bakeiro/micro_php_template_engine and "minimum-stability": "stable",

Any idea anyone?

add airbnb code guidelines for JS and convert old js classes

use Library\Config; is empty

Hi, use Library\Config; is empty.

....system/library/config.php): failed to open stream: No such file or directory

HMVC

Interesting project. Any plans to add HMVC support? How hard would it be to import a project from CI to this?

implement PSR-4 autoload

Installation production... way?

Describe the bug
I had run the command composer create-project bakeiro/light-php on local.

To Reproduce
And i send all files on server. (i know it's not the good practice)

Expected behavior
The method isValidPath is no working correctly.
File does not exists....

So, my url is https://sub.domain/public

When i tried command : PHP -S localhost:8080 -t .\public
Nothing happens... xD

Could you help me?

Implement PSR-0, PSR-1

Inlcude precommit and github templates

that

Weird variable name

Light-PHP/system/engine/Database.php

Line 20 in 94515f5

$smtp = Database::$CONN->prepare($sql_query);

$smtp = Database::$CONN->prepare($sql_query);

smtp sounds like Simple Mail Transfer Protocol

Fatal error: Default value for parameters with a class type can only be NULL in /Users/wlin/dev/light-php/system/library/Config.php on line 22

Describe the bug

When I was trying to access the framework, I got error:

Fatal error: Default value for parameters with a class type can only be NULL in /Users/wlin/dev/light-php/system/library/Config.php on line 22

To Reproduce
Steps to reproduce the behavior:

1. Install and run the framework by the command:

   composer create-project bakeiro/light-php
   PHP -S localhost:8080 -t light-php/
   

2. boot the website by URL: http://localhost:8080/public/index.php?route=product/product/getProduct&prod_id=1

3. See error

Expected behavior
No error with a hello world view on the page.

Environment

• OS: MacOS
• Browser: Chrome
• PHP Version: 7.4
• Light-PHP Version: 1.981.0.0

Improve documentation

Issue along installing.

I tried to install Light-PHP, and I got through this weird error.

What should I do to fix this?

Add class for security and permissions

Installation error

[Not working] installed by composer

"Forbidden
You don't have permission to access this resource.

Apache/2.4.54 (Win64) OpenSSL/1.1.1p PHP/8.1.10 Server at localhost Port 80"

It's on a local XAMP server. it's on local.

Where should I look? htaccess or where should I check? I can't make it work.

Util.php missing in system/engine

Hi,
I was trying to install light-php with composer when it run post-install.php file it gives failed to open "./system/engine/Util.php". you need to update post-install file as you have moved Util.php file under library directory.

improve phpDOc

Improve the functions and classes comments

Add and prepare query to avoid queries that fail and make something wrong in the db

Check clean input

Check wether it's working or not
sysmtem/engine/Util::cleanInput()