PHP LibDatabase Beispiele

Beispiel #1

Datei: database.php Projekt: englund/eitf05

 /**
  * Create and return the connection to the database.
  *
  * @return PDO object
  */
 private static function get_connection()
 {
     if (is_null(self::$db)) {
         self::$db = new \PDO(sprintf('%s:host=%s;dbname=%s;charset=utf8', DB_TYPE, DB_HOST, DB_NAME), DB_USER, DB_PASS);
     }
     return self::$db;
 }

Beispiel #2

Datei: Database.php Projekt: kiou/DevKit2016

 public static function getInstance()
 {
     if (is_null(self::$instance)) {
         self::$instance = new Database();
     }
     return self::$instance;
 }

Beispiel #3

Datei: Database.php Projekt: Opportunity-Hack-2015-Arizona/Team13

 public static function getInstance()
 {
     if (!isset(self::$instance)) {
         $object = __CLASS__;
         self::$instance = new $object();
     }
     return self::$instance;
 }

Beispiel #4

Datei: database.php Projekt: boristodorov/PHP-from-scratch

 private function __construct()
 {
     $host = DB_HOST;
     $username = DB_USER;
     $password = DB_PASS;
     $dbname = DB_NAME;
     $db = new \mysqli($host, $username, $password, $dbname);
     self::$db = $db;
 }

Beispiel #5

Datei: Database.php Projekt: KonstantinKirchev/WebDevelopmentProject

 private function __construct()
 {
     // Read the config/db.php db settings
     $host = DB_HOST;
     $username = DB_USERNAME;
     $password = DB_PASSWORD;
     $database = DB_DATABASE;
     $db = new \mysqli($host, $username, $password, $database);
     self::$db = $db;
 }

Beispiel #6

Datei: fetch_banners.php Projekt: dernalis/tvshows

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL && ~E_NOTICE);
date_default_timezone_set('Europe/Berlin');
require_once 'config/config.inc.php';
require_once 'lib/lib_mediaobject.php';
require_once 'lib/lib_helper.php';
require_once 'lib/lib_database.php';
require_once 'lib/lib_directory.php';
require_once 'lib/lib_options.php';
$helper = new LibHelper();
$db = new LibDatabase($dbs);
$options = new LibOptions();
$img_basedir = $options->get('banner_directory');
$tvdb_url = $options->get('tvdb_url');
# GET BANNER FOR SHOW
$banner = $tvdb->getBanners($tvshow['tvdb_id'], 'poster');
$tvshow['poster'] = $banner[0]->path;
$db->update($tvshow, 'tv_shows');
$db_images = $db->load_all_objects('tv_shows', array('banner'));
foreach ($db_images as $image) {
    $image_path = $img_basedir . $image['banner'];
    if (!file_exists($image_path)) {
        $img_url = $tvdb_url . '/banners/_cache/' . $image['banner'];
        echo $img_url . "\n";
        file_put_contents($image_path, fopen($img_url, 'r'));
    }
}
?>
 

Beispiel #7

Datei: fetch_missing_episodes.php Projekt: dernalis/tvshows

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL && ~E_NOTICE);
date_default_timezone_set('Europe/Berlin');
require_once 'config/config.inc.php';
require_once 'lib/lib_mediaobject.php';
require_once 'lib/lib_helper.php';
require_once 'lib/lib_database.php';
require_once 'lib/lib_directory.php';
require_once 'lib/lib_options.php';
$helper = new LibHelper();
$db = new LibDatabase($dbs);
$options = new LibOptions();
# 3RD PARTY MODULE SETUP: TVDB #####################################
define('TVDB_URL', $options->get('tvdb_url'));
define('TVDB_API_KEY', $options->get('tvdb_api_key'));
include __DIR__ . '/../3rd_party/Moinax/TvDb/CurlException.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Client.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Serie.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Banner.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Episode.php';
use Moinax\TvDb\Client;
$tvdb = new Client(TVDB_URL, TVDB_API_KEY);
$serverTime = $tvdb->getServerTime();
#####################################################################
$shows = $db->load_all_objects('tv_shows');
foreach ($shows as $show) {
    $data = $tvdb->getSerieEpisodes($show['tvdb_id'], 'de');
    foreach ($data['episodes'] as $episode) {
        $db_episode = $db->load_episode($show['id'], $episode->season, $episode->number);

Beispiel #8

Datei: fetch_episodes.php Projekt: dernalis/tvshows

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL && ~E_NOTICE);
date_default_timezone_set('Europe/Berlin');
require_once 'config/config.inc.php';
require_once 'lib/lib_mediaobject.php';
require_once 'lib/lib_helper.php';
require_once 'lib/lib_database.php';
require_once 'lib/lib_directory.php';
require_once 'lib/lib_options.php';
$helper = new LibHelper();
$db = new LibDatabase($dbs);
$options = new LibOptions();
# 3RD PARTY MODULE SETUP: TVDB #####################################
define('TVDB_URL', $options->get('tvdb_url'));
define('TVDB_API_KEY', $options->get('tvdb_api_key'));
include __DIR__ . '/../3rd_party/Moinax/TvDb/CurlException.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Client.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Serie.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Banner.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Episode.php';
use Moinax\TvDb\Client;
$tvdb = new Client(TVDB_URL, TVDB_API_KEY);
$serverTime = $tvdb->getServerTime();
#####################################################################
$episodes = $db->load_objects_by_sql('SELECT s.tvdb_id, f.id, f.filename FROM tv_files f, tv_shows s WHERE f.show_id = s.id');
foreach ($episodes as $episode) {
    # FIRST VERSION: EXPECT NAME TO BE LIKE
    # <SHOWNAME> - <EPISODE SXXEYY> - <OPTIONAL EPISODE-TITLE>.<EXTENSION>
    # SIMPLE / DIRTY

Beispiel #9

Datei: fetch_posters.php Projekt: dernalis/tvshows

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL && ~E_NOTICE);
date_default_timezone_set('Europe/Berlin');
require_once 'config/config.inc.php';
require_once 'lib/lib_mediaobject.php';
require_once 'lib/lib_helper.php';
require_once 'lib/lib_database.php';
require_once 'lib/lib_directory.php';
require_once 'lib/lib_options.php';
$helper = new LibHelper();
$db = new LibDatabase($dbs);
$options = new LibOptions();
# 3RD PARTY MODULE SETUP: TVDB #####################################
define('TVDB_URL', $options->get('tvdb_url'));
define('TVDB_API_KEY', $options->get('tvdb_api_key'));
include __DIR__ . '/../3rd_party/Moinax/TvDb/CurlException.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Client.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Serie.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Banner.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Episode.php';
use Moinax\TvDb\Client;
$tvdb = new Client(TVDB_URL, TVDB_API_KEY);
$serverTime = $tvdb->getServerTime();
#####################################################################
$img_basedir = $options->get('banner_directory');
$tvdb_url = $options->get('tvdb_url');
$db_images = $db->load_all_objects('tv_shows');
foreach ($db_images as $image) {
    $banner = $tvdb->getBanners($image['tvdb_id'], 'poster');

Beispiel #10

Datei: fetch_seasons.php Projekt: dernalis/tvshows

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL && ~E_NOTICE);
date_default_timezone_set('Europe/Berlin');
require_once 'config/config.inc.php';
require_once 'lib/lib_mediaobject.php';
require_once 'lib/lib_helper.php';
require_once 'lib/lib_database.php';
require_once 'lib/lib_directory.php';
require_once 'lib/lib_options.php';
$helper = new LibHelper();
$db = new LibDatabase($dbs);
$options = new LibOptions();
# 3RD PARTY MODULE SETUP: TVDB #####################################
define('TVDB_URL', $options->get('tvdb_url'));
define('TVDB_API_KEY', $options->get('tvdb_api_key'));
include __DIR__ . '/../3rd_party/Moinax/TvDb/CurlException.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Client.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Serie.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Banner.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Episode.php';
use Moinax\TvDb\Client;
$tvdb = new Client(TVDB_URL, TVDB_API_KEY);
$serverTime = $tvdb->getServerTime();
#####################################################################
$img_basedir = $options->get('banner_directory');
$tvdb_url = $options->get('tvdb_url');
$db_files = $db->load_all_objects('tv_files');
foreach ($db_files as $file) {
}

Beispiel #11

Datei: lookup.php Projekt: dernalis/tvshows

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL && ~E_NOTICE);
date_default_timezone_set('Europe/Berlin');
require_once 'config/config.inc.php';
require_once 'lib/lib_mediaobject.php';
require_once 'lib/lib_helper.php';
require_once 'lib/lib_database.php';
require_once 'lib/lib_directory.php';
require_once 'lib/lib_options.php';
$helper = new LibHelper();
$db = new LibDatabase($dbs);
$options = new LibOptions();
# 3RD PARTY MODULE SETUP: TVDB #####################################
define('TVDB_URL', $options->get('tvdb_url'));
define('TVDB_API_KEY', $options->get('tvdb_api_key'));
include __DIR__ . '/../3rd_party/Moinax/TvDb/CurlException.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Client.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Serie.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Banner.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Episode.php';
use Moinax\TvDb\Client;
$tvdb = new Client(TVDB_URL, TVDB_API_KEY);
$serverTime = $tvdb->getServerTime();
#####################################################################
$files = $db->get_incomplete_shows();
$i = 0;
foreach ($files as $file) {
    # FIRST VERSION: EXPECT NAME TO BE LIKE
    # <SHOWNAME> - <EPISODE SXXEYY> - <OPTIONAL EPISODE-TITLE>.<EXTENSION>