Ec (2); & lt ;? Php & nbsp; dd & nbsp; new & nbsp; LampDb (localhost, root, 2184237, note, utf8); & nbsp; $ SQL & nbsp; & quot; select & nbsp; * & nbsp; from & nbsp; mynote & quot; script ec (2); script
- Dd =NewLampDb ('localhost', 'root', '123', 'note', 'utf8 ');
- $ SQL = "select * from mynote ";
- $ Handle = $ dd-> query ($ SQL );
- $ Aa = $ dd-> fetchOneRow ($ handle );
- Print_r ($ aa );
- Echo" ";
- $ Ddd = $ dd-> fetchRows ($ handle );
- For($ N = 0; $ n <count ($ ddd); $ n ++ ){
- Echo $ ddd [$ n] ['id']. "title". $ ddd [$ n] ['subobject'];
- Echo"
";
- }
- Echo" ";
- Echo "nums =". $ dd-> fetchRowNums ($ handle );
- ?>
- Php
- Class LampDb
- {
- Private $ conn;
- // Connect to the database
- Function _ construct ($ host, $ user, $ pass, $ dbname, $ charset)
- {
- $ This-> conn = mysql_connect ($ host, $ user, $ pass );
- Mysql_query ('set names $ charset ');
- $ Db = mysql_select_db ($ dbname, $ this-> conn );
- }
- // Query statement
- Function query ($ SQL)
- {
- $ Handle = mysql_query ($ SQL, $ this-> conn );
- Return $ handle;
- }
- // Query a record
- Function fetchOneRow ($ handle)
- {
- $ Aa = mysql_fetch_assoc ($ handle );
- Return $ aa;
- }
- // Query multiple records
- Function fetchRows ($ handle, $ I = 0)
- {
- While ($ bb = mysql_fetch_assoc ($ handle )){
- $ Bbb [$ I] = $ bb;
- $ I ++;
- }
- Return $ bbb;
- }
- // Obtain the number of records returned by a query statement
- Function fetchRowNums ($ handle)
- {
- // $ Handle = $ this-> query ($ SQL );
- $ Num = mysql_num_rows ($ handle );
- Return $ num;
- }
- }
- ?>