You are required to create a small Web site. You have to choose the project idea
ID: 3572526 • Letter: Y
Question
You are required to create a small Web site. You have to choose the project idea and work in it as individual or with a group. The website must cover all aspects in the course (HTML, CSS and PHP or JSP/Servlet). JS is optional. The number of students/project: 2 (3 only for exception) The number of Web pages must be at least 5 The number of dynamic Web pages must be at least 3 The Web Site must connect to a database (select + Update) Each student have to prepare Desciption.docx: a small report that explains all the functionalities of the website (With screenshots) Project.zip: contains all the files of the project (html, css, php or jsp, sql, ...). Identical project will get ZERO for both projects (if the change in only colors and text). Projects must be with different ideas or different implementation.Explanation / Answer
index.php
<?php ob_start();
include('config.php');
if(isset($_POST['submit'])){
$user = $_POST['user'];
$pass = sha1($_POST['pass']);
$query = "select * from userdata where username='$user' and password='$pass'";
echo "<br><br>".$pass." Hellooooo"; echo $query;
$r = mysql_query($query);
if(mysql_num_rows($r) == 1)
{
$row = mysql_fetch_array($r);
$_SESSION['level'] = $row['level'];
$_SESSION['id'] = $row['username'];
$_SESSION['name'] = $row['fname'].' '.$row['lname'];
header('location:'.$row['level'].'');
}
else
{
header('location:index.php?login=0');
}
}
if(isset($_SESSION['level'])){
header('location:'.$_SESSION['level'].'');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="favicon.ico">
<title>Mobilinks, Micromax Care</title>
<!-- Bootstrap core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="css/font-awesome.min.css" />
<link rel="stylesheet" href="css/style.css" />
<!-- Custom styles for this template -->
<link href="jumbotron.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.php">Mobilinks MMX Care</a>
</div>
<div id="navbar" class="navbar-collapse collapse">
<form class="navbar-form navbar-right" role="form" action="index.php" method="POST">
<div class="form-group">
<?php if(isset($_GET['login'])): ?>
<label class="text-danger">Invalid Username/Password</label>
<?php endif; ?>
</div>
<div class="form-group">
<input type="text" placeholder="ID No." class="form-control" name="user">
</div>
<div class="form-group">
<input type="password" placeholder="Password" class="form-control" name="pass">
</div>
<button type="submit" class="btn btn-success" name="submit">Sign in</button>
</form>
</div><!--/.navbar-collapse -->
</div>
</nav>
<!-- Main jumbotron for a primary marketing message or call to action -->
<div class="jumbotron">
<div class="container">
<h1>Mobilinks MMX Care</h1>
<p>Mobilinks Institution Started in January 2006, the Institute of Mobile Technologies, providing technical education, has grown by leaps and bounds in a short span of time (Alhumdullilah) and now is regarded as one of the foremost institutes for mobile technology and research in the valley. The electronic field takes big leaps in very short span and technology changes every year or so, and it is very difficult to advance with the technology and so far we have tried our best to remain with the latest technologies and hope for the same in future.</p>
<p><a class="btn btn-primary btn-lg" href="http://www.mobilinks.co.in/mobilinks/about.php" role="button">Learn more »</a></p>
</div>
</div>
<div class="container">
<!-- Example row of columns -->
<div class="row">
<div class="col-md-4"><img src="naseer2.jpg" width='100%'>
<p>Naseer AHmad Baba, Founder and CEO of Mobilinks Institute of mobile repairing</p>
</div>
<div class="col-md-4"><img src="asif.jpg" width='100%'>
<p>The man behind Mobilinks. He is the backbone of the company without whom the company would not have reached such status</p-->
</div>
<div class="col-md-4"><img src="juni.jpg" width='100%'>
<p>A parasite without whom the company would have reached even higher status. When all three together, you can call them 3 idiots</p>
<!--p>The man behind Mobilinks. He is the backbone of the company without whom the company would not have reached such status</p-->
</div>
</div>
<div class="row">
<div class="col-md-12">
The application has been developed and maintained by Mr. Asif Iqbal Khan. He has single handedly developed the application and that too free of cost. Free! Free! Free!. In return he shall get a lifetime membership in the company
under the membership all his mobile phones shall be repaired free of cost(including spares). Additionally, He (Asif Iqbal Khan) shall be provided with all the facilities which include food and drinks (soft drinks) during his visit to the office. Rest of the things will be communicated to the CEO in personal messages.
</div>
</div>
<hr>
<footer>
<p>© Mobilinks</p>
</footer>
</div> <!-- /container -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="js/jquery.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
config.php
<?php
session_start();
$host = 'localhost';
//$user = 'snaseer_jobsheet';
$user = 'root';
//$pass = 'jobsheet_123';
$pass = '';
$db = 'snaseer_jobsheet';
$con=mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db);
?>
logout.php
<?php
session_start();
session_destroy();
header('location:index.php');
?>
database.sql
-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 14, 2016 at 04:24 PM
-- Server version: 5.6.16
-- PHP Version: 5.5.9
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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: `mobilinks_jobsheet`
--
-- --------------------------------------------------------
--
-- Table structure for table `cco`
--
CREATE TABLE IF NOT EXISTS `cco` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ccoid` varchar(50) NOT NULL,
`fname` varchar(100) NOT NULL,
`lname` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `cco`
--
INSERT INTO `cco` (`id`, `ccoid`, `fname`, `lname`) VALUES
(10, 'naseer_cco', 'Naseer', 'Baba');
-- --------------------------------------------------------
--
-- Table structure for table `jobsheet`
--
CREATE TABLE IF NOT EXISTS `jobsheet` (
`jobsheetid` int(11) NOT NULL AUTO_INCREMENT,
`cust_name` varchar(50) NOT NULL,
`cust_address` varchar(500) NOT NULL,
`cust_contact` varchar(50) NOT NULL,
`cust_email` varchar(100) NOT NULL,
`phone_model` varchar(20) NOT NULL,
`imei1` varchar(30) NOT NULL,
`imei2` varchar(30) NOT NULL,
`problem_desc` text NOT NULL,
`warranty_status` varchar(10) NOT NULL,
`battery_no` varchar(50) NOT NULL,
`els` varchar(50) NOT NULL,
`technical_remarks` text NOT NULL,
`internal_remarks` text NOT NULL,
`physical_condition` text NOT NULL,
`estimate` varchar(6) NOT NULL,
`part_cost` varchar(6) NOT NULL,
`total_estimate` varchar(6) NOT NULL,
`present_status` varchar(20) NOT NULL,
`completed_by` varchar(50) NOT NULL,
`j_date` varchar(30) NOT NULL,
`deleted` bit(1) NOT NULL DEFAULT b'0',
`online_status` varchar(30) NOT NULL,
`online_jobsheet_no` varchar(30) NOT NULL,
`online_remarks` text NOT NULL,
`delivery_date` varchar(30) NOT NULL,
`delivered_by` varchar(30) NOT NULL,
PRIMARY KEY (`jobsheetid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `jobsheet`
--
INSERT INTO `jobsheet` (`jobsheetid`, `cust_name`, `cust_address`, `cust_contact`, `cust_email`, `phone_model`, `imei1`, `imei2`, `problem_desc`, `warranty_status`, `battery_no`, `els`, `technical_remarks`, `internal_remarks`, `physical_condition`, `estimate`, `part_cost`, `total_estimate`, `present_status`, `completed_by`, `j_date`, `deleted`, `online_status`, `online_jobsheet_no`, `online_remarks`, `delivery_date`, `delivered_by`) VALUES
(1, 'Asif Iqbal ', ' Batamaloo', '9858323226', '', 'MMX A67', '91332122834999', '', ' Get My Back Panel', 'DOA', '0', 'snaseer_t', ' Its my Phone ', 'Naseer will order my back panel for free', 'pipin Hue', '0', '0', '0', 'Under Process', 'imkhan107', '2016-05-05', b'0', '', '', '', '', ''),
(3, 'Naseer Baba', ' Batamaloo', '9858323226', '', 'MMX A67', '91332122834999', '', ' Get My Back Panel', 'DOA', '0', 'snaseer_t', ' Its my Phone ', 'Naseer will order my back panel for free', 'pipin Hue', '628642', '0', '628642', 'Part Awaiting', 'imkhan107', '2016-05-05', b'0', '', '', '', '', ''),
(4, 'Asif Iqbal Khan', 'Batamaloo Srinagar', '9858323226', '', 'MMX A67', '911998988889', '911879877890', ' PDD', 'IW', '2311889288', 'snaseer_t', 'Remarks', 'IR', 'C: Pipin Hue', '120', '100', '220', 'Part Awaiting', 'naseer_cco', '2016-05-12', b'0', 'Part Awaiting', '001', 'OR', '', 'Fiza');
-- --------------------------------------------------------
--
-- Table structure for table `technician`
--
CREATE TABLE IF NOT EXISTS `technician` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`techid` varchar(50) NOT NULL,
`fname` varchar(100) NOT NULL,
`lname` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `technician`
--
INSERT INTO `technician` (`id`, `techid`, `fname`, `lname`) VALUES
(2, 'snaseer_t', 'Naseer', 'Baba');
-- --------------------------------------------------------
--
-- Table structure for table `userdata`
--
CREATE TABLE IF NOT EXISTS `userdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`fname` varchar(100) NOT NULL,
`lname` varchar(100) NOT NULL,
`level` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Dumping data for table `userdata`
--
INSERT INTO `userdata` (`id`, `username`, `password`, `fname`, `lname`, `level`) VALUES
(2, 'imkhan107', '9c9a2e92d9e51fd2c0138107077868e1e3a8d4ba', 'Asif Iqbal', 'Khan', 'admin'),
(24, 'naseer_cco', '8b554fd31f813961fc958f81abe32cf27d13e170', 'Naseer', 'Baba', 'cco');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Please comment for further assistance. You might require more files for styling
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.