function toggleMode()
{
$conn = getDbConn();
$sql = "SELECT * FROM cloud_gallery_config WHERE config_key='IS_READ_ONLY_MODE'";
$result = $conn->query($sql);
$rows = $result->num_rows;
if ($rows > 0) {
if (isReadOnlyMode()) {
$sql = "UPDATE cloud_gallery_config SET config_value='0' WHERE config_key='IS_READ_ONLY_MODE'";
} else {
$sql = "UPDATE cloud_gallery_config SET config_value='1' WHERE config_key='IS_READ_ONLY_MODE'";
}
} else {
$sql = "INSERT into cloud_gallery_config (config_key, config_value) VALUES ('IS_READ_ONLY_MODE', '1')";
}
$conn->query($sql);
$conn->close();
}
<?php
require 'vendor/autoload.php';
require 'resources/library/db.php';
define('DEBUG_ON', TRUE);
if (DEBUG_ON) {
error_reporting(-1);
}
$now = date("Ymd_His");
syslog(LOG_INFO, "phpMyS3Backup - Starting run ID {$now}");
// ********************************
// Get list of databases
// ********************************
$alldb = array();
$GLOBALS['con'] = getDbConn();
$res = mysqli_query($GLOBALS['con'], "SHOW DATABASES;");
while ($row = mysqli_fetch_array($res)) {
if ($row['Database'] != "information_schema") {
$alldb[] = $row['Database'];
deb("Database found: {$row['Database']}");
}
}
// ********************************
// MySQLDump each database
// ********************************
system("mkdir /tmp/{$now}/");
foreach ($alldb as $db) {
$cmd = "mysqldump {$db} -h " . getDbHost() . " -u controller -pilovebunnies > /tmp/{$now}/{$db}.sql";
deb("Doing: {$cmd}");
system($cmd);
}
<?php
include 'lib/config.php';
require_once 'lib/fbconfig.php';
include 'iHackyFunctions.php';
$userId = $_POST['id'];
$classId = $_POST['class'];
$classRank = $_POST['rank'];
$conn = getDbConn();
$queryChangeRank = "UPDATE CLASS_USERS SET class_rank = {$classRank} \r\n WHERE CLASS_USERS.facebook_id = {$userId} AND CLASS_USERS.class_id = {$classId}";
mysql_query($queryChangeRank);
closeDb($conn);
echo "<a href=\"profile.php\">Return to your Profile</a>";
<?php
session_start();
include 'header.php';
echo "</p></p>";
echo "<h4>All Items </h4>";
$link = getDbConn();
$link->real_query("SELECT * FROM items");
$res = $link->use_result();
echo "Result set order...\n";
while ($row = $res->fetch_assoc()) {
echo $row['id'] . " " . $row['email'] . " " . $row['phone'];
}
$link->close();
include 'footer.php';
