function showData()
{
$conn = makeConnection();
$sql = "SELECT * FROM donations";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
echo "Thank you " . $row["sponsor"] . " for your donation of " . $row["amount"] . "<br>";
}
} else {
echo "0 results";
}
closeConnection($conn);
}
function executeQuery($qry)
{
//session_start();
$conn = $_SESSION['connection'];
if ($_SESSION['connAlive'] != "alive") {
$_SESSION['connection'] = makeConnection();
} else {
$conn = $_SESSION['connection'];
$_SESSION['connection'] = makeConnection();
}
//$conn = makeConnection();
$result = mysql_query($qry);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ';
die($message);
}
return $result;
}
<?php
include 'includes/_global.php';
$dbc = makeConnection('servicing');
if (isset($_POST['deleteSite']) && isset($_POST['site']) && !empty($_POST['site'])) {
//Check site has no items
}
if (isset($_POST['addSite']) && isset($_POST['name']) && !empty($_POST['name'])) {
//Check name unique
}
$statement = $dbc->prepare('SELECT site_id, site_name FROM sites');
$result = $statement->execute();
$sites = $statement->fetchAll();
$tpl = new Smarty();
$tpl->template_dir = getcwd() . '/templates/';
$tpl->compile_dir = getcwd() . '/templates/cache/';
$tpl->assign('title', 'Service Sites');
$tpl->assign('sites', $sites);
$tpl->display('servicing/sites.tpl');
<?php
include 'connect.php';
include 'GameDataMiner.php';
# Global parameters
date_default_timezone_set('UTC');
$myTeam = "Warriors";
$link = mysqli_connect("localhost", "ostaton", "Takarajima1", "DB_SportAlert");
# Global email settings
$to = "";
$subject = 'Sport Alert';
$message = "";
makeConnection();
// teamNameInTable($myTeam);
// $array = getAllGamesForTeam($myTeam);
// $array = gamesToday($array);
// print("Today there is a ".$array[0]["TeamName"]." game in ".$array[0]["Location"]."!<br/>");
// print("Be sure to tune in for the game at ".$array[0]["Time"].".<br/>");
# TODO: GET USER PREFERENCES
# For each user
# Check user preference
# Check team data
# Respond if appropriate
$queryUsers = "SELECT * FROM `Users`";
# For each User:
if ($resultUsers = mysqli_query($link, $queryUsers)) {
while ($userData = mysqli_fetch_array($resultUsers)) {
# Update email info
$to = $userData["Email"];
$message = "Hello " . $userData["UserName"] . ",\n";
# For each setting ID:
<?php
include "resources/functions.php";
if (isset($_COOKIE['usedID'])) {
$idPost = $_GET['id'];
$usedIdEncode = $_COOKIE['usedID'];
//get userID from cookie
$usedIdDencode = base64_decode($usedIdEncode);
$con = makeConnection();
$sqlCheakIfPublish = mysql_fetch_array(mysql_query("SELECT*FROM postTbale WHERE id=" . $idPost));
$user = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id`='{$usedIdDencode}'"));
if ($sqlCheakIfPublish['isPublish'] == '0' and $sqlCheakIfPublish['username'] == $user['username'] or $usedIdDencode == '1') {
$sql = "DELETE FROM postTbale WHERE id=" . $idPost;
mysql_query($sql, $con);
if (!$con) {
die("error:" . mysql_error());
}
mysql_close($con);
header("Location: postMaganer.php");
die;
} else {
mysql_close($con);
header("Location: error.php");
die;
}
} else {
header("Location: error.php");
die;
}
function getPostByIDShow()
{
$flag = false;
$idPost = $_GET['id'];
$con = makeConnection();
$sqlCheakIfPublish = mysql_fetch_array(mysql_query("SELECT*FROM postTbale WHERE id=" . $idPost));
if ($sqlCheakIfPublish['isPublish'] == '0') {
$usedIdEncode = $_COOKIE['usedID'];
//get userID from cookie
$usedIdDencode = base64_decode($usedIdEncode);
$user = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id`='{$usedIdDencode}'"));
if ($sqlCheakIfPublish['username'] == $user['username'] or $usedIdDencode == '1') {
//is it the same username
$flag = true;
}
} else {
$flag = true;
}
if ($flag) {
echo "<div class='post-heading' >";
echo "<h1>" . $slCheakIfPublish['title'] . "</h1>";
echo "</div>";
echo "Written by: " . $sqlCheakIfPublish['username'] . "<br><br>";
echo "<p>" . $sqlCheakIfPublish['content'] . "</p>";
echo "<br><br>";
mysql_close($con);
} else {
mysql_close($con);
header("Location: error.php");
die;
}
}
