PHP getAllFrom Examples

Example #1

File: getVideos.php Project: pennmanor/1-1-Stream

function getDBFiles()
{
    $dbFiles = array();
    openConnection();
    $result = getAllFrom("episode");
    closeConnection();
    while ($episode = mysqli_fetch_assoc($result)) {
        $dbFiles[] = $episode['filename'];
    }
    return $dbFiles;
}

Example #2

File: getTags.php Project: pennmanor/1-1-Stream

<?php

require dirname(__FILE__) . '/mysql-connect.php';
openConnection();
if (isset($_GET['q'])) {
    $result = getLikeValueFrom('name', $_GET['q'], 'tag');
} else {
    $result = getAllFrom('tag');
}
closeConnection();
$tags = array();
while ($row = mysqli_fetch_assoc($result)) {
    $row['id'] = intval($row['id']);
    $tags[] = $row;
}
echo json_encode($tags);