PHP Tutorial MSSQL Database Tutorial Connection Class code
The code is as follows |
Copy Code |
Class Db_sql { var $Host = ""; var $Database = ""; var $User = ""; var $Password = ""; var $Link _id = 0; var $Query _id = 0; var $Record = array (); var $Row = 0;
var $Errno = 0; var $Error = ""; var $Auto _free = 0; # # Set this to 1 to automatically free results
* Public:constructorwww.111cn.net * * function Db_sql ($query = "") { $this->query ($query); } function Connect () { if (0 = = $this->link_id) { $this->link_id=mssql_connect ($this->host, $this->user, $this->password); if (! $this->link_id) $this->halt ("Link-id = = False, Mssql_pconnect failed"); Else @mssql_select_db ($this->database, $this->link_id); } } function Free_result () { Mssql_free_result ($this->query_id); $this->query_id = 0; }
function query ($Query _string) {
/* No empty queries, please, since PHP4 chokes on them. */ if ($Query _string = "") /* The empty query string is passed on from the constructor, * When calling the class without a query, e.g. in situations * like: ' $db = new Db_sql_subclass; ' */ return 0; if (! $this->link_id) $this->connect ();
# printf ("<br>debug:query =%s<br>", $Query _string); |