Cancelado

PHP code to search MySQL database with Multiple Terms

I need to use a PHP form to query a MySQL database.

I have a dictionary database with a few thousand entries. I *must* be able to enter, say, 50 to 100 words at once and return those 50 words with the entered words, pronunciations, and definitions. It is easy to do this one word at a time, but that's much too slow for me. I need to do this quickly, so I need to enter a LOT of words at once. I need the words, definitions, and pronunciations returned on one page.

## Deliverables

I need to use a PHP form to query a MySQL database.

I have a dictionary database with a few thousand entries. I *must* be able to enter, say, 50 to 100 words at once and return those 50 words with the entered words, pronunciations, and definitions. It is easy to do this one word at a time, but that's much too slow for me. I need to do this quickly, so I need to enter a LOT of words at once. I need the words, definitions, and pronunciations returned on one page.

Note:

* I am attaching the file that I have been working on myself. I can get most of this, but I can't make it accept multiple terms all at once. (I tried passing exploded variables from the form, but gave up.)

* I am attaching a sample of the database.

* I have modified some things, such as username, password, database name, etc., for security reasons.

### More information and requirements

This is an idea of what the form should look like. If you can make it better, please do.

#### Form with words entered (before hitting Submit)

This is an example of what the form should look like right before the user clicks Submit if the user needs three words defined:

#### Results

The results need to be separated by a comma and should look like this:

IMPORTANT! Please read:

* I need the entire code, from the opening ? doctype declaration to the very last body tag. (Just to make sure that it works.)

* I am enclosing the code of what I was working on as an example. Please improve on it and change anything.

* Please comment the code nicely. (I need to learn!)

* Note: Although this code is NOT for public use, it would be nice to have some security measures, such stripping SQL-injection attacks, etc. Mostly to be safe, but also partly to learn.

* Do a good job, and I have a lot more of stuff like this.

* I have tried to upload the files people have requested, but if I'm missing anything, let me know. Thanks!

* * *This broadcast message was sent to all bidders on Friday Dec 10, 2010 1:21:55 PM:

Hi, everybody. I have removed the 'expert rating' requirement (or whatever it's called), so please place your bids. I may choose more than one person, since it seems a couple of you are capable and easy to work with. Thank you.

* * *This broadcast message was sent to all bidders on Friday Dec 10, 2010 3:15:20 PM:

Thanks to the people who reported that the .php file in the uploaded document was simply a copy of the job description. I have updated the document to show the code that I've been playing with. It should be apparent where I'm not passing variables properly.

* * *This broadcast message was sent to all bidders on Wednesday Dec 15, 2010 1:43:35 AM:

Hello, everybody. This is just a quick announcement to let you know that this project has been completed. Two people actually put up demo scripts when they messaged me; of those, one was very close to the instructions, down to the placement of the commas and so on. This was a small project, but I still considered choosing more than one coder, just to compare coding and commenting styles, but since the script is completed and working, I've decided to start putting together my next projects. A few of you seem like good people with solid skills at fair rates, and I will get in touch with you separately to follow up on messages sent.

## Platform

-

Habilidades: Amazon Web Services, Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: solid works work, solid works projects, solid works job, skills improve, safe touch, projects search, people search work, learn sql, like learn, get right code, database one word two, coder search, to search, learn code, database skills, database management skills, database management job description, php learn, job search coder, sql database improve, need quick mysql script, mysql database , mysql copy, database security, code security

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #2974288

10 freelancers estão ofertando em média $83 para este trabalho

andreioniga

See private message.

$68 USD in 2 dias
(43 Comentários)
6.8
ofer

See private message.

$127.5 USD in 2 dias
(156 Comentários)
6.4
vishaygupta

See private message.

$85 USD in 2 dias
(48 Comentários)
5.9
gopisoft

See private message.

$382.5 USD in 2 dias
(58 Comentários)
5.8
keithyox1

See private message.

$22.1 USD in 2 dias
(42 Comentários)
5.6
bestflancer

See private message.

$21.25 USD in 2 dias
(12 Comentários)
4.1
roganartu

See private message.

$42.5 USD in 2 dias
(5 Comentários)
3.9
serjrac

See private message.

$8.5 USD in 2 dias
(9 Comentários)
2.6
IamTheCoder

See private message.

$42.5 USD in 2 dias
(10 Comentários)
2.8
nicoe

See private message.

$12.75 USD in 2 dias
(1 Comentário)
0.0
solrak

See private message.

$42.5 USD in 2 dias
(0 Comentários)
0.0