PHP Basic Tutorials ,PHP Sources Code,PHP Online Example

Algorithms Arrays Passwords Uncategorized
Commerce Uncategorized
Databases Abstraction Layers Informix LDAP MS SQL MySQL ODBC PostgreSQL Uncategorized
Date & Time Calculators Conversion Translation Uncategorized
Discussion Chat Forums Guestbooks Polls Uncategorized
Email Validation Uncategorized
External Uncategorized
Files and Directories Uncategorized
Games Uncategorized
Graphics 3-D Graphs Resizing Thumbnails Uncategorized
HTML Forms Menus & Navigation Source Viewers Tables Templates Uncategorized
HTTP Authentication Cookies File Uploading Uncategorized
I18N Uncategorized
Math Uncategorized
Miscellaneous Uncategorized
Searching and Trees Uncategorized
Security Uncategorized
Text Uncategorized
Utilities Calendars Counters Link Checkers Weather Uncategorized
XML Uncategorized

php sample source codes
Can't get around the MSSQL 255 character read limit when fetching a row object? Here's a quick and dirty workaround... $query = "select substring(content,1,250) as content from page_content where page_content_id = $page_content_id"; $result = mssql_query($query,$dbconn); $row = mssql_fetch_object($result); $x=1; $content = ""; while ($row->content!="") { $content .= $row->content; $query = "select substring(content,(250*$x)+1,250) as content from page_content where page_content_id = $page_content_id"; $result = mssql_query($query,$dbconn); $row = mssql_fetch_object($result); $x++; } // while
Very simple to use this class for return query result and access to fields by its name from MSSQL database. Tested on php v. 3.x and 4.x with MS SQL Server 6.5 and 7.0 <? class Recordset { var $result, // result id $rowcount, // number of rows in result $curpos, // index of current row (begin=0, end=rowcount-1) $fieldcount, // number of fields in result $fn, // Array of fields names $rowset, // Array of fields with keys on field name $connection, // connection id $sql; // sql query //Constructor function Recordset($Sql,$Conn) { $this->connection=$Conn; $this->sql=$Sql; $this->fn=array(); $this->rowset=array(); $this->Query(); } // Execute query function Query() { $this->Close(); $this->result = @mssql_query($this->sql,$this->connection); if (!$this->result) return(0); $this->rowcount = @mssql_num_rows($this->result); $this->fieldcount = @mssql_num_fields($this->result); for ($i=1;$i<=$this->fieldcount;$i++) { $f=@mssql_fetch_field($this->result,$i-1); // Fill fields names array $this->fn[$i]=$f->name; } $this->curpos=0; } //Move to first record function MoveFirst() { $this->curpos=0; } //Return current row elements and move to next record function MoveNext() { if (!$this->result) return(0); if ($this->curpos==$this->rowcount) return(0); for($i=1;$i<=$this->fieldcount;$i++) $this->rowset[$this->fn[$i]] = @mssql_result($this->result,$this->curpos,$this->fn[$i]); $this->curpos++; return($this->rowset); } //Return true if last record function Eof() { if ($this->curpos==$this->rowcount-1) return(1); return(0); } //Return true if first record function Bof() { if (!$this->curpos) return(1); return(0); } // Free result if exist function Close() { if ($this->result && $this->rowcount) mssql_free_result($this->result); $this->result=0; $this->fn=array(); $this->rowset=array(); $this->rowcount=0; $this->fieldcount=0; } } ?>

php sample source codes

Can't get around the MSSQL 255 character read limit when fetching a row object? Here's a quick and dirty workaround...

Very simple to use this class for return query result and access to fields by its name from MSSQL database. Tested on php v. 3.x and 4.x with MS SQL Server 6.5 and 7.0

<?
  class Recordset {
  var $result,     // result id
      $rowcount,   // number of rows in result
      $curpos,     // index of current row (begin=0, end=rowcount-1)
      $fieldcount, // number of fields in result
      $fn,         // Array of fields names
      $rowset,     // Array of fields with keys on field name
      $connection, // connection id
      $sql;        // sql query

//Constructor

function Recordset($Sql,$Conn) {
    $this->connection=$Conn;
    $this->sql=$Sql;
    $this->fn=array();
    $this->rowset=array();
    $this->Query();
  }

// Execute query

function Query() {
    $this->Close();
    $this->result = @mssql_query($this->sql,$this->connection);
    if (!$this->result)
      return(0);
    $this->rowcount = @mssql_num_rows($this->result);
    $this->fieldcount = @mssql_num_fields($this->result);
    for ($i=1;$i<=$this->fieldcount;$i++) {
       $f=@mssql_fetch_field($this->result,$i-1);
// Fill fields names array
       $this->fn[$i]=$f->name;
    }
    $this->curpos=0;
  }

//Move to first record

function MoveFirst() {
    $this->curpos=0;
  }

//Return current row elements and move to next record

function MoveNext() {
    if (!$this->result) return(0);
    if ($this->curpos==$this->rowcount) return(0);
    for($i=1;$i<=$this->fieldcount;$i++)
      $this->rowset[$this->fn[$i]] = @mssql_result($this->result,$this->curpos,$this->fn[$i]);
    $this->curpos++;
    return($this->rowset);
  }

//Return true if last record

function Eof() {
    if ($this->curpos==$this->rowcount-1)
      return(1);
    return(0);
  }

//Return true if first record

function Bof() {
    if (!$this->curpos)
      return(1);
    return(0);
  }

// Free result if exist

function Close() {
    if ($this->result && $this->rowcount) 
      mssql_free_result($this->result);
    $this->result=0;
    $this->fn=array();
    $this->rowset=array();
    $this->rowcount=0;
    $this->fieldcount=0;
  }
}
?>

php.ComLanka.com PHP Tutorial ,PHP source code, PHP online example