[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

PHP // Standard Database Connectivity Templates

Hi all,
we are looking for a way to standardize database access by means of function calls or so...
1. PHP connects to standard database e.g. MaxDB
2. PHP reads/writes (SELECT, UPDATE...) via standard templates from/to database
Is there any standard framework one could use for this kind of task??
Ciao
0
go4java
Asked:
go4java
3 Solutions
 
dr_dedoCommented:
you could always implement your own class to standardize your db connection and manipulation, there are a vide varity of classes ready to use or simply create your own. see phpclasses.org for a handful of classes
0
 
mattaobCommented:
I wrote my own class:

pseudo code below
<?
  class db {
    
    function db() {
       connect to database here
    }
 
    function getone($sql) {
       code to get one value from a single row
    }
 
    function getrow($sql) {
       code to get a single row
    }
 
    function getall($sql) {
       code to get all values from a query
    }
 
    etc etc etc
  }

Open in new window

0
 
Loganathan NatarajanLAMP DeveloperCommented:
I  too recommend to write your own standard classes by applying all the functions .., it is good always how to use & where to use...

but you can still look for those db files / package /library /template from the standard open source projects like cms solutions or any other professional tools... they have standard template for db operations..,


0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now