PDO

IT Helpdesk Ticketing System using PHP and MySQL with Source Code

Submitted by jaypabs on
IT Helpdesk Ticketing System using PHP and MySQL with Source Code
The IT Helpdesk Ticketing System is a web application built with PHP and MySQL that lets employees or students report computer problems, and lets the IT team track, assign and resolve each request in one place. Instead of support requests getting lost in chat messages and sticky notes, every issue becomes a numbered ticket with a status, a priority, an assigned technician, and a full conversation

How to Build a Simple REST API in PHP and MySQL Using PDO (CRUD with JSON)

Submitted by jaypabs on

Sooner or later every web project needs to talk to something other than a browser. A mobile app wants to load products, a JavaScript front end wants to save a form without reloading the page, or a classmate's system needs to read your data for a capstone integration. The usual answer is a REST API: a set of URLs that accept and return JSON.

Multi Role Login System Using PHP and MySQL with Source Code

Submitted by rems on
Welcome to the Multi-Role Login System, a sophisticated web application crafted to deliver secure and role-specific access using PHP and MySQL. This dynamic system introduces an innovative approach to user authentication, allowing individuals to log in with distinct roles, such as "Admin" or "User," each with unique privileges. Through a seamless integration of PHP for server-side scripting and

MySQLi vs. PDO: Which PHP Database API Should You Use?

Submitted by rems on
Interacting with databases is crucial in numerous web applications, and PHP, a widely used and adaptable scripting language for web development, is well-suited for this task. In PHP, two commonly favored methods for database interaction are MySQLi (short for MySQL Improved) and PDO (PHP Data Objects). They both provide means to connect with databases, execute queries, and fetch data, but they

PHP CRUD - Joins Two Tables with Free Source Code

Submitted by rems on
In web development, creating efficient and interactive applications is a common pursuit. When dealing with databases, the CRUD (Create, Read, Update, Delete) operations are fundamental for managing data. Often, data is distributed across multiple tables, necessitating JOIN operations to retrieve and manipulate information comprehensively. This project will guide you through building a dynamic PHP

Preventing SQL Injection in PHP Tutorial

Submitted by oretnom23 on

Introduction

In this tutorial, I will teach you how to Prevent SQL Injection in writing your PHP Queries for your current and future PHP Projects. This tutorial aims to give the IT/CS Students or those new to PHP Language a reference to learn for securing their database data in PHP. Here, I will be providing some snippets with a sample source code that demonstrates our topic for this tutorial.

Online Employee Leave Management System in PHP Free Source Code

Submitted by oretnom23 on
Introduction This project is entitled Online Leave Management System. This is a web-based application project developed in PHP and MySQL Database. The main goal of this project is to provide the certain Company to manage their employees' leave requests. This is also helpful to the employees as an easy way of submitting their leave requests. The application has a pleasant user interface using

Point of Sale (POS) System Using PHP/PDO Free Source Code

Submitted by argie on
Introduction This is a PHP Project called Point of Sales System. This project has many features that commonly needed to ease the day-to-day transaction of a certain store/company. This POS System can also handle customer credit which the customer can make an installment payment. The system has a simple user interface and user-friendly functionalities. About the system This Point of Sale System was

Creating a Simple Activity Log Feature in Web App using PHP/PDO

Submitted by justinwilliam on
This is a simple PHP/PDO tutorial script source code that tracks the system users' time log. The program was developed using PHP/PDO, MySQL Database, HTML, Javascript, jQuery, and Bootstrap. This will help you to learn how to create a simple activity log in your PHP web application. In this tutorial app, the system also updates automatically the login status of the user either online or offline
Subscribe to PDO