PHP

Simple CRUD File Handling System

Submitted by ronard on
Hi sourcecodesterian, I try to make a simple CRUD in File Handling System that will store data using files in txt format. The main feature of this program that will Create, Read, Update and Delete. The process of this program will add fullname and address. In fullname field, the system will auto create a txt files and get the current date with the random number for the file naming and save the

FreePHP: Simple Web-Based Inventory & POS System [UPDATED: FIXED]

Submitted by DavaoCloudStudio on
AC POS system is a online web based point of sale system build in PHP language. It uses MySQL as the data storage back-end and has a friendly UI. Features: Very easy to use & friendly UI Centralized database for top management Mass Import / Export feature Shop-wise Transaction details Inventory status and availability Individual Account for user - Added MISSING Database name Goto phpmyadmin, then

Count Total Subject/Row and Total Average Using Multiple Queries in One Table in PHP and MySQL

Submitted by ronard on
Hi sourcecodesterian especially for novice in PHP Programming, last time I uploaded was the " Multiple quries in one table using PHP and MySQL". Now I show you a simple queries in MySQL that count the total subject/row of student from table "grades" and display the total average grade from the student. This is just one table nested. Hope it will help. Thanks for reading...

Count Total Time Visited by User using PHP and MySQL

Submitted by ronard on
Hi sourcecodesterian, I would like to share this script that is part of my last project. The feature of this script is it will count the total time visited by user logged to the system. This will help the system admin to track the total time login by the user/client. Hope it will help you. How to install this script, copy the folder "tutorials" inside the "db" directory. And paste it to this path

Count Total Failed Login by the User in PHP and MySQL

Submitted by ronard on
This script will teach you especially for novice in PHP Programming. This script will count the total failed login by the user if the username inputted in the textbox is exists in table users. Then it will add to the table failed login. How to install this script? Unzip the downloaded file. And copy the "tutorials" directory from "db" directory to "mysql/data/". Then copy also the "check_failed

Object Oriented C Programming In PHP With advance query and trapping sql injection

Submitted by michael.galanza on
1. Create Database name OOP 2. Create table about your project 3. include or require the MySqlDb.php to any of your project query 3. Create $Db = new MySqlDb('localhost', 'root', '', 'OOP'); depending on your localhost username and password 4. your automatic query are in delete,save,edit and update are $Db->where('tableid', table subject); $Db->delete('database table'); 5. database example in

Import Database Tables Using PHP/MySQL

Submitted by argie on
This tutorial will teach you on how create a script that restore or import database tables using PHP. The feature of this tutorial is it allows the user to restore or imports database backup without using the phpmyadmin panel. To understand more about this tutorial follow the steps bellow

Creating Our Database

First we are going to create our database which stores our data. To create a database: 1. Open phpmyadmin 2. Then create database and name it as "tutorials".

Creating Our Form

The code bellow will provide us the form where we can attach our sql file.

Insert multiple data from your database using While Loop in PHP and MySQL

Submitted by ronard on
Hi sourcecodester, Do you wish to insert multiple data to your database using While Loop? Will PHP and MySQL can do that. Just select the table you want to insert in another table then loop it using "While Loop". And just define a variable you want to insert to another table and call it to your insertion query. Then run it to your web browser. The multiple data will automatically add to your table

Online Catering Reservation Using PHP/MySQL

Submitted by jery on
This complete system will help you to create a online catering reservation using PHP PDO query. the feature of this system is it allows you to backup and restore database without using phpmyadmin windows. Others feature of this products includes, it can generate reservation details report, can assign a catering team in each reservation, secure login, filter user based on their rules and manage

Count The Number Of Rows In The Database Table Using PHP/MySQL

Submitted by argie on
This tutorial will teach you on how to count the number of rows in your database table using PHP PDO query. to start with, follow the steps bellow.

Creating Our Database

First we are going to create our database which stores our data. To create a database: 1. Open phpmyadmin 2. Then create database and name it as "tutorial". 3.
Subscribe to PHP