当前位置: 首页>>代码示例>>PHP>>正文


PHP SQLQuery::firstRow方法代码示例

本文整理汇总了PHP中SQLQuery::firstRow方法的典型用法代码示例。如果您正苦于以下问题:PHP SQLQuery::firstRow方法的具体用法?PHP SQLQuery::firstRow怎么用?PHP SQLQuery::firstRow使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SQLQuery的用法示例。


在下文中一共展示了SQLQuery::firstRow方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: getVersionedConnection

 public function getVersionedConnection($recordID, $userID, $definitionID, $wasPublished = 0)
 {
     // Turn this into an array and run through implode()
     $filter = "\"AuthorID\" = '" . $userID . "' AND \"RecordID\" = '" . $recordID . "' AND \"WorkflowDefinitionID\" = '" . $definitionID . "' AND WasPublished = '" . $wasPublished . "'";
     $query = new SQLQuery();
     $query->setFrom('SiteTree_versions')->setSelect('COUNT(ID)')->setWhere($filter);
     $query->firstRow();
     $hasAuthored = $query->execute();
     if ($hasAuthored) {
         return true;
     }
     return false;
 }
开发者ID:normann,项目名称:advancedworkflow,代码行数:13,代码来源:WorkflowInstance.php

示例2: testSelectFirst

 public function testSelectFirst()
 {
     // Test first from sequence
     $query = new SQLQuery();
     $query->setFrom('"SQLQueryTest_DO"');
     $query->setOrderBy('"Name"');
     $result = $query->firstRow()->execute();
     $records = array();
     foreach ($result as $row) {
         $records[] = $row;
     }
     $this->assertCount(1, $records);
     $this->assertEquals('Object 1', $records[0]['Name']);
     // Test first from empty sequence
     $query = new SQLQuery();
     $query->setFrom('"SQLQueryTest_DO"');
     $query->setOrderBy('"Name"');
     $query->setWhere(array("\"Name\" = 'Nonexistent Object'"));
     $result = $query->firstRow()->execute();
     $records = array();
     foreach ($result as $row) {
         $records[] = $row;
     }
     $this->assertCount(0, $records);
     // Test that given the last item, the 'first' in this list matches the last
     $query = new SQLQuery();
     $query->setFrom('"SQLQueryTest_DO"');
     $query->setOrderBy('"Name"');
     $query->setLimit(1, 1);
     $result = $query->firstRow()->execute();
     $records = array();
     foreach ($result as $row) {
         $records[] = $row;
     }
     $this->assertCount(1, $records);
     $this->assertEquals('Object 2', $records[0]['Name']);
 }
开发者ID:jakedaleweb,项目名称:AtomCodeChallenge,代码行数:37,代码来源:SQLQueryTest.php

示例3: getVersionedConnection

 public function getVersionedConnection($recordID, $userID, $wasPublished = 0)
 {
     // Turn this into an array and run through implode()
     $filter = "RecordID = {$recordID} AND AuthorID = {$userID} AND WasPublished = {$wasPublished}";
     $query = new SQLQuery();
     $query->setFrom('"SiteTree_versions"')->setSelect('COUNT("ID")')->setWhere($filter);
     $query->firstRow();
     $hasAuthored = $query->execute();
     if ($hasAuthored) {
         return true;
     }
     return false;
 }
开发者ID:Neumes,项目名称:advancedworkflow,代码行数:13,代码来源:WorkflowInstance.php


注:本文中的SQLQuery::firstRow方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。