Interview Questions & Answers

Model-View-Controller is the concept introduced by Smalltalk's inventors to encapsulating some data together with its processing (the model) and isolate it from the manipulation (the controller) and presentation (the view) part that has to be done on a UserInterface.
A model :- is an object representing data e.g. a database table.
A view :- is some form of visualization of the state of the model.
A controller :- offers facilities to change the state of the model.
<?php
//////////////My Property Class////////////
// it contain getter setter function
abstract class EmployeeProperty
{
private $deptid;
public function getDeptId() //Getter
{
return $this->deptid;
}
public function setDeptId($id) //setter
{
$this->deptid=$id;
}
}
//////////My Interface /////////
interface iEmployee
{
function getEmployeeName(EmployeeProperty $objEmployeeProperty);
}
/////////My Data access layer//////
// it fetch data from database server
//it model part of mvc
class DALEmployee implements iEmployee
{
public function getEmployeeName(EmployeeProperty $objEmployeeProperty)
{
$con = mysql_connect("localhost","root","root"); //open connection
if (!$con)
{
die('Could not connect to mysql ' . mysql_error()); // error message
}
else
{
mysql_select_db("test",$con); // select database
$result= mysql_query("select emp_name from employee where deptid=".$objEmployeeProperty-> getDeptId()); // fire query
mysql_close($con); // close connection
}
return $result;
}
}
///////////My business logic layer////////
// it is controller part of mvc
class BALEmployee extends EmployeeProperty
{
public function getEmployeeName(EmployeeProperty $objEmployeeProperty)
{
$objiEmployee=new DALEmployee();
return $objiEmployee->getEmployeeName($objEmployeeProperty);
}
}
?>
/////////////////////My View Part///////////////////////////////////////
New Document
<?php
include("Employee.php");
///////////////My View Part//////////////////
$objBALEmployee=new BALEmployee(); //Create object of business logic layer
$objBALEmployee->setDeptId(1); // Set Property
$result= $objBALEmployee->getEmployeeName($objBALEmployee); // excess bll function
while($row = mysql_fetch_row($result)) // fetch result
{
echo $row[0].""; // display result
}
?>