Source Code - Cut and paste from the Source Code field. Website Information Author Bradley Buskey Email deckyon@gmail.com Website http://scripts.deckyon.com Script Name Template - DB Functions Language PHP Purpose This is the function file that interacts with the database. FYI: This website is based on this template! Source Code - Use <CTRL> - <A> to select all and then <CTRL> - <C> to Copy the text. <?php // ToDo: Update the database information define ("Template", "1.5"); define ("DB_SERVER", ""); define ("DB_DATABASE", ""); define ("DB_USER", ""); define ("DB_PASS", ""); class DB { var $Host = DB_SERVER; var $Database = DB_DATABASE; var $User = DB_USER; var $Password = DB_PASS; var $Link_ID = 0; var $Query_ID = 0; var $Record = array(); var $Row; var $Errno = 0; var $Error = ""; function DB($altHost = "",$altDB = "",$altUser = "",$altPassword = "") { if ($altHost == "") $altHost = $this->Host; if ($altDB == "") $altDB = $this->Database; if ($altUser == "") $altUser = $this->User; if ($altPassword == "") $altPassword = $this->Password; $this->Host = $altHost; $this->Database = $altDB; $this->User = $altUser; $this->Password = $altPassword; } function halt($msg) { echo("<B>Database error:</B> $msg<BR>\n"); echo("<B>MySQL error</B>: $this->Errno ($this->Error)\n"); die("Session halted."); } function connect() { global $DBType; if($this->Link_ID == 0) { $this->Link_ID = mysql_connect($this->Host,$this->User,$this->Password); if (!$this->Link_ID) { $this->halt("Link_ID == false, connect failed"); } $SelectResult = mysql_select_db($this->Database, $this->Link_ID); if(!$SelectResult) { $this->Errno = mysql_errno($this->Link_ID); $this->Error = mysql_error($this->Link_ID); $this->halt("cannot select database <I>".$this->Database."</I>"); } } } function query($Query_String) { $this->connect(); $this->Query_ID = mysql_query($Query_String,$this->Link_ID); $this->Row = 0; $this->Errno = mysql_errno(); $this->Error = mysql_error(); if (!$this->Query_ID) { $this->halt("Invalid SQL: ".$Query_String); } return $this->Query_ID; } function next_record() { $this->Record = mysql_fetch_array($this->Query_ID); $this->Row += 1; $this->Errno = mysql_errno(); $this->Error = mysql_error(); $stat = is_array($this->Record); if (!$stat) { mysql_free_result($this->Query_ID); $this->Query_ID = 0; } return $this->Record; } function num_rows() { return mysql_num_rows($this->Query_ID); } function affected_rows() { return mysql_affected_rows($this->Link_ID); } function insert_id() { return mysql_insert_id($this->Link_ID); } function optimize($tbl_name) { $this->connect(); $this->Query_ID = @mysql_query("OPTIMIZE TABLE $tbl_name",$this->Link_ID); } function clean_results() { if($this->Query_ID != 0) mysql_freeresult($this->Query_ID); } function close() { if($this->Link_ID != 0) mysql_close($this->Link_ID); } } ?>

Deckyon's Script Center - Select a script to see the source code and purpose. View Script Name Language Author Email Website SysInfo VBS Bradley Buskey GroupMembers VBS Bradley Buskey UserInfo VBS Bradley Buskey WB Emailer WinBatch Bradley Buskey GeoConvert WinBatch Bradley Buskey CheckWks WinBatch Bradley Buskey Template - View PHP/HTML Bradley Buskey Template - Admin PHP/HTML Bradley Buskey Template - DB Functions PHP Bradley Buskey Template - Table SQL Bradley Buskey Rollover Javascript Bradley Buskey Restore Desktop VBS Bradley Buskey User Backup VBS Bradley Buskey Printer Map VBS Bradley Buskey Ghost Server VBS Bradley Buskey Profile Remover VBS Bradley Buskey