Mam jakąś klase co mi znajomy dał
<?php
/*
* Session Management for PHP3
*
* Copyright (c) 1998-2000 NetUSE AG
* Boris Erdmann, Kristian Koehntopp
*
* $Id: db_mysql.inc,v 1.2 2000/07/12 18:22:34 kk Exp $
*
*/
define("DATABASE_HOST","localhost"); define("DATABASE_NAME","panel"); define("DATABASE_USER","panel"); define("DATABASE_PASSWORD","123454567890-=0987654321345678909876543");
class DB_Sql {
/* public: connection parameters */
var $Host = DATABASE_HOST;
var $Database = DATABASE_NAME;
var $User = DATABASE_USER;
var $Password = DATABASE_PASSWORD;
/* public: configuration parameters */
var $Auto_Free = 1; ## Set to 1 for automatic mysql_free_result()
var $Debug = 0; ## Set to 1 for debugging messages.
var $Halt_On_Error = "no"; ## "yes" (halt with message), "no" (ignore errors quietly), "report" (ignore errror, but spit a warning)
var $Seq_Table = "db_sequence";
/* public: result array and current row number */
var $Row;
/* public: current error number and error text */
var $Errno = 0;
var $Error = "";
/* public: this is an api revision, not a CVS revision. */
var $type = "mysql";
var $revision = "1.2";
/* private: link and query handles */
var $Link_ID = 0;
var $Query_ID = 0;
function close() {
if ( $this->link_id())
{
$this->Link_ID = 0;
}
}
/* public: constructor */
function DB_Sql($query = "") {
$this->query($query);
}
/* public: some trivial reporting */
function link_id() {
return $this->Link_ID;
}
function query_id() {
return $this->Query_ID;
}
/* public: connection management */
function connect($Database = DATABASE_NAME, $Host = DATABASE_HOST, $User = DATABASE_USER, $Password = DATABASE_PASSWORD) {
/* Handle defaults */
if ("" == $Database)
$Database = $this->Database;
if ("" == $Host)
$Host = $this->Host;
if ("" == $User)
$User = $this->User;
if ("" == $Password)
$Password = $this->Password;
/* establish connection, select database */
if ( 0 == $this->Link_ID ) {
# mysql_query('SET NAMES latin2');
if (!$this->Link_ID) {
$this->halt("connect($Host, $User, \$Password) failed.");
return 0;
}
.
Ciach
...
?>