PHP AppConfig::gacv方法代码示例

 function get_table($paged = 0)
 {
     /* Execute a prepared statement by passing an array of values */
     $dbh = new PDO('mysql:dbname=' . AppConfig::gacv("AC_db") . ';host=' . AppConfig::gacv("AC_server"), AppConfig::gacv("AC_user"), AppConfig::gacv("AC_pass"));
     $sql = sprintf("select * from %s WHERE " . $this->lookup_tbl_id_col . " = :lookup_tbl_id_col OR 1 = :lookup_not_set order by %s", $this->tbl_name, $this->lookup_value_col);
     if ($paged) {
         $sql .= MyEDB_Pager::get_sql_limit_clause();
     }
     $sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_FWDONLY));
     //
     //$sth->execute(array(':lookup_tbl_id_col' => ($_REQUEST[$this->lookup_tbl_id_col])? $_REQUEST[$this->lookup_tbl_id_col] : $this->lookup_tbl_id_col));
     $sth->bindParam(':lookup_tbl_id_col', $lookup_tbl_id_col);
     $sth->bindParam(':lookup_not_set', $lookup_not_set);
     $lookup_tbl_id_col = $_REQUEST[$this->lookup_tbl_id_col];
     $lookup_not_set = $_REQUEST[$this->lookup_tbl_id_col] ? 0 : 1;
     $sth->execute();
     $res = $sth->fetchAll(PDO::FETCH_BOTH);
     //echo $sql.$this->lookup_tbl_id_col;//
     $table_hash = array();
     //print_r($res);
     foreach ($res as $ar) {
         //echo $sql."-".$lookup_tbl_id_col." ".$lookup_not_set;
         $table_hash[$ar[0]] = array($ar[1], "lookup_table_id" => $ar[$this->lookup_tbl_id_col], "disabled" => $ar['disabled']);
     }
     return $table_hash;
 }

 function delete_search_keys()
 {
     $dbh = new PDO('mysql:dbname=' . AppConfig::gacv("AC_db") . ';host=' . AppConfig::gacv("AC_server"), AppConfig::gacv("AC_user"), AppConfig::gacv("AC_pass"));
     $memcache_obj = memcache_pconnect('localhost', 11211);
     $sql = sprintf("select search_key from %s ", "memcache_search_keys");
     $sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_FWDONLY));
     //
     $sth->execute();
     $res = $sth->fetchAll(PDO::FETCH_BOTH);
     //echo $sql.$this->lookup_tbl_id_col;//
     foreach ($res as $ar) {
         memcache_delete($memcache_obj, $ar["search_key"], 0);
     }
     /* Delete all rows from the FRUIT table */
     $count = $dbh->exec("DELETE FROM memcache_search_keys");
 }

	function update_medb_order_res_field_name_value($res_field_name, $new_value)
	{	 
		if (1 == get_magic_quotes_runtime() || 1 == get_magic_quotes_gpc()){ 
        	$new_value = stripslashes($new_value); //PDO does the escaping 
    	} 
    	$new_value = trim($new_value);
    	//$new_value = htmlspecialchars($new_value,ENT_NOQUOTES);
    	//echo htmlentities($new_value)."-[-"; die();
		//$new_value = htmlentities($new_value, ENT_QUOTES);
		
		$dbh = new PDO('mysql:dbname='.AppConfig::gacv("AC_db").';host='.AppConfig::gacv("AC_server")
				,AppConfig::gacv("AC_user"),AppConfig::gacv("AC_pass")); 
		$sql = sprintf("select details_xml from medb_order WHERE order_id = :pdo_order_id "); 
		$sth = $dbh->prepare($sql ,array(PDO::ATTR_CURSOR, PDO::CURSOR_FWDONLY));//
		//$sth->execute(array(':lookup_tbl_id_col' => ($_REQUEST[$this->lookup_tbl_id_col])? $_REQUEST[$this->lookup_tbl_id_col] : $this->lookup_tbl_id_col));
		$sth->bindParam(':pdo_order_id',$this->order_id, PDO::PARAM_INT);
	//	$sth->bindParam(':lookup_not_set',$lookup_not_set);
	//	$lookup_tbl_id_col = $_REQUEST[$this->lookup_tbl_id_col] ;
	//	$lookup_not_set = ($_REQUEST[$this->lookup_tbl_id_col])? 0 : 1;
		$sth->execute();
		$details_xml = $sth->fetchColumn();
		
		$xml = simplexml_load_string($details_xml);

		$result = $xml->xpath("/travel_res_info/travel_res_submitted_fields/travel_res_submit_field [@res_field_name='" . $res_field_name . "']" );

		$result[0]->res_field_value=$new_value;
  		$new_details_xml = $xml->asXML();
		//echo "yoohoo".htmlentities($xml->asXML()); die;
		
		$sql = sprintf("update medb_order set details_xml = :new_details_xml WHERE order_id = :pdo_order_id "); 
		$sth = $dbh->prepare($sql ,array(PDO::ATTR_CURSOR, PDO::CURSOR_FWDONLY));//
		//$sth->execute(array(':lookup_tbl_id_col' => ($_REQUEST[$this->lookup_tbl_id_col])? $_REQUEST[$this->lookup_tbl_id_col] : $this->lookup_tbl_id_col));
		$sth->bindParam(':pdo_order_id',$this->order_id, PDO::PARAM_INT);
		$sth->bindParam(':new_details_xml',$new_details_xml);
	//	$lookup_tbl_id_col = $_REQUEST[$this->lookup_tbl_id_col] ;
	//	$lookup_not_set = ($_REQUEST[$this->lookup_tbl_id_col])? 0 : 1;
		$sth->execute();
		
		return $new_value;
				
	}

 function get_all_eids_by_type_category($type_category, $type_id)
 {
     /*		$sql = "select distinct eid from view_varchar_prop_to_e_p_to_e natural join type where  type_category = 'product'  ";
     		$eids = array();
     		$result = mysql_query($sql);
     		while ($row = mysql_fetch_array($result))
     		{
     			$eids[] = $row['eid'];
     		}
     		return $eids;
     */
     $dbh = new PDO('mysql:dbname=' . AppConfig::gacv("AC_db") . ';host=' . AppConfig::gacv("AC_server"), AppConfig::gacv("AC_user"), AppConfig::gacv("AC_pass"));
     $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     $all_types = 0;
     if ($type_id > 0) {
         $sql_type_id = $type_id;
         //echo "I'm here";
     } else {
         $sql_type_id = "";
         $all_types = 1;
     }
     $thisclass = get_class($this);
     $sql = sprintf("select distinct eid from {$thisclass} natural join type WHERE type_category = :the_type_category \n\t\t\t\tand (type_id = :sql_type_id or 1 = :all_types)");
     //echo $sql;
     $sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_FWDONLY));
     //
     //$sth->execute(array(':lookup_tbl_id_col' => ($_REQUEST[$this->lookup_tbl_id_col])? $_REQUEST[$this->lookup_tbl_id_col] : $this->lookup_tbl_id_col));
     $sth->bindParam(':the_type_category', $type_category);
     $sth->bindParam(':sql_type_id', $sql_type_id);
     $sth->bindParam(':all_types', $all_types, PDO::PARAM_INT);
     $sth->execute();
     $res = $sth->fetchAll(PDO::FETCH_BOTH);
     //echo $sql.$this->lookup_tbl_id_col;//
     $eids = array();
     // print_r($res);
     foreach ($res as $ar) {
         $eids[] = $ar['eid'];
     }
     return $eids;
 }

	static function getpdo()
	{
		$dbh = new PDO('mysql:dbname='.AppConfig::gacv("AC_db").';host='.AppConfig::gacv("AC_server"),AppConfig::gacv("AC_user"),AppConfig::gacv("AC_pass")); 
		return $dbh;
	}