I am using a switch statement to delete/update records and sort the table. I wish to set up the application to save the sort even as a different switch option is selected. Right now I can sort the data, but when I click to delete a data element the data set reverts to the original unsorted form. I have attempted to save the state with $state and if statements in the other switches. If I remove the if statement and leave a function it works fine, however the if statements are needed to select the specific last state the system was in. What is incorrect here?
$TPL[‘displayTable’] = true;
$TPL[‘updateTable’] = false;
$TPL["fetchedrecord"] = [];
$state = 0;
switch ($_REQUEST["act"]) {
case "updatestart":
$recordid = $_REQUEST["id"];
$TPL["fetchedrecord"] = fetchRecord($conn, $recordid);
$TPL[‘displayTable’] = false;
$TPL[‘updateTable’] = true;
break;
// updating a record from the database
case "update":
updateRecord($conn,
$_REQUEST["id"],
$_REQUEST["fnameUP"],
$_REQUEST["lnameUP"],
$_REQUEST["phoneUP"],
$_REQUEST["emailUP"],
$_REQUEST["locationUP"],
$_REQUEST["mcUP"],
$_REQUEST["posUP"],
$_REQUEST["deptUP"]);
$TPL[‘displayTable’] = true;
$TPL[‘updateTable’] = false;
if($state==1){
$TPL["phonebook"] = sortDataLName($conn);
}
if($state==2){
$TPL["phonebook"] = sortDataPosition($conn);
}
if($state==3){
$TPL["phonebook"] = sortDataDepartment($conn);
}
else{
$TPL["phonebook"] = getAllData($conn);
}
break;
// deleting a record from the database
case "delete":
$recordid = $_REQUEST["id"];
deleteRecord($conn, $recordid);
if($state==1){
$TPL["phonebook"] = sortDataLName($conn);
}
if($state==2){
$TPL["phonebook"] = sortDataPosition($conn);
}
if($state==3){
$TPL["phonebook"] = sortDataDepartment($conn);
}
else{
$TPL["phonebook"] = getAllData($conn);
}
break;
// sorting records by last nae
case "sortname":
$state = 1; //state is sort name
$TPL["phonebook"] = sortDataLName($conn);
break;
case "sortposition":
$state = 2; //state is sort position
$TPL["phonebook"] = sortDataPosition($conn);
break;
case "sortdepartment":
$state = 3; //state is sort department
$TPL["phonebook"] = sortDataDepartment($conn);
break;
// insert a new record into the database
case "insert":
insertRecord($conn,
$_REQUEST["fname"],
$_REQUEST["lname"],
$_REQUEST["phone"],
$_REQUEST["email"],
$_REQUEST["location"],
$_REQUEST["mc"],
$_REQUEST["pos"],
$_REQUEST["dept"]);
if($state==1){
$TPL["phonebook"] = sortDataLName($conn);
}
if($state==2){
$TPL["phonebook"] = sortDataPosition($conn);
}
if($state==3){
$TPL["phonebook"] = sortDataDepartment($conn);
}
else{
$TPL["phonebook"] = getAllData($conn);
}
break;
default:
$TPL["phonebook"] = getAllData($conn);
}
Aucun commentaire:
Enregistrer un commentaire