You are required to create a small Web site. You have to choose the project idea

ID: 3689426 • 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, JS and PHP or JSP/Servlet)

- The number of students /project: 2

- 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

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, js, php or jsp, sql,,…).

Explanation / Answer

The website is used to collect the details of all the employees in a college, save them to a database and display their profiles. The data base is also included

All the required functionalities were included

index.html

   var x = 5;
function add_field()
       {
       var table = document.getElementById("tab1");
           var lastRow = table.rows.length;
       var row = table.insertRow(lastRow-1);

           var cell1 = row.insertCell(0);
       var cell2 = row.insertCell(1);
       var cell3 = row.insertCell(2);
       var cell4 = row.insertCell(3);

           cell1.innerHTML = "<input type = 'text' name =" + ("ed" + x) + ">";
           x++;
       cell2.innerHTML = "<input type = 'text' name =" + ("ed" + x) + ">";
           x++;
       cell3.innerHTML = "<input type = 'text' name =" + ("ed" + x) + ">";
           x++;
       cell4.innerHTML = "<input type = 'text' name =" + ("ed" + x) + ">";
           x++;
       }

</script>
</head>

<body>

<h2><center><FONT>WEBSITE</FONT></center></h2>

   <tr><td>Name : </td><td><input type="text" name = "nam"></td><td>Department : </td><td><select name = "dept"><option>-Select-</option>
                                                                                                               <option>BME</option>
                                                                                                               <option>EEE</option>
                                                                                                               <option>ECE</option>
                                                                                                               <option>CSE</option>
                                                                                                               <option>IT</option>
                                                                                                               <option>BS & H</option></select></td></tr>
   <tr><td>Username : </td><td><input type="text" name = "usr"></td><td>Password : </td><td><input type="password" name = "pas"></td></tr>
   <tr><td>Email : </td><td><input type="text" name = "email"></td><td>Phone : </td><td><input type="text" name = "phone"></td></tr>
   <tr><td>Qualification : </td><td><input type="text" name = "qual"></td><td>Designation : </td><td><input type="text" name = "desg"></td></tr>
   <tr><td colspan = "4" align = "center"><hr></td></tr>
</table>

<input type = "hidden" name="h1">

<table id = "tab1" align = "center" border="0" width = "80%">
<tr><td colspan = "3"><b>Educational Details : (order of highest degree first to lowest degree last)</b></td></tr>
<tr><td>Degree</td><td>Specialization</td><td>Year of Completion/Award</td><td>College/University</td></tr>
<tr><td><input type = "text" name = "ed1"></td><td><input type = "text" name = "ed2"></td><td><input type = "text" name = "ed3"></td><td><input type = "text" name = "ed4"></td></tr>
<tr><td colspan = "4" align = "right"><input type = "button" value = "Add"></td></tr>
</table>

<input type = "hidden" name="h2">

<table id = "tab2" align = "center" border="0" width = "80%">
<tr><td colspan = "3"><b>Experience Details : (order of current employer first to first employer last)</b></td></tr>
<tr><td>Organization</td><td>Designation</td><td>From Date</td><td>To Date</td><td>Experience (In Years)</td></tr>
<tr><td><input type = "text" name = "ex1"></td><td><input type = "text" name = "ex2"></td><td><input type = "text" name = "ex3"></td><td><input type = "text" name = "ex4"></td><td><input type = "text" name = "ex5"></td></tr>
<tr><td colspan = "5" align = "right"><input type = "button" value = "Add"></td></tr>
</table>

<input type = "hidden" name="h3">

<table id = "tab3" align = "center" border="0" width = "80%">
<tr><td><b>Professional Body Memberships : </b></td><td><input type="text" name = "prof_body"></td></tr>
<tr><td><b>Areas Of Interest : </b></td><td><input type="text" name = "areas_int"></td></tr>
</table>

<input type = "hidden" name="h4">

