add extjs 6.0.1 sources

[extjs.git] / extjs / examples / classic / simple-tasks / php / config / update.php

<?php\r
\r
include '../connection.php';\r
\r
try {\r
    $key = $_POST['key'];\r
    $value = $_POST['value'];\r
\r
    // first read the config table to see if a config already exists for this key\r
    $statement = $db->prepare("select value from config where key = '$key'");\r
    if(!$statement->execute()) {\r
        throw new Exception(implode(', ', $statement->errorInfo()));\r
    }\r
    if(!$statement->fetch(PDO::FETCH_COLUMN)) {\r
        $sql = "insert into config (key, value) values('$key', '$value')";\r
    } else {\r
        $sql = "update config set value = '$value' where key = '$key'";\r
    }\r
\r
    $statement = $db->prepare($sql);\r
    if(!$statement->execute()) {\r
        throw new Exception(implode(', ', $statement->errorInfo()));\r
    }\r
    $jsonResult = array('success' => true);\r
} catch(Exception $e) {\r
    $jsonResult = array(\r
        'success' => false,\r
        'message' => $e->getMessage()\r
    );\r
}\r
\r
echo json_encode($jsonResult);\r
\r
?>