Code Examples -> Database and Recordset classes fo SyBASE Usage is obvious.

	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


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	Database and Recordset classes fo SyBASE Usage is obvious.
Categories :	Sybase, Databases, PHP Classes, PHP	Razvan Stanescu
Date :	Jan 17th 1999
Grade :	1 of 5 (graded 1 times)
Viewed :	6599
File :	No file for this code example.
Images :	No Images for this code example.

Search :	More code by Razvan Stanescu
Action :	Grade This Code Example
Tools :	My Examples List

Code

<?php

//
// Author: Razvan STANESCU <pappy@gecad.ro>
//
// You may use this code as long as you leave this note
//

//
// Usage example
//
// require("sybase.php3");
//
// $sybdb = new CSybDb("SYBASE", "http_user", "http_pass", "http_db");
// $sybrs = new CSybRs("select * from http_log", $sybdb);
//
// $sybrs->display(); // ... or do anything else
//
// $sybrs->destroy();
// $sybdb->destroy();
//

class CSybDb
{
var $sybdb;

function CSybDb($server, $user, $pass, $dbname = "")
{
$this->sybdb = sybase_connect($server, $user, $pass);
if( $this->valid() && $dbname != "" ) {
if( !sybase_select_db($dbname, $this->sybdb) ) {
destroy();
}
}
}
function destroy()
{
if( $this->valid() ) {
sybase_close($this->sybdb);
}
$this->sybdb = 0;
}
function valid()
{
return $this->sybdb != 0;
}
};

class CSybRs
{
var $recs;
var $rows;
var $cols;
var $crow;
var $rarr;
var $fail;

function CSybRs($query, $sybdb)
{
$this->recs = 0;
$this->rows = 0;
$this->cols = 0;
$this->fail = 1;
$this->crow = 0;

if( !$sybdb->valid() ) return;

$this->recs = sybase_query($query, $sybdb->sybdb);
if( !$this->recs ) return;

$this->rows = sybase_num_rows($this->recs);
$this->cols = sybase_num_fields($this->recs);

$this->fail = 0;
}

function destroy()
{
if( !$this->recs ) return;
// sybase_freeresult($this->recs);
$this->recs = 0;
}

function valid()
{
return !$this->fail && $this->recs != 0;
}

function seek($nrow)
{
if( !$this->valid() ) return 0;
if( $this->bof() && $this->eof() ) return 0;

if( sybase_data_seek($this->recs, $nrow) ) {
$this->crow = $nrow;
$this->rarr = sybase_fetch_array($this->recs);
if( $this->rarr ) {
return 1;
}
}
$this->fail = 1;
return 0;
}

function eof()
{
return $this->crow == $this->rows;
}

function bof()
{
return $this->crow < 0;
}

function first()
{
$this->crow = 0;
if( !$this->seek($this->crow) ) {
// mark as bof
$this->crow = -1;
}
}

function prev()
{
if( $this->bof() ) return;
$this->crow--;
if( $this->bof() ) return;

if( !$this->seek($this->crow) ) {
// mark as bof
$this->crow = -1;
}
}

function next()
{
if( $this->eof() ) return;
$this->crow++;
if( $this->eof() ) return;

$this->rarr = sybase_fetch_array($this->recs);
if( !$this->rarr ) {
// mark as eof
$this->crow = $this->rows;
}
}

function last()
{
$this->crow = $this->rows - 1;
if( !$this->seek($this->crow) ) {
// mark as eof
$this->crow = $this->rows;
}
}

function valueof($col)
{
if( !$this->valid() ) return;
return $this->rarr[$col];
}

function showheader($col, $fmt = "")
{
$fld = sybase_fetch_field($this->recs, $col);
printf( "\t<th %s>%s</th>\n", $fmt, is_string($col) ? $col : $fld->name);
}

function showvalue($col, $fmt = "", $def = "�")
{
$v = $this->valueof($col);
printf( "\t<td %s>%s</td>\n", $fmt, $v == "" ? $def : $v);
}

function display()
{
if( !$this->valid() ) return;

printf( "<table cellspacing=1 cellpadding=1 border=1>\n");

printf( "<tr>\n");
for( $c = 0; $c < $this->cols; $c++ ) {
$this->showheader($c);
}
printf( "</tr>\n");

$this->first();
while( !$this->eof() ) {
printf( "<tr>\n");
for( $c = 0; $c < $this->cols; $c++ ) {
$this->showvalue($c);
}

printf( "</tr>\n");
$this->next();
}
printf( "</table>\n");
}
};

?>

Related Code Examples

	Powerful php/mysql Pagination for up to 6 URL Params Categories : PHP, PHP Classes, Databases, MySQL, Navigation
	Password reminder Categories : PHP, PHP Classes, Databases, MySQL, Mail
	usercounter class Categories : PHP, PHP Classes, Databases, MySQL, Environment Variables
	MySQL Handler Categories : PHP, Databases, MySQL, Classes and Objects, PHP Classes
	PostGreSQL and MySQL 2 in 1 db Manager Categories : PHP, PHP Classes, Databases, PostgreSQL, MySQL
	MySQL Class to ease Database connectivity Categories : MySQL, PHP Classes, Databases, PHP
	Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0. Categories : Databases, PHP, mSQL, Databases
	Simple Mini Poll class library (SimPoll) Categories : PHP, PHP Classes, Databases, MySQL, Complete Programs
	Simple class to create insert and update statements. Independent of the access to the database. Makes handling complex inserts easier - especially when the table structure is liable to change. Categories : Databases, PHP Classes, PHP
	Online Automatic Class Generator for MySQL Tables Categories : PHP, PHP Classes, Classes and Objects, Databases, MySQL
	Specify your connection settings and create a link to a MySQL database. Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides
	Use this class to connect your database transparently... Categories : PHP Classes, Databases, PHP
	Simple database class Categories : PHP, PHP Classes, MySQL, Databases
	Simple usersOnline class - keep track of how many users are online on your site Categories : PHP, PHP Classes, Databases, MySQL
	DBE - Database Expander: Edit PostgreSQL individual database tables online via your Web browser! Categories : PostgreSQL, Complete Programs, Databases, PHP Classes, PHP

User Comments

	Morgan Heijdeman wrote :127 If you change < into <= in function bof() it doesn`t complain about empty tables.