|
|
|
<?
/*
MySQL DB DUMP
CREATE TABLE menus (
menu_id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
menu_name varchar(60) NOT NULL,
menu_desc text,
PRIMARY KEY (menu_id),
UNIQUE menu_name (menu_name)
);
INSERT INTO menus VALUES( '1', 'Activities', 'Test');
INSERT INTO menus VALUES( '2', 'Sports', 'Test');
INSERT INTO menus VALUES( '3', 'Movies', 'Test');
INSERT INTO menus VALUES( '4', 'Some Other', 'Test');
*/
?>
<?header("Content_type: image/gif");?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<TITLE>PHP Generated Gif - Javascript Mouseover - uses MySQL for button text</TITLE>
<?
mysql_connect("localhost","urname","urpass")or die (mysql_error());
mysql_select_db("menu")or die(mysql_error());
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
browserName = navigator.appName;
browserVer = parseInt(navigator.appVersion);
if ((browserName == "Netscape" && browserVer >=3) || (browserName == "Microsoft Internet Explorer" && browserVer >=4))
{
browserOK = "yes";
}
else
{
browserOK = "no";
}
if (browserOK == "yes")
{
<?
$sql_select = "select menu_name from menus order by menu_name";
$result = mysql_query($sql_select);
$number = @MYSQL_NUMROWS($result);
$i = 0;
while ($i < $number)
{
$menu_name = @mysql_result($result,$i,"menu_name");
$im=ImageCreate(150,30);
$black=ImageColorAllocate($im,50,50,50);
$white=ImageColorAllocate($im,255,255,255);
$grey=ImageColorAllocate($im,75,75,75);
$red=ImageColorAllocate($im,255,0,0);
$points[0]=130;$points[1]=10;
$points[2]=130;$points[3]=20;
$points[4]=140;$points[5]=15;
$points1[0]=128;$points1[1]=8;
$points1[2]=128;$points1[3]=22;
$points1[4]=142;$points1[5]=15;
ImageLine($im,0,3,150,3, $grey);
ImageFilledPolygon($im,$points,3,$red);
ImagePolygon($im,$points,3,$grey);
ImagePolygon($im,$points1,3,$red);
ImageString($im, 10,10,10, $menu_name, $red);
ImageGif($im, "images/$i.gif");
$im2=ImageCreate(150,30);
$white2=ImageColorAllocate($im2,200,200,200);
$black2=ImageColorAllocate($im2,0,0,0);
$yellow=ImageColorAllocate($im2,255,128,0);
$blue=ImageColorAllocate($im2,0,0,255);
$red=ImageColorAllocate($im2,255,0,0);
ImageLine($im2,0,3,150,3, $blue);
ImageLine($im2,0,4,150,4, $black2);
ImageLine($im2,10,3,125,3, $red);
ImageString($im2, 12,12,11, $menu_name,$yellow);
ImageString($im2, 10,10,10, $menu_name,$black2);
ImageGif($im2, "images/$i$i.gif");
$menu_name=ereg_replace(" ", "_", $menu_name);
echo"\n$menu_name"."On = new Image(150, 30);";
echo"\n$menu_name"."On.src = \"images/$i.gif\";";
echo"\n$menu_name"."Off = new Image(150, 30);";
echo"\n$menu_name"."Off.src = \"images/$i$i.gif\";";
$i++;
}
?>
}
function imageOn(imgName)
{
if (browserOK == "yes")
{
imgOn = eval(imgName + "On.src");
document [imgName].src = imgOn;
}
}
function imageOff(imgName)
{
if (browserOK == "yes")
{
imgOff = eval(imgName + "Off.src");
document [imgName].src = imgOff;
}
}
//-->
</script></head>
<body bgcolor=black>
<?
$sql_selectmn = "select menu_name from menus order by menu_name";
$resultmn = mysql_query($sql_selectmn);
$numbermn = @MYSQL_NUMROWS($resultmn);
$imn = 0;
while ($imn < $numbermn)
{
$menu_name = @mysql_result($resultmn,$imn,"menu_name");
$menu_name=ereg_replace(" ", "_", $menu_name);
echo"<br>
<A HREF='javagif.php3' onMouseover=\"imageOn('$menu_name')\" onMouseout=\"imageOff('$menu_name')\"><img SRC=\"images/$imn$imn.gif\"
BORDER=\"0\"
WIDTH=150 HEIGHT=30 NAME=$menu_name></a>\n";
$imn++;
}
?>
</body>
</html>
|
|
| Building dynamic menus with PHP & MySQL (ADO), JavaScript and CSS Categories : PHP, Databases, MySQL, Java Script, User Interface | | | Pull Down Surfing - Surf on Change Categories : Java Script, MySQL, HTML and PHP, PHP, Databases | | | Linked comboboxes with php-mysql & javascript Categories : PHP, Java Script, Databases, MySQL | | | OverEasy - PHP generated JavaScript to do mouseovers on
your pages. Modify one file and one function does it all
for you! Categories : PHP, Java Script, HTML and PHP, MySQL | | | This PHP function creates dropdown select lists for time and date that you can change, outputs a 14 char MySQL timestamp in a text field Categories : PHP, MySQL, Java Script, HTML and PHP | | | A Complete table(ADD,EDIT,VIEW,DELETE) management System PHP,MYSQL, JAVASCRIPT Categories : PHP, MySQL, Java Script, Databases | | | A Simple sign up script with PHP and JavaScript validations. Categories : PHP, Java Script, MySQL, Databases | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | AJAX Data Grid System using php and mysql. A complete login system with the ability to display data in a grid using ajax. Add , update and delete the records without reloading the page. Categories : PHP, AJAX, Databases, MySQL, Java Script | | | Retrieve text from table and email to your e-
address in pipe delimited format. Categories : PHP, MySQL | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases, PHP, MySQL, Complete Programs | | | Cut your MySQL Connections to 1 line of code Categories : PHP, Beginner Guides, Databases, MySQL | | | phpAds, a complete banner and ad management system with detailled tracking and stats. Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Displaying records of database in more than one page (paging) Categories : Databases, MySQL, PHP | |
|
|
|