php

PHP/MySQL/HTML Login Form

Submitted by Yorkiebar on
Introduction: This tutorial will cover creating a login form with PHP/MySQL/HTMl. Pre-creation: First you need to have some user accounts stored in a database, you can check out my profile for a tutorial on creating a register form. Steps of Creation: Step 1: First we need to connect to the database holding the user accounts... mysqli_connect uses the parameters; server, username, password* Step 2

PHP Basic Syntax

Submitted by Yorkiebar on
Introduction: This tutorial will cover the basic syntax of PHP files. What is syntax? Syntax is defined as "the structure of statements in a computer language." and as such refers to the format of the given scripts. Importance of correct syntax Having correct syntax in any script is extremely important.

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.