simple database

Greg_BigPhpAmat

Hello.
I am looking for sample code where after type in input field any word script will find descripction to this word in database. I have alredy database but dont knwo how to use it.
database sample:

INSERT INTO `words` VALUES ('', ' word1', 'description1', NOW());

I could write all descriptions in txt file if this way is easer.
Thank you🙂

bradgrafelman

Just to be clear, are you wanting a sort of "auto-complete" script that offers word suggestions as you are typing (similar to the search box on Google)? Or, are you instead simply after a script that allows you to submit a word and it then displays the corresponding definition?

Greg_BigPhpAmat

bradgrafelman;10907839 wrote:
Just to be clear, are you wanting a sort of "auto-complete" script that offers word suggestions as you are typing (similar to the search box on Google)? Or, are you instead simply after a script that allows you to submit a word and it then displays the corresponding definition?

2nd. I just want to create simple small dictionary. Just want the script to find description for word after typing word. Thats my wish but not sure if it is not to much for my knowledge🙂

bradgrafelman

Well, first I would suggest cleaning up your INSERT's; specify the column names in the query and omit columns such as AUTO_INCREMENT id's and whatnot.

Second, you'd just do a simple SELECT query with a WHERE clause to lookup the data. Example format:

SELECT foo FROM bar WHERE foobar = 'world'

EDIT: Also note that adding an index on the column you're searching (e.g. the word column) would help optimize the SELECT queries.

Greg_BigPhpAmat

bradgrafelman;10907912 wrote:
Well, first I would suggest cleaning up your INSERT's; specify the column names in the query and omit columns such as AUTO_INCREMENT id's and whatnot.

I tried to dump my data to database. I did setup table. All data I have in sql. file. so I tried RESTORE from that file and I got error. Could you tell me how can I dump data to my table on server. Right now it looks like this:

[/INSERT INTO words VALUES ('', ' word1', 'description1', NOW());