You need to create a web application that, given a .txt file (.txt only) in input, generates MySQL code to add a new database (if not existent), a new table (if not existent) and a new record (if not existent).
If the database already exists, it will add the new table with the specified record. If both the database and the table already exist, it will add the new record. If the record already exists, it will print an error message on the webpage.
Content of the file:
The file contains a line with the name of the database, a line with the name of the table, a line per each of the fields in the specified table. Remember that the file can contain more than one entry, even with different database/table names. It could be similar to this:
Edwin Abbott Abbott
Note: Between two different records, you always find the string "---"
14 freelancers are bidding on average $26 for this job
I will complete your PHP Homework right now Relevant Skills and Experience Relevant experience on PHP : 8 years Proposed Milestones $30 USD - COST Stay tuned, I'm still working on this proposal.
Hey there, I can do this task as I'm an experienced professional, working from last 6 years. I'm pretty sure it can be done within the given time. Let's discuss it further in a chat.
if I understand the txt file format clearly, publications is the database name, the next line is the table name? and other content is the record to add? How does the app knows the table columns to create? Thanks