Skip to content

Instantly share code, notes, and snippets.

@samroar
Created July 19, 2014 12:36
Show Gist options
  • Select an option

  • Save samroar/561f51176237e9a63247 to your computer and use it in GitHub Desktop.

Select an option

Save samroar/561f51176237e9a63247 to your computer and use it in GitHub Desktop.
<?php
if(!empty($_POST)) {
$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
$query = $dbh->prepare('INSERT INTO comments (user, body) VALUES (?, ?)');
$query->execute(array($_POST['user'], $_POST['body']));
echo $_POST['user'];
echo $_POST['body'];
}
Select * from `post` inner join `comments` on `post`.`id` = `comments`.`post_id`
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment