 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Mobile Dev World | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<HTML> <TITLE>Color Selector Widget</TITLE> <BODY> <? /* Script Name: color_drop.html Script Purpose: A widget for presenting color options in a drop down menu. Script Author: Paul D. Meagher (meagher@mallnetglobal.com). Copyright: Open Source Freeware. Demo: http://www.mallnetglobal.com/colors/color_drop.html Script Setup: This script draws color information (color name, color code) from a MySQL database and presents it to the user as a drop down menu of color terms. There are many situations in which you will want to allow people to control the color of some object by selecting its color. In this example, I want to allow the person to control the color of text. You will need to create a database and insert color names and associated rgb values into it. I have developed a php3 script that facilitates entry of new color terms and values, but it is not yet ready for release. This might be overkill as it is probably easier to load a text file of mysql inserts. Here is the table schema that I am using. CREATE TABLE colors ( uid MEDIUMINT(8) NOT NULL AUTO_INCREMENT, color_name VARCHAR(50), color_code VARCHAR(10), PRIMARY KEY(uid) ); The program also maintains state information about the color previously selected. If this program is passed the variable text_color, it will present its value as the currently selected item in the drop down box. */ /* Declare some variables. */ $hostname = "localhost"; $password = ""; $user = "ftp"; $database = "colors_db"; $table = "colors"; /* Main Loop */ echo "The text will look link this <font color=\"$text_color\">Sample</font> <br>"; mysql_connect($hosthame,$user,$password); $result = mysql($database, "SELECT distinct color_name,color_code FROM $table ORDER BY color_name"); $num_cols = mysql_numrows($result); $counter = 0; echo "<FORM METHOD = \"POST\" ACTION=\"color_drop.html\">\n"; echo "<select name=\"text_color\">\n"; if ($text_color == "") { echo "<option selected>Select Color...\n" ; }; while($counter < $num_cols): $cn = @mysql_result($result,$counter, "color_name"); $cc = @mysql_result($result,$counter, "color_code"); if ($text_color == $cc) { echo "<option value=\"$cc\" selected>$cn\n" ; } else { echo "<option value=\"$cc\">$cn\n" ; }; $counter = $counter + 1; endwhile; echo "</select>\n"; echo "<INPUT TYPE=\"submit\" VALUE=\"View Color\">\n"; echo "</FORM>\n"; ?> </BODY> </HTML> | |||||
| Related Code Examples | |||||
