This is a simplest PHP program to automatically fetch table details from your mysql database and create all necessary CRUD functions in a php file.
The details of the files are as follows:
#dao_code_generator.php This is the actual code file that needs to be executed to generate a PHP file with crud methods NOTE: please open the file and update the database details and the class name of the PHP file to be generated
define('MYSQL_SERVER', 'localhost'); define('MYSQL_DATABASE_NAME', 'kistyle'); define('MYSQL_USERNAME', 'root'); define('MYSQL_PASSWORD', 'password'); define('CLASS_NAME', 'saloonDAO');
#saloonDAO.php This is the file created as a result of executing the code generator PHP
#queriesHelper.php Just a PHP file with some utility methods to assist in proper formation of the queries and execution
#Controller.php PHP file with database connection details to be used later for executing the generated PHP file
#sql.php Utility PHP file with code to connect to mysql database using PDO