PHP mysqli_array_buildの例

コード例 #1

ファイル: function.tracker.allowed.php プロジェクト: NCommander/phoenix

function tracker_allowed()
{
    global $connection, $settings;
    require_once __DIR__ . '/once.db.connect.php';
    require_once __DIR__ . '/function.mysqli.array.build.php';
    $torrents = mysqli_array_build('SELECT `info_hash` FROM `' . $settings['db_prefix'] . 'torrents`');
    if (!$torrents) {
        tracker_error('No torrents allowed at this time.');
    } else {
        return $torrents;
    }
}

コード例 #2

ファイル: function.tracker.allowed.php プロジェクト: dogsAreReallyCool/phoenix

function tracker_allowed($connection, $settings)
{
    require_once $settings['functions'] . 'function.mysqli.array.build.php';
    $sql = 'SELECT `info_hash` FROM `' . $settings['db_prefix'] . 'torrents`;';
    $allowed_torrents = mysqli_array_build($connection, $sql);
    if (!$allowed_torrents) {
        // tracker_error('No torrents allowed at this time.');
        return array();
    } else {
        return $allowed_torrents;
    }
}

コード例 #3

ファイル: test.mysqli.array.build.php プロジェクト: dogsAreReallyCool/phoenix

<?php

require_once $settings['functions'] . 'function.mysqli.array.build.php';
$select = 'SELECT `info_hash` FROM `' . $settings['db_prefix'] . 'torrents`;';
$result = mysqli_array_build($connection, $select);
if (!empty($result)) {
    echo 'Error: Empty query was not empty.' . PHP_EOL;
    $failure = true;
}
$insert = 'INSERT INTO `' . $settings['db_prefix'] . 'torrents` ( `info_hash` ) VALUES (\'__TEST_1__\'),  (\'__TEST_2__\'),  (\'__TEST_3__\');';
mysqli_query($connection, $insert);
$result = mysqli_array_build($connection, $select);
$count = count($result);
if ($count != 3) {
    echo 'Error: Query for 3 items returned ' . $count . PHP_EOL;
    $failure = true;
}
$delete = 'DELETE FROM `' . $settings['db_prefix'] . 'torrents` WHERE `info_hash` LIKE \'__TEST_%\';';
mysqli_query($connection, $delete);