Blog Archives

Web Based Library System in PHP, MySQL Free Download Source code

Web Based Library System

Database Schema

tblbook (id, isbn, bookTitle, bauthors, category, publisher, copyrightyear, bsection(circulation, reserved), noOfCopies, dateReceived, dateEncoded, encodedBy)

tblcategory (id, categoryName, description)

tblborrower (id, fname, mname, lname, contact, category (student, teacher,) courseid, image)

tblcourse (id, coursecode, coursename)

tblborrowedbook (id, bookid, borrowerid, dateborrowed, duedate, numCopies, status(returned, not), processedby, datereturned, receivedby)

Web Based Grading System for High School using PHP and MySQL

Web Based Grading System

Web Based Grading System for High School using PHP and MySQL

Database schema

tblschoolyear (id, schoolyear)

tblyearlevel (id, yearlevel, description)

tblsubjects (id, subjectname, description, yearlevelid)

tblstudent (id, lname, fname, mname, contact, address, username, password)

tblclass (id, classname, schoolyearid, yearlevelid)

tblstudentclass (id, classid, studentid)

Web Based Filing Management System Free Download Source code

Web Based File Management System

Web Based Filing Management System

Database Schema

tblSemester (id, semester)

tblSchoolYear (id, schoolyear, )

tblFaculty (id, facultyid, lname, fname, mname, address, contact, username, password)

tblFileCategory (id, categoryname, description, deadline) Deliverables

tblFilesSubmitted (id, filename, categoryid, description, facultyid, semesterid, schoolyearid, uploadedFiles, dateUploaded, dateUpdated, status(approved, not), remarks)

Web Based Dynamic Voting System Free Download Source code

Web Based Student Council Voting System

Web Based Dynamic voting system free download source code
System Features
monitoring of voted and non voted students
user accounts and user groups and privileges
student list, import list from excel or csv file, password generator for students and print list
manage party list (create, update, delete, search and print)

Web Based Math Learning App in PHP, MySQL and Bootstrap

Web Based Math Learning App

Web Based Math Learning App in PHP, MySQL and Bootstrap

Installation Procedure

  1. First upload the mathlearning folder to your C:\xampp\htdocs
  2. Open the Xampp Control Panel
  3. Start the Apache and MySQL Modules. Kill the process of Skype to prevent conflict with Apache. Make sure that the Apache and MySQL are running (green color is the indicator)
  4. Open now your browser (firefox, chrome) and type localhost/phpmyadmin
  5. Click the Database Tab and create a database and click Create button
  6. Open the newly create database. On your part, you don’t have tables. The next process are the following:
    1. Click the Import Tab
    2. Click Choose File button and browse and select the learning.sql, click Go button
  7. Open now your browser and type localhost/mathlearning

Hotel Reservation and Billing System With Android App

Web Based Hotel Reservation System

Hotel Reservation and Billing System With Android App

Front End

Display the following:

  • Company Profile
  • Policies
  • Location, Address
  • Contact Details
  • Services Offered
  • Facilities: Room Rates (allow users to register and reserve the room for a specified dates and view the total amount to pay)

PHP Simple Scripts for Beginners

PHP Snippets

PHP Snippets Free Download

PHP Simple Scripts for Beginners

the package includes the following codes

basicmathcalculator.php
browserdetector.php
calculatesumofcolumn.php
countnumberofcharacters.php
displaydatetime.php
displaylistofdatabaseinmysqlserver.php
emailvalidation.php
feettometer.php

Online Grading with Grade Viewing System in PHP MySQL Free Download Source code

Online Grade Viewing System

Online Grading System and Grade Viewing System

Administrator account

  1. Encode/update/delete subjects info (id, subjectname)
  2. Encode/update/delete class info Ex: BSIT 3-A (id, classname, sem)
  3. Encode/update/delete student (id, studentname)
  4. Student subject (id, studentid, subjected, classid) Ex: Juan Dela Cruz – BSIT 3-A – MATH 101 (this module will add a student to a certain class)
  5. Encode/update/delete teachers (id, teachername)
  6. Teacher load (id, teacherid, classid, sem)

Feet to meter converter in PHP

Feet to meter converter in PHP

Sample script in PHP that will convert feet to meter.

Get the filesize and file extension of a file in PHP

Get the filesize and file extension of a file in PHP

PHP script that will get the file size and file extension of the uploaded file.