PHP Classes
elePHPant
Icontem

File: ex-Db.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of carex  >  Form Table PgSQL  >  ex-Db.php  >  Download  
File: ex-Db.php
Role: Example script
Content type: text/plain
Description: example Db
Class: Form Table PgSQL
Generate Web forms to access PostgreSQL tables
Author: By
Last change:
Date: 9 years ago
Size: 881 bytes
 

Contents

Class file image Download
<?php
   
require 'conf/dbConf.php';
    require
'object/database/dbConnection.php';
   
   
//create new
   
$db1=new pgsqldb();

   
//for select
   
$db1->DbQuery="SELECT * FROM sch_user.t_base";
   
$db1->GetDbQuery('SELECT');
    for(
$i=0; $i < $db1->DbNumRows; $i++){
      for(
$j=0; $j < $db1->DbNumCols; $j++){
        print
$db1->Data[$i][$j]."------";
      }
      print
"<br>";
    }
   
   
//for delete
// $db1->dbQuery="DELETE FROM sch_user.t_base WHERE id=100202020";
// db1->get_dbQuery('DELETE');
   
    //for update
// $db1->dbQuery="UPDATE sch_user.t_base SET nama='CAREX' WHERE id=20";
// $db1->get_dbQuery('UPDATE');

    //for insert
// $db1->dbQuery="INSERT INTO sch_user.t_base(id,nama) VALUES(101,'Windy')";
// $db1->get_dbQuery('INSERT');

    // NB: Anything depend of SQL Syntax for PostgreSQL

?>