How to query MYSQL when clicked?

Question

I have a while statement, echoing my whole database that match a WHERE parameter. How can I make it so when I click on something (anything for the moment), it updates that specific row. Here's my code.

                    while($request = mysql_fetch_array( $request_db )) {
                    echo "<tr><td style=\"width:33%;padding:1px;\">";
                    echo $request['SongName'];  
                    echo "</td><td style=\"width:33%;\">";
                    echo $request['Artist'];    
                    echo "</td><td style=\"width:33%;\">";
                    echo $request['DedicatedTo'];
                    echo "</td><td style=\"width:33%;\">";
                    echo "UPDATE A ROW's 'Hasplayed' value to '1'.";
                    echo "</td></tr>";  
                }
                echo "</table>";

Thanks!

EDIT: If you want an example, PHPmyAdmin can do this. Could I use some sort temporary cookie?

Comments seem to point towards ajax but you didn't indicate whether a page reload is allowed on click or not. — koen
– koen, Commented Jun 17, 2010 at 10:10

Your Common Sense · Accepted Answer · 2010-06-17 10:09:12Z

1

You can make a form and a button.
And update your table usual way, by handling this form with some PHP script.

You will need such a script anyway. Because no browser nor cookie can have access to your database. But only PHP script.

You can add to this script AJAX functionality later.

answered Jun 17, 2010 at 10:09

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Sam Over a year ago

I was thinking about this, but does a form require some sort of <input>?

Your Common Sense Over a year ago

@Sam sure it does. though you can use javascript "onclick" property on any element, if you wish. what kind of control you want?

Your Common Sense Over a year ago

but you'd better to do it step by step. Add input type = "submit" first to test if it ever works

Sam Over a year ago

Is it possible to do this WITHOUT an input? Would it be as simple as adding a name attribute to a <p> or <div>, and whatever is in is is sent through?

Sam Over a year ago

Why must I use JavaScript to do this? I'm under the impression that all I have to do is wrap the text I want to send through in a <p>, <div> or <span> and then wrap that in a form like a normal form. Are there any tutorials or SO questions? A name for this process?

|

Tobias Reithmeier · Accepted Answer · 2010-06-17 09:51:44Z

1

Give the rows an id and do an ajax request via a link with the id of the db element as parameter. The server script reloads that db id and returns the fresh database values. :)

answered Jun 17, 2010 at 9:51

Tobias Reithmeier

6818 silver badges19 bronze badges

1 Comment

Sam Over a year ago

Are there any other ways to achieve this? I am not very experienced in AJAX.

Collectives™ on Stack Overflow

How to query MYSQL when clicked?

2 Answers 2

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related