<table id = "tab4" align = "center" border="0" width = "80%">
<tr><td colspan = "3"><b>Achievements : </b></td></tr>
<tr><td colspan = "3"><b>FDPs/Workshops/Conferences Attended : (order of latest attended first to first attended at last)</b></td></tr>
<tr><td>TiTle</td><td>Venue</td><td>Date</td></tr>
<tr><td><input type = "text" name = "a1"></td><td><input type = "text" name = "a2"></td><td><input type = "text" name = "a3"></td></tr>
<tr><td colspan = "3" align = "right"><input type = "button" value = "Add"></td></tr>
</table>

<input type = "hidden" name="h5">

<table id = "tab5" align = "center" border="0" width = "80%">
<tr><td colspan = "3"><b>Publications : (order of latest publications first and old publications at last)</b></td></tr>
<tr><td>TiTle</td><td>Journal</td><td>National/International</td><td>Date of Publication</td></tr>
<tr><td><input type = "text" name = "p1"></td><td><input type = "text" name = "p2"></td><td><input type = "text" name = "p3"></td><td><input type = "text" name = "p4"></td></tr>
<tr><td colspan = "4" align = "right"><input type = "button" value = "Add"></td></tr>
</table>

</div>

</body>
</html>

enter.php

<?php

$edu_details = array();
$exp_details = array();
$ach_details = array();
$jou_details = array();

$con = mysql_connect("localhost:3306","root","");
mysql_select_db("fac",$con);

$tes = $_POST;
echo "<br>";

$count=0;
$arr = array();
foreach( $tes as $a=>$b)
   {
       //echo "Key " . $a . " Value " . $b . "<br>";
       $arr[$count] = $b;

       $count++;
   }


$sp1 = array_search("", $arr);

//echo "<br>SP1 : " . $sp1;

if ($sp1) {
$first = array_slice($arr, 0, $sp1);
$second = array_slice($arr, ($sp1+1),(sizeof($arr)-($sp1+1)));
}
$sp2 = array_search("", $second);

if ($sp2) {
$sec = array_slice($second, 0, $sp2);
$third = array_slice($second, ($sp2+1),(sizeof($second)-($sp2+1)));
           }

$sp3 = array_search("", $third);

if ($sp3) {
$th = array_slice($third, 0, $sp3);
$fourth = array_slice($third, ($sp3+1),(sizeof($third)-($sp3+1)));

}

$sp4 = array_search("", $fourth);

if ($sp4) {
$four = array_slice($fourth, 0, $sp4);
$fifth = array_slice($fourth, ($sp4+1),(sizeof($fourth)-($sp4+1)));
}

$sp5 = array_search("", $fifth);

if ($sp5) {
$fif = array_slice($fifth, 0, $sp5);
$sixth = array_slice($fifth, ($sp5+1),(sizeof($fifth)-($sp5+1)));
}
echo "FIRST " . $first[0] . " " . $first[1] . " " . $first[2] . " " . $first[3] . " " . $first[4] . " " . $first[5] . " " . $first[6]. " " . $first[7];
$qry = "insert into fac_details values('$first[0]','$first[1]','$first[2]','$first[3]','$first[4]','$first[5]','$first[6]','$first[7]')";

$res1 = mysql_query("$qry",$con);

//echo $res1 . " INSERTED";

//-------------INSERTING FOR EDUCATION DETAILS------------
$j=0;
for($i=0;$i<(sizeof($sec)/4);$i++)
   {
       $val1 = $sec[$j];       $val2 = $sec[$j+1];       $val3 = $sec[$j+2];       $val4 = $sec[$j+3];
       $qry1 = "insert into educational_details values('$first[2]','$val1','$val2','$val3','$val4')";
       $res2 = mysql_query("$qry1",$con);
       $j = $j+4;
   }

//-----------FINISHED FOR EDUCATIONAL DETAILS---------------

