Ec (2); Next let's take a look at how php imports the. SQL File Code & lt ;? Phpif (! Defined (WEBROOT) {& nbsp; die (AccessDenied !);} Classdbsql {& nbsp; var $ dblinkNULL; & nbsp; var $ queryCount0; & nbsp; functiondbconnect ($ script ec (2); script
Next let's take a look at how php imports the. SQL file code.
If (! Defined ('webroot ')){
Die ('Access Denied! ');
}
Class dbsql {
Var $ dblink = NULL;
Var $ queryCount = 0;
Function dbconnect ($ dbserver, $ dbuser, $ dbpwd, $ dbname = '', $ pconnect = 0, $ charset = 'utf8 '){
If ($ pconnect ){
If (! $ This-> dblink = @ mysql_pconnect ($ dbserver, $ dbuser, $ dbpwd )){
$ This-> msghalt ('can not connect to MySQL Server ');
}
} Else {
If (! $ This-> dblink = @ mysql_connect ($ dbserver, $ dbuser, $ dbpwd )){
$ This-> msghalt ('can not connect to MySQL Server ');
}
}
/* If ($ this-> version ()> '4. 1 '){
Global $ charset, $ dbcharset;
If (! $ Dbcharset & in_array (strtolower ($ charset), array ('gbk', 'big5', 'utf-8 '))){
$ Dbcharset = str_replace ('-', '', $ charset );
}
If ($ dbcharset ){
@ Mysql_query ("SET character_set_connection = $ dbcharset, character_set_results = $ dbcharset, character_set_client = binary", $ this-> dblink );
}
If ($ this-> version ()> '5. 0.1 '){
@ Mysql_query ("SET SQL _mode ='' ", $ this-> dblink );
}
}*/
@ Mysql_query ('set names "utf8 "');
If ($ dbname ){
If (! Mysql_select_db ($ dbname, $ this-> dblink )){
$ This-> msghalt ('can not connect to MySQL Server ');
}
}
}
Function select_db ($ dbname ){
Return @ mysql_select_db ($ dbname, $ this-> dblink );
}
Function query ($ SQL = ''){
If ($ SQL ){
If (! ($ Query = mysql_query ($ SQL, $ this-> dblink ))){
$ This-> msghalt ("MYSQL Query Error! N $ SQL ");
} Else {
$ This-> queryCount ++;
Return $ query;
}
} Else {
Return false;
}
}
Function unb_query ($ SQL = ''){
If ($ SQL ){
If (! ($ Query = mysql_unbuffered_query ($ SQL, $ this-> dblink ))){
$ This-> msghalt ('mysql Query Error!
'. $ SQL .'
');
} Else {
$ This-> queryCount ++;
Return $ query;
}
} Else {
Return false;
}
}
Function fetch_array ($ query, $ result_type = MYSQL_ASSOC ){
Return mysql_fetch_array ($ query, $ result_type );
}
Function fetch_one ($ SQL ){
Return $ this-> fetch_array ($ this-> query ($ SQL ));
}
Function affected_rows (){
Return mysql_affected_rows ($ this-> dblink );
}
Function num_rows ($ query, $ q = 1)
{
If ($ q = 1 ){
Return mysql_num_rows ($ query );
} Else {
Return mysql_num_rows ($ this-> query ($ query ));
}
// Return $ query;
}
Function result ($ query, $ row ){
$ Query = @ mysql_result ($ query, $ row );
Return $ query;
}
Function num_row ($ query) {// useless for the moment
Return mysql_num_rows ($ query );
}
Function free_result ($ query ){
Return mysql_free_result ($ query );
}
Function insert_id (){
Return ($ id = mysql_insert_id ($ this-> dblink)> = 0? $ Id: $ this-> result ($ this-> query ("SELECT last_insert_id ()"));
}
Function num_fields ($ query ){
Return mysql_num_fields ($ query );
}
Function version (){
Return mysql_get_server_info ($ this-> dblink );
}
Function close (){
Return mysql_close ($ this-> dblink );
}
Function insert_data ($ tname, $ data ){
$ Values = '';
$ Filed = implode (',', array_keys ($ data ));
$ Filednum = count ($ data)-1;
// Echo $ filednum;
$ I = 0;
Foreach ($ data as $ key => $ val ){
$ Values. = "'". $ val ."'";
If ($ I <$ filednum ){
$ I ++;
$ Values. = ',';
}
}
$ SQL = "INSERT INTO". $ tname. "(". $ filed. ") VALUES (". $ values .")";
Return $ this-> unb_query ($ SQL );
}
Function update_data ($ tname, $ fid, $ data, $ whereid = 'id '){
$ Col = array ();
Foreach ($ data as $ key => $ values)
{
$ Col [] = $ key. "= '". $ values ."'";
}
$ SQL = "UPDATE". $ tname. "SET". implode (',', $ col). "WHERE $ whereid = '$ fid '";
Return $ this-> unb_query ($ SQL );
}
Function error (){
Return ($ this-> dblink )? Mysql_error ($ this-> dblink): mysql_error ());
}
Function errno (){
Return intval ($ this-> dblink )? Mysql_errno ($ this-> dblink): mysql_errno ());
}
Function msghalt ($ msg = ''){
$ Message ="NN ";
$ Message. =" N ";
$ Message. ="N ";
$ Message. ="N ";
$ Message. ="N ";
$ Message. ="
Datebase Error:
".htmlspecialchars($msg)."
N ";
$ Message. ="
Mysql error number: ". $ This-> errno ()." n
";
$ Message. ="
Mysql error description: ". Htmlspecialchars ($ this-> error ()." n
";
$ Message. ="
Date: ". Date (" Y-m-d @ H: I ")." n
";
$ Message. ="
Script: Http: // ". $ _ SERVER ['HTTP _ host']. $ _ SERVER ['php _ SELF '].'? '. $ _ SERVER ['query _ string']. "n
";
$ Message. ="N";
Echo $ message;
Exit;
}
}
/**********************
$ Sb = new dbsql ();
$ Sb-> dbconnect ('localhost', 'root', '', 'fdwp ');
Echo 'fdfs ';
****************************/
?>