本文整理汇总了PHP中DataManager::retrieveNumberOfResults方法的典型用法代码示例。如果您正苦于以下问题:PHP DataManager::retrieveNumberOfResults方法的具体用法?PHP DataManager::retrieveNumberOfResults怎么用?PHP DataManager::retrieveNumberOfResults使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataManager
的用法示例。
在下文中一共展示了DataManager::retrieveNumberOfResults方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getControlMessage
function getControlMessage($sid)
{
$dbM = new DataManager(SXN_USER, SXN_PASSWORD, "localhost", SXN_DATABASE_CONTROL);
$dbM->selectAllFromTable(SXN_CONTROL_TABLE_COMMANDS, SXN_CONTROL_COMMANDS_COLUMN_SID . "=" . "{$sid} AND " . SXN_CONTROL_COMMANDS_COLUMN_STATUS . "=" . "'new'");
//TODO add enum table for new, etc..
$numRes = $dbM->retrieveNumberOfResults();
if ($numRes > 0) {
while ($data = $dbM->retrieveResult()) {
echo " :" . $data[SXN_CONTROL_COMMANDS_COLUMN_COMMAND] . "\n";
}
//Update status to "executed"
$columns = array(SXN_CONTROL_COMMANDS_COLUMN_STATUS);
$values = array("executed");
$dbM->updateRow(SXN_CONTROL_TABLE_COMMANDS, $columns, $values, SXN_CONTROL_COMMANDS_COLUMN_SID . "=" . "{$sid} AND " . SXN_CONTROL_COMMANDS_COLUMN_STATUS . "=" . "'new'");
}
}
示例2: fopen
if ($importFile != "error" || $sid == 999) {
echo "<br>Importing {$importFile} to database<br>";
$in = fopen($importFile, "r") or die("can't open file r: {$importFile}");
while (!feof($in)) {
$row = fgets($in);
//echo("$row<br/>");
sscanf($row, "%d:%d:%d %f %f", $hour, $min, $sec, $data, $delay);
//echo("$sid $yy-$mm-$dd $hour:$min:$sec,$data,$delay<br>");
$timestamp = date('Y-m-d G:i:s', mktime($hour, $min, $sec, $mm, $dd, $yy));
//echo("$sid $data $timestamp<br>");
if ($g_dbM2) {
$tableName = SXN_COLLECTOR_TABLE_DATA_PREFIX . $sid;
//$doesTableExist = $this->mysqli_->query("SELECT 1 FROM $tableName");
//$doesTableExist = $g_dbM2->selectAllFromTable($tableName, $conditions);
$g_dbM1->selectAllFromTable(SXN_ADMIN_TABLE_STREAMS, SXN_ADMIN_STREAMS_COLUMN_SID . " = {$sid}");
$doesSidExist = $g_dbM1->retrieveNumberOfResults();
//$g_dbM2->checkIfValueExists(SXN_ADMIN_TABLE_USERS,SXN_ADMIN_USERS_COLUMN_NAME,$name) == false
if ($doesSidExist) {
//echo "Sid is ok! data=$data time=$timestamp \n";
$valueArray = array($data, $timestamp);
$columnArray = array(SXN_COLLECTOR_DATA_COLUMN_VALUE, SXN_GENERAL_COLUMN_TIMESTAMP);
$g_dbM2->insertRow($tableName, $columnArray, $valueArray);
//return true;
} else {
echo "Sid does not exists! ({$doesSidExist})\n";
}
} else {
echo "-Database is not open. Data not added!\n";
}
}
fclose($in);