How to match words with those in the database?

[dsmarinov]

Hi there, I’m wondering if it possible to match words, which are inserted by a form, with for example “id” that corresponds to the word I want a redirection to?

I currently wrote a code which has a href link inside it, with “&word_id=” as a key. The problem is I can’t match the inserted word with the one corresponding in the database.

Any idea or help appreciated.

[Dormilich]

@dsmarinov

I’m wondering if it possible to match words

yes. The SQL commands for that are WHERE, LIKE or–if you need to do a full text search–MATCH.

[Dormilich]

@dsmarinov

This is the code I’m using.

And for what are you using it and how does that relate to the question?

besides, you’re totally open to SQL injection with that.

@dsmarinov

Do I need to duplicate the SELECT command for that or can I use the existing one?

That depends. using a function would certainly enhance re-usability.