Disponible en: https://cgutierr3zdev.000webhostapp.com/
git clone https://github.com/cgutierr3z/coffee-shop.git
cd coffee-shop
- Editar parametros de bd en archivo env y renombrar a .env
composer install
php spark db:create ci4coffeeshop
php spark migrate
php spark db:seed InitSeeder
php spark serve
acceder a http://localhost:8080/
- Realizar una consulta que permita conocer cuál es el producto que más stock tiene
- SELECT * FROM productos ORDER BY productos.stock DESC LIMIT 1;
- Realizar una consulta que permita conocer cuál es el producto más vendido.
- SELECT ventas.id_producto, productos.nombre, SUM(ventas.cantidad) AS 'cantidad ventas' FROM ventas JOIN productos ON ventas.id_producto = productos.id GROUP BY productos.id ORDER BY SUM(ventas.cantidad) DESC LIMIT 1;
CodeIgniter is a PHP full-stack web framework that is light, fast, flexible and secure. More information can be found at the official site.
This repository holds a composer-installable app starter. It has been built from the development repository.
More information about the plans for version 4 can be found in CodeIgniter 4 on the forums.
The user guide corresponding to the latest version of the framework can be found here.
composer create-project codeigniter4/appstarter
then composer update
whenever
there is a new release of the framework.
When updating, check the release notes to see if there are any changes you might need to apply
to your app
folder. The affected files can be copied or merged from
vendor/codeigniter4/framework/app
.
Copy env
to .env
and tailor for your app, specifically the baseURL
and any database settings.
index.php
is no longer in the root of the project! It has been moved inside the public folder,
for better security and separation of components.
This means that you should configure your web server to "point" to your project's public folder, and not to the project root. A better practice would be to configure a virtual host to point there. A poor practice would be to point your web server to the project root and expect to enter public/..., as the rest of your logic and the framework are exposed.
Please read the user guide for a better explanation of how CI4 works!
We use GitHub issues, in our main repository, to track BUGS and to track approved DEVELOPMENT work packages. We use our forum to provide SUPPORT and to discuss FEATURE REQUESTS.
This repository is a "distribution" one, built by our release preparation script. Problems with it can be raised on our forum, or as issues in the main repository.
PHP version 7.4 or higher is required, with the following extensions installed:
Additionally, make sure that the following extensions are enabled in your PHP: