Exemplo n.º 1
0
//check inputs for all required fields
foreach ($requiredFields as $postKey) {
    if (!isset($inputs[$postKey]) || empty($inputs[$postKey])) {
        return errorHandler("missing {$postKey}", 503);
    }
}
//print debug statement
if ($SERVERDEBUG) {
    echo "\r\n inputs:";
    echo json_encode($inputs);
}
$prepstmt = setNames();
$prepstmt->execute();
//setup for query
if (!isset($inputs['html'])) {
    $stmt = updateBlogAdmin($DB, $inputs['name'], $inputs['desc'], $inputs['title'], $inputs['blogid']);
} else {
    $stmt = updateBlog($DB, $inputs['name'], $inputs['desc'], $inputs['title'], $inputs['html'], $inputs['feature'], $inputs['blogid']);
}
if (!$stmt) {
    return;
}
// createNewList already send error.
if (!$stmt->execute()) {
    return errorHandler("failed to create this list {$stmt->errno}: {$stmt->error}");
}
if ($stmt->affected_rows != 1) {
    return errorHandler("Updated {$stmt->affected_rows} rows", 503);
}
?>
  
Exemplo n.º 2
0
<?php 
require 'connectSql.php';
if (!isset($_POST["submit"])) {
    echo "Error!";
    exit(0);
}
if (empty($_POST["caption"])) {
    echo '请输入标题';
    exit(0);
}
if (empty($_POST["text"])) {
    echo '请输入正文';
    exit(0);
}
$caption = $_POST['caption'];
$artical = $_POST['text'];
$id = $_GET['id'];
$date = date("Y/m/d H:i:s", time());
$db = connect();
//$query = "UPDATE blogs SET caption = "."'".$caption."'" . ', artical = '."'".$artical."'".',
//		   date = '."'".$date."'"." WHERE blog_id = ".$id;
//$db->query($query);
if (updateBlog($db, $caption, $artical, $date, $id)) {
    echo "Update Succeed!<br>";
} else {
    echo "Update Failed!<br>";
}
$db->close();
?>
<a href="houtai.php" name="return">Return</a>
</html>
Exemplo n.º 3
0
//the verb used to run the script (e.g. GET, POST)
switch ($verb) {
    case "GET":
        //just gets the entire database
        $results = getAllBlogs("all");
        break;
    case "POST":
        //action is a variable (set by the function) sent along with any variables
        $action = $_REQUEST['action'];
        switch ($action) {
            case "ADD":
                addBlog($_REQUEST);
                $results = getAllBlogs("all");
                break;
            case "UPDATE":
                updateBlog($_REQUEST);
                $results = getAllBlogs("all");
                break;
            case "DELETE":
                deleteBlog($_REQUEST['code']);
                $results = getProductsDB("all");
                break;
            case "search":
                $results = getSearchDB($_REQUEST['search']);
                break;
            default:
                //if the specified action isn't recognised set meta details
                $results["meta"]["msg"] = "action not recognised, illegal action!";
                $results["meta"]["status"] = 400;
                $results["meta"]["ok"] = false;
        }