Data Retrieval and Table Display
Posted: Sun Oct 30, 2011 10:37 am
Okay so I need to make a database and then I have to display it using my xampp server kinda thing. Ummm... This database is more like an inventory that I need to display on the browser in a table format.
This is the following code that I made and imported using PHPmyAdmin...
I'm really confused how to work on the data-retrieval, as well as making it display in a table form..
Please help me..This is my assignment and I've been working on it for a week to get through it...

This is the following code that I made and imported using PHPmyAdmin...
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 29, 2011 at 09:25 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `school_of_engineering`
--
-- --------------------------------------------------------
--
-- Table structure for table `Inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`ID` varchar(10) NOT NULL,
`Name` varchar(20) NOT NULL,
`Qty` int(10) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `Inventory`
--
INSERT INTO `Inventory` (`ID`, `Name`, `Qty`) VALUES
('1', 'Breadboard', 1),
('10', 'Utility Cutter', 2),
('12', 'Screwdriver', 1),
('13', 'Phillip screwdriver', 1),
('15', 'Long nose plier', 1),
('16', 'Combination Plier', 1),
('17', 'Adjustable Spanner', 1),
('18', 'Ring Spanner', 1),
('2', 'Glue Gun', 1),
('21', 'Digital multimeter', 1),
('22', 'Analogue multimeter', 1),
('25', 'Multi Extension', 1),
('26', 'Measuring Tape', 1),
('28', 'Semi-Circle File', 1),
('29', 'Triangle File', 1),
('3', 'Soldering Iron', 1),
('30', 'Square File', 1),
('31', 'Round File', 1),
('32', 'Flat File', 1),
('33', 'Bench Vice', 1),
('34', 'Multi-Adapter', 1),
('35', 'Hacksaw', 1),
('36', 'Hand Saw', 1),
('37', 'Metal Ruler', 1),
('39', 'Goggle', 1),
('4', 'Soldering stand & sp', 1),
('40', 'Battery Drill', 1),
('41', 'Electric Hand Drill', 1),
('42', 'Jig saw', 1),
('43', 'Hammer', 1),
('44', 'Mallet', 1),
('45', 'Drill bits', 1),
('46', 'Mallet', 1),
('5', 'Soldering Lead', 1),
('6', 'De-soldering pump', 1),
('60', 'OSC Probe', 1),
('64', 'BNC - BNC', 1),
('7', 'Wire stripper', 1),
('8', 'Wire cutter', 1);
I'm really confused how to work on the data-retrieval, as well as making it display in a table form..
Please help me..This is my assignment and I've been working on it for a week to get through it...