|
|
|
| Title : |
GetCombo
Combo-BOX - Abstraction With function you can retrieve the combo-box structure with its data. |
| Categories : |
PHP, HTML and PHP |
jose di |
| Date : |
Feb 15th 2001 |
| Grade : |
5 of 5 (graded 1 times) |
| Viewed : |
3186 |
| File : |
No file for this code example. |
| Images : |
No Images for this code example. |
|
| Search : |
More code by jose di |
|
| Action : |
Grade This Code Example
|
|
| Tools : |
My Examples List |
|
|
|
|
|
|
<?php
function GetCombo_Where($db, $nombre, $tabla, $campo_lista, $campo_graba,
$campo_seleccionado,$valor_seleccionado,$where)
{
$query="SELECT * FROM $tabla ";
$query.=($where)?"WHERE ".$where:"";
$db -> query ($query);
$cant_registros = $db -> num_rows ( );
$string = "<select name=".$nombre.">";
if ($seleccionado=="")
$string .="<option></option>";
for ($i=1;$i<=$cant_registros;$i++)
{
$db -> next_record ( );
$value = $db -> Record[$campo_graba];
if ($valor_seleccionado == $db -> Record[$campo_seleccionado])
$string .= "<option selected value = ".$value." >";
else
$string .= "<option value = ".$value." >";
$string .= $db -> Record[$campo_lista];
$string .= "</option>";
}
$string .= "</select>";
return $string;
}
?>
How to use it----> GetCombo_Where(database,combo name,table,output combo text, combo value, table row selected, table
value selected, sql where statement without
where clause ); |
|
| PHP3: Formmail. Just a cgi formmail, but than in PHP. It is easy to use!
Categories : HTML and PHP, Email, PHP, Perl, HTML and PHP | | | a function that builds an HTML select list from any mysql table.
Categories : PHP, MySQL, HTML and PHP | | | Tag content retrieval from websites with preg_match
Categories : PHP, Regexps, Arrays, HTML and PHP | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Check parameters validity. Paranoia was designed to check the validity of the parameters that a php page will receive after a form submission. It can be used to check the variables sent by POST or GET
Categories : Algorithms, HTML and PHP, PHP, Variables | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | Constantly refresh your PHP/HTML page data.
Categories : PHP, HTML and PHP, Sybase | | | background music script for random notes in a frame
Categories : PHP, Content Management, HTML and PHP | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Random Image Display
Categories : PHP, Filesystem, Graphics, HTML and PHP | | | PhpView 0.1 - simple php viewer, using temporary files and frames.
Categories : PHP, PHP Options and Info, Debugging, HTML and PHP | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | PHP template processing
Categories : PHP, Templates, HTML and PHP | | | XDT Topsite (Gold v1.0)
Categories : Databases, CSS, PHP, HTML and PHP, Sessions | | | function textwrap will wrap text to any desired width using <BR>\n as the default line break.
Default wrap width is 80 columns.
Categories : Strings, HTML and PHP, PHP | |
|
|
|
