* Date: 12-01-2016 * Time: 16:36 */ require "../../vendor/autoload.php"; $c = new \Slim\Container(); //Create Your container //Override the default Not Found Handler $c['notFoundHandler'] = function ($c) { return function ($request, $response) use($c) { return $c['response']->withStatus(404)->withHeader('Content-Type', 'text/json')->write('{"status":404}'); }; }; $app = new \Slim\App($c); $app->group('/discussion', function () { include "../../requirements/sqli.php"; $sqli = new sqli(array("127.0.0.1", "", "", "test")); $this->get('', function ($request, $response, $args) use($sqli) { echo json_encode($sqli->pull_multiple("select * from diskotioner")->data); }); $this->post('', function ($request, $response, $args) use($sqli) { if (isset($_POST['title'])) { $insert = $sqli->push("insert into diskotioner (title) VALUES (?)", "s", $_POST['title']); if ($insert->affected_rows == 1) { return $response->withStatus(201)->write($insert->insert_id); } return $response->withStatus(400); } return $response->withStatus(400); }); $this->delete('/{id:[0-9]+}', function ($request, $response, $args) use($sqli) { $sqli->push("delete FROM diskotion_kommentar where fk_kommentar = ?", "i", $args['id']);
<pre> <?php include "sqli.php"; // Connect to the database $sqli = new sqli(["127.0.0.1", "", "", "test"]); // Insert three rows to have some data to play with $insert1 = $sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test"); echo "Insert id:" . $insert1->id . "\n"; $insert2 = $sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test"); echo "Insert id:" . $insert2->id . "\n"; $insert3 = $sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test"); echo "Insert id:" . $insert3->id . "\n\n"; // Show the data form the array foreach ($sqli->pull_multiple("SELECT id, msg as message FROM test")->data as $row) { echo $row['id'] . " : " . $row['message'] . "\n"; } echo "\n"; // Show one row echo "First insert row: " . $sqli->pull_once("SELECT msg as message FROM test WHERE id=?", "i", $insert1->id)->data['message'] . "\n"; // Clere the table echo "Deleted rows:" . $sqli->push("DELETE FROM test")->affected_rows . "\n"; // Some rows left? echo "Rows left: " . $sqli->pull_multiple("SELECT * FROM test")->count; /* HERES MY OUTPUT Insert id:1 Insert id:2 Insert id:3 1 : Just a test 2 : Just a test 3 : Just a test