How to make an image "button" select a link from a mysql database

wdanney

Hello, I'm requesting assistance with making an image being used as a button execute a sql command of selecting a link from a database and then loading the link as a new page to the user's browser.

Perfect example, User clicks a video thumbnail, the click calls a PHP function which grabs a variable from the click and the executes a sql select to pull the appropriate video link from the mysql database and display this link as a web page.

I understand I need ajax to make this happen. Can anyone help?

The code I have so far is as follows:

include_once "db.php";

$result = mysql_query("SELECT id, thumbnail, title, descrip, embed, fblike, fbcom, fbimg, thumblk FROM media ");

while($row = mysql_fetch_array($result))
{

echo ' <FORM name="mediaselect" method="GET" action="showimage.php">';

echo ' <input type="text" name="title" '. $row["title"] .' /> ';

echo ' <input type="submit" value="View" />';

echo ' </FORM>';

//////////////////////////////////////////////////////////////////////////

I would like the user to be able to click the video thumbnail to send the required variable to PHP and then have PHP send the sql command to display the results.

Any help is appreciated.

Thanks.

johanafm

wdanney;10991987 wrote:
Hello, I'm requesting assistance with making an image being used as a button

It's simpler to just wrap an image in an anchor. It's also simpler to only retrieve the video url once, when grabbing the stuff for the video thumbnail. Then you can pass this information directly to the videopage instead of having to execute another database query.

printf('
<a href="videopage.php?url=%s&amp;w=%d&amp;h=%d">
	<img src="%s" width="%d" height="%d" />
</a>',
	/* put the url to your video src here rather than an id */
	htmlentities($row['video_url'], ENT_QUOTES, 'utf-8'),
	/* you should also pass in the video dimensions straight away
		so they are known without another db query */
	$row['video_width'],
	$row['video_height'],
	htmlentities($row['thumbnail'], ENT_QUOTES, 'utf-8'),
	$row['thumb_width'],
	$row['thumb_height']
);

wdanney;10991987 wrote:
I understand I need ajax to make this happen. Can anyone help?

No you don't. You only need ajax if you don't want to discard the current document when sending a new request from the browser. And in your case, you could still easily change the video data source using javascript without ajax, since you allready have information about the video url.

But, with the current approach, you just echo a new document containing all the usual stuff (html, head, title etc) and also your video element containing the url from $GET['url'] and width and height from $GET['w'] and $_GET['h'] respectively.

wdanney

johanafm,

Outstanding. I had to add the additional height and width tables and switch around the title and URL tables. After these changes and some code editing this piece of the project is complete. Thank you.