Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class database{
- var $MyDatabase;
- public function database($MyDatabase){
- $this->MyDatabase= $MyDatabase;
- }
- public function connect($host,$user = false , $password = false)
- {
- $db = mysql_connect($host,$user,$pass);
- $db = mysql_select_db( $this->MyDatabase);
- }
- public function query($cosa,$dove,$quali,$where = false)
- {
- switch ($cosa)
- {
- case "select":
- $query = "select";
- $query .= $quali ." ";
- $query .= "from ".$dove ." ".$where;
- break;
- case "insert":
- $query = "insert into";
- $query .= $dove ."(";
- $query .= foreach ($where in $row){
- $query .= $row ",";
- }
- $query .= ") values ("
- $query .= foreach ($quali in $row){
- $query .= $row ",";
- }
- $query.= ")";
- break;
- case "delete":
- $query = "delete from";
- $query .= $dove;
- $query .= "where ".$quali;
- break;
- case "update":
- $query = "update ";
- $query .= $dove;
- $query .= "set ";
- $query .= foreach ($where as $key => $value){
- $query .= $key." = ".$value .","
- }
- break;
- }//end switch
- return mysql_query($query);
- }
- }
- ?>
- <?
- $a = new database("nomedb");
- $a->connect('127.0.0.1');
- $a->query("select","tabella","*");
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement