Learning PHP and MySQL MVC Framework: 8.How to delete data in the database?

1. In jobseeker_list_view.php, type the following:

<html>

<head>

<title>Jobseeker-List | BizjobFinder.com</title>

</head>

<body>

<tr>

<th>Lastname</th>

<th>Firstname</th>

<th>Address</th>

<th>Action</th>

</tr>

<?php

require_once $_SERVER['DOCUMENT_ROOT'].'/bizjobfinder.com/application/models/jobseeker_model.php';

$obj=new jobseeker_model();

$jobseekers=$obj->get_all_jobseekers();

$ctr=0;

foreach($jobseekers as $jobseeker){?>

<tr>

<td>

<a href="jobseekers.php?model=jobseeker-delete&id=<?php echo $jobseeker['id']?>">Delete</a>

</td>

</tr>

<?php }?>

</table>

</html>

2. In jobseekers.php, type the following:

<?php

session_start();

*Filename:jobseekers.php

*projectname:bizjobfinder.com

*Date created:November 18,2011

*Created by:Mario T. Silvano

<?php

class jobseekers{

public function jobseeker_list(){

return 'views/jobseeker_list_view';

}

public function delete(){

require_once($_SERVER['DOCUMENT_ROOT'].'/bizjobfinder.com/application/models/jobseeker_model.php');

$jobseeker = new jobseeker_model();

return $jobseeker->delete($_GET['id']);

}

$obj = new jobseekers();

$view = '';

$model = '';

if(!empty($_GET['view'])){

$view = $_GET['view'];

switch($view){

case 'jobseeker-list':

$page=$obj->jobseeker_list();

break;

}

include $_SERVER['DOCUMENT_ROOT'].'/bizjobfinder.com/application/'.$page.'.php';

}

else{

if(!empty($_GET['model'])){

$model = $_GET['model'];

switch($model){

case 'jobseeker-delete':

$result=$obj->delete();

header('Location:jobseekers.php?view=jobseeker-list');

break;

}

*End of file jobseekers.php

*Location:/application/controllers/jobseekers.php

3. In jobseeker_model.php, type the following:

<?php

define("DB_SERVER","localhost");

define("DB_USER","root");

define("DB_PASS","");

define("DB_NAME","bizjobfinder_db");

class jobseeker_model{

public $id;

public $firstname;

public $mi;

public $lastname;

public $street_barangay;

public $town_city;

public $province;

public function delete($id){

$sql="DELETE FROM jobseekers WHERE id=$id";

$db=$this->_open_connection();

$result=mysql_query($sql,$db);

return $this->_confirm_query($result);

}

public function get_all_jobseekers(){

$sql="SELECT * FROM jobseekers

ORDER BY lastname";

$db=$this->_open_connection();

$result=mysql_query($sql,$db);

$jobseekers=array();

if($this->_confirm_query($result)){

while($r=mysql_fetch_array($result)){

$row=array();

foreach($r as $k=>$v){

$row[$k]=$v;

}

array_push($jobseekers,$row);

unset($row);

}

return $jobseekers;

}

private function _open_connection(){

$con = mysql_connect(DB_SERVER,DB_USER,DB_PASS);

if(!$con)die('Error Connection:'.mysql_error());

$db_select = mysql_select_db(DB_NAME,$con);

if(!$db_select)die('Error Selection:'.mysql_error());

return $con;

}

private function _confirm_query($result){

if(!$result)die('Error Query:'.mysql_error());

return $result;

}

4. In index.php, type the following:

<html>

<head>

<title>Home | BizjobFinder</title>

</head>

<body>

<a href='application/controllers/jobseekers.php?view=jobseeker-list'>Job Seeker List</a><br>

</body>

</html>

5. On your browser, type the following:

http://localhost/bizjobfinder.com/

8.How to delete data in the database?

4 comments: