<?php

$host = "localhost";
$user = 'root';
$password = '12345';
$dbname = 'pdoposts';

=============================
 Set DSN (data source name)
=============================

$dsn ='mysql:host='.$host. ';dbname=' . $dbname;

=========================
Create a PDO instance
=========================
$pdo = new PDO($dsn, $user, $password);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ); //Fetch as object
=============
#PDO Query
=============
$stmt = $pdo->query("SELECT * FROM table");

while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
	echo $row['title']

}
===========================================
PREPARED STATEMENTS (prepare & execute)
===========================================

$sql = "SELECT * FROM posts WHERE author = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$author]);
$posts = $stmt->fetchAll(); // More than one
foreach($posts as $post){
	echo $post->title;
}

===========================================
          INSERT Statements
===========================================
$title = 'TheHobbit';
$body = "This book is cool";
$author = "JK Tolking";

$sql = "INSERT INTO posts(title, body, author) VALUES (:title, :body, :author)";
$stmt = $pdo->prepare($sql);
$stmt->execute(['title'=>$title, 'body'=>$body, 'author':$author]);
echo "Post added"