Differences

This shows you the differences between two versions of the page.

--- snippets:php [2025-06-26 12:38] – Seite inkl. erstem Snippet „Mail-Versand“ erstellt malte70
+++ snippets:php [2025-11-10 15:56] (current) – [SQLite3] Quellcode-Kommentare malte70
@@ Line 2: / Line 2: @@
 [[:snippets:start|← Zurück zu :snippets:start]]
+==== Gists ====
+Zusätzlich zu den Snippets hier im Wiki habe ich folgende Gists auf GitHub veröffentlicht:
+  * [[https://gist.github.com/malte70/7673316660a8fa9b574a86196e9543bb|Markdown-Vorschau via PHP-Skript]] \\ Rendert eine Markdown-Datei in zu HTML, inkl. Stylesheet. Wenn an die URL der Markdown-Datei ''?preview'' angehängt wird, leitet eine //RewriteRule// automatisch zur Vorschau-Ansicht um.
 ===== Mail-Versand =====
@@ Line 29: / Line 35: @@
 echo "\$mail_sent = " . ($mail_sent ? "True" : "False") . "\n;"
+</file>
+===== SQLite3 =====
+  * [[https://www.php.net/manual/en/class.sqlite3.php|PHP: SQLite3 - Manual]]
+  * [[https://www.php.net/manual/en/class.sqlite3stmt.php|PHP: SQLite3Stmt - Manual]]
+  * [[https://www.php.net/manual/en/class.sqlite3result.php|PHP: SQLite3Result - Manual]]
+<file php sqlite3.php>
+<?php
+// Open database and create it if necessary
+$db = new SQLite3("dbfile.sqlite3");
+// Initialize the database with a table and some data
+$db->exec('CREATE TABLE users(id INT NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT DEFAULT NULL, password TEXT NOT NULL');
+$db->exec('INSERT INTO users (name, email, password) VALUES ("john.doe", "john.doe@example.com", "1234"));');
+$db->exec('INSERT INTO users (name, email, password) VALUES ("jane.doe", "jane.doe@example.com", "asdf"));');
+// Create a SQLite3Stmt, bind some values and execute the SQL command safely
+$stmt = $db->prepare('SELECT * FROM users WHERE id=:id AND name=:name');
+$stmt->bindValue(':id', 1, SQLITE3_INTEGER);
+$stmt->bindValue(':name', "john.doe", SQLITE3_TEXT);
+// Execute statement and get first row as an associative Array
+$res = $stmt->execute();
+var_dump($res->fetchArray());
 </file>