Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //
- // Atnaujinta 2010-20-25
- //
- //
- class MySQL
- {
- function Connect($server, $user, $password, $database)
- {
- $this->connect_id = mysql_connect($server, $user, $password);
- if($this->connect_id)
- {
- if(mysql_select_db($database))
- {
- return $this->connect_id;
- }
- else
- {
- return $this->Error();
- }
- }
- else
- {
- return $this->Error();
- }
- }
- //
- // klaidos pranešimas
- //
- function Error()
- {
- if(mysql_error() != '')
- {
- echo "<b>MySQL Klaida</b>: ".mysql_error()."<br />";
- return true;
- }
- else
- {
- return false;
- }
- }
- //
- // klaidos pranešimas
- //
- function Query($query)
- {
- if($query != NULL)
- {
- $this->query_result = mysql_query($query, $this->connect_id);
- if(!$this->query_result)
- {
- return $this->Error();
- }
- else
- {
- return $this->query_result;
- }
- }
- else
- {
- return '<b>MySQL Error</b>: Empty Query!';
- }
- }
- //
- // gražintu stulpeliu skaicius
- //
- function GetNumRows($query_id = "")
- {
- if($query_id == NULL)
- {
- $return = mysql_num_rows($this->query_result);
- }
- else
- {
- $return = mysql_num_rows($query_id);
- }
- if(!$return)
- {
- $this->Error();
- }
- else
- {
- return $return;
- }
- }
- //
- // gauti stulpelio informacija
- //
- function FetchRow($query_id = "")
- {
- if($query_id == NULL)
- {
- $return = mysql_fetch_array($this->query_result);
- }
- else
- {
- $return = mysql_fetch_array($query_id);
- }
- if(!$return)
- {
- $this->Error();
- }
- else
- {
- return $return;
- }
- }
- //
- // gauti skaiciu itakotu rezultatu
- //
- function GetAffectedRows($query_id = "")
- {
- if($query_id == NULL)
- {
- $return = mysql_affected_rows($this->query_result);
- }
- else
- {
- $return = mysql_affected_rows($query_id);
- }
- if(!$return)
- {
- $this->Error();
- }
- else
- {
- return $return;
- }
- }
- //
- // uždarau užklausas
- //
- function Close()
- {
- if($this->connect_id)
- {
- return mysql_close($this->connect_id);
- }
- }
- }
- //
- // PG SQL
- //
- class PgSQL
- {
- function Connect($server, $user, $password, $database, $port)
- {
- $this->connect_id = pg_connect("host=$server port=$port dbname=$database user=$user password=$password");
- if($this->connect_id)
- {
- return $this->connect_id;
- }
- else
- {
- return $this->Error();
- }
- }
- //
- // klaidos pranešimas
- //
- function Error()
- {
- if(pg_last_error() != '')
- {
- echo '<b>PgSQL Error</b>: '.pg_last_error().'<br />';
- }
- }
- //
- // klaidos pranešimas
- //
- function Query($query)
- {
- if($query != NULL)
- {
- $this->query_result = pg_query($this->connect_id, $query);
- if(!$this->query_result)
- {
- return $this->Error();
- }
- else
- {
- return $this->query_result;
- }
- }
- else
- {
- return '<b>PqSQL Error</b>: Empty Query!';
- }
- }
- //
- // gražintu stulpeliu skaicius
- //
- function GetNumRows($query_id = "")
- {
- if($query_id == NULL)
- {
- $return = pg_num_rows($this->query_result);
- }
- else
- {
- $return = pg_num_rows($query_id);
- }
- if(!$return)
- {
- $this->Error();
- }
- else
- {
- return $return;
- }
- }
- //
- // gauti stulpelio informacija
- //
- function FetchRow($query_id = "")
- {
- if($query_id == NULL)
- {
- $return = pg_fetch_array($this->query_result);
- }
- else
- {
- $return = pg_fetch_array($query_id);
- }
- if(!$return)
- {
- $this->Error();
- }
- else
- {
- return $return;
- }
- }
- //
- // gauti skaiciu itakotu rezultatu
- //
- function GetAffectedRows($query_id = "")
- {
- if($query_id == NULL)
- {
- $return = pg_affected_rows($this->query_result);
- }
- else
- {
- $return = pg_affected_rows($query_id);
- }
- if(!$return)
- {
- $this->Error();
- }
- else
- {
- return $return;
- }
- }
- //
- // uždarau užklausas
- //
- function Close()
- {
- if($this->connect_id)
- {
- return pg_close($this->connect_id);
- }
- }
- }
- ?>
Add Comment
Please, Sign In to add comment