|
|
|
|
|
in the .zip above you have all the files needed to run the example (DB Scripts also
included)
<?
include "Recordset.php";
/*
// DATABASE SPLITING EXAMPLE
$db_connection = odbc_connect("testDSN", "sa", "");
$sql = "SELECT * FROM test_table";
$rs = new Recordset($db_connection, $sql);
$rs->Elems(13);
$results = $rs->Split($page);
echo "<table border=\"1\">\r";
for($i = 0; $i < count($results); $i++)
{
echo "<tr>";
echo "<td>" . $results[$i]["cod"] . "</td>";
echo "<td>" . $results[$i]["name"] . "</td>";
echo "<td>" . $results[$i]["description"] . "</td>";
echo "</tr>\r";
}
echo "</table>\r";
$rs->DisplayGuide("example.php", $page);
*/
// RECORDSET EXAMPLE
$db_connection = odbc_connect("testDSN", "sa", "");
$sql = "SELECT * FROM test_table";
$rs = new Recordset($db_connection, $sql);
while(!$rs->Eof())
{
$rs_tmp = $rs->MoveNext();
echo $rs_tmp["description"] . "<br>";
}
echo "-- <b>" . $rs->RecordCount() . "</b> row(s) returned --";
?> |
|
| ADODB Database Wrapper Abstraction Library for PHP: MySQL, MSSQL,
Oracle, Interbase,ODBC, Microsoft Access and FoxPro. Categories : PHP Classes, Databases, PHP, General SQL, ODBC | | | [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 | | | db2tab.php - Simple scripts to access IBM DB2 Universal DataBase tables through PHP ODBC funtions. Categories : Databases, PHP, ODBC | | | Password reminder Categories : PHP, PHP Classes, Databases, MySQL, Mail | | | 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 | | | Dynamic WHERE CLAUSE depending on number of FORM FIELDS Categories : ODBC, General SQL, PHP, Complete Programs, Databases | | | MySQL Connection/Query Class Categories : Databases, MySQL, PHP, PHP Classes | | | Simple class for accessing databases like MSSql Server, Oracle etc by Raju Categories : PHP, MS SQL Server, Databases, PHP Classes, Oracle | | | DbObject - A PHP wrapper for working with various databases Categories : Databases, PHP, PHP Classes | | | Specify your connection settings and create a link to a MySQL database. Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | This is a class with functions that are taken from simple SQL statements.
I made it to have an easier connection between PHP3 and DBase files. Categories : General SQL, PHP, PHP Classes, Databases | | | phpFormGenerator for Dynamic Form Generation from MySQL Categories : PHP, PHP Classes, MySQL, Databases, HTML and PHP | | | MySQL Class to ease Database connectivity Categories : MySQL, PHP Classes, Databases, PHP | | | DBXML- A Class to backup databases in XML Format using web interface Categories : PHP, PHP Classes, Databases, MySQL, XML | |
| |
| |
|