EasyPHPMYSQL is a command-line python script that is used to write a PHP class files that connect and manipulate data in a MYSQL database just by answering a couple question about the #database. Also, it writes an optional login script for an administrator backend and an optional example script that shows a person how to use the php class.
Note: This project is in the beta stage; thus, there are probably a couple of bugs that I still need to address
The following python modules need to be installed to use this script:
- MySQLdb
To install this modules, open the terminal and enter the following:
pip install MySQL-python
#if you have Ubuntu, you can enter the following command
sudo apt-get install python-mysqldb
To run and use this script, open the terminal and go to the script folder. Then enter the following command.
python ./easyphpmysql.py
What is the host name for the database (ie - localhost)?
localhost
What is the userename for the database?
username
What is the password for the database?
password
What is the name of the database?
testdb
What is the filename for the php class?
test.php
What is the name of the php class?
testclass
Do you want login script in the php class (y)es or (n)o?
yes
What is the name of the table with the login information?
logintable
What is the column name that holds the username?
user
What is the column name that holds the password?
password
Do you want example php files to be wrote to demostrate the php class (y)es or (n)o?
yes
The files has been written. Finished!!
#That is it. Now you should have a php class file called test.php, a php login script called login.php
and an example php file that shows you how to use the php class called example.php