php - Updating MySql table when clicking a button based on content from the table (but not when refreshing the page) -


i'm randomly loading string database table used load youtube video. when user clicks button, want value related loaded video updated in database.

previously had: $uv = $mysqli->query("update table set x = x + 1 embedcode = '" . $row[embedcode]. "';"); , <a href="<?php echo $uv ?>">test</a>

this works triggered when page loads opposed when button clicked. don't have use anchor tag, assumed doing mean when clicking on link table updated, apparently not.

what's best way go this?

ajax

it allows values sent without refresh using javascript , xml


Comments

Post a Comment

Popular posts from this blog

Java sticky instances of class com.mysql.jdbc.Field aggregating -

i noticed (via jmap+jhat) app leaking storing many instances com.mysql.jdbc.field  class - double checked code make sure closing preparedstatements, find few missing didn't change outcome. - preparedstatement created , closed right away - several others created @ start , reused many times - using org.apache.tomcat.jdbc.pool.datasource connection pool what can cause type of behavior? are closing of preparedstatements / result sets using: preparedstatement stmt (possible assignment here); try { // work prepared statement resultset rs; try { while (rs.next()) ... // process results } { rs.close(); } } { stmt.close(); } so guarantee result sets closed when finished (regardless of exceptions) , statements closed (regardless of exceptions)? there other ways write that, idea same. if you're doing of properly, unless have many references it's taking inordinate amount of memory, it's ok , nothing needs done it.
Read more