//-------------INSERTING FOR EXPERIENCE DETAILS------------
$k=0;
for($i=0;$i<(sizeof($th)/5);$i++)
   {
       $val1 = $th[$k];       $val2 = $th[$k+1];       $val3 = $th[$k+2];       $val4 = $th[$k+3];       $val5 = $th[$k+4];
       $qry2 = "insert into exp_details values('$first[2]','$val1','$val2','$val3','$val4','$val5')";
       $res3 = mysql_query("$qry2",$con);
       $k = $k + 5;
   }

//-----------FINISHED FOR EXPERIENCE DETAILS---------------

//-------------INSERTING FOR PROF BODY MEM AND AREAS OF INT DETAILS------------
$_prof = $four[0];
$_int = $four[1];
$qry3 = "insert into prof_body values('$first[2]','$_prof','$_int')";
$res4 = mysql_query("$qry3",$con);
//-----------FINISHED FOR PROF BODY MEM AND AREAS OF INT DETAILS---------------

//-------------INSERTING FOR ACHIEVEMENTS DETAILS------------
$l=0;
for($i=0;$i<(sizeof($fif)/3);$i++)
   {
       $val1 = $fif[$l];       $val2 = $fif[$l+1];       $val3 = $fif[$l+2];
       $qry4 = "insert into fac_achievements values('$first[2]','$val1','$val2','$val3')";
       $res4 = mysql_query("$qry4",$con);
       $l = $l + 3;
   }

//-----------FINISHED FOR ACHIEVEMENT DETAILS---------------

//-------------INSERTING FOR PUBLICATION DETAILS------------
$m=0;
for($i=0;$i<(sizeof($sixth)/4);$i++)
   {
       $val1 = $sixth[$m];       $val2 = $sixth[$m+1];       $val3 = $sixth[$m+2];       $val4 = $sixth[$m+3];
       $qry5 = "insert into fac_publications values('$first[2]','$val1','$val2','$val3','$val4')";
       $res5 = mysql_query("$qry5",$con);
       $m = $m + 4;
   }

//-----------FINISHED FOR PUBLICATION DETAILS---------------

header("Location:add_img.php?un=".$first[2]);

add_img.php

<!DOCTYPE html>
<head>

</head>
<body>

   <?php
       $user = $_REQUEST['un'];
   ?>

   <div>
<form action="save_image.php" method="post" enctype="multipart/form-data">
           <label>USER : </label><?php echo $user;?><br />
Select a Profile Picture<input type="file" name="userfile"><br>
           <input type = "hidden" name = "un" value = "<?php echo $user;?>" />
<input type="submit" value="Upload file">
</form>
</div>
</body>
</html>

file_constants.php

<?php
$host="localhost";
$user="root";
$pass="";
$db="fac";
?>

file_display.php

<?php
include "file_constants.php";
$username = $_REQUEST["un"];
error_reporting(E_ALL);
//connect to the db
$link = mysql_connect("$host", "$user", "$pass")
or die("Could not connect: " . mysql_error());

// select our database
mysql_select_db("$db") or die(mysql_error());

// get the image from the db
$sql = "SELECT image FROM test_image WHERE username='" . $username . "'";

// the result of the query
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());

// set the header for the image
header("Content-type: image/jpeg");
echo mysql_result($result, 0);

// close the db link
mysql_close($link);
?>

print.php

