Using user's input data

Yes, just make a form on your page that you have the report on like this:

<form method="POST">
<select name="choice"><option value="...">...</option></select>
</form>

and then add the POST variable to the query like this:

SELECT * FROM table WHERE field = '<?php $_POST[choice]; ?>'

Thank You!

I’ve use the following codes in my template, it doesn’t seem to retrieve anything, but works only if I hard coded the ‘choice’.

Could it be my syntax error here? I tried both $_POST[‘choice’] and $_POST[choice]..

<?php
$str = “SELECT * FROM wp_cf7dbplugin_submits where field_name = “. $_POST[‘choice’];

$res = $wpdb->get_results( $str );
foreach ( $res as $a ) {echo $a->field_name. ” = “. $a->field_value.”
“;}
?>

Dickson

Ok I got it!

It should be
<?php
$str = “SELECT * FROM wp_cf7dbplugin_submits where field_name = ‘”. $_POST[‘choice’].”‘”;

…?>

Thank You!
Dickson

Ok, I’m a little confused. Are you using my plugin to display the query or are you writing your own PHP?

The example I give in my last post was to be used within my plugin.

The code you have shown here looks like your own custom PHP.

… just got you second post as I was writing this. I guess you figured it out. ??

Aloha, Eli

Initially I tried using

SELECT * FROM wp_cf7dbplugin_submits WHERE field_name = “<?php $_POST[‘choice’]; ?>”

in your plugin, and use the shortcode over the page with user input. However cant seem to get the input working…
So I tried putting it in the template page of php..

Is that the correct way of sending input to the plugin?

??
Dickson

$_POST[‘choice’];
the above is correct in PHP but in my plugin you can only access the elements in global array without the quotes, like this:
$_POST[choice];

If you give me the URL to the page where you are using my shortcode I’ll take a look and see if I can tell what’s wrong.

Oh! I just figured out again..
It should be
SELECT * FROM wp_cf7dbplugin_submits WHERE field_value = ‘<?php $_POST[prdt]; ?>’

field_value ??

Thanks alot, its working now ??

Dickson