Helix Installation   Getting Started   Reference Documentation   Global Functions   Quick Start
ModulesClassesFunctions
 

Class Reference

class mssql

Helixmssql
Hide Inherited MembersHelix Core
Description
No description.
 
Constants
No constants.
 
Properties
publicdatabase[ mssql ]
publicerror[ mssql ]
publichost[ mssql ]
publicinsert_id[ mssql ]
publicle[ mssql ]
publicpassword[ mssql ]
publicport[ mssql ]
publicre[ mssql ]
publicrecord[ mssql ]
publicrow[ mssql ]
publicserver_type[ mssql ]
publicusername[ mssql ]
 
Methods
publicconnect ( )[ mssql ]
Parameters
No parameters for this method
Code
029  public function connect(){
030      if ($this->lid == 0)
031      {
032          try
033          {
034              $this->lid = mssql_connect("$this->host,$this->port",$this->username,$this->password);
035          }
036          catch (Exception $e)
037          {
038              echo "<BR>Exception: ".$e->getMessage()."\n";
039              echo "<BR>Can't connect to ".$this->host." using user:".$this->username."\n";
040          }
041          if (!$this->lid)
042          {
043              $this->halt("Cannot connect to database host: $this->host",true);
044              return false;
045          }
046      }
047 
048      if (strlen($this->database) > 0)
049      {
050          if (!@mssql_select_db($this->database))
051          {
052              $this->halt("Cannot connect to database: " . $this->database);
053              return false;
054          }
055      }
056      return $this->lid;
057  }
public__construct ( host , database , username , password , port ["1433"] )[ mssql ]
Parameters
optionalhost
optionaldatabase
optionalusername
optionalpassword
optionalport ["1433"]
Code
017  public function __construct($__host=null,$__database=null,$__username=null,$__password=null,$__port=db::MSSQL_PORT){
018      $this->host = (is_null($__host))?$this->host:$__host;
019      $this->database = (is_null($__database))?$this->database:$__database;
020      $this->username = (is_null($__username))?$this->username:$__username;
021      $this->password = (is_null($__password))?$this->password:$__password;
022      $this->port = (is_null($__port))?$this->port:$__port;
023      $this->lid=0;
024     
025      $this->le = db::MSSQL_LE;
026      $this->re = db::MSSQL_RE;
027  }
publicget_prefixes ( )[ mssql ]
Parameters
No parameters for this method
Code
071  public function get_prefixes(){
072      return null;
073  }
publicget_tables ( search )[ mssql ]
Parameters
requiredsearch
Code
075  public function get_tables($__search){
076      return null;
077  }
publicget_views ( )[ mssql ]
Parameters
No parameters for this method
Code
079  public function get_views(){
080      return null;
081  }
publicparam_string ( value )[ mssql ]
Parameters
requiredvalue
Code
067  public function param_string($__value){
068      return null;
069  }
publicquery ( q )[ mssql ]
Parameters
requiredq
Code
059  public function query($__q){
060      return null;
061  }
publicvalue_string ( value )[ mssql ]
Parameters
requiredvalue
Code
063  public function value_string($__value){
064      return null;
065  }
 
Accessors
publicprefixes[ mssql ]
Code
071  public function get_prefixes(){
072      return null;
073  }
publictables[ mssql ]
Code
075  public function get_tables($__search){
076      return null;
077  }
publicviews[ mssql ]
Code
079  public function get_views(){
080      return null;
081  }
Get Helix PHP Framework at SourceForge.net. Fast, secure and Free Open Source software downloads