<html>

   .div_main
       {
           margin:0px auto;
           width:1000px;
           //height:930px;
           border:1px solid black;
       }

   .div_pic
       {
           width:150px;
           height:180px;
           border:1px solid red;
           margin-left:5px;
           margin-top:5px;
           float:left;
       }
   .heading{font-family:Calibri;   font-size:24px; color:#0066FF;   font-variant:small-caps; font-weight:bold;   padding-left:10px;}

   th{font-variant:small-caps;border:1px solid black;}
   .edu{
       font-family:Calibri; text-align:center; border:1px solid black;}

</style>
</head>
<?php

$user = $_REQUEST["un"];

$con = mysql_connect("198.143.165.100:3306","gvpapp","gvpapp");
mysql_select_db("gvpapp",$con);
$qry = "select * from fac_details where username = '".$user."'";
$ret = mysql_query($qry);

?>
<body>

       <img src="source.php?un=<?php echo $user;?>" width='150' height='180' />
   </div>
<?php
   while($row = mysql_fetch_array($ret))
       {
?>
   <br /><br /><br /><br /><br /><br />
   <font class = "heading"><?php echo $row['name']; ?></font><br />
   <font><b><?php echo $row['qual']; ?></b></font><br />
   <font><b><?php echo $row['desg']; ?>, <?php echo $row['dept']; ?></b></font><br />

   <div id = "contact-info">
       <font><b>    Contact Information</b></font>
   </div>

   <table align = "left" width="100%">
   <tr><td><font>Email ID : </font><b><?php echo $row['emailid']; ?></b></td>
       <td><font>Phone : </font><b><?php echo $row['phone']; ?></b></td></tr>
       <tr><td> </td>
       </tr>
   </table>

   <br /><br />

<?php
       }
?>

<div id = "edu-info">
       <font><b>    Educational Information</b></font>
   </div>


<table align="center" border="0" width="100%">
<tr><th>Degree</th><th>Specialization</th><th>Year of Completion</th><th>University/College</th></tr>
<?php
$qry1 = " select * from educational_details where username = '".$user."'";
$ret1 = mysql_query($qry1);
   while($row1 = mysql_fetch_array($ret1))
       {
?>

</table>

<div id = "exp-info">
       <font><b>    Experience Information</b></font>
   </div>

<table align="center" border="0" width="100%">
<tr><th>Organization</th><th>Designation</th><th>From</th><th>To</th><th>Years of Experience</th></tr>
<?php
$qry2 = " select * from exp_details where username = '".$user."'";
$ret2 = mysql_query($qry2);
while($row2 = mysql_fetch_array($ret2))
{
?>

</table>

<div id = "exp-info">
       <font><b>    Professional Body Memberships & Areas of Interest</b></font>
   </div>

<?php
$qry3 = " select * from prof_body where username = '".$user."'";
$ret3 = mysql_query($qry3);
   while($row3 = mysql_fetch_array($ret3))
       {
?>
<table align="center" width="100%">
   <tr><td><font>Professional Body Memberships : </font><b><?php echo $row3['prof_body']; ?></b></td></tr>
   <tr><td></td></tr>
   <tr><td><font>Areas of Interest : </font><b><?php echo $row3['areas_int']; ?></b></td></tr>

<?php
       }
?>

</table>

<div id = "exp-info">
       <font><b>    FDPs / Workshops / Conferences Attended</b></font>
   </div>

<table align="center" border="0" width="100%">
<tr><th>Program</th><th>Venue</th><th>Date</th></tr>
<?php
$qry4 = " select * from fac_achievements where username = '".$user."'";
$ret4 = mysql_query($qry4);
while($row4 = mysql_fetch_array($ret4))
{
?>

</table>

<div id = "exp-info">
       <font><b>    Publications - International / National</b></font>
   </div>

<table align="center" border="0" width="100%">
<tr><th>Title</th><th>Journal</th><th>International / International</th><th>Date of Publication</th></tr>
<?php
$qry5 = " select * from fac_publications where username = '".$user."'";
$ret5 = mysql_query($qry5);
while($row5 = mysql_fetch_array($ret5))
{
?>

</table>

</div>

save_image.php

<?php
$username = $_REQUEST["un"];
include "file_constants.php";
$maxsize = 10000000; //set to approx 10 MB

//check associated error code
if($_FILES['pass_pic']['error']==UPLOAD_ERR_OK) {

//check whether file is uploaded with HTTP POST
if(is_uploaded_file($_FILES['pass_pic']['tmp_name'])) {

//checks size of uploaded image on server side
if( $_FILES['pass_pic']['size'] < $maxsize) {

//checks whether uploaded file is of image type
//if(strpos(mime_content_type($_FILES['pass_pic']['tmp_name']),"image")===0) {
$finfo = finfo_open(FILEINFO_MIME_TYPE);
if(strpos(finfo_file($finfo, $_FILES['pass_pic']['tmp_name']),"image")===0) {

// prepare the image for insertion
$imgData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));

// put the image in the db...
// database connection
mysql_connect($host, $user, $pass) OR DIE (mysql_error());

// select the db
mysql_select_db ($db) OR DIE ("Unable to select db".mysql_error());

// our sql query
$sql = "INSERT INTO test_image
(image, name, username)
VALUES
('{$imgData}', '{$_FILES['userfile']['name']}','{$username}');";

$sql1 = "delete from test_image where username = '" . $username . "'";

// insert the image
                   mysql_query($sql1);
mysql_query($sql) or die("Error in Query: " . mysql_error());
$msg='<p>Image successfully saved in database with id ='. mysql_insert_id().' </p>';
                   header("Location:edit_print.php?un=".$username);
                   //echo "edit_print.php?un=".$username;
}
else
$msg="<p>Uploaded file is not an image.</p>";
}
else {
// if the file is not less than the maximum allowed, print an error
$msg='<div>File exceeds the Maximum File limit</div>
<div>Maximum File limit is '.$maxsize.' bytes</div>
<div>File '.$_FILES['userfile']['name'].' is '.$_FILES['userfile']['size'].
' bytes</div><hr />';
}
}
else
$msg="File not uploaded successfully.";
}

database file

-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 14, 2016 at 09:19 PM
-- Server version: 5.5.25a
-- PHP Version: 5.4.4

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: `fac`
--

-- --------------------------------------------------------

--
-- Table structure for table `educational_details`
--

CREATE TABLE IF NOT EXISTS `educational_details` (
`username` varchar(20) NOT NULL,
`degree` varchar(8) NOT NULL,
`specialization` varchar(40) NOT NULL,
`year` varchar(4) NOT NULL,
`university` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `exp_details`
--

CREATE TABLE IF NOT EXISTS `exp_details` (
`username` varchar(20) NOT NULL,
`organization` varchar(100) NOT NULL,
`designation` varchar(30) NOT NULL,
`from_date` varchar(20) NOT NULL,
`to_date` varchar(20) NOT NULL,
`years_exp` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fac_achievements`
--

CREATE TABLE IF NOT EXISTS `fac_achievements` (
`username` varchar(20) NOT NULL,
`program` varchar(200) NOT NULL,
`venue` varchar(100) NOT NULL,
`date` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fac_details`
--

CREATE TABLE IF NOT EXISTS `fac_details` (
`name` varchar(40) NOT NULL,
`dept` varchar(10) NOT NULL,
`username` varchar(100) NOT NULL,
`pass` varchar(20) NOT NULL,
`emailid` varchar(40) NOT NULL,
`phone` varchar(10) NOT NULL,
`qual` varchar(30) NOT NULL,
`desg` varchar(30) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fac_publications`
--

CREATE TABLE IF NOT EXISTS `fac_publications` (
`username` varchar(20) NOT NULL,
`title` varchar(200) NOT NULL,
`journal` varchar(200) NOT NULL,
`nat` varchar(20) NOT NULL,
`date_of_pub` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `file`
--

CREATE TABLE IF NOT EXISTS `file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT 'Untitled.txt',
`mime` varchar(50) NOT NULL DEFAULT 'text/plain',
`size` bigint(20) unsigned NOT NULL DEFAULT '0',
`data` longblob NOT NULL,
`created` datetime NOT NULL,
`username` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `prof_body`
--

CREATE TABLE IF NOT EXISTS `prof_body` (
`username` varchar(20) NOT NULL,
`prof_body` varchar(100) NOT NULL,
`areas_int` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `student`
--

CREATE TABLE IF NOT EXISTS `student` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(20) NOT NULL,
`AGE` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

/*!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 */;

Navigate

You are required to create a small Web site. You have to choose the project idea

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

You are required to create a small Web site. You have to choose the project idea

Question

Explanation / Answer

Related Questions

Navigate