PHP MySQL CRUD Application

Step 1: Create Database Table (`db.php`)

You create a table called employees with columns for id, name, position, office, age, start_date, and salary. This table is used to store employee information.

CREATE TABLE employees (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    position VARCHAR(255) NOT NULL,
    office VARCHAR(255) NOT NULL,
    age VARCHAR(255) NOT NULL,
    start_date DATETIME NOT NULL,
    salary INT(10) NOT NULL
);

Step 2: Configuration File (`config.php`)

This file connects to the MySQL database using credentials for the localhost, root user, and a defined password. The connection is checked, and if successful, it allows the rest of the PHP pages to interact with the database.

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '654321');
define('DB_NAME', 'name_db');

$connection = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);

if($connection === false) {
    die("ERROR: Could not connect. " . mysqli_connect_error());
}

Step 3: Display Data (`index.php`)

This PHP script fetches all employee data from the employees table and displays it in a Bootstrap-styled table. The data is displayed along with action icons for viewing, editing, or deleting records.

<?php
require_once "config.php";
$sql = "SELECT * FROM employees";
if($result = mysqli_query($connection, $sql)) {
    if(mysqli_num_rows($result) > 0) {
        // Output table headers and employee data here
    }
}
?>

The page uses the DataTables library to provide additional features like search, sorting, and pagination. External libraries like Bootstrap and DataTables are linked in the <head> section for styling and functionality.

Step 4: Custom Styles (`style.css`)

Custom CSS is used to style buttons, tables, and other elements. Specific styles for table headers, action buttons, and export options are defined.

.btn-app {
    background-color: steelblue !important;
}
.btn-app:hover {
    transform: scale(1.1);
}

Step 5: Custom JavaScript (`js.js`)

JavaScript is used to initialize the DataTable and enable exporting functionality (CSV, Excel, PDF, etc.) as well as custom translations for button text.

var idioma = {
    "sProcessing": "Procesando...",
    "sLengthMenu": "Mostrar _MENU_ registros",
    "sZeroRecords": "No se encontraron resultados",
    // Other localization strings
};

$(document).ready(function() {
    var table = $('#ejemplo').DataTable({
        "language": idioma,
        // Other DataTable settings
        buttons: [
            {
                extend: 'copyHtml5',
                text: '<i class="fa fa-clipboard"></i> Copiar',
                className: 'btn btn-app export barras',
                exportOptions: { columns: [0, 1] }
            },
            // Other export buttons (PDF, Excel, etc.)
        ]
    });
});

Additional Notes:

read.php, update.php, and delete.php: These files would be used for viewing, updating, and deleting employee data, although the actual implementation is not shown here.
Export Options: You have buttons for exporting data in PDF, Excel, CSV formats, or printing.
Localization: The JavaScript includes Spanish translations for DataTable text like "Processing", "Show MENU records", etc.

Souy Soeng

PHP MySQL CRUD Application

Step 1: Create Database Table (`db.php`)

Step 2: Configuration File (`config.php`)

Step 3: Display Data (`index.php`)

Step 4: Custom Styles (`style.css`)

Step 5: Custom JavaScript (`js.js`)

Additional Notes:

Post a Comment

Souy Soeng

PHP MySQL CRUD Application

Step 1: Create Database Table (db.php)

Step 2: Configuration File (config.php)

Step 3: Display Data (index.php)

Step 4: Custom Styles (style.css)

Step 5: Custom JavaScript (js.js)

Additional Notes:

Post a Comment

Step 1: Create Database Table (`db.php`)

Step 2: Configuration File (`config.php`)

Step 3: Display Data (`index.php`)

Step 4: Custom Styles (`style.css`)

Step 5: Custom JavaScript (`js.js`)