samroar’s gists

samroar / gist:5a286efe760ae1361ee0

Created June 27, 2014 09:18

	<?php
	$dsn= 'mysql:dbname=reddit;host:localhost';
	$user='root';
	$password='';
	$dbh = new PDO($dsn, $user, $password, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
	$sql="INSERT INTO posts (id, title) VALUES ('', ?)";
	$dbh->query("SELECT title FROM posts");
	?>

samroar / gist:044bc36bbbe17b58a481

Created July 1, 2014 12:08

	<?php
	if(empty($_post)) {}
	else {
	$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
	$form = $_post;
	$id = $form['id'];
	$title = $form['title'];
	$subreddit = $form['subreddit'];
	$sql="INSERT INTO posts (id, title, subreddit) VALUES ('', :title, :subreddit)";
	$query=$db->prepare($sql);

samroar / gist:283e21c706c5cf90721b

Created July 2, 2014 09:53

	<?php
	if(empty($_POST)) {}
	else {
	$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
	$title = $_POST['title'];
	$subreddit = $_POST['subreddit'];
	$sql='INSERT INTO posts (title, subreddit) VALUES (?, ?)';
	$query=$db->prepare($sql);
	}
	?>

samroar / gist:b388b6425f3a7a5b38e9

Created July 2, 2014 10:52

	<?php
	if(empty($_POST)) {}
	else {
	$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
	$title = $_POST['title'];
	$subreddit = $_POST['subreddit'];
	$sql='INSERT INTO posts (title, subreddit) VALUES (?, ?)';
	$query=$db->prepare($sql);
	$query->execute(array($title, $subreddit));
	}

samroar / gist:1397ea50074287e9a7a6

Created July 2, 2014 10:53

	<!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>
	<form action="http://localhost/reddit/redditform.php" method="POST">

samroar / gist:cc9516a3aa59c52ea481

Created July 2, 2014 11:11

	<?php
	if(!empty($_POST)) {
	$dbh = new PDO('mysql:dbname=reddit;host:localhost', 'root', '', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
	$title = $_POST['title'];
	$subreddit = $_POST['subreddit'];
	$sql='INSERT INTO posts (title, subreddit) VALUES (?, ?)';
	echo $title, $subreddit;
	$query=$db->prepare($sql);
	$query->execute(array($title, $subreddit));
	}

samroar / gist:d946b3d3fc0ecf434517

Created July 2, 2014 11:23

	<!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>
	<form action="redditform.php" method="POST">

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>

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 / 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'];
	}
	?>

Saurabh Arora samroar