UpMVC PHP CRUD Framework: Build CRUD Apps with JS Action Confirmations

Recommend this page to a friend!

Download .zip

Info

Example

Demos

View files (26)

Download .zip

Reputation

Support forum

Blog (1)

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2023-11-21 (5 months ago)		Not enough user ratings				Total: 102		All time: 9,765 This week: 455

Version		License		PHP version		Categories
`upmvc-crud` 1.1		Freeware		8.2		HTML, PHP 5, Databases, Libraries, De...

Description

Author

Adrian M

This package allows developers to build CRUD applications with JavaScript action confirmations.

It provides base controller, model, and view classes to let developers implement applications that implement CRUD (Create, Read, Update, and Delete) operations on data records stored in a database.

The base classes generate HTML and JavaScript to make dialog boxes appear to let users confirm important actions they can ask the application to perform.

Adrian M

Performance

Level

Name:	Adrian M `<contact>`
Classes:	4 packages by Adrian M
Country:	Ireland

Level 2

Example


<?php

/*

 *   Copyright (c) 2023 BitsHost

 *   All rights reserved.



 *   Permission is hereby granted, free of charge, to any person obtaining a copy

 *   of this software and associated documentation files (the "Software"), to deal

 *   in the Software without restriction, including without limitation the rights

 *   to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

 *   copies of the Software, and to permit persons to whom the Software is

 *   furnished to do so, subject to the following conditions:



 *   The above copyright notice and this permission notice shall be included in all

 *   copies or substantial portions of the Software.



 *   THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR

 *   IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,

 *   FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE

 *   AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER

 *   LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

 *   OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE

 *   SOFTWARE.

 */



require_once 'vendor/autoload.php';



//error_reporting(1);

use MyApp\Controllers\UserController;

use MyApp\Models\UserModel;

use MyApp\Views\UserView;







$crudController = new UserController(new UserModel(), new UserView());

$crudController->renderHeader();

$crudController->handleRequest();

$crudController->renderFooter();

?>

Details

Building a Simple PHP CRUD Application with JavaScript Confirmation In this tutorial, we'll walk through the process of creating a basic PHP CRUD (Create, Read, Update, Delete) application. Additionally, we'll integrate a JavaScript confirmation dialog to ensure a user's intent before performing a delete operation.

Demo: https://upmvc.com/crud/

Prerequisites Before getting started, make sure you have the following:

A web server (e.g., Apache) installed on your machine. PHP installed. Basic knowledge of HTML, PHP, and JavaScript. Project Structure Here's the directory structure of our project:

Step 1: Setting Up the Project Create the project directory structure as shown above. Set up your web server to point to the public directory.

Step 2: Creating the Database Use the provided data.sql file to create a simple users table in your MySQL database. Adjust the database configuration in src/Models/UserModel.php accordingly.

Step 3: Implementing CRUD Operations Create: Implement the logic for adding a new user in CrudController.php. Read: Fetch and display users in a paginated manner in CrudController.php and CrudView.php. Update: Implement the logic for updating user information in CrudController.php. Delete: Implement the logic for deleting a user in CrudController.php and add a confirmation dialog using JavaScript in script.js.

Step 4: Paginating the User List In CrudController.php and CrudView.php, add pagination to display a limited number of users per page.

Step 5: Making the Delete Confirmation Specific In script.js, modify the confirmDeletion function to respond only to buttons with a specific class (e.g., delete-button).

Conclusion Congratulations! You've successfully built a PHP CRUD application with JavaScript confirmation for delete operations. This project serves as a foundation that you can extend and enhance based on your specific requirements.

Feel free to customize the application further, add user authentication, and integrate more advanced features to meet the needs of your project.

Happy coding!

UpMVC PHP CRUD

Open in a separate window

Files

File	Role	Description
`config` (3 files)
`public` (1 directory)
`src` (3 directories)
`vendor` (1 file, 1 directory)
`.htaccess`	Data	Auxiliary data
`composer.json`	Data	Auxiliary data
`fileStructure.txt`	Doc.	Documentation
`index.php`	Example	Example script
`LICENSE`	Lic.	License text
`README.md`	Doc.	Documentation

Files

config

File	Role	Description
`conf.php`	Class	Class source
`DbConnection.php`	Class	Class source
`sample.sql`	Data	Auxiliary data

Files

public

File	Role	Description
`assets` (2 directories)

Files

public

assets

File	Role	Description
`css` (1 file)
`js` (1 file)

Files

public

assets

css

File	Role	Description
`styles.css`	Data	Auxiliary data

Files

public

assets

File	Role	Description
`script.js`	Data	Auxiliary data

Files

src

File	Role	Description
`Controllers` (2 files)
`Models` (2 files)
`Views` (2 files)

Files

src

Controllers

File	Role	Description
`BaseController.php`	Class	Class source
`UserController.php`	Class	Class source

Files

src

Models

File	Role	Description
`BaseModel.php`	Class	Class source
`UserModel.php`	Class	Class source

Files

src

Views

File	Role	Description
`BaseView.php`	Class	Class source
`UserView.php`	Class	Class source

Files

vendor

File	Role	Description
`composer` (8 files)
`autoload.php`	Aux.	Auxiliary script

Files

vendor

composer

File	Role	Description
`autoload_classmap.php`	Aux.	Auxiliary script
`autoload_namespaces.php`	Aux.	Auxiliary script
`autoload_psr4.php`	Aux.	Auxiliary script
`autoload_real.php`	Class	Class source
`autoload_static.php`	Class	Class source
`ClassLoader.php`	Class	Class source
`LICENSE`	Lic.	License text
`platform_check.php`	Aux.	Auxiliary script