博客榜—查看频道“Andy's Blog”

总排名： 2375

Andy's Blog

RSS地址： http://feed.21andy.com
共有16篇文章被收藏推荐

鲜果类别： IT.科技
收录于2008-02-05

认领

报错

最新文章

精华文章

50位订阅者

▶ 前列腺健康自检表 2008-08-23 15:38

前列腺疾病健康自检表是√ 否×● 是否有尿无力、尿不尽的感觉 □● 是否在某时段明显尿频感觉 □● 是否有尿急、尿意强的感觉 □● 是否有尿刺痛（灼热）感觉 □● ...

▶ 使用 eAccelerator 加密PHP程序 2008-08-22 00:27

使用 eAccelerator 加密PHP程序# /usr/local/bin/encoder执行后会看到简单的使用说明：Usage: encoder [options] source_file_nameencoder [options] source_file_name...encoder [options] source_directory_name...Options:-s suffixencode files only with following suffix (default is "php")-aencode all files (no by default)-lfollow symbolic links (no by default)-rencode directories...

▶ Mac OS Leopard视频教程下载 2008-08-19 14:05

《Leopard使用教程》《美洲豹使用教程》下载：中文名称：美洲豹新特征概览英文名称：Lynda.com Mac OS X 10.5 Leopard New Features资源类型：ISO发行时间：2007年地区：美国语言：英语苹果发布的 Mac 新一代旗舰操作系统 -- Mac OS X 10.5 Leopard (美洲豹)...

▶ 2008年十大赚钱的暴利行业 2008-06-08 16:51

2008年十大赚钱的暴利行业图解：...

▶ DB class for CodeIgniter 2008-06-07 19:05

It's a simple and useful MySQL DB class. I modify it from WordPress2.5.1 wp-db.phpIt also automatic load DB config from CI config file.Author: http://www.21andy.comUsage: just put it in your CI app library folder, usually in system/application/libraries and name Db.phpnow , you can load the library anywhere, or set it automatic load in autoload config file$this->load->library('db');turn...

It's a simple and useful MySQL DB class.
I modify it from WordPress2.5.1 wp-db.php

It also automatic load DB config from CI config file.

Author: http://www.21andy.com

Usage:
just put it in your CI app library folder, usually in system/application/libraries
and name Db.php

now , you can load the library anywhere, or set it automatic load in autoload config file

$this->load->library('db');

turn SAVE QUERIES on

$this->db->save_query(true);

I think these method is good than CI database, only ONE line code.

$this->db->get_var($sql);
$this->db->get_row($sql);
$this->db->get_col($sql);
$this->db->get_results($sql);

enjoy it!!!
anyway, sorry for my poor english.

下载: Db.php

<?php
/**
*@Filename: Db.php
*@Version : 1.0
*@Author : Andy
*@Website: http://www.21andy.com/
*@Update : 2008-06-07
*@Content : DB class for CodeIgniter
* ORIGINAL CODE FROM:
* Justin Vincent (justin@visunet.ie)
* http://php.justinvincent.com
*/

define('OBJECT', 'OBJECT', true);
define('OBJECT_K', 'OBJECT_K', false);
define('ARRAY_A', 'ARRAY_A', false);
define('ARRAY_N', 'ARRAY_N', false);

