Mysql封装类 php 数据库 操作类 db 数据库

Another unpolished class. Those take time to polish it up please do inform me. This class has been used extensively in my web project and I really find that it is very much convenient to use. This is the way to use it: ------------------------------------------------ INITIALIZATION: include_once "class_mysql.php"; $my_db = new MYSQL("server", "user", "passwd", "database to use"); ------------------------------------------------ DO A QUERY EXPECTING INPUT $stmt = "SELECT * ...."; $status = $my_db->RunDB($stmt); if ($status != "OK") { echo "FAIL"; die; } now the number of records retreived is stored in $no_rec = $my_db->no_rows; to retrieve individual fields, say field name is "A", "B", C" for ($i = 0; $i < $no_rec; $i ++) // record number { $fieldA=$my_db->row[$i]['A']; $fieldA=$my_db->row[$i]['B']; $fieldA=$my_db->row[$i]['C']; ... do your processing. } IF you don't know about the field names, here's what you can do: for ($j = 0; $j < $my_db->no_fields; $j ++) $field_name[j] = $my_db->field[$j]; no_fields contains no of fields within a record. each field name is contained in $my_db->field[$j] --------------------------------------------------- DO A SQL STATEMENT NOT EXPECTING OUTPUT If you do a insert or update, you do not expect the array $my_db->row to be filled, so you specify a 0 after the RunDB statement: $stmt="INSERT INTO table (a,b,c) VALUES(1,2,3);"; $status = $my_db->RunDB($stmt, 0); if ($status != "OK") { echo "FAILED: $status"; die; } ------------------------------------------------------ USE THE BUILT IN HTML OUTPUT Pretty but seldom used function. This is for me to displayed an unknown SQL table data. $status = $my_db->RunDB("select * from user;"); if ($status != "OK") { echo "<HR>DB Error: $status.<HR>"; die; } $mysql->ShowHTML("table_header","row header","cell header"); The HTML output will be something like: <TABLE table_header> <TR row_header> <TD cell_header> value ....