· 10 years ago · Apr 29, 2016, 01:15 PM
1<?php
2
3
4// database connection config
5$dbHost = 'localhost';
6$dbUser = 'kallu';
7$dbPass = '78607860';
8$dbName = 'courier_db';
9
10$dbConn = mysql_connect ($dbHost, $dbUser, $dbPass, $dbName) or die ('MySQL connect failed. ' . mysql_error());
11mysql_select_db($dbName) or die('Cannot select database. ' . mysql_error());
12
13function dbQuery($sql)
14{
15 $result = mysql_query($sql) or die(mysql_error());
16
17 return $result;
18}
19
20function dbAffectedRows()
21{
22 global $dbConn;
23
24 return mysql_affected_rows($dbConn);
25}
26
27function dbFetchArray($result, $resultType = MYSQL_NUM) {
28 return mysql_fetch_array($result, $resultType);
29}
30
31function dbFetchAssoc($result)
32{
33 return mysql_fetch_assoc($result);
34}
35
36function dbFetchRow($result)
37{
38 return mysql_fetch_row($result);
39}
40
41function dbFreeResult($result)
42{
43 return mysql_free_result($result);
44}
45
46function dbNumRows($result)
47{
48 return mysql_num_rows($result);
49}
50
51function dbSelect($dbName)
52{
53 return mysql_select_db($dbName);
54}
55
56function dbInsertId()
57{
58 return mysql_insert_id();
59}
60?>
61
62-- phpMyAdmin SQL Dump
63-- version 2.11.9.2
64-- http://www.phpmyadmin.net
65--
66-- Host: localhost
67-- Generation Time: Jan 30, 2011 at 12:49 PM
68-- Server version: 5.0.67
69-- PHP Version: 5.2.6
70
71SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
72
73
74/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
75/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
76/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
77/*!40101 SET NAMES utf8 */;
78
79--
80-- Database: `courier_db`
81--
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `tbl_courier`
87--
88
89CREATE TABLE IF NOT EXISTS `tbl_courier` (
90 `cid` int(10) NOT NULL auto_increment,
91 `cons_no` varchar(20) NOT NULL,
92 `ship_name` varchar(100) NOT NULL,
93 `phone` varchar(12) NOT NULL,
94 `s_add` varchar(200) NOT NULL,
95 `rev_name` varchar(100) NOT NULL,
96 `r_phone` varchar(12) NOT NULL,
97 `r_add` varchar(200) NOT NULL,
98 `type` varchar(40) NOT NULL,
99 `weight` double NOT NULL,
100 `invice_no` varchar(20) NOT NULL,
101 `qty` int(10) NOT NULL,
102 `book_mode` varchar(20) NOT NULL,
103 `freight` double NOT NULL,
104 `mode` varchar(20) NOT NULL,
105 `pick_date` varchar(20) NOT NULL,
106 `pick_time` varchar(10) NOT NULL,
107 `status` varchar(20) NOT NULL,
108 `comments` varchar(250) NOT NULL,
109 `book_date` date NOT NULL,
110 PRIMARY KEY (`cid`)
111) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
112
113--
114-- Dumping data for table `tbl_courier`
115--
116
117INSERT INTO `tbl_courier` (`cid`, `cons_no`, `ship_name`, `phone`, `s_add`, `rev_name`, `r_phone`, `r_add`, `type`, `weight`, `invice_no`, `qty`, `book_mode`, `freight`, `mode`, `pick_date`, `pick_time`, `status`, `comments`, `book_date`) VALUES
118(1, 'M22P7KHM', 'Tousif Khan', '020 253623', 's sd sdsd', 'Rizwan Ahmed', '020 88552', 'sd sd s', 'Parcel', 20, '252525', 12, 'TBB', 240, 'Road', '29/01/2011', '12', 'Completed', 'ds ds d', '2011-01-29'),
119(2, 'QIWWGIQP', 'Asif khan', '020 253623', 'shani peth', 'munna bhai', '020 88552', 'asdas das d', 'Documents', 20, '252525', 12, 'TBB', 240, 'Train', '29/01/2011', '4', 'Delivered', 'Plz deliver it', '2011-01-29'),
120(3, 'Q906F73L', 'Amol sarode', '9532653652', 'metha nagar, bhusawal', 'sunil pal', '8585425412', 'balliram peth', 'Documents', 12, '239098', 12, 'ToPay', 200, 'Air', '26/01/2013', '4', 'In Transit', 'Thanks', '2011-01-29'),
121(4, '2THBV8UM', 'Farzana Sk', '9532652365', 'xzyz', 'Asif Khan', '9852451254', 'ABC', 'Parcel', 2, '23788', 4, 'Paid', 90, 'Road', '20/01/2011', '12', 'Delivered', 'Plz transit', '2011-01-30');
122
123-- --------------------------------------------------------
124
125--
126-- Table structure for table `tbl_courier_officers`
127--
128
129CREATE TABLE IF NOT EXISTS `tbl_courier_officers` (
130 `cid` int(10) NOT NULL auto_increment,
131 `officer_name` varchar(40) NOT NULL,
132 `off_pwd` varchar(40) NOT NULL,
133 `address` varchar(250) NOT NULL,
134 `email` varchar(100) NOT NULL,
135 `ph_no` varchar(12) NOT NULL,
136 `office` varchar(100) NOT NULL,
137 `reg_date` datetime NOT NULL,
138 PRIMARY KEY (`cid`)
139) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
140
141--
142-- Dumping data for table `tbl_courier_officers`
143--
144
145INSERT INTO `tbl_courier_officers` (`cid`, `officer_name`, `off_pwd`, `address`, `email`, `ph_no`, `office`, `reg_date`) VALUES
146(1, 'kapil', 'kapil', 'asif nagar , hyderabad', 'kapil@gmail.com', '9890989989', 'Fast Courier - Jalgaon', '2011-01-30 09:25:21'),
147(2, 'Ashraf Sk.', 'ashraf', '11, bhaguday nagar', 'ashraf@gmail.com', '9854254125', 'Fast Courier - Aurangabad', '2011-01-30 09:40:42'),
148(3, 'sunil', 'sunil', '390, sani peth', 'sunil@gmail.com', '9890989989', 'Fast Courier - Pune', '2011-01-30 17:50:34');
149
150-- --------------------------------------------------------
151
152--
153-- Table structure for table `tbl_courier_track`
154--
155
156CREATE TABLE IF NOT EXISTS `tbl_courier_track` (
157 `id` int(10) NOT NULL auto_increment,
158 `cid` int(10) NOT NULL,
159 `cons_no` varchar(20) NOT NULL,
160 `current_city` varchar(100) NOT NULL,
161 `status` varchar(30) NOT NULL,
162 `comments` varchar(255) NOT NULL,
163 `bk_time` datetime NOT NULL,
164 PRIMARY KEY (`id`)
165) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
166
167--
168-- Dumping data for table `tbl_courier_track`
169--
170
171INSERT INTO `tbl_courier_track` (`id`, `cid`, `cons_no`, `current_city`, `status`, `comments`, `bk_time`) VALUES
172(1, 1, 'M22P7KHM', 'Fast Courier - Jalgaon', 'Delayed', 'Delay due to rain', '2011-01-30 10:23:04'),
173(3, 1, 'M22P7KHM', 'Fast Courier - Jalgaon', 'Delayed', 'Delayed due to rain', '2011-01-30 10:26:43'),
174(4, 4, '2THBV8UM', 'Fast Courier - Aurangabad', 'Delayed', 'Due to rain', '2011-01-30 17:44:52'),
175(5, 1, 'M22P7KHM', 'Fast Courier - Jalgaon', 'Completed', 'Completed', '2011-01-30 17:49:11');
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `tbl_offices`
181--
182
183CREATE TABLE IF NOT EXISTS `tbl_offices` (
184 `id` int(10) NOT NULL auto_increment,
185 `off_name` varchar(100) NOT NULL,
186 `address` varchar(230) NOT NULL,
187 `city` varchar(100) NOT NULL,
188 `ph_no` varchar(20) NOT NULL,
189 `office_time` varchar(100) NOT NULL,
190 `contact_person` varchar(100) NOT NULL,
191 PRIMARY KEY (`id`)
192) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
193
194--
195-- Dumping data for table `tbl_offices`
196--
197
198INSERT INTO `tbl_offices` (`id`, `off_name`, `address`, `city`, `ph_no`, `office_time`, `contact_person`) VALUES
199(1, 'Fast Courier - Jalgaon', '290, shani peth, jalgaon', 'Jalgaon', '0257-25125', '10.00 am - 9.00 pm', 'Shammi Kapur'),
200(2, 'Fast Courier - Aurangabad', '20/12, sector 12, bhavani peth', 'Aurangabad', '0245-858521', '10.00 am - 9.00 pm', 'Amol Patil'),
201(3, 'Fast Courier - Pune', '230, Fashion Street', 'pune', '020-25125', '10.00 am - 9.00 pm', 'Atul Nigade');