classDb{

   var$show_errors = false;
   var$suppress_errors = false;
   var$last_error = '';
   var$num_queries = 0;
   var$last_query;
   var$col_info;
   var$queries;
   var$prefix = '';
   var$ready = false;

   var$charset;
   var$collate;
   var$savequeries = true;

   functionDb(){

   include(APPPATH.'config/database'.EXT);

   if( ! isset($db)ORcount($db) == 0)
   {
   show_error('No database connection settings were found in the database config file.');
   }

   if( ! isset($active_group)OR ! isset($db[$active_group]))
   {
   show_error('You have specified an invalid database connection group.');
   }

   $params = $db[$active_group];

   $this->dbuser = $params['username'];
   $this->dbpassword = $params['password'];
   $this->dbname = $params['database'];
   $this->dbhost = $params['hostname'];
   $this->charset = $params['char_set'];
   $this->collate = $params['dbcollat'];

   register_shutdown_function(array(&$this, "__destruct"));

   if(defined('DEBUG')andDEBUG == true)
   $this->show_errors();

   if(defined('DB_CHARSET'))
   $this->charset = DB_CHARSET;

   if(defined('DB_COLLATE'))
   $this->collate = DB_COLLATE;

   $this->dbh = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpassword, true);
   if(!$this->dbh){
   $this->bail("can't connect to db");
   return;
   }

   $this->ready = true;

   if( !empty($this->charset))
   mysql_query("SET character_set_connection={$this->charset}, character_set_results={$this->charset}, character_set_client=binary");

   if($this->version()> '5.0.1')
   mysql_query("SET sql_mode=''");

   $this->select($this->dbname);
   }

   function__destruct(){
   returntrue;
   }

   functionversion(){
   returnmysql_get_server_info();
   }

   functionselect($db){
   if(!@mysql_select_db($db, $this->dbh)){
   $this->ready = false;
   $this->bail("select db error $db");
   return;
   }
   }

   functionsave_query($enable = false){
   $this->savequeries = $enable;
   }

   functionescape($string){
   returnaddslashes($string);
   }

   functionescape_by_ref(&$s){
   $s = $this->escape($s);
   }

   functionprepare($args=NULL){
   if(NULL === $args)
   return;
   $args = func_get_args();
   $query = array_shift($args);
   $query = str_replace("'%s'", '%s', $query); // in case someone mistakenly already singlequoted it
   $query = str_replace('"%s"', '%s', $query); // doublequote unquoting
   $query = str_replace('%s', "'%s'", $query); // quote the strings
   array_walk($args, array(&$this, 'escape_by_ref'));
   return @vsprintf($query, $args);
   }

   functionprint_error($str = ''){

   if(!$str)$str = mysql_error($this->dbh);

   if($this->suppress_errors)
   returnfalse;

   $error_str = "Database error $str for query $this->last_query";
   if($caller = $this->get_caller())
   $error_str .= " made by $caller";

   $log_error = true;
   if( ! function_exists('error_log'))
   $log_error = false;

   $log_file = @ini_get('error_log');
   if( !empty($log_file)&& ('syslog' != $log_file)&& !is_writable($log_file))
   $log_error = false;

   if($log_error)
   @error_log($error_str, 0);

   // Is error output turned on or not..
   if( !$this->show_errors)
   returnfalse;

   $str = htmlspecialchars($str, ENT_QUOTES);
   $query = htmlspecialchars($this->last_query, ENT_QUOTES);

   // If there is an error then take note of it
   print"<div id='error'>
   <p class='wpdberror'><strong>Database error:</strong> [$str]<br />
   <code>$query</code></p>
   </div>";
   }

   functionshow_errors($show = true){
   $errors = $this->show_errors;
   $this->show_errors = $show;
   return$errors;
   }

   functionhide_errors(){
   $show = $this->show_errors;
   $this->show_errors = false;
   return$show;
   }

   functionsuppress_errors($suppress = true){
   $errors = $this->suppress_errors;
   $this->suppress_errors = $suppress;
   return$errors;
   }

   functionflush(){
   $this->last_result = array();
   $this->col_info = null;
   $this->last_query = null;
   }

   functionquery($query){
   if( ! $this->ready)
   returnfalse;

   $return_val = 0;
   $this->flush();

   $this->func_call = "\$db->query(\"$query\")";

   $this->last_query = $query;

   if($this->savequeries)
   $this->timer_start();

   $this->result = @mysql_query($query, $this->dbh);
   ++$this->num_queries;

   if($this->savequeries)
   $this->queries[] = array($query, $this->timer_stop(), $this->get_caller());

   if($this->last_error = mysql_error($this->dbh)){
   $this->print_error();
   returnfalse;
   }

   if(preg_match("/^\\s*(insert|delete|update|replace) /i",$query)){
   $this->rows_affected = mysql_affected_rows($this->dbh);
   if(preg_match("/^\\s*(insert|replace) /i",$query)){
   $this->insert_id = mysql_insert_id($this->dbh);
   }
   $return_val = $this->rows_affected;
   }else{
   $i = 0;
   while($i< @mysql_num_fields($this->result)){
   $this->col_info[$i] = @mysql_fetch_field($this->result);
   $i++;
   }
   $num_rows = 0;
   while($row = @mysql_fetch_object($this->result)){
   $this->last_result[$num_rows] = $row;
   $num_rows++;
   }

   @mysql_free_result($this->result);
   $this->num_rows = $num_rows;
   $return_val = $this->num_rows;
   }

   return$return_val;
   }

   functionadd_magic_quotes($array){
   foreach($arrayas$k => $v){
   if(is_array($v)){
   $array[$k] = $this->add_magic_quotes($v);
   }else{
   $array[$k] = $this->escape($v);
   }
   }
   return$array;
   }

   functioninsert($table, $data){
   $data = $this->add_magic_quotes($data);
   $fields = array_keys($data);
   return$this->query("INSERT INTO $table (`" . implode('`,`',$fields) . "`) VALUES ('".implode("','",$data)."')");
   }

   functionupdate($table, $data, $where){
   $data = $this->add_magic_quotes($data);
   $bits = $wheres = array();
   foreach(array_keys($data)as$k)
   $bits[] = "`$k` = '$data[$k]'";

   if(is_array($where))
   foreach($whereas$c => $v)
   $wheres[] = "$c = '" . $this->escape($v) . "'";
   else
   returnfalse;
   return$this->query("UPDATE $table SET " . implode(', ', $bits) . ' WHERE ' . implode(' AND ', $wheres) . ' LIMIT 1');
   }

   functionget_var($query=null, $x = 0, $y = 0){
   $this->func_call = "\$db->get_var(\"$query\",$x,$y)";
   if($query)
   $this->query($query);
   if( !empty($this->last_result[$y])){
   $values = array_values(get_object_vars($this->last_result[$y]));
   }
   return(isset($values[$x])&& $values[$x]!=='') ? $values[$x] : null;
   }

   functionget_row($query = null, $output = OBJECT, $y = 0){
   $this->func_call = "\$db->get_row(\"$query\",$output,$y)";
   if($query)
   $this->query($query);
   else
   returnnull;
   if( !isset($this->last_result[$y]))
   returnnull;
   if($output == OBJECT){
   return$this->last_result[$y] ? $this->last_result[$y] : null;
   }elseif($output == ARRAY_A){
   return$this->last_result[$y] ? get_object_vars($this->last_result[$y]) : null;
   }elseif($output == ARRAY_N){
   return$this->last_result[$y] ? array_values(get_object_vars($this->last_result[$y])) : null;
   }else{
   $this->print_error("\$db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N");
   }
   }

   functionget_col($query = null , $x = 0){
   if($query)
   $this->query($query);
   $new_array = array();
   for($i=0; $i< count($this->last_result); $i++ ){
   $new_array[$i] = $this->get_var(null, $x, $i);
   }
   return$new_array;
   }

   functionget_results($query = null, $output = OBJECT){
   $this->func_call = "\$db->get_results(\"$query\", $output)";
   if($query)
   $this->query($query);
   else
   returnnull;
   if($output == OBJECT){
   return$this->last_result;
   }elseif($output == OBJECT_K){
   foreach($this->last_resultas$row){
   $key = array_shift(get_object_vars($row));
   if( !isset($new_array[$key]))
   $new_array[$key] = $row;
   }
   return$new_array;
   }elseif($output == ARRAY_A || $output == ARRAY_N){
   if(</

推荐频道：
已打标签：
添加标签：
	别人打过的标签：我使用过的标签：

21andy.com相关文章

21andy.com相关文章

《Leopard使用教程》

21andy.com相关文章

21andy.com相关文章