Question on Web Technology : please I need correct answer 100% if you do not sur

ID: 3690664 • Letter: Q

Question

Question on Web Technology :

please I need correct answer 100% if you do not sure please do not answer? :

You are required to create a small Web site. You have to choose the project idea and work in it as individual The website must cover all aspects in the course (HTML, CSS, JS and PHP) 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 1. Desciption.docx: a small report that explains all the functionalities of the website (With screenshots) 2. Project.zip: contains all the files of the project (html, css, js, php, sql.,...). Marking Schema Web elements (list, table, form ...) Navigation (Links are clear and located in the same 1 area on each page. All links are functional Design (using CSS) Website clearly demonstrates design principles: with consistent alignment roximity, repetition, and contrast Client side dynamic behavior using JavaScript (forms1 and event handler, ...) HTML 2 CSS JavaScript Dynamic Web pages (PHP Communication with DB(select+Update) Total PHP +DB 2 2 9

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

Question on Poisson processes vehicles cross highway with rate of lamda = 5 per

Question on \"Plasmid conformations and mobility on agarose gel vs. oxidative st

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

Question on Web Technology : please I need correct answer 100% if you do not sur

Question

Explanation / Answer

Related Questions

Navigate