 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
The program below is intended for database programmers using Visual Basic and who uses ODBC to connect on a database. During my first season with PHP, it was really a learning curve for me, especially when i access my database and i really had fun, but i find it hard typing so many commands over and over again so I thought maybe I could make it more easier by creating database objects. Now onto our PHP Database Objects codes. Open a notepad.exe or any editor you wish to make your scripts with. I use notepad.exe. Copy the codes and save your file as phpdbo.php (which is stands for "PHP Database Objects"). <?php /*-------------------------------------------------------------- */ /* PHP DATABASE OBJECTS (PHPDBO.PHP) */ /*-------------------------------------------------------------- */ /* Author : Santiago B. Calo III */ /* Email : myownphp@yahoo.com */ /* As of now, all of the codes below support ODBC only, */ /* but you can modify my codes in order to fit your needs */ /* */ /* note: if you use this code, don't omit this header */ /*-------------------------------------------------------------- */ /* Create an class for database connectivity */ class odbc { /* Set connection variables */ var $record_set,$con_nect,$cur_sur,$dbtype,$num_rows,$current_rec,$cur_field, $current_row; /* Create an object to set the cursor of the database */ function cursorname($cursor){ $this->cur=$cursor; } /*-----------------------------------*/ /* Connects to the remote database */ /* $domain = data source name */ /* $userid = user id */ /* $passwd = password */ /* $cursr = type of cursor */ /*-----------------------------------*/ /* Create an object to connect to the database/ODBC */ function opendb($domain,$userid,$passwd,$cursr){ $this->con_nek = odbc_connect($domain,$userid,$passwd,$cursr); /* means odbc_connect($dsn,$uid,$pwd,$cur) */ if (!$this->con_nek){ return $this->con_nek; break; } else{ return $this->con_nek; } } /*----------------------------------------- */ /* execute an sql query for the recordset */ /* $SqlQuery = the sql statement */ /*----------------------------------------- */ function openrs($sqlstatement){ $this->record_set = odbc_exec($this->con_nek,$sqlstatement); /* get the result */ while (odbc_fetch_row($this->record_set)){ $this->num_rows += 1; /* count the number of rows */ } $this->current_rec = odbc_fetch_row($this->record_set,1); /* gets the current row */ $this->current_row = 1; /* reset row (first row) */ return $this->record_set; } /*-----------------------------------*/ /* display the value of the field */ /* $dbtype = sql server type */ /* $kword = column name */ /*-----------------------------------*/ function getfield($kword){ $this->field = odbc_result($this->record_set,$kword); /* get the value of the column */ return $this->field; /* return the value */ } // move to the first record function movetofirst(){ $this->current_row=1; $this->current_rec = odbc_fetch_row($this->record_set,1); } // move to the next record function movetonext(){ $this->current_row+=1; /* move to the next row */ if ($this->current_row <= $this->num_rows){ /* see if current row is less than the number of rows returned */ $this->current_rec = odbc_fetch_row($this->record_set,$this->current_row); /* set current row */ } } // move to the previous record function movetoprev(){ $this->current_row-=1; /* move to the previous row */ if (!$this->current_row < 1){ /* see if current row is greater than 0 */ $this->current_rec = odbc_fetch_row($this->record_set,$this->current_row); /* set current row */ } } // move to the last record function movetolast(){ $this->current_row = $this->num_rows; /* move to the last row */ $this->current_rec = odbc_fetch_row($this->record_set,$this->current_row); /* set current row */ } function eof(){ if ($this->current_row > $this->num_rows) /* see if last row is reached */ { $this->current_row = $this->num_rows; /* if current row passes the number of rows, set it back to the last row */ return true; /* returns true if current row is the last row */ } else { return false; /* returns false if current row is less than the number of rows */ } } function bof(){ if ($this->current_row < 1) /* see if first row is reached */ { $this->current_row = 1; /* if current row passes the first row, set it back to the first row */ return true; /* returns true if current row is the first row */ } else { return false;/* returns false if current row is not yet the first row */ } } function close(){ odbc_close($this->con_nek); } function free(){ odbc_free_result($this->record_set); } } ?> Contratulations, you now have in your posession a kewl tool to access ODBC database the Object Oriented Way. Let's try out the PHPDBO.PHP Creating the php script First of all we must include our PHPDBO since it is stored in another filename. You may use include() or require(), currently I am using require(). Using the PHPDBO.PHP <?php require('phpdbo.php'); /* include the PHP Database Objects */ $my_odbc = new odbc; /* create object connection */ $dbtype="odbc"; $dsn="My ODBC"; $usr="admin"; $pwd=""; $cursr="SQL_CUR_DEFAULT"; $my_odbc->opendb($dbtype,$dsn,$usr,$pwd,$cursr); /* connect to database */ /* set sql statement */ $my_sql = "select * from database"; /* get result from database */ $my_odbc->openrs($my_odbc,$my_sql); $my_odbc->movetofirst(); /* move to first row */ /* display all fields */ while (!$my_odbc->eof()){ print $my_odbc->getfield("author"); /* displays the field */ print "<br>"; $my_odbc->movetonext(); } print "<p> note the fields above if the movetonext(), movetolast(), movetoprev(), movetofirst(), corresponds below : "; print "<p> move to first row<br>"; $my_odbc->movetofirst(); print $my_odbc->getfield("author"); print "<p>move to last row<br>"; $my_odbc->movetolast(); print $my_odbc->getfield("author"); print "<p> move to prev row<br>"; $my_odbc->movetoprev(); print $my_odbc->getfield("author"); print "<p> move to first row<br>"; $my_odbc->movetofirst(); print $my_odbc->getfield("author"); print "<p> move to next row<br>"; $my_odbc->movetonext(); print $my_odbc->getfield("author"); print "<p> move to prev row<br>"; $my_odbc->movetoprev(); print $my_odbc->getfield("author"); print "<p>"; $my_odbc->free() /* clear out the memory */ $my_odbc->close(); /* close connection */ ?> Thats all folks, enjoy and have a nice coding =). Some features will be added shortly. Example /* display all fields */ while (!$my_odbc->eof()){ print $my_odbc->getfield("author"); /* displays the field */ print "<br>"; $my_odbc->movetonext(); } /*note : connect to access database only.... mysql is still under contruction */ | |||||
| Related Code Examples | |||||
