|
|
|
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 | | | Powerful php/mysql Pagination for up to 6 URL Params
Categories : PHP, PHP Classes, Databases, MySQL, Navigation | | | The Ajax Tree view class fetches data from a db for the requested parent category id. The data is then stored in an array and converted into JSON (Javascript Object Notation) format. This format is then used by JavaScript for populating tree view.
Categories : PHP, PHP Classes, Java Script, AJAX, Databases | | | Password reminder
Categories : PHP, PHP Classes, Databases, MySQL, Mail | | | MySQL Class to ease Database connectivity
Categories : MySQL, PHP Classes, Databases, PHP | | | A set of functions sitting on top of the abstraction layer that makes it a little easier to do SQL stuff. Documentation is within
Categories : Databases, ODBC, Complete Programs, PHP | | | 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 | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0.
Categories : Databases, PHP, mSQL, Databases | | | Use this class to connect your database transparently...
Categories : PHP Classes, Databases, PHP | | | 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 | | | DBE - Database Expander: Edit PostgreSQL individual database tables online via your Web browser!
Categories : PostgreSQL, Complete Programs, Databases, PHP Classes, PHP | |
|
|
|
