PHP-databaskonstruktion

Log | Files | Refs

delete.php (1120B)

      1 <?php
      2     require 'utils/imports.php';
      3     $db = dbconnection::getInstance();
      4     $pdo = $db->getPdo();
      5 
      6     if (isset($_GET['table']) && !empty($_GET['table'])) {
      7         $table = $_GET['table'];
      8         $conditions = [];
      9 
     10         foreach ($_GET as $key => $value) {
     11             if ($key !== 'table' && $key !== 'redir') {
     12                 if (isset($value)) {
     13                     $value = urldecode($value);
     14                     $conditions[] = "$key = '$value'";
     15                 }
     16                 
     17             }
     18         }
     19 
     20         if (count($conditions) > 0) {
     21             $whereClause = implode(' AND ', $conditions);
     22             $sql = "DELETE FROM $table WHERE $whereClause";
     23 
     24             $pdo->prepare($sql)->execute();
     25 
     26             if (isset($_SERVER['HTTP_REFERER'])) {
     27                 header('Location: ' . $_SERVER['HTTP_REFERER']);
     28                 exit;
     29             } else {
     30                 echo "Unable to redirect to the previous page.";
     31             }
     32 
     33         } else {
     34             echo "No keys provided to identify a unique row.";
     35         }
     36     } else {
     37         echo "Table parameter is missing.";
     38     }
     39 ?>