|
|
|
/* cut here
/* raju_mssql.inc */
<?php
class DB_Sql {
var $Server = "";
var $Database ="";
var $User = "";
var $Conn = "";
var $Query_ID = "";
var $Record = array();
var $Row;
var $Password="";
/**********************************************************
This function gives the error msg
***********************************************************/
function raju_halt($msg) {
printf("</td></tr></table><b>Database error:</b> %s<br>\n", $msg);
printf("<b>MS SQL Error</b>: %s (%s)<br>\n",$this->Errno,$this->Error);
die("Session halted.");
}
/***********************************************************
Explaination About the Class :
In this Class i am sending the 4 parameters.
1. $TableName is the name the Table in the Database.
2. $TestField is the field on which you would like to
where condition.
3. $Field1 is the name of the field which you would like to
get from the database.
4. $Fieldn is the the value of the field.
example:
select ename($Field1 u can have as many values as u wish like $Field2...... form emp
($TableName) where empno($TestField) = &1($Fieldn);
*/
/***********************************************************
You can use this class for any database. here i am showing
you using MS-SqlServer.
*/
function raju_selectwhere($TableName,$TestField,$Field1,$Fieldn) {
//$TableName is the Name of the Table from which u would like to query.
//$TestField is the Name of the Column on which u would like to perform where condition.
//establish connection with database
$this->connect();
$Select_String = "Select ";
$From_String = "From ";
$Where_String = "Where ";
$Equal_String = "=";
//Now we concatinate all the Strings into one single sql statement
$Query_String =
$Select_String.$Field1.$From_String.$TableName.$Where_String.$TestField.$Equal_String.$Fie
ldn;
//Here the query is executed.
$this->Query_ID = mssql_query($Query_String,$this->Conn);
//if the query contains no records it will give error.
if (!$this->Query_ID) {
$this->raju_halt("Invalid SQL: ".$Query_String);
}
//the function returns the no of records.
return $this->Query_ID;
}
}
/* cut here
/* cut here
/* raju_local.inc */
<?php
/*
raju_local.inc which is the extended class of raju_mssql.inc
in which u can give ur database name, username,password
of the database.
*/
class DB_Sample extends DB_Sql {
var $Server = "yourservername";
var $User = "yourusername";
var $Database = "yourdatabasename";
var $Password = "yourpassword";
}
?>
/* cut here
|
|
| Recordset Class for MSSQL database Categories : PHP Classes, Databases, PHP, MS SQL Server | | | Convert SQL from oracle,mysql,mssql,sqlite and odbc to SQL compatible Categories : PHP, PHP Classes, Databases, MySQL, MS SQL Server | | | [PHP5] aDB PDO LIKE Database Abstraction. Switch easily from one db server to another, strong errors management, manage transactions, queries preparation and more. Categories : PHP, PHP Classes, Databases, MS SQL Server, MySQL | | | Mssql database Manager Categories : PHP, Databases, MS SQL Server, Classes and Objects, PHP Classes | | | PHP CLASS for ORACLE (database connectivity) Categories : PHP, PHP Classes, Classes and Objects, Databases, Oracle | | | 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 | | | normalize fields and strings used in where (command's Sql) Categories : PHP, Databases, Oracle, Functions | | | 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 | |
|
|
|