PHP Blog\DB\query Examples

Example #1

File: index.php Project: biswajit077/PHP-Tutorial

<?php

require '../blog.php';
$data = array();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title = $_POST['title'];
    $body = $_POST['body'];
    if (empty($title) || empty($body)) {
        $data['status'] = "Please fill out both inputs.";
    } else {
        //then create a new row in the table
        Blog\DB\query("INSERT INTO posts(title, body) VALUES(:title, :body)", array('title' => $title, 'body' => $body), $conn);
        $data['status'] = "Row has Successfully been inserted.";
    }
}
view('admin/create', $data);

Example #2

File: index.php Project: brian1999lin/php

<?php

require "../db.php";
require "../blog.php";
$data = array();
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $title = $_POST["title"];
    $body = $_POST["body"];
    if (empty($title) || empty($body)) {
        $data["status"] = "Please fill out both inputs.";
    } else {
        // create a new row in the table
        Blog\DB\query("INSERT INTO posts(title, body) VALUES(:title, :body)", array("title" => $title, "body" => $body), $conn);
        $data["status"] = "Row has successfully been inserted.";
    }
}
view("admin/create", $data);