PHP

How to Block Countries From Accessing Your Website

Submitted by chrislim2888 on
This sample code demonstrate you on how to block the countries from accessing your website based on visitor's IP address using a non-intrusive method on application level (webpage). I'm using the BIN data file approach that will free my hassle to set up a relation database for this. The IP geolocation BIN data provided in this sample zip is outdated, and you can always download a free IP

Record Management System Using PHP/MySQL with PDO Query

Submitted by argie on
This system will allow you to record the transaction that comes in and out of the Record Office. I developed this using PHP/MySQL with PDO support. The features of this system are login form, transaction form. It has the basic features of a database system like add, edit, update, and delete. It also has a masterfile for document type and offices. The masterfile is then used in the transaction form

Divide 24 hours into 3 shifts schedule with MySQL date_format function

Submitted by ronard on
I'm currently developing an application for shifting schedule in our team and I would like to share with you guys on how to divide 24 hours into 3 shifts. The following schedules are: First shift: 7-15 (7am-3pm) Second shift: 15-23 (3pm-11pm) Third shift: 23-7 (11pm-7am) I used date_format function in MySQL and call the current system time, and I also declare variable for each shifts in and out

Multiple Delete Data Using PHP/MySQL and PDO Query

Submitted by argie on
This tutorial will teach you on how to create an application in PHP/MySQL using PDO query that delete multiple data using checkbox as selector. I used checkbox as a selector in every row that u want to delete from database table. To understand more about this tutorial, fallow 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 "pdo_ret". 3.

CRUD Using PHP/MySQL with PDO Query

Submitted by argie on
This Tutorial will teach you on how to create a simple CRUD system using PHP/MySQL and PDO Query.This Code is combination on my previous tutorial posted in this site. The feature of this system are CREATE, UPDATE, and DELETE using PDO Query. This is different from the other CRUD system posted in this site, because I used PDO Query and this system also is safe for SQL Injection. Other feature of

Delete Data Using PHP/MySQL with PDO Query

Submitted by argie on
This tutorial will teach you on how to delete data from database table. I used PHP/MySQL with PDO query in this delete system. To start this tutorial fallow 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 "pdo_ret". 3.

Edit/Update Data Using PHP/MySQL with PDO Query

Submitted by argie on
This tutorial will teach you on how to edit data from database table. This edit system is in PHP/MySQL withy PDO query. to start this tutorial fallow 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 "pdo_ret". 3.

Chat System Using PHP/MySQL with PDO Query and Ajax

Submitted by argie on
This Chat System will help you, specially to thus programmer who are building their own social networking site. This chat system is very easy to implement, risk free to install. This chat application includes ajax post and load messages, this chat save and load your message without loading the page content. In short this chat content looks like the Facebook chat, the last conversation start at the

How to Create Login Page in PHP/MySQL using PDO Query

Submitted by argie on
Yesterday I posted a tutorial on how to create a registration page using PHP/MySQL with PDO Query. To make some follow up with my registration page tutorial, I decided to create another tutorial on how to create a login page using PHP/MySQL with PDO Query Also. in this tutorial you will also learn how to use php server side validation and how to add filter in PDO Query. Username: admin Password: admin To start this tutorial let’s follow the steps bellow.

Creating Our Database

First we are going to create our database which stores our data. To create a database: 1.