Skip to content

Instantly share code, notes, and snippets.

View samroar's full-sized avatar

Saurabh Arora samroar

2 followers · 0 following
View GitHub Profile
@samroar
samroar / gist:064da086d19278b6acac
Created July 20, 2014 16:04
<?php
if(!empty($_POST)) {
$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
$rows = $dbh->query("SELECT * from posts where id = ?");
$query = $dbh->prepare('INSERT INTO comments (post, user, body) VALUES (?, ?, ?)');
$query->execute(array($_POST['post'], '', $_POST['body']));
}
?>
<!DOCTYPE HTML>
<html>
@samroar
samroar / gist:f74c28878f6a7e1da0c3
Created July 19, 2014 21:04
<?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 (post, user, body) VALUES (?, ?, ?)');
$query->execute(array($_POST['post'], '', $_POST['body']));
}
?>
<!DOCTYPE HTML>
<html>
<head>
@samroar
samroar / gist:d19d0583777b3674535a
Created July 19, 2014 20:40
<!doctype HTML>
<html>
<head>
<title>reddit: the front page of the internet</title>
<link href="reddit.css" rel="stylesheet"/>
<script src ="reddit.js" type="text/javascript"></script>
</head>
<body>
<?php
$dbh = new PDO('mysql:host=localhost;dbname=reddit','root',"");
@samroar
samroar / gist:46a483117987275f3006
Created July 19, 2014 20:23
<?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 posts (title, subreddit, user, url) VALUES (?, ?, ?, ?)');
$query->execute(array($_POST['title'], $_POST['subreddit'], $_POST['user'], $_POST['url']));
echo $_POST['title'];
echo $_POST['subreddit'];
echo $_POST['user'];
echo $_POST['url'];
}
@samroar
samroar / gist:b571e09064168fc2af97
Created July 19, 2014 20:17
<?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 posts (title, subreddit, user, url) VALUES (?, ?, ?, ?)');
$query->execute(array($_POST['title'], $_POST['subreddit'], $_POST['user'], $_POST['url']));
echo $_POST['title'];
echo $_POST['subreddit'];
echo $_POST['user'];
echo $_POST['url'];
}
@samroar
samroar / gist:4b210eec7f248d6539cc
Created July 19, 2014 19:42
<!doctype HTML>
<html>
<head>
<title>reddit: the front page of the internet</title>
<link href="reddit.css" rel="stylesheet"/>
<script src ="reddit.js" type="text/javascript"></script>
</head>
<body>
<?php
$dbh = new PDO('mysql:host=localhost;dbname=reddit','root',"");
@samroar
samroar / gist:a312ea12f1d03b5b5a79
Created July 19, 2014 19:36
<!doctype HTML>
<html>
<head>
<title>reddit: the front page of the internet</title>
<link href="reddit.css" rel="stylesheet"/>
<script src ="reddit.js" type="text/javascript"></script>
</head>
<body>
<?php
$dbh = new PDO('mysql:host=localhost;dbname=reddit','root',"");
@samroar
samroar / gist:184147a35256a51685a9
Created July 19, 2014 17:35
<!doctype HTML>
<html>
<head>
<title>reddit: the front page of the internet</title>
<link href="reddit.css" rel="stylesheet"/>
<script src ="reddit.js" type="text/javascript"></script>
</head>
<body>
<?php
$dbh = new PDO('mysql:host=localhost;dbname=reddit','root',"");
@samroar
samroar / gist:3d3d82914c2f946b206b
Created July 19, 2014 17:31
<!doctype HTML>
<html>
<head>
<title>reddit: the front page of the internet</title>
<link href="reddit.css" rel="stylesheet"/>
<script src ="reddit.js" type="text/javascript"></script>
</head>
<body>
<?php
$dbh = new PDO('mysql:host=localhost;dbname=reddit','root',"");
@samroar
samroar / gist:67bc5bc8858b21833b95
Created July 19, 2014 16:47
<!doctype HTML>
<html>
<head>
<title>reddit: the front page of the internet</title>
<link href="reddit.css" rel="stylesheet"/>
<script src ="reddit.js" type="text/javascript"></script>
</head>
<body>
<?php
$dbh = new PDO('mysql:host=localhost;dbname=reddit','root',"");