php

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

How to Retrieve Data from Database Table using PDO Query

Submitted by argie on
SQL Attack is rampant now a days, this is the way of hacking a site using SQL injection. Reading this tutorial will teach you on how to protect your queries from SQL injection attack using PDO Query. PHP Data Objects (PDO) Query executes an SQL statement in a single function call, returning the result set (if any) returned by the statement as a PDOStatement object. This is code will help you on how to retrieve data from Database table using PDO query.

Simple Shopping CART

Submitted by BikramLimbu.damak on
This simple PHP program deals with online Book shopping cart. It display all the books, if you click on Add to the cart then it will add to cart table and on top of page No of item and total amount is Displayed. this was my simple class project. Please feel free to modify to your needs. WARNING : tag css is not compatible with IE.

Baptismal Information System

Submitted by joken on
This is a complete Baptism Information system. This system created using PHP/MySQL and Twitter bootstrap framework and TCPDF for reports.And it has a feature for adding new entry for baptism, edit entry and delete entry and this system is also capable of generating a baptismal reports. Here are the following step to set the system. 1. Extract the downloaded sourcecode 2. and paste it inside your

Students Activities and Grades Information System send via SMS

Submitted by joken on
This is a complete System for student Activities and Grades Information System send via SMS. System features: • Adding of New Student, update and delete information of a specific student. • Student grades are automatically computed • The registrar can send the Grades to all students • The Supreme Student Government can send the different activities through SMS • Add new activities, update and

Online Public Access Catalog (OPAC)

Submitted by admin on
This is a modified version of Online Public Access Catalog. The code is totally different from the previous one. I made this because I found a lot of problem in the previous version. I am using Twitter Bootstrap in this version. So the design is kinda different from the original code. Since this script is using MS Access as the database backend, I’m using ODBC to connect to the database. So you

NetBeans 7.4 Released

Submitted by jproimakis on
NetBeans IDE 7.4 is now available, with its HTML5 development support implemented in version 7.3, now expanded to Java EE and PHP applications, as well as support for mobile web development on Android and iOS. NetBeans IDE allows you to quickly and easily develop Java desktop, mobile and web applications as well as HTML5 applications with HTML, JavaScript and CSS. The IDE also provides a variety

Language Use List: Groovy Enters Top-20; C Still on Top

Submitted by jproimakis on
Dramatic jumps over the past year have seen the Groovy language break into the top-20 list of programming languages, reaching the 18th spot, according to this month’s Tiobe index of programming language popularity. A dynamic language for the Java Virtual Machine, Groovy has managed to jump over 35 spots since last year, when it was ranked at the 53rd position. Though its use percentage is at a
Subscribe to php