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:3f4647890ece9dcd4414
Created July 19, 2014 14:41
<!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>
<?php
if(!empty($_POST)) {
$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
@samroar
samroar / gist:f349feb89861106ec6f0
Created July 19, 2014 14:14
<!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>
<form action="comments.php" method="POST">
<label for="id"><input type="number" name="id" />id</label>
@samroar
samroar / gist:2f960d937690beb79c10
Created July 19, 2014 14:09
<!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>
<form action="comments.php" method="POST">
<label for="id" input type="number">id</label>
@samroar
samroar / gist:c8e6ba1645ac088727f5
Created July 19, 2014 14:03
<?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']));
echo $_POST['post'];
echo $_POST['body'];
}
?>
@samroar
samroar / gist:6c7e4780613faa7a8cc9
Created July 19, 2014 13:57
html
<!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>
@samroar
samroar / gist:1ac927fd73977786e85e
Created July 19, 2014 13:29
html
<!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>
@samroar
samroar / gist:acf2d532f590102e21ce
Created July 19, 2014 13:16
html
<!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>
@samroar
samroar / gist:b81da8a30532d2c86c3f
Created July 19, 2014 13:14
<?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['user'], $_POST['body'], $_POST['post']));
echo $_POST['post'];
echo $_POST['user'];
echo $_POST['body'];
}
?>
@samroar
samroar / gist:561f51176237e9a63247
Created July 19, 2014 12:36
<?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`
?>
@samroar
samroar / gist:66dd5600e47f5a6401aa
Created July 17, 2014 16:22
html
<!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>