Login   Register  
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

?>