onclick and php mysql query

Forum Moderators: coopster

Message Too Old, No Replies

onclick and php mysql query

click on a button then run the variable to query the db

indiguy

3:31 am on Aug 31, 2009 (gmt 0)

hi, i have a new question ive been working on:
I have 4 options from buttons in php page.
i want to be able to click on a button then run the variable to query the db, and if another button is clicked, then the variable relating to that is queried etc...

Can it be done?

eg:
$menu1 = mysql_query("..."); //query the database tea table
$menu2 = mysql_query("...");

echo "<td>"."<input type='button' value='Teas' name='button1' onclick='".$menu1."'></td>";//
echo "<td><input type='button' value='Platters' name='button2' onclick='".$menu2."'></td>";//

if ($menu1) {...}
if ($menu2) {...}

tr8er8

3:50 am on Aug 31, 2009 (gmt 0)

you cant call a php function from onclick.

but you can make those buttons submit, and do this:

if(isset($_POST['button1'])) {
$q = mysql_query("INSERT INTO table (keys) VALUES ('$values')")or die(mysql_error());
if($q) {
echo "successful";
}else {
echo "error";
}
}

andrewsmd

6:24 pm on Aug 31, 2009 (gmt 0)

You can call a function onclick by using AJAX, but it gets kind of complicated. I would take tr8er8's suggestion and just make them buttons. Check out this simple example.
<html>
<body>
<form name="form" method="post">

</form>
</body>
<?php

if(isset($_POST['button1'])){

echo("You clicked button one!");

}//if isset

if(isset($_POST['button2'])){

echo("You clicked button two!");

}//if isset

if(isset($_POST['button3'])){

echo("You clicked button three!");

}//if isset

if(isset($_POST['button4'])){

echo("You clicked button four!");

}//if isset

?>
</html>

indiguy

11:48 pm on Aug 31, 2009 (gmt 0)

you guys are heros.. thanks a lot :)

it works, i never would have guessed, just very new to php. But it makes sence. I tried ifelse, but that didnt work, i didnt know about teh isset option :s

Thank you~