IT Project

View and edit of items are handled in "view_items.php" file. We link this file in the "View Items" sub menu in "Inventory" main menu. When visit to the page, it shows all items we created. When click on "Edit" link, item editing panel shows in the right side panel. That because when you click on "edit" link, it refer to the same page, but with a url parameter "id" and with a value of the product id of the database table. In PHP we write argument to show the editing form, only if this URL parameter is passed to the page. Source code of "view_items.php" page: <?php include("inc/page_header.php"); ?> <?php if(check('Manage Inventory') != 'Valid'){ header("Location: sys_home.php?pre=error"); ob_end_flush(); } ?> <script type="text/javascript"> function newCat(){ var catname=prompt("New Category Name: "); if(catname!=null &...

Learn PHP by Coding - Free Tutorial

In this website, you can learn PHP by coding a real system with lots of functions. This is a system for a construction company and it is an inventory control system. First of all you will need to install wamp server in your computer and learn basics of HTML and Java Scripts. In this tutorial project you can gain a good knowledge in PHP programming. The complete source code is provided along with MySQL database for you to download in a zip file. You can use this as your IT project by further developing and changing interfaces, functions, page names etc. Download link is provided some where in this website, you are supposed to read through this tutorial and learn the basics before just download and directly use it. Because once you reading posts in this website, you will get the direct download link of all files of this project in a zip file.

View and Edit Stocks

In the Stocks menu, select the "View / Edit Stocks" sub menu. It is linked to "view_stocks.php" page / file. This page shows stocks of all items (items that has an stock record). Stocks table in the MySQL database records stocks details of products. An item can have many stocks records. This table only records stock purchases. To get the stock balance we get the total of all stocks in's and total of stock out's. By getting the difference of total in and total out, we can get the balance stock. This page has another php script for pagination. If there are hundreds of items, showing all in one page is difficult and takes long time to load, therefore we uses pagination process. Also included a search function to locate an item easily. To edit a stock record, you should click on an item name. Item name is linked to "view_stock_items.php?itm=15" with an URL parameter "itm" having the value of item index (primary key). In this page...

BCS Online Lectures

Free online lectures for BCS (British Computer Society) Professional Qualifications Certificate Level Examinations. Subject includes Information Systems, Software Development, Computer and Network Technology.

bcsonlinelectures.com/

Followers

Free PHP / MySQL Tutorial

Learn to develop an easy payment system for an electronic store using PHP and MySQL. Complete coding with full project directory.

phpfromexample.blogspot.com