GÉNÉRATION DE CLASSES D'ACCÈS AUX DONNÉES À PARTIR DES TABLES DAO

<?php
/**
 * Class Generation
 * for PHP4 or PHP5
 * @version 1.0
 * @copyright 2008
 */
function WriteContent($n, $d, $flag = false) {
    $mode = "w";
    $f = @fopen($n, $mode);
    if ($f === false) {
        return 0;
    }
	else
	{
        if (is_array($d)) $d = implode($d);
        $bytes_written = fwrite($f, $d);
        fclose($f);
        return $bytes_written;
    }
}
//usage : writeContent($string, $page);
class ClassesGenerator{
 	var $pathToStoreGeneratedClasses = "classes/";
 	var $fileNamesPrefix = "class.";
 	var $fileExtention = ".php";
 	var $versionPhp = 4;

	function GenerateClasses($versionPhp){
 		$this->versionPhp = $versionPhp;
 		$this->GetAllTables();
	}

 	function GetAllTables(){
 		$query = "SHOW TABLES";
 		$result = mysql_query($query);
 		$num_results = mysql_num_rows($result);
 		for($i=0;$i<$num_results;$i++){
 			$row = mysql_fetch_array($result);
 			//echo "<b>".$row[0]."</b><br />";//for debug
 			//$this->GetTableDetails($row[0]);
 			echo "Writing class ".$row[0];
 			$this->WriteClasses($row[0]);
 			echo "done.<br />\n";
		}
 	}

 	//For Debug Only
 	function GetTableDetails($tableName){
 		$query = "DESCRIBE $tableName";
 		$result = mysql_query($query) or die("<p>Problem with table detail : ".mysql_error()." :<br />".$query."</p>");
		$num_fields = mysql_num_fields($result);
		while($val = mysql_fetch_array($result)){
			//for debug
			echo "Field : ".$val["Field"]."<br />";
			echo "Type : ".$val["Type"]."<br />";
			echo "Key : ".$val["Key"]."<br />";
			echo "Null : ".$val["Null"]."<br />";
			echo "Default : ".$val["Default"]."<br />";
			echo "Extra : ".$val["Extra"]."<br />";
			echo "<hr />";
		}
	}

 	function WriteClasses($tableName){
 		echo ".";
		$stringToWrite = $this->GetClassHeader($tableName);
		$stringToWrite .= $this->GetMembers($tableName);
		$stringToWrite .= $this->GetObjectFunction($tableName);
		$stringToWrite .= $this->GetInsert($tableName);
		$stringToWrite .= $this->GetUpdate($tableName);
		$stringToWrite .= $this->GetDelete($tableName);
		$stringToWrite .= $this->GetClassFooter();
		echo ".";
		$fullPath = $this->pathToStoreGeneratedClasses.$this->fileNamesPrefix.$tableName.$this->fileExtention;
		WriteContent($fullPath,$stringToWrite);
		echo ".";

		//for Debug
		/*
		echo "<b>".nl2br($stringToWrite)."</b><br />";
		echo "Write Content => \\".WriteContent($this->pathToStoreGeneratedClasses.$this->fileNamesPrefix.$tableName.$this->fileExtention,
			$stringToWrite)."//";
		*/
	}

	/////////// HEADER AND FOOTER ////////////////
	function GetClassHeader($tableName){
		return "<?php\nclass ".ucfirst($tableName). "{\n";
	}
	function GetClassFooter(){
		return "}//class\n?>";
	}
	function GetFunctionHeader($functionName,$parameters){
		if($this->versionPhp<=4)
			return "\tfunction ".$functionName."($parameters){\n";
		if($this->versionPhp>=5)
			return "\tpublic function ".$functionName."($parameters){\n";
	}
	function GetFunctionFooter($functionName){
		return "\t}//function $functionName\n";
	}
	/////////// HEADER AND FOOTER ////////////////

	/////////// CORE FUNCTIONS ////////////////
	function GetMembers($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$members = NULL."\t//Members\n";
		while($val=mysql_fetch_array($result)){
			if($this->versionPhp<=4){
				$members .= "\tvar \$".$val["Field"]." = NULL;\n";
			}//if
			if($this->versionPhp>=5){
				$members .= "\tprivate \$".$val["Field"]." = NULL;\n";
			}//if
		}//while
		return $members."\n\t//Methods";
	}
	function GetObjectFunction($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$params = $this->GetPrimaryKeyFields($tableName);
		$objectFunction = "\n";
		$objectFunction.= $this->GetFunctionHeader("Get".ucfirst($tableName),$params);

		$memberList = $this->GetMemberList($tableName);
		$whereClause = $this->GetPrimaryKeyQueryString($tableName);

		$objectFunction.="\t\t\$query = \"SELECT $memberList FROM $tableName WHERE $whereClause\";\n";
		$objectFunction.="\t\t\$result = mysql_query(\$query);\n";
		$objectFunction.="\t\t\$val = mysql_fetch_assoc(\$result);\n";

		while($val=mysql_fetch_array($result)){
			$objectFunction	.=	"\t\t\$this->".$val["Field"]." = \$val[\"".$val["Field"]."\"];\n";
		}//while
		$objectFunction.="\t\treturn \$this;\n";
		$objectFunction.=$this->GetFunctionFooter("Get".ucfirst($tableName));
		return $objectFunction;
	}
	function GetMemberList($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$memList = NULL;
		while($val=mysql_fetch_array($result)){
			$memList.=$val["Field"].",";
		} // while
		$memList = $this->RemoveLastCharacter($memList);
		return $memList;
	}
	function RemoveLastCharacter($stringToRemoveLastCharacter){
		if(substr($stringToRemoveLastCharacter,-1)=="\n")
			return substr($stringToRemoveLastCharacter,0,strlen($stringToRemoveLastCharacter)-2);
		else
			return substr($stringToRemoveLastCharacter,0,strlen($stringToRemoveLastCharacter)-1);
	}
	function GetPrimaryKeyFields($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$priKeys = NULL;
		$pk_found=FALSE;
		while($val=mysql_fetch_array($result)){
			if($val["Key"]=="PRI"){
				if($pk_found==TRUE)
					$priKeys.=",\$".$val["Field"];
				else{
					$priKeys.="\$".$val["Field"];
					$pk_found=TRUE;
				}//else
			}//if
		}//while
		return $priKeys;
	}
	function GetPrimaryKeyQueryString($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$priKeys = NULL;
		$pk_found=FALSE;
		while($val=mysql_fetch_array($result)){
			if($val["Key"]=="PRI"){
				if($pk_found==TRUE)
					$priKeys.=" AND ".$val["Field"]."='\$".$val["Field"]."'";
				else{
					$priKeys.=$val["Field"]."='\$".$val["Field"]."'";
					$pk_found=TRUE;
				}//else
			}//if
		}//while
		return $priKeys;
	}
	function GetInsertMembers($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$fields = NULL;
		while($val=mysql_fetch_array($result)){
			if($val["Extra"]!="auto_increment"){
				$fields.=$val["Field"].",";
			}//if
		}//while
		$fields=$this->RemoveLastCharacter($fields);
		return $fields;
	}
	function GetInsertValues($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$fields = NULL;
		while($val=mysql_fetch_array($result)){
			if($val["Extra"]!="auto_increment"){
				$fields.="'\".\$this->".$val["Field"].".\"',";
			}//if
		}//while
		$fields=$this->RemoveLastCharacter($fields);
		return $fields;
	}
	function GetInsert($tableName){
		$insertString = $this->GetFunctionHeader("Insert","");
		$insertString .= "\t\t\$query = \"INSERT INTO $tableName\n\t\t(".$this->GetInsertMembers($tableName).")\n\t\tVALUES\n\t\t(".$this->GetInsertValues($tableName).")\";\n";
		$insertString .= "\t\t\$result = mysql_query(\$query);\n";
		$insertString .= "\t\tif(mysql_affected_rows()==-1)\n";
		$insertString .= "\t\t\treturn FALSE;\n";
		$insertString .= "\t\telse\n";
		$insertString .= "\t\t\treturn TRUE;\n";
		$insertString .= $this->GetFunctionFooter("Insert");
		return $insertString;
	}
	function GetUpdateValues($tableName){
		$query = "DESCRIBE $tableName";
		$result = mysql_query($query);
		$fields = NULL;
		while($val=mysql_fetch_array($result)){
			$fields.="\t\t\t".$val["Field"]."='\".\$this->".$val["Field"].".\"',\n";
		}//while
		$fields=$this->RemoveLastCharacter($fields);
		return $fields;
	}
	function GetUpdate($tableName){
		$updateString = $this->GetFunctionHeader("Update",$this->GetPrimaryKeyFields($tableName));
		$updateString .= "\t\t\$query = \"UPDATE $tableName SET (\n".$this->GetUpdateValues($tableName)."\n\t\t)\n\t\tWHERE (".$this->GetPrimaryKeyQueryString($tableName).")\";\n";
		$updateString .= "\t\t\$result = mysql_query(\$query);\n";
		$updateString .= "\t\tif(mysql_affected_rows()==-1)\n";
		$updateString .= "\t\t\treturn FALSE;\n";
		$updateString .= "\t\telse\n";
		$updateString .= "\t\t\treturn TRUE;\n";
		$updateString .= $this->GetFunctionFooter("Update");
		return $updateString;
	}
	function GetDelete($tableName){
		$deleteString = $this->GetFunctionHeader("Delete",$this->GetPrimaryKeyFields($tableName));
		$deleteString .= "\t\t\$query = \"DELETE FROM $tableName\n\t\tWHERE (".$this->GetPrimaryKeyQueryString($tableName).")\";\n";
		$deleteString .= "\t\t\$result = mysql_query(\$query);\n";
		$deleteString .= "\t\tif(mysql_affected_rows()==-1)\n";
		$deleteString .= "\t\t\treturn FALSE;\n";
		$deleteString .= "\t\telse\n";
		$deleteString .= "\t\t\treturn TRUE;\n";
		$deleteString .= $this->GetFunctionFooter("Delete");
		return $deleteString;
	}
	/////////// CORE FUNCTIONS ////////////////
}
?>

Télécharger le zip

26 septembre 2008 16:17:00 :

Mise à jour : - Correction petite erreur dans GetObject => mysql_query($query) aulieu de mysql_query($result)