Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > alt.comp.programming > #47

Object based relational php database system, that saves data to files and uses only 1 file (the system php file)

Show all headers | View raw

Updated the file.

Kristjan Robam
Tel. : 372 6861327
E-mail: robam man 2020 @ hotmail . com
(Please remove spaces)

<?php

class Myobj {
   public $a;
   public $a2;
   public function getNameOfClass()
   {
      return static::class;
   }
}

class Myobj2 {
   public $a2;
   public $a3;
   public function getNameOfClass()
   {
      return static::class;
   }
}

class Easyphpdb {
	
	private $dbtables;
	function setvalue($a) {
		$this->dbtables=$a;
	}
	function getvalue() {
		return $this->dbtables;
	}
	
    function saveobjecttable($obj, $name) {
        if (file_exists($name)) {
            return false;
        }
        $b=serialize($obj);
        $fh = fopen($name.".edb", "a");
        fwrite($fh, $b);
        fclose($fh);
        chmod($name.".edb", 0700);
        return true;
    }
    function loadobjecttables() {	
		$dbtables = array();
		foreach (glob("*.edb") as $file) {
                $file1 = file_get_contents($file, true);
		  $dbtables[] = unserialize($file1);
		}
		$this->setvalue($dbtables);
    }
    function deleteotable($otabname) {	
        if (file_exists($otabname.".edb")) {
            unlink($otabname.".edb");
        }
        $this->loadobjecttables();
    }
	
    function insertobject($obj) {
		$this->loadobjecttables();
		$oclass=$obj->getNameOfClass();
                echo $oclass;
		$tabls=$this->getvalue();
		$oarridx=-1;
        for($i=0; $i<count($tabls); $i++) {
			if($tabls[$i][0]->getNameOfClass()==$oclass) {
				   $oarridx=$i;
			}
		}
		if($oarridx==-1) return false;
        $tabls[$oarridx][]=$obj;
        unlink($tabls[$oarridx][0]->getNameOfClass().".edb");
        $b=serialize($tabls[$oarridx]);
        $fh = fopen($tabls[$oarridx][0]->getNameOfClass().".edb", "a");
        fwrite($fh, $b);
        fclose($fh);
        chmod($tabls[$oarridx][0]->getNameOfClass().".edb", 0700);
	}
    function objectClassestoarray($objectA, 
                        $objectB) {      
       $new_object = array(); 
          
       foreach($objectA as $property => $value) { 
           $new_object[$property]=$value;
       } 
              
       foreach($objectB as $property => $value) { 
           $new_object[$property]=$value;
       } 
          
       return $new_object; 
    } 
        

    function query($query) {
		$this->loadobjecttables();
        $ovars=array();
        $objects=$this->getvalue();
        for($i=0; $i<count($objects); $i++) {
            $ovars[]=array_keys(get_object_vars($objects[$i][0]));       
        }
        $mches=false;
        $results=null;
        
        for($i=0; $i<count($objects); $i++) {
            for($j=0; $j<count($ovars); $j++) {
                if(preg_match("/^select ".$ovars[$i][$j]." from ".$objects[$i][0]->getNameOfClass().";$/",$query)) {
                    return array_column($objects[$i], $ovars[$i][$j]);
                    $mches=true;
                    break;
                }   
            }
        }
        

        for($i=0; $i<count($objects); $i++) {
            for($j=0; $j<count($ovars); $j++) {
                for($k=0; $k<count($objects); $k++) {
                    for($l=0; $l<count($ovars); $l++) {
                        if(preg_match("/^select \* from ".$objects[$i][0]->getNameOfClass()." join ".$objects[$k][0]->getNameOfClass()." on \(".$objects[$i][0]->getNameOfClass()."\.".$ovars[$i][$j]."\=".$objects[$k][0]->getNameOfClass()."\.".$ovars[$k][$l]."\);$/",$query)) {
                                                  
                            $outp=array();
                            
                            $oobj = $this->objectClassestoarray($objects[$i][0], $objects[$k][0]); 
                            $outp[]=$oobj;
                            $mches=true;
                            return $outp;
                            break;
                        } 
                    }
                }
            }
        }


        return $mches;        
    }

}

$aone=array();

$a1=new Myobj();
$a1->a="11111";
$a1->a2="22222";
$aone[]=$a1;

$a1=new Myobj();
$a1->a="33333";
$a1->a2="44444";
$aone[]=$a1;

$atwo=array();

$a1=new Myobj2();
$a1->a2="22222";
$a1->a3="12345";
$atwo[]=$a1;

$a1=new Myobj2();
$a1->a2="44444";
$a1->a3="67890";
$atwo[]=$a1;

$mydb=new Easyphpdb();

/*
$mydb->saveobjecttable($aone, "Myobj");
$mydb->saveobjecttable($atwo, "Myobj2");

$a1=new Myobj();
$a1->a="333335";
$a1->a2="444445";

$mydb->insertobject($a1);
*/
//$mydb->deleteotable("Myobj");

print_r($mydb->query("select a from Myobj;"));
print_r($mydb->query("select a2 from Myobj2;"));

//print_r($mydb->query("select * from Myobj join Myobj2 on (Myobj.a2=Myobj2.a2);"));



?>

Back to alt.comp.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Includable simple object based relational php database, that saves data to files and uses only 1 file (the database system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-21 09:46 -0700
  Object based relational php database system, that saves data to files and uses only 1 file (the system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-22 23:26 -0700
    Re: Simple object based relational php database system, that saves data to files and uses only 1 file (the system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-25 03:32 -0700
      Re: Simple object based relational php database system, that saves data to files and uses only 1 file (the system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-26 01:27 -0700
  Re: Includable simple object based relational php database, that saves data to files and uses only 1 file (the database system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-26 04:46 -0700
  Re: Includable simple object based relational php database, that saves data to files and uses only 1 file (the database system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-27 05:21 -0700
    Re:  Simple object based relational php database, that saves data to files and uses only 1 file (the system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-27 05:22 -0700
      Re: Simple object based relational php database, that saves data to files and uses only 1 file (the system php file) ikristjanrobam@gmail.com - 2020-03-28 05:53 -0700
        Re: Simple object based relational php database, that saves data to files and uses only 1 file (the system php file) he12457@hotmail.com - 2020-08-29 03:30 -0700
          Re: Simple object based relational php database, that saves data to files and uses only 1 file (the system php file) Bischoop <Bischoop@vimart.net> - 2020-08-31 11:58 +0000
            Re: Simple object based relational php database, that saves data to files and uses only 1 file (the system php file) ownerofachattingportal@gmail.com - 2020-09-01 07:57 -0700

csiph-web