function addtoServer($time, $date, $location) { $status = isPublic(); $user = $_SESSION['user']; mysql_query("INSERT INTO list(time_posted, date_posted, file_location, user, status) VALUES ('{$time}', '{$date}', '{$location}', '{$user}', '{$status}')") or die("Could not insert image into data base" . mysql_error()); }
$dbname = "dev"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $error = false; $error_message = ""; $data = json_decode(file_get_contents('php://input'), true); $user = $data["username"]; $channelname = $data["channelname"]; $channelowner = $data["channelowner"]; if (isAdmin($conn, $user) || isOwner($conn, $user, $channelname, $channelowner) || isModerator($conn, $user, $channelname, $channelowner)) { $moderators = getModerators($conn, $channelname, $channelowner); $viewers = getViewers($conn, $channelname, $channelowner); $banned = getBanned($conn, $channelname, $channelowner); $public = isPublic($conn, $channelname, $channelowner); } else { $error = true; $error_message = "You do not have permission access settings for this channel"; } $conn->close(); $response = array('error' => $error, 'error_message' => $error_message, 'moderators' => $moderators, 'viewers' => $viewers, 'banned' => $banned, 'public' => $public); echo json_encode($response); function getModerators($conn, $channelname, $channelowner) { $stmt = $conn->prepare("SELECT cm_username FROM channelmods WHERE cm_chname=? AND cm_chowner=?"); $stmt->bind_param("ss", $channelname, $channelowner); $stmt->execute(); $stmt->bind_result($username); $users = []; while ($stmt->fetch()) {