Login   Register  
PHP Classes

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


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

//for select
$db1->DbQuery="SELECT * FROM sch_user.t_base";
$i=0$i $db1->DbNumRows$i++){
$j=0$j $db1->DbNumCols$j++){
//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