Hello,
I want to do an application that generators the sql for creating a table by simply typing up text instead of having to use phpmyadmin which is a bit slow, so basically the requirement is as follows:
- I would type the tables I need in a simple text format such as:
cars: id, name, description, image
the column ' : ' would tell the script that what is before it is the table name, and commas ',' tell the script it's a column name
- the trick is that as I type, I want the script to automatically guess what is the column type, so for example after I finish typing the above, the script would have updated the display to be something like this:
cars: id int-autoinc-primary, name varchar(255), description text, image varchar(255)
it is a bit like facebook when you tag people
The script will use something like jquery's autocomplete plugin,
if I click on one of the field types or press backspace, I want be able to edit the column types or select from a predefined list
I want the text input to be color coded, so color coding table names, column names, and column types.
For example the above:
cars would have a gray background,
id, name, description, and image would be have a green background,
and int-auto, varchar, text would have a pink background
I should be able to paste a string of text and the script will automatically figure out what it is, so for example if I paste this:
cars: id, name, description, image ; colors: id, name
the script will automiatcally know that there are 2 tables and with the appropriate column types
Here are some usable scripts I found that can be good reference and have the looks & feel I want:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Budget is less than 50$ as I think this shouldn't take more than 5 hours of work (I am an experienced developer)
Hi, interesting project... I have strong knowledge of JavaScript, including jQuery, understand SQL very well, and your project description too. If you have any question or more information, please don't hesitate to contact me by private message. I'm looking forward to our cooperation.
Hi
we checked your requirement,We could develop as per your need.
u could check that out. we would work till your satisfaction.
Thanks & Regards
Techwelfare
Please check inbox for our previous work.
Good day, 7 years experienced developer working with Joomla/PHP/HTML/MySQL/Javascript is ready to start. Expert into PSD to Joomla, PSD to HTML, Joomla 1.5 migrations/update, Joomla module/plugin/component creations,Joomla customizations and CSS fixes
Dear Client,
I have developed previous application successfully. I have 6 years of experience in software engineering. I am expert in jQuery, Ajax (XML/JSON), PHP, MySQL. I am Oracle Certified Professional. I can do this job. Thank you.