|
|
|
<?
/* put this class into a file cls/dbconnect.cls */
/************************************************************************/
class Db {
cfunction connect() {
/*connect db class*/
$host = "me.mydomain.com";
$user = "myuser";
$passwd = "mypassword";
$db = "mydb";
mysql_connect($host,$user,$passwd) or die("Sorry, can't connect to SQL server, please come
later...");
@mysql_select_db("$db");
}
/************************************************************************/
cfunction close() {
/*close connection*/
mysql_close();
}
};
?>
<?
/*this is an example of how to use the above class...*/
require("http://me.mydomain.com/cls/dbconnect.cls");
$myDb = new Db;
/*connect to database*/
$myDb->connect();
/*show entire table*/
$qry = "SELECT * FROM foo";
$result=mysql_query($qry) or die("Error: couldn't execute query 1 ($qry)");
/*use your result...*/
/*disconnect*/
$myDb->close();
?>
|
|
| Powerful php/mysql Pagination for up to 6 URL Params
Categories : PHP, PHP Classes, Databases, MySQL, Navigation | | | MySQL Class to ease Database connectivity
Categories : MySQL, PHP Classes, Databases, PHP | | | 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 | | | 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 | | | DBE - Database Expander: Edit PostgreSQL individual database tables online via your Web browser!
Categories : PostgreSQL, Complete Programs, Databases, PHP Classes, PHP | | | Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | 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 | | | Setting up InnoDB on MySQL and using Transactions Begin, Commit, Rollback in PHP.
Categories : PHP Classes, Databases, PHP, MySQL, InnoDB | |
|
|
|
