dimanche 18 février 2018

PHP switch statement not saving states when using $variable and if statements within switch options

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