PHP unknown_type::prepare方法代码示例

 /**
  * 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;
 }

 /**
  * (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;
     }
     //
 }

 /**
  * 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];
 }

/**
 * 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;
}

 /**
  * (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;
     }
 }

 /**
  * (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;
     }
     //
 }

/**
 *
 * @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();
}