Skip to content

Instantly share code, notes, and snippets.

@anonoz

anonoz/mysqli_db_conn.php

Last active August 29, 2015 14:24
Show Gist options
  • Save anonoz/9a1efe41c4fae28ff3e2 to your computer and use it in GitHub Desktop.
Save anonoz/9a1efe41c4fae28ff3e2 to your computer and use it in GitHub Desktop.
Download ZIP
PDO vs MySQLi
Raw
mysqli_db_conn.php
<?php
// Our database config
$db_host = "localhost";
$db_user = "yolol";
$db_pass = "yolol_pass";
$db_name = "yolol";
// Connect to our MySQL database
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
Raw
mysqli_index.php
<?php
include "_db_conn.php";
// If there is new tweet submission, persist it.
if (isset($_POST["username"]) && isset($_POST["tweet"]))
{
$stmt = mysqli_stmt_init($conn);
$insert_sql = "INSERT INTO tweets (username, tweet) VALUES (?, ?)";
if (mysqli_stmt_prepare($stmt, $insert_sql))
{
mysqli_stmt_bind_param($stmt, "ss", $_POST["username"], $_POST["tweet"]);
mysqli_execute($stmt);
}
}
// Fetch all the tweets, in descending order so newest tweets are shown first.
$sql = "SELECT * FROM tweets ORDER BY id DESC";
$result = mysqli_query($conn, $sql);
?><!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Yolol</title>
</head>
<body>
<h1>YOLOL app</h1>
<table>
<thead>
<th>Username</th>
<th>Tweet</th>
</thead>
<tbody>
<?php while ($row = mysqli_fetch_assoc($result)): ?>
<tr>
<td><?= $row["username"] ?></td>
<td><?= $row["tweet"] ?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
<!-- Form to create new tweet -->
<h2>Post a tweet!</h2>
<form method="POST">
<input type="text" placeholder="Username" name="username">
<input type="text" placeholder="Your tweet content goes here" name="tweet">
<input type="submit" value="Tweet!">
</form>
</body>
</html>
Raw
pdo_db_conn.php
<?php
// Our database config
$db_host = "localhost";
$db_user = "yolol";
$db_pass = "yolol_pass";
$db_name = "yolol";
// Connect to our MySQL database
try {
$DBH = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_pass);
}
catch (PDOException $e) {
echo $e->getMessage();
}
Raw
pdo_index.php
<?php
include "_db_conn.php";
// If there is new tweet submission, persist it.
if (isset($_POST["username"]) && isset($_POST["tweet"]))
{
$insert_data = array($_POST["username"], $_POST["tweet"]);
$insert_sth = $DBH->prepare("INSERT INTO tweets (username, tweet) VALUES (?, ?)");
$insert_sth->execute($insert_data);
}
// Fetch all the tweets, in descending order so newest tweets are shown first.
$INDEX_STH = $DBH->query("SELECT * FROM tweets ORDER BY id DESC");
?><!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Yolol</title>
</head>
<body>
<h1>YOLOL app</h1>
<table>
<thead>
<th>Username</th>
<th>Tweet</th>
</thead>
<tbody>
<?php while ($row = $INDEX_STH->fetch()): ?>
<tr>
<td><?= $row["username"] ?></td>
<td><?= $row["tweet"] ?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
<!-- Form to create new tweet -->
<h2>Post a tweet!</h2>
<form method="POST">
<input type="text" placeholder="Username" name="username">
<input type="text" placeholder="Your tweet content goes here" name="tweet">
<input type="submit" value="Tweet!">
</form>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment