Generating PHP Table Objects from MySql
I needed to generate some PHP table objects for a couple MySql tables so wrote up the query below real quick. I am sure there are better ways to do this through IDE's, tools, or PHP. There will also be some kinks that can be worked out such as turning database fields such as create_date into getCreateDate instead of getCreate_date but this did the trick for me. It will generate class members, getters and setters. SET @table = 'post'; SET @db = 'blog'; SELECT '<?php' UNION ALL SELECT CONCAT('class ', CONCAT( UCASE(SUBSTRING(@table,1,1)), SUBSTRING(@table,2)), '{') UNION ALL SELECT CONCAT('\tprotected $_', COLUMN_NAME, ';') FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = @table and table_schema = @db UNION ALL SELECT '\n' UNION ALL SELECT CONCAT('public function get', CONCAT(UCASE(SUBSTRING(COLUMN_