Closed

database tables generator

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:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Budget is less than 50$ as I think this shouldn't take more than 5 hours of work (I am an experienced developer)

Skills: AJAX, CSS, jQuery / Prototype, MySQL, PHP

See more: tables generator, what is sql coding, tag background color html 5, php autocomplete, less than 3 press, jquery html code generator demo, html 5 table generator, html 5 generator, facebook developer html code, creating php table, code image generator, background color html 5 table, ajax sql developer, ajax autocomplete sql, what is a database developer, think pink, database html sql, format html table jquery, auto click facebook script, background image jquery plugin, php table generator, jquery image tag, jquery html format, names cars, html tag generator

About the Employer:
( 46 reviews ) Ballouneh, Lebanon

Project ID: #4677986

15 freelancers are bidding on average $141 for this job

srinichal

I can deliver the project as per the specs

$236 USD in 6 days
(88 Reviews)
7.0
jsr3

I understand your requirements and ready to start right now. Please check your message box for more details.

$263 USD in 3 days
(73 Reviews)
6.4
morff

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 con More

$53 USD in 1 day
(119 Reviews)
6.2
techwelfare

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.

$174 USD in 8 days
(47 Reviews)
6.0
Champian

Let Champian handle this for you.

$147 USD in 1 day
(27 Reviews)
5.3
muhammadghasan

Expert Developer here, Check your PM, Thanks

$200 USD in 7 days
(25 Reviews)
5.2
JoomlaVogue

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$144 USD in 3 days
(15 Reviews)
5.1
RimoTM

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,Jo More

$150 USD in 1 day
(21 Reviews)
4.9
prasy8

Hi there, Our preferred technology: PHP/Mysql, JavaScript, AJAX Ready to start asap. Let me know if you have any questions. Thanks, prasy

$50 USD in 7 days
(7 Reviews)
4.2
stevecorsi

I am an experienced developer

$111 USD in 1 day
(11 Reviews)
4.0
santosoftvw

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 t More

$250 USD in 13 days
(7 Reviews)
3.4
VhanguArt

Please check PM, Thanks!

$45 USD in 5 days
(3 Reviews)
2.5
kartikkshah

My self Kartik Shah I have over 6 years experience to work in the web technologies and software field. I have experience to Work on: php, mysql, LAMP, ajax, jquery, json, javascript, xml, html, css, webserviecs wi More

$45 USD in 2 days
(4 Reviews)
2.3
jvmxgs

Hi, i want work now.

$35 USD in 1 day
(1 Review)
0.0
sezan

I am ready to work. please check PM

$155 USD in 3 days
(0 Reviews)
0.0
Aleksrennit

I can do it. It seems quite easy. I have experience. Ready to work as people sat there.

$100 USD in 3 days
(0 Reviews)
0.0