Rollover - is it possible - PHPBuilder Forums

Rollover - is it possible

leoneo

I have a bit of javascript code to display some values as the user passes the cursor over an image.

function frollover(nValue, sName) {
document.f.nAmount.value=nValue;
document.f.sPhone.value=sName;
}

And am using this for the display:

onmouseover="javascript: frollover(120, 'Z7');"

My question is:
I would like to read the values from a mysql database instead of hard coding them in the code. Is there a way of using php to populate the 120 value dynamically from the database without a slow the whole effect if the rollover. On some screens I have up to 30 of these images with a rollover.

Please Help.

Leo

Mordecai

Keep in mind that PHP is server-side and JavaScript is client-side.

What you want can be achieved by using [man]echo[/man] after running a query on MySQL (see [man]mysql_query/man). There are many examples under the [man]mySQL[/man] functions.

leoneo

thanks for you reply, are you saying that I can load the data into an array from the data base and then do a echo from the array with a identifier for the lookup. If I was to do the sql query each time I did the rollover there would be a performance issue?

Leo

dnast

No, rollovers are client side. You'd use php to output (echo) the values you need from the database into the javascript.

for example:

<?php
//Get database values
.
.
?>

<html>
.
.
.
onmouseover="javascript: frollover(<?php echo $db_record['value']?>, 'Z7');"
.
.
</html>
?>

Whatever 'value' is in the current record will be placed into the Javascript. So if that record's value is 150, it would show in the HTML source like

onmouseover="javascript: frollover(150, 'Z7');"

So the querying would be done before rollovers.

leoneo

Thanks for your help dnast, having one last problem though. Could please help!
I need to get all the values for the rollover. I am loading them into an array. I can not get the (blue) prt of the code to work, but the hard coded array (green) works fine. What am I doing wrong?

Many thanks in advance.

My code is as follows.
<?php
$result = mysql_query("SELECT model, points from table where make='sony'") ;

<?while ($phones = mysql_fetch_array($result)) {
$phones["model"];
$phones["points"];
}

//$phones = array("Z7" => "120",
// "Z5" => "40",
// "J6" => "40");

mysql_close($link);

The rollover code is:
onmouseover="javascript: frollover(<?php echo "{$phones['Z7']}"; ?>, 'Z7');"

BuzzLY

Try this instead:

<?while ($phones = mysql_fetch_array($result)) {
$phonelist[$phones["model"]] = $phones["points"];
}

leoneo

Works great , many thanks BuzzLY

Leo😃