Skip to content

Instantly share code, notes, and snippets.

View Chrismichael's full-sized avatar

Chris Davidson Chrismichael

View GitHub Profile
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least #one
# space.
#
<!<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
</body>
<?php
session_start();
require('../thumbs.php');
define("DB_SERVER", "localhost");
define("DB_USER", "root");
function getimageinfo()
{
include("includes/config.php");
$images_path = ($_GET['images_path']);
$pdo = connect();
$stmt = "SELECT i.submission_date, i.category, i.memberID, m.username, m.memberID FROM images i JOIN members m ON i.memberID = m.memberID WHERE i.images_path = '" . $images_path . "'";
$query = $pdo->prepare($stmt);
$pdo = connect();
$search = $_POST['search-bar'];
$sql = "SELECT * FROM images WHERE tags LIKE('%$search%') OR memberID LIKE '%$search%' OR category LIKE '%$search%'";
$query = $pdo->prepare($sql);
$query->execute();
$number_of_rows = $query->fetchColumn();
$list = $query->fetchAll();
if ($number_of_rows == 0) {
echo '<h1>No results found for ';
/*TICKER*/
body > .content {
margin-top: 50px; /* Make space for the ticker */
}
.titlebox .md h4 {
position: absolute;
top: 192px; /* How far from the top of the page the ticker will be positioned */
left: 8px;
right: 330px;
background-color:#fff;