解析用PHP操作MySql数据库(DB类)(3)_PHP教程
教程Tag：暂无Tag,欢迎添加,赚取U币!
推荐：浅析php如何判断来访网页地址php利用系统函数HTTP_REFERER判断来访的网页地址 如注册用户时必须是来自某网址的 $str=@$_SERVER[’HTTP_REFERER’];//@为除错功能 if(strstr($str,www.code-123.com))// echo来自www.code-123.com; else echo其它网址;
//错误提示
function halt(the_error=""){
message = the_error."<br/>\r\n";
message.= this->get_errno() . "<br/>\r\n";
sql = "INSERT INTO `db_error`(pagename, errstr, timer) VALUES(’"._SERVER["PHP_SELF"]."’, ’".addslashes(message)."’, ".time().")";
@mysql_unbuffered_query(sql);
if (DEBUG==true){
echo "<html><head><title>MySQL 数据库错误</title>";
echo "<style type=\"text/css\"><!--.error { font: 11px tahoma, verdana, arial, sans-serif, simsun; }--></style></head>\r\n";
echo "<body>\r\n";
echo "<blockquote>\r\n";
echo "<textarea class=\"error\" rows=\"15\" cols=\"100\" wrap=\"on\" >" . htmlspecialchars(message) . "</textarea>\r\n";
echo "</blockquote>\r\n</body></html>";
exit;
}
}
function __destruct(){
this->shutdown_queries = array();
this->close_db();
}
function sql_select(tbname, where="", limit=0, fields="*", orderby="id", sort="DESC"){
sql = "SELECT ".fields." FROM `".tbname."` ".(where?" WHERE ".where:"")." ORDER BY ".orderby." ".sort.(limit ? " limit ".limit:"");
return sql;
}
function sql_insert(tbname, row){
foreach (row as key=>value) {
sqlfield .= key.",";
sqlvalue .= "’".value."’,";
}
return "INSERT INTO `".tbname."`(".substr(sqlfield, 0, -1).") VALUES (".substr(sqlvalue, 0, -1).")";
}
function sql_update(tbname, row, where){
foreach (row as key=>value) {
sqlud .= key."= ’".value."’,";
}
return "UPDATE `".tbname."` SET ".substr(sqlud, 0, -1)." WHERE ".where;
}
function sql_delete(tbname, where){
return "DELETE FROM `".tbname."` WHERE ".where;
}
//新增加一条记录
function row_insert(tbname, row){
sql = this->sql_insert(tbname, row);
return this->query_unbuffered(sql);
}
//更新指定记录
function row_update(tbname, row, where){
sql = this->sql_update(tbname, row, where);
return this->query_unbuffered(sql);
}
//删除满足条件的记录
function row_delete(tbname, where){
sql = this->sql_delete(tbname, where);
return this->query_unbuffered(sql);
}
分享：php教程之语言中switch的用法介绍?php $czc=reg; switch($czc){ case’reg’://注册 echo注册的代码; break;//如果注释掉此句,将执行下在的代码,否则终止 case’logout’://退出 echo退出的代码; break; default://此代码除了reg,logout外其它的都是执行以下面的代码 include’user/in
相关PHP教程：
- 相关链接：
- 教程说明：
PHP教程-解析用PHP操作MySql数据库(DB类)(3)
。