PHP PDOConnection类代码示例

古城微笑少年丶 2023-10-13 07:50 20阅读 0赞

本文整理汇总了PHP中**PDOConnection类**的典型用法代码示例。如果您正苦于以下问题：PHP PDOConnection类的具体用法？PHP PDOConnection怎么用？PHP PDOConnection使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

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

### 示例1: get\_addresses ###

### 示例2: update\_address ###

### 示例3: update\_inventory ###

### 示例4: update\_unit ###

### 示例5: update\_product ###

### 示例6: verifyUserIsAdmin ###

function verifyUserIsAdmin($username)
    {
        $dbh = new PDOConnection();
        $query = 'SELECT user_id FROM admins JOIN users ON users.id = user_id WHERE username = :username';
        $sth = $dbh->prepare($query);
        $sth->bindParam(':username', $username, PDO::PARAM_STR);
        if (!$sth->execute()) {
            throw new Exception($sth->errorInfo()[2]);
        }
        $result = $sth->fetchAll();
        $retval = !empty($result);
        return $retval;
    }

### 示例7: get\_product\_classes ###

function get_product_classes($classFilters = NULL)
    {
        $dbh = new PDOConnection();
        $query = "SELECT * FROM product_classes ";
        $classArray = array();
        $sth = $dbh->prepare($query);
        $sth->execute();
        $result = $sth->fetchAll(PDO::FETCH_ASSOC);
        foreach ($result as $row) {
            $classArray[] = $row;
        }
        return $classArray;
    }

### 示例8: add\_product\_class ###

### 示例9: initialize ###

/**
      * @codeCoverageIgnore
      */
     protected static function initialize()
     {
         static::$classNS = get_called_class();
         static::$tableName = static::getTableName(static::$classNS);
         $pdo = PDOConnection::getInstance();
         static::$DBH = $pdo->connect();
     }

### 示例10: revisionData ###

public function revisionData()
     {
         $dao = new JobRevisionDataDao(PDOConnection::connectINIT());
         $data = $dao->getData($this->request->id_job, $this->auth_param);
         $result = new Json_RevisionData_Job($data);
         $this->response->json($result->render());
     }

### 示例11: obtain ###

public static function obtain($server = null, $user = null, $pass = null, $database = null)
     {
         if (!self::$instance) {
             self::$instance = new PDOConnection($server, $user, $pass, $database);
         }
         return self::$instance;
     }

### 示例12: add\_product\_class ###

function add_product_class($classArray)
    {
        $dbh = new PDOConnection();
        $code = $classArray['code'];
        $description = $classArray['description'];
        $query = "SELECT code FROM product_classes where code = :code";
        $sth = $dbh->prepare($query);
        $sth->bindParam(':code', $code, PDO::PARAM_STR);
        $sth->execute();
        if ($sth->rowCount() > 0) {
            throw new Exception("Class code exists");
        }
        $query = "INSERT INTO product_classes(description,code) VALUES(:description,:code)";
        $sth = $dbh->prepare($query);
        $sth->bindParam(':code', $code, PDO::PARAM_STR);
        $sth->bindParam(':description', $description, PDO::PARAM_STR);
        return $sth->execute();
    }

### 示例13: get\_units ###

### 示例14: getPosiciones ###

public function getPosiciones()
     {
         $list = array();
         $db = PDOConnection::getInstance();
         $req = $db->prepare('SELECT posicion as posicion, FK_pincho_prem as id_pincho FROM premiados WHERE FK_premio_prem =?');
         $req->execute(array($this->getId()));
         foreach ($req->fetchAll() as $posicion) {
             $list[] = array($posicion['posicion'], Pincho::find($posicion['id_pincho'])->getNombre());
         }
         return $list;
     }

### 示例15: get\_customers ###