CMS Made Simple Forums

I have a site with dynamic MySQL data incorporated into CMSMS.

I would like to make some basic searches in the MySQL database with user input. But I have not found how to do it. What I would like to have in my user defined tag is something like this: SELECT * FROM table WHERE field=[input]%

I could be a simple "Get" prcedure, where the [input] is included as a Get variable. But it must give the result with two paramaters in the form
index.php?page=name&input=Word

In all the examples I have tried, I get only one of the parameters.

Can anyone help me with some code?

olavt wrote: I have a site with dynamic MySQL data incorporated into CMSMS.

I would like to make some basic searches in the MySQL database with user input. But I have not found how to do it. What I would like to have in my user defined tag is something like this: SELECT * FROM table WHERE field=[input]%

I could be a simple "Get" prcedure, where the [input] is included as a Get variable. But it must give the result with two paramaters in the form
index.php?page=name&input=Word

In all the examples I have tried, I get only one of the parameters.

Have you add action="get" in your search form?
Or post your search form html code

Alby

alby wrote: Have you add action="get" in your search form?
Or post your search form html code

Alby

I have tried something like this:

echo '
Name:


';

But the result is: index.php?name=clapton , which only gives the index page, as the parameters are not correct.

olavt wrote: I have tried something like this:

echo '
Name:


';

But the result is: index.php?name=clapton , which only gives the index page, as the parameters are not correct.

No, the sintax is:

echo '
Name:


';

If artist is the alias of your page and page is value in config.php of query_var:
$config['query_var'] = 'page';

Alby

or even
works with post also...

While tsw was writing his reply, I was also trying the "hidden" input, and it worked with a code like this:

echo '

Name:


';