phpdb
⑴ php db類的使用
你的query()有返回值，你可以把代碼改成這樣再試試
function fn_select($tabl){
return $this->query("select * from $tabl order by id desc");
}
你沒有用到自己定義的
function fetch_array($query, $result_type = MYsql_ASSOC) {
return @mysql_fetch_array($query, $result_type);
}
你試著在後面加上
$row=$db->fetch_array($a,MYSQL_NUM);
print_r($row);
應該就看到結果了
www.365php.net 365PHP培訓與交流平台 歡迎光臨
⑵ php db.class怎麼寫
<?php
class Db{
public $host;
public $username;
public $password;
public $database;
public $conn;
public $table;
public $sql;
public $field = '*';
function __construct($host,$username,$password,$database){
$this->host = $host;
$this->username = $username;
$this->password = $password;
$this->database = $database;
$this->connect();
}
function connect(){
$this->conn = new mysqli($this->host, $this->username, $this->password,$this->database);
if ($this->conn->connect_error) {
die("連接失敗: " . $this->conn->connect_error);
}
}
function M($table){
$this->table = $table;
return $this;
}
function where($array){
$this->sql = '';
$sql = 'where ';
$one = '';
if($array){
if(is_array($array)){
foreach($array as $key=>$vo){
$one .= '`'.$key.'` = "'.$vo.'" and';
}
$one = trim($one,'and');
$sql .= $one;
$this->sql = $sql;
}else{
$sql .= $array;
$this->sql = $sql;
}
}
return $this;
}
function add($array){
$sql = 'insert into `'.$this->table.'` (';
$one = '';
$two = '';
if($array){
if(is_array($array)){
foreach($array as $key=>$vo){
$one .= '`'.$key.'` ,';
$two .= '"'.$vo.'",';
}
$one = trim($one,',');
$two = trim($two,',');
if($one && $two){
$sql .= $one.') values ('.$two.')';
$this->sql = $sql;
$r = $this->conn->query($this->sql);
if($r){
return mysqli_insert_id($this->conn);
}else{
return false;
}
}
}else{
exit('非數組');
}
}else{
exit('數組為空');
}
}
function select(){
$array = '';
$sql = 'select '.$this->field.' from `'.$this->table.'`'.$this->sql;
$result = $this->conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$array[] = $row;
}
}
return $array;
}
function find(){
$row = '';
$sql = 'select '.$this->field.' from `'.$this->table.'`'.$this->sql.'limit 1';
$result = $this->conn->query($sql);
if($result){
$row = $result->fetch_assoc();
}
return $row;
}
function edit($array){
$sql = 'update `'.$this->table.'` set ';
$one = '';
if($array){
if(is_array($array)){
foreach($array as $key=>$vo){
$one .= '`'.$key.'` = "'.$vo.'",';
}
$one = trim($one,',');
$sql .= $one.' '.$this->sql;
}else{
$sql .= $array.' '.$this->sql;
}
$r = $this->conn->query($sql);
if($r){
return true;
}else{
return false;
}
}else{
exit('未接收到參數');
}
}
function del(){
$sql = 'delete from `'.$this->table.'` ';
$sql .= $this->sql;
$r = $this->conn->query($sql);
if($r){
return true;
}else{
return false;
}
}
function order($data){
$this->sql = $this->sql.' order by '.$data;
return $this;
}
function limit($data){
$this->sql = $this->sql.' limit '.$data;
return $this;
}
function field($data){
$this->field = $data;
return $this;
}
}
?>
⑶ php程序中的.db文件怎麼打開
什麼打不開 你是怎麼打的啊
⑷ php能否使用mysql語句操作.db文件啊
它所得到的那個$ret，你需要使用mysql_fetch_row()、mysql_fetch_assoc()、mysql_fetch_array()以及mysql_fetch_field()這樣的函數來取得它的結果集才行哦親。
你的程序在：
$ret = mysql_query($sql,$con);
一行下面，需要加上：
$result = mysql_fetch_array($ret);
之後，你再print_r或者var_mp($ret)，你就可以看到結果了哦。
⑸ 為什麼PHP函數里邊的$db需要寫成global $db才能正常
作用范圍的問題，函數裡面是一個封閉的環境，如果不是全局變數的話，是不能在函數裡面使用的。
global $db, 聲明 $db 的作用范圍為全局，就可以在函數裡面使用了
回復能不能正常點，還要腦補的， - -！，首先，你可以在第一次聲明的時候聲明 global 這個看你的需求，其次，函數裡面去include 的文件，我是沒有遇到過誰這么寫過，初次聲明的時候 global 就行了，沒必要去鑽牛角尖。估計不能起作用的問題是，include_once 只引入一次文件，第二次 include_once同一文件的時候是忽略的，換成 include 的試試。
⑹ 求一個php寫的DB類
這個是ECSHOP的資料庫類，你可以參考一下：
class cls_mysql
{
var $link_id = NULL;
var $settings = array();
var $queryCount = 0;
var $queryTime = '';
var $queryLog = array();
var $max_cache_time = 300; // 最大的緩存時間，以秒為單位
var $cache_data_dir = 'temp/query_caches/';
var $root_path = '';
var $error_message = array();
var $platform = '';
var $version = '';
var $dbhash = '';
var $starttime = 0;
var $timeline = 0;
var $timezone = 0;
var $mysql_config_cache_file_time = 0;
var $mysql_disable_cache_tables = array(); // 不允許被緩存的表，遇到將不會進行緩存
function __construct($dbhost, $dbuser, $dbpw, $dbname = '', $charset = 'gbk', $pconnect = 0, $quiet = 0)
{
$this->cls_mysql($dbhost, $dbuser, $dbpw, $dbname, $charset, $pconnect, $quiet);
}
function cls_mysql($dbhost, $dbuser, $dbpw, $dbname = '', $charset = 'gbk', $pconnect = 0, $quiet = 0)
{
if (defined('EC_CHARSET'))
{
$charset = strtolower(str_replace('-', '', EC_CHARSET));
}
if (defined('ROOT_PATH') && !$this->root_path)
{
$this->root_path = ROOT_PATH;
}
if ($quiet)
{
$this->connect($dbhost, $dbuser, $dbpw, $dbname, $charset, $pconnect, $quiet);
}
else
{
$this->settings = array(
'dbhost' => $dbhost,
'dbuser' => $dbuser,
'dbpw' => $dbpw,
'dbname' => $dbname,
'charset' => $charset,
'pconnect' => $pconnect
);
}
}
function connect($dbhost, $dbuser, $dbpw, $dbname = '', $charset = 'utf8', $pconnect = 0, $quiet = 0)
{
if ($pconnect)
{
if (!($this->link_id = @mysql_pconnect($dbhost, $dbuser, $dbpw)))
{
if (!$quiet)
{
$this->ErrorMsg("Can't pConnect MySQL Server($dbhost)!");
}
return false;
}
}
else
{
if (PHP_VERSION >= '4.2')
{
$this->link_id = @mysql_connect($dbhost, $dbuser, $dbpw, true);
}
else
{
$this->link_id = @mysql_connect($dbhost, $dbuser, $dbpw);
mt_srand((double)microtime() * 1000000); // 對 PHP 4.2 以下的版本進行隨機數函數的初始化工作
}
if (!$this->link_id)
{
if (!$quiet)
{
$this->ErrorMsg("Can't Connect MySQL Server($dbhost)!");
}
return false;
}
}
$this->dbhash = md5($this->root_path . $dbhost . $dbuser . $dbpw . $dbname);
$this->version = mysql_get_server_info($this->link_id);
/* 如果mysql 版本是 4.1+ 以上，需要對字元集進行初始化 */
if ($this->version > '4.1')
{
if ($charset != 'latin1')
{
mysql_query("SET character_set_connection=$charset, character_set_results=$charset, character_set_client=binary", $this->link_id);
}
if ($this->version > '5.0.1')
{
mysql_query("SET sql_mode=''", $this->link_id);
}
}
$sqlcache_config_file = $this->root_path . $this->cache_data_dir . 'sqlcache_config_file_' . $this->dbhash . '.php';
@include($sqlcache_config_file);
$this->starttime = time();
if ($this->max_cache_time && $this->starttime > $this->mysql_config_cache_file_time + $this->max_cache_time)
{
if ($dbhost != '.')
{
$result = mysql_query("SHOW VARIABLES LIKE 'basedir'", $this->link_id);
$row = mysql_fetch_assoc($result);
if (!empty($row['Value']{1}) && $row['Value']{1} == ':' && !empty($row['Value']{2}) && $row['Value']{2} == "\\")
{
$this->platform = 'WINDOWS';
}
else
{
$this->platform = 'OTHER';
}
}
else
{
$this->platform = 'WINDOWS';
}
if ($this->platform == 'OTHER' &&
($dbhost != '.' && strtolower($dbhost) != 'localhost:3306' && $dbhost != '127.0.0.1:3306') ||
(PHP_VERSION >= '5.1' && date_default_timezone_get() == 'UTC'))
{
$result = mysql_query("SELECT UNIX_TIMESTAMP() AS timeline, UNIX_TIMESTAMP('" . date('Y-m-d H:i:s', $this->starttime) . "') AS timezone", $this->link_id);
$row = mysql_fetch_assoc($result);
if ($dbhost != '.' && strtolower($dbhost) != 'localhost:3306' && $dbhost != '127.0.0.1:3306')
{
$this->timeline = $this->starttime - $row['timeline'];
}
if (PHP_VERSION >= '5.1' && date_default_timezone_get() == 'UTC')
{
$this->timezone = $this->starttime - $row['timezone'];
}
}
$content = '<' . "?php\r\n" .
'$this->mysql_config_cache_file_time = ' . $this->starttime . ";\r\n" .
'$this->timeline = ' . $this->timeline . ";\r\n" .
'$this->timezone = ' . $this->timezone . ";\r\n" .
'$this->platform = ' . "'" . $this->platform . "';\r\n?" . '>';
@file_put_contents($sqlcache_config_file, $content);
}
/* 選擇資料庫 */
if ($dbname)
{
if (mysql_select_db($dbname, $this->link_id) === false )
{
if (!$quiet)
{
$this->ErrorMsg("Can't select MySQL database($dbname)!");
}
return false;
}
else
{
return true;
}
}
else
{
return true;
}
}
function select_database($dbname)
{
return mysql_select_db($dbname, $this->link_id);
}
function set_mysql_charset($charset)
{
/* 如果mysql 版本是 4.1+ 以上，需要對字元集進行初始化 */
if ($this->version > '4.1')
{
if (in_array(strtolower($charset), array('gbk', 'big5', 'utf-8', 'utf8')))
{
$charset = str_replace('-', '', $charset);
}
if ($charset != 'latin1')
{
mysql_query("SET character_set_connection=$charset, character_set_results=$charset, character_set_client=binary", $this->link_id);
}
}
}
function fetch_array($query, $result_type = MYSQL_ASSOC)
{
return mysql_fetch_array($query, $result_type);
}
function query($sql, $type = '')
{
if ($this->link_id === NULL)
{
$this->connect($this->settings['dbhost'], $this->settings['dbuser'], $this->settings['dbpw'], $this->settings['dbname'], $this->settings['charset'], $this->settings['pconnect']);
$this->settings = array();
}
if ($this->queryCount++ <= 99)
{
$this->queryLog[] = $sql;
}
if ($this->queryTime == '')
{
if (PHP_VERSION >= '5.0.0')
{
$this->queryTime = microtime(true);
}
else
{
$this->queryTime = microtime();
}
}
/* 當當前的時間大於類初始化時間的時候，自動執行 ping 這個自動重新連接操作 */
if (PHP_VERSION >= '4.3' && time() > $this->starttime + 1)
{
mysql_ping($this->link_id);
}
if (!($query = mysql_query($sql, $this->link_id)) && $type != 'SILENT')
{
$this->error_message[]['message'] = 'MySQL Query Error';
$this->error_message[]['sql'] = $sql;
$this->error_message[]['error'] = mysql_error($this->link_id);
$this->error_message[]['errno'] = mysql_errno($this->link_id);
$this->ErrorMsg();
return false;
}
if (defined('DEBUG_MODE') && (DEBUG_MODE & 8) == 8)
{
$logfilename = $this->root_path . DATA_DIR . '/mysql_query_' . $this->dbhash . '_' . date('Y_m_d') . '.log';
$str = $sql . "\n\n";
if (PHP_VERSION >= '5.0')
{
file_put_contents($logfilename, $str, FILE_APPEND);
}
else
{
$fp = @fopen($logfilename, 'ab+');
if ($fp)
{
fwrite($fp, $str);
fclose($fp);
}
}
}
return $query;
}
function affected_rows()
{
return mysql_affected_rows($this->link_id);
}
function error()
{
return mysql_error($this->link_id);
}
function errno()
{
return mysql_errno($this->link_id);
}
function result($query, $row)
{
return @mysql_result($query, $row);
}
function num_rows($query)
{
return mysql_num_rows($query);
}
function num_fields($query)
{
return mysql_num_fields($query);
}
function free_result($query)
{
return mysql_free_result($query);
}
function insert_id()
{
return mysql_insert_id($this->link_id);
}
function fetchRow($query)
{
return mysql_fetch_assoc($query);
}
function fetch_fields($query)
{
return mysql_fetch_field($query);
}
function version()
{
return $this->version;
}
function ping()
{
if (PHP_VERSION >= '4.3')
{
return mysql_ping($this->link_id);
}
else
{
return false;
}
}
function escape_string($unescaped_string)
{
if (PHP_VERSION >= '4.3')
{
return mysql_real_escape_string($unescaped_string);
}
else
{
return mysql_escape_string($unescaped_string);
}
}
function close()
{
return mysql_close($this->link_id);
}
function ErrorMsg($message = '', $sql = '')
{
if ($message)
{
echo "<b>ECSHOP info</b>: $message\n\n<br /><br />";
//print('<a href="http://faq.comsenz.com/?type=mysql&dberrno=2003&dberror=Can%27t%20connect%20to%20MySQL%20server%20on" target="_blank">http://faq.comsenz.com/</a>');
}
else
{
echo "<b>MySQL server error report:";
print_r($this->error_message);
//echo "<br /><br /><a href='http://faq.comsenz.com/?type=mysql&dberrno=" . $this->error_message[3]['errno'] . "&dberror=" . urlencode($this->error_message[2]['error']) . "' target='_blank'>http://faq.comsenz.com/</a>";
}
exit;
}
/* 模擬 Adodb 函數 */
function selectLimit($sql, $num, $start = 0)
{
if ($start == 0)
{
$sql .= ' LIMIT ' . $num;
}
else
{
$sql .= ' LIMIT ' . $start . ', ' . $num;
}
return $this->query($sql);
}
function getOne($sql, $limited = false)
{
if ($limited == true)
{
$sql = trim($sql . ' LIMIT 1');
}
$res = $this->query($sql);
if ($res !== false)
{
$row = mysql_fetch_row($res);
if ($row !== false)
{
return $row[0];
}
else
{
return '';
}
}
else
{
return false;
}
}
function getOneCached($sql, $cached = 'FILEFIRST')
{
$sql = trim($sql . ' LIMIT 1');
$cachefirst = ($cached == 'FILEFIRST' || ($cached == 'MYSQLFIRST' && $this->platform != 'WINDOWS')) && $this->max_cache_time;
if (!$cachefirst)
{
return $this->getOne($sql, true);
}
else
{
$result = $this->getSqlCacheData($sql, $cached);
if (empty($result['storecache']) == true)
{
return $result['data'];
}
}
$arr = $this->getOne($sql, true);
if ($arr !== false && $cachefirst)
{
$this->setSqlCacheData($result, $arr);
}
return $arr;
}
⑺ 在PHP中$db=new DB();是什麼意思
new 是實例化一個對象
而DB 就是那個對象的名稱 也可以叫類名
$db = new DB; // 將DB這個對象實例化後賦予變數$db
$db->query(); // 那麼這個query()函數 就是DB類里的一個方法
⑻ db.php這裡面這是什麼意思呀，資料庫什麼的
db.php是一個php頁面，不是資料庫，而且也不知道用的什麼資料庫
PHP（外文名:PHP: Hypertext Preprocessor，中文名：「超文本預處理器」）是一種通用開源腳本語言。語法吸收了C語言、Java和Perl的特點，利於學習，使用廣泛，主要適用於Web開發領域。PHP 獨特的語法混合了C、Java、Perl以及PHP自創的語法。它可以比CGI或者Perl更快速地執行動態網頁。
⑼ php+txtdb 新手教程
我對 TXTDB 還算比較自信。你有興趣來找我。 42696883
⑽ PHP語句中的 $db->query($sql); 請問這個->符號是什麼 以及他的作用。
$db 是一個實例化好的資料庫類，query是這個類裡面的一個方法，$db->query($sql); 就是訪問$db類里的query方法，->相當於訪問類裡面方法的一個語法而已。操作方法如下：
1、首先寫上這個程序的注釋內容，#創建一個類並實例化它。
