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

PHP Mysql::getData方法代码示例

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


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

示例1: getList

 public function getList($search)
 {
     $mysql = new Mysql();
     $PageSize = intval($search->PageSize);
     $FirstRow = intval($search->PageIndex - 1) * $PageSize;
     $sqlList = "select Subject,Url from project where (Status=6 or Status=7) and Type=" . intval($this->Type) . " order by Pv desc LIMIT {$FirstRow}, {$PageSize};";
     $sqlCount = "select count(Id) from project where (Status=6 or Status=7) and Type=" . intval($this->Type);
     $res = array();
     if ($search->NeedCount) {
         // 查找 count 和 数据
         $totalCount = $mysql->getVar($sqlCount);
         if (empty($totalCount)) {
             $res["Success"] = true;
             $res["Data"] = null;
             $res["Count"] = 0;
         } else {
             $res["Success"] = true;
             $res["Data"] = $mysql->getData($sqlList);
             $res["Count"] = $totalCount;
         }
     } else {
         // 只查找数据
         $res["Success"] = true;
         $res["Data"] = $mysql->getData($sqlList);
     }
     $mysql->closeDb();
     return $res;
 }
开发者ID:xuyintao，项目名称:thindev，代码行数:28，代码来源:Project.class.php

示例2: getList

 public function getList($projectId)
 {
     $mysql = new Mysql();
     $sql = "SELECT m.*,u.Name FROM " . $mysql->dbpre . "memo" . $mysql->debug . " as m," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE m.UserId=u.UserId AND ProjectId=" . intval($projectId);
     // var_dump( $sql );
     // exit;
     $result = $mysql->getData($sql);
     $mysql->closeDb();
     return $result;
 }
开发者ID:xuyintao，项目名称:thindev，代码行数:10，代码来源:Memo.class.php

示例3: getListByParentId

 public function getListByParentId($parentId)
 {
     $mysql = new Mysql();
     $sql = "select * from " . $mysql->dbpre . "department" . $mysql->debug . " where parentId=" . intval($this->ParentId);
     $data = $mysql->getData($sql);
     $mysql->closeDb();
     $res = array();
     if (!empty($data)) {
         $res["Success"] = true;
         $res["Data"] = $data;
     } else {
         $res["Success"] = false;
     }
     return $res;
 }
开发者ID:xuyintao，项目名称:thindev，代码行数:15，代码来源:Department.class.php

示例4: getList

 public function getList($search)
 {
     $mysql = new Mysql();
     $PageSize = intval($search->PageSize);
     $FirstRow = intval($search->PageIndex - 1) * $PageSize;
     $sqlList = "SELECT h.*,(SELECT Subject FROM " . $mysql->dbpre . "project" . $mysql->debug . " WHERE Id=h.ProjectId) AS Subject,u.Name,u.Ratio as UserRotio FROM " . $mysql->dbpre . "hours" . $mysql->debug . " as h," . $mysql->dbpre . "user" . $mysql->debug . " as u WHERE h.UserId=u.UserId";
     $sqlCount = "SELECT COUNT(Id) from " . $mysql->dbpre . "hours" . $mysql->debug . " where 1=1";
     if ($search->ProjectId > -1) {
         $sqlList .= " AND ProjectId= " . intval($search->ProjectId);
         $sqlCount .= " AND ProjectId= " . intval($search->ProjectId);
     }
     if ($search->Status > -1) {
         $sqlList .= " AND Status= " . intval($search->Status);
         $sqlCount .= " AND Status= " . intval($search->Status);
     }
     // var_dump( $sql );
     // exit;
     $sqlList .= " Order by id desc LIMIT {$FirstRow}, {$PageSize};";
     //var_dump( $sqlList );
     //var_dump( $sqlCount );
     // 		exit;
     $res = array();
     if ($search->NeedCount) {
         // 查找 count 和 数据
         $totalCount = $mysql->getVar($sqlCount);
         if (empty($totalCount)) {
             $res["Success"] = true;
             $res["Data"] = null;
             $res["Count"] = 0;
         } else {
             $res["Success"] = true;
             $res["Data"] = $mysql->getData($sqlList);
             //print_r($sqlList);
             $res["Count"] = $totalCount;
         }
         //$Res["Set"] = true;
     } else {
         // 只查找数据
         $res["Success"] = true;
         $res["Data"] = $mysql->getData($sqlList);
         //$res["Set"] = false;
     }
     $mysql->closeDb();
     // $Res["Sql"] = $Sql;
     // $Res["SqlCount"] = $SqlCount;
     return $res;
 }
开发者ID:xuyintao，项目名称:thindev，代码行数:47，代码来源:Hours.class.php

示例5: addOrEditCategory

 function addOrEditCategory($id, $description, $displayOrder, $status, $name, $nameUrl, $parentId, $image)
 {
     $mysql = new Mysql();
     // @helu time 2014-06-13
     //判断别名是否添加过如果添加过则不能添加
     $sqlAlias = "SELECT COUNT(nameurl) as countId, id FROM " . $mysql->dbpre . "category" . $mysql->debug;
     $sqlAlias .= " WHERE nameurl= '" . $mysql->escape($nameUrl) . "'";
     $aliasRes = $mysql->getData($sqlAlias);
     $aliasCount = intval($aliasRes[0]['countId']);
     $aliasId = $aliasRes[0]['id'];
     // var_dump( $id );
     // var_dump( $aliasCount );
     // var_dump( $aliasId );
     // exit;
     if ($aliasCount === 1) {
         if (empty($id) || $id != $aliasId) {
             $result = array();
             $result['Success'] = false;
             $result['Code'] = -1;
             // -1 : 别名已经添加过
             $mysql->closeDb();
             return $result;
         }
     }
     if ($id > 0) {
         $sqlformat = "update %scategory%s set Description='%s',DisplayOrder=%d,status=%d,name='%s',nameurl='%s',parentid=%d,image='%s' where id=%d and belong=%d";
         $sql = sprintf($sqlformat, $mysql->dbpre, $mysql->debug, $mysql->escape($description), intval($displayOrder), intval($status), $mysql->escape($name), $mysql->escape($nameUrl), intval($parentId), $mysql->escape($image), intval($id), intval($this->Belong));
     } else {
         $sqlformat = "insert into %scategory%s (Description,DisplayOrder,status,Name,NameUrl,ParentId,Image,Belong,Creator) values('%s',%d,%d,'%s','%s',%d,'%s',%d,%d)";
         $sql = sprintf($sqlformat, $mysql->dbpre, $mysql->debug, $mysql->escape($description), intval($displayOrder), intval($status), $mysql->escape($name), $mysql->escape($nameUrl), intval($parentId), $mysql->escape($image), intval($this->Belong), intval($this->Creator));
     }
     $result = $mysql->runSql($sql);
     $mysql->closeDb();
     return $result;
 }
开发者ID:xuyintao，项目名称:web01，代码行数:35，代码来源:Category.class.php

示例6: Mysql

 function getChildPosts2($ids)
 {
     $mysql = new Mysql();
     //$postSearch=new PostSearch();
     $sql = "select Id,Subject,Image,Summary,Content,Link,Belong from " . $mysql->dbpre . "post" . $mysql->debug . " where belong=" . intval($this->Belong);
     $sql .= " and id in (" . $ids . ") limit 10;";
     $result = $mysql->getData($sql);
     $mysql->closeDb();
     return $result;
 }
开发者ID:xuyintao，项目名称:web01，代码行数:10，代码来源:Post.class.php

示例7: getList

 function getList($search)
 {
     $mysql = new Mysql();
     $PageSize = intval($search->PageSize);
     $FirstRow = intval($search->PageIndex - 1) * $PageSize;
     $sqlList = "SELECT *,(SELECT name FROM user WHERE UserId=p.UserId) as Name from " . $mysql->dbpre . "project" . $mysql->debug . " as p where 1=1";
     $sqlCount = "SELECT COUNT(Id) from " . $mysql->dbpre . "project" . $mysql->debug . " where 1=1";
     if ($search->Type > -1) {
         $sqlList .= " AND Type= " . intval($search->Type);
         $sqlCount .= " AND Type= " . intval($search->Type);
     }
     if ($search->Department > -1) {
         $sqlList .= " AND Department= " . intval($search->Department);
         $sqlCount .= " AND Department= " . intval($search->Department);
     }
     if ($search->Team > -1) {
         $sqlList .= " AND Team= " . intval($search->Team);
         $sqlCount .= " AND Team= " . intval($search->Team);
     }
     if ($search->Status > 0) {
         if ($search->Status == 100) {
             $sqlList .= " AND Status<6";
             $sqlCount .= " AND Status<6";
         } else {
             if ($search->Status == 200) {
                 $sqlList .= " AND Status>5 AND Status<10";
                 $sqlCount .= " AND Status>5 AND Status<10";
             } else {
                 $sqlList .= " AND Status=" . intval($search->Status);
                 $sqlCount .= " AND Status=" . intval($search->Status);
             }
         }
     }
     if ($search->UserId > 0) {
         $sqlList .= " AND UserId= " . intval($search->UserId);
         $sqlCount .= " AND UserId =" . intval($search->UserId);
     }
     if ($search->Developer > 0) {
         $sqlList .= " AND ( Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "hours" . $mysql->debug . " where UserId =" . intval($search->Developer) . ")";
         $sqlCount .= " AND ( Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "hours" . $mysql->debug . " where UserId =" . intval($search->Developer) . ")";
         $sqlList .= " OR Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "developer" . $mysql->debug . " where UserId =" . intval($search->Developer) . "))";
         $sqlCount .= " OR Id in ( SELECT ProjectId FROM " . $mysql->dbpre . "developer" . $mysql->debug . " where UserId =" . intval($search->Developer) . "))";
     }
     //	1按提交顺序（从先到后）2按上线时间（从近到远）3按总PV值（从高到低）4按推荐指数（从高到低）5按工时（从少到多）
     switch ($search->Order) {
         case 1:
             $sqlList .= " ORDER BY ID ASC";
             break;
         case 2:
             $sqlList .= " ORDER BY PublishTime DESC";
             break;
         case 3:
             $sqlList .= " ORDER BY PV DESC";
             break;
         case 4:
             $sqlList .= " ORDER BY LAUD DESC,PublishTime DESC";
             break;
         case 5:
             $sqlList .= " ORDER BY Hours ASC";
             break;
         default:
             if ($search->Status == 200) {
                 $sqlList .= " ORDER BY PublishTime DESC";
             } else {
                 if ($search->Status == 100) {
                     $sqlList .= " ORDER BY PublishTime ASC, CreateTime ASC";
                 } else {
                     $sqlList .= " ORDER BY Status ASC";
                 }
             }
             break;
     }
     $sqlList .= " LIMIT {$FirstRow}, {$PageSize};";
     //var_dump( $sqlList );
     //var_dump( $sqlCount );
     // 		exit;
     $res = array();
     if ($search->NeedCount) {
         // 查找 count 和 数据
         $totalCount = $mysql->getVar($sqlCount);
         if (empty($totalCount)) {
             $res["Success"] = true;
             $res["Data"] = null;
             $res["Count"] = 0;
         } else {
             $res["Success"] = true;
             $res["Data"] = $mysql->getData($sqlList);
             //print_r($sqlList);
             $res["Count"] = $totalCount;
         }
         //$Res["Set"] = true;
     } else {
         // 只查找数据
         $res["Success"] = true;
         $res["Data"] = $mysql->getData($sqlList);
         //$res["Set"] = false;
     }
     $mysql->closeDb();
     // $Res["Sql"] = $Sql;
     // $Res["SqlCount"] = $SqlCount;
//.........这里部分代码省略.........
开发者ID:xuyintao，项目名称:thindev，代码行数:101，代码来源:Project.class.php

示例8: getUserListByDept

 public function getUserListByDept($deptId)
 {
     $mysql = new Mysql();
     $sql = "SELECT UserId,Name FROM " . $mysql->dbpre . "user" . $mysql->debug . " WHERE  Department=" . intval($deptId);
     // var_dump( $sql );
     // exit;
     $result = $mysql->getData($sql);
     $mysql->closeDb();
     return $result;
 }
开发者ID:xuyintao，项目名称:thindev，代码行数:10，代码来源:User.class.php


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