DByte\DB::row PHP Метод

row() статический публичный Метод

Fetch a single query result row
static public row ( string $query, array $params = NULL ) : mixed
$query string query string
$params array query parameters
Результат mixed
    static function row($query, $params = NULL)
    {
        if ($statement = DB::query($query, $params)) {
            return $statement->fetch();
        }
    }

Usage Example

Пример #1
0
    $check_nrows = mysqli_num_rows($sample_check);
    if ($check_nrows > 0) {
        $check_row = mysqli_fetch_array($sample_check);
        extract($check_row);
        echo "<dt>From the sample set</dt><dd><a href=\"browse_sample.php?SampleID={$SampleID}\">{$SampleName}</a></dd>";
    }
}
$specinfo = DB::row("SELECT `SpecMaxFreq`, `ImageFFT` from `SoundsImages` WHERE `SoundID`=" . $SoundID . " AND `ImageType`='spectrogram'");
$SpecMaxFreq = $specinfo->SpecMaxFreq;
$ImageFFT = $specinfo->ImageFFT;
echo "<dt>Spectrogram settings</dt>\n\t\t\t\t\t\t\t<dd>Max frequency: {$SpecMaxFreq} Hz<br>\n\t\t\t\t\t\t\tFFT size: {$ImageFFT}</dd>\n";
if ($OtherSoundID != "") {
    echo "<dt>Custom ID</dt><dd>{$OtherSoundID}</dd>";
}
if ($SensorID != "") {
    $sensor = DB::row('SELECT `Recorder`, `Microphone`, `Notes` from `Sensors` WHERE `SensorID`=' . $SensorID);
    $Recorder = $sensor->Recorder;
    $Microphone = $sensor->Microphone;
    $SensorNotes = $sensor->Notes;
    echo "<dt>Sensor used</dt><dd>{$Recorder}, {$Microphone} ({$SensorNotes})</dd>";
} elseif ($SensorID == "1") {
    echo "<dt>Sensor used</dt><dd>Not set</dd>";
} else {
    echo "<dt>Sensor used</dt><dd>Not set</dd>";
}
if ($SiteElevation != "") {
    echo "<dt>Elevation</dt><dd>{$SiteElevation}</dd>\n";
}
if ($SiteURL != "") {
    echo "<dt>Site URL</dt><dd>{$SiteURL}</dd>\n";
}
All Usage Examples Of DByte\DB::row