<?php $host = 'localhost'; $db = 'demos'; $user = 'root'; $password = ''; $dsn = "mysql:host=$host;dbname=$db;charset=UTF8"; try { $conn = new PDO($dsn, $user, $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); } catch (PDOException $e) { echo $e->getMessage(); } $data = [ 'title' => 'test title', 'content' => 'test content' ]; $sql = 'INSERT INTO posts(title, content) VALUES(:title, :content)'; $statement = $conn->prepare($sql); $statement->execute($data); echo "Post saved successfully!";
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter