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


PHP unknown_type::prepare方法代码示例

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


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

示例1: foreach

 /**
  * Perform term count update immediately.
  *
  * @since 2.5.0
  *
  * @param array $terms The term_taxonomy_id of terms to update.
  * @param string $taxonomy The context of the term.
  * @return bool Always true when complete.
  */
 function update_term_count_now($terms, $taxonomy)
 {
     $terms = array_map('intval', $terms);
     $taxonomy = $this->get_taxonomy($taxonomy);
     if (!empty($taxonomy->update_count_callback)) {
         call_user_func($taxonomy->update_count_callback, $terms);
     } else {
         // Default count updater
         foreach ((array) $terms as $term) {
             $count = $this->db->get_var($this->db->prepare("SELECT COUNT(*) FROM {$this->db->term_relationships} WHERE term_taxonomy_id = %d", $term));
             $this->db->update($this->db->term_taxonomy, compact('count'), array('term_taxonomy_id' => $term));
         }
     }
     $this->clean_term_cache($terms);
     return true;
 }
开发者ID:nxtclass,项目名称:NXTClass,代码行数:25,代码来源:class.nxt-taxonomy.php

示例2: Execute

 /**
  * (non-PHPdoc)
  * @see RedBean/RedBean_Driver#Execute()
  */
 public function Execute($sql, $aValues = array())
 {
     $this->exc = 0;
     if ($this->debug) {
         echo "<HR>" . $sql . print_r($aValues, 1);
     }
     try {
         $s = $this->pdo->prepare($sql);
         $s->execute($aValues);
         $this->affected_rows = $s->rowCount();
         return $this->affected_rows;
     } catch (PDOException $e) {
         //Unfortunately the code field is supposed to be int by default (php)
         //So we need a property to convey the SQL State code
         $x = new RedBean_Exception_SQL($e->getMessage(), 0, $e);
         $x->setSQLState($e->getCode());
         throw $x;
     }
     //
 }
开发者ID:nurulimamnotes,项目名称:DewiSriDesktop,代码行数:24,代码来源:PDO.php

示例3: queryColumns

 /**
  * Show columns of current table
  *
  * @return Array
  */
 public function queryColumns()
 {
     if (empty(self::$cache[static::$table])) {
         // temporaire...
         if ($this->db->getDriver() == 'mysql') {
             $s = $this->db->query("SHOW COLUMNS FROM " . static::$table);
         } elseif ($this->db->getDriver() == 'pgsql') {
             $s = $this->db->prepare("SELECT column_name AS field FROM information_schema.columns WHERE table_name=?");
             $s->execute(array(static::$table));
         }
         if ($s->rowCount() <= 0) {
             throw new LiException('La table ' . $table . ' ne contient aucune colonne');
         }
         $rs = $s->fetchAll();
         $fields = array();
         foreach ($rs as $row) {
             $fields[] = $row['field'];
         }
         self::$cache[static::$table] = $fields;
     }
     return self::$cache[static::$table];
 }
开发者ID:wamania,项目名称:mynd-framework,代码行数:27,代码来源:Model.php

示例4: get_homologue_ens_ids_slow

/**
 * get the homologue ensemble ids of the target species to a given set of ensebl ids.
 *
 * @param unknown_type $compara
 * @param unknown_type $unique_ids
 * @param target_genome_db_id the genome of the target species for filtering (speed up)
 */
function get_homologue_ens_ids_slow($compara, $unique_ids, $target_genome_db_id)
{
    $homology = array();
    $sql = 'SELECT m.stable_id,hom.description FROM homology AS hom,member AS m inner join homology_member AS h
		ON (m.member_id = h.member_id
		AND h.homology_id = hom.homology_id 
		AND m.genome_db_id = ?)
		INNER join homology_member AS h2
		ON h.homology_id = h2.homology_id
		INNER join member AS m2
		ON m2.member_id = h2.member_id AND m2.stable_id = ?
		GROUP BY m.stable_id;';
    $stmt = $compara->prepare($sql);
    foreach ($unique_ids as $unique_id) {
        /* bind parameters for markers */
        $stmt->bind_param("is", $target_genome_db_id, $unique_id);
        /* execute query */
        $stmt->execute();
        /* bind result variables */
        $stmt->bind_result($homo_id, $homo_descript);
        $homology[$unique_id] = array();
        /* fetch value */
        while ($stmt->fetch()) {
            $homology[$unique_id][] = $homo_id;
            $homology[$unique_id][$homo_id] = $homo_descript;
        }
        /*$result = $compara->query($sql) or fatal_error('Homology query failed: '.$compara->error);
        	 $members = array();
        	 while ($row = $result->fetch_assoc()){
        		$members[] = $row['stable_id'];
        		}
        		$homology[$unique_id] = $members;*/
    }
    /* close statement */
    $stmt->close();
    return $homology;
}
开发者ID:BackupTheBerlios,项目名称:eqtl,代码行数:44,代码来源:db_functions.php

示例5: Execute

 /**
  * (non-PHPdoc)
  * @see RedBean/RedBean_Driver#Execute()
  */
 public function Execute($sql, $aValues = array())
 {
     $this->connect();
     $this->exc = 0;
     if ($this->debug) {
         echo "<HR>" . $sql . print_r($aValues, 1);
     }
     try {
         if (strpos("pgsql", $this->dsn) === 0) {
             $s = $this->pdo->prepare($sql, array(PDO::PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT => true));
         } else {
             $s = $this->pdo->prepare($sql);
         }
         $s->execute($aValues);
         $this->affected_rows = $s->rowCount();
         return $this->affected_rows;
     } catch (PDOException $e) {
         if (version_compare(PHP_VERSION, '5.3.0', '<')) {
             $x = new RedBean_Exception_SQL($e->getMessage(), 0);
         } else {
             $x = new RedBean_Exception_SQL($e->getMessage(), 0, $e);
         }
         $x->setSQLState($e->getCode());
         throw $x;
     }
 }
开发者ID:nev3rm0re,项目名称:hondex,代码行数:30,代码来源:rb127lg.php

示例6: Execute

 /**
  * (non-PHPdoc)
  * @see RedBean/RedBean_Driver#Execute()
  */
 public function Execute($sql, $aValues = array())
 {
     //FlexiLogger::error(__METHOD__, "SQL: " . $sql);
     $this->exc = 0;
     if ($this->debug) {
         echo "<HR>" . $sql . print_r($aValues, 1);
     }
     try {
         if (strpos("pgsql", $this->dsn) === 0) {
             $s = $this->pdo->prepare($sql, array(PDO::PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT => true));
         } else {
             $s = $this->pdo->prepare($sql);
         }
         $s->execute($aValues);
         $this->affected_rows = $s->rowCount();
         return $this->affected_rows;
     } catch (PDOException $e) {
         //Unfortunately the code field is supposed to be int by default (php)
         //So we need a property to convey the SQL State code.
         FlexiLogger::error(__METHOD__, "SQL: " . $sql . ", error: " . $e->getMessage());
         if (version_compare(PHP_VERSION, '5.3.0', '<')) {
             $x = new RedBean_Exception_SQL($e->getMessage(), 0);
         } else {
             $x = new RedBean_Exception_SQL($e->getMessage(), 0, $e);
         }
         $x->setSQLState($e->getCode());
         throw $x;
     }
     //
 }
开发者ID:u007,项目名称:FlexiPHP,代码行数:34,代码来源:rb.php

示例7: addOrUpdateValue

/**
 *
 * @param unknown_type $db
 * @param unknown_type $tstamp
 * @param unknown_type $kwatt
 */
function addOrUpdateValue($db, $tstamp, $kwatt)
{
    $st = $db->prepare('REPLACE INTO consumption (date, kwatt) values (:date, :kwatt)');
    $st->bindParam(':date', $tstamp);
    $st->bindParam(':kwatt', $kwatt);
    $st->execute();
}
开发者ID:ka2er,项目名称:cc128-php-extractor,代码行数:13,代码来源:cc128.php


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