examples of database integration with combobox

Screen shoot :

This is the step :

First :

Make one database.
Exp : test

And then., Import this code to test database :

--
-- Table structure for table `sql_stat`
--
CREATE TABLE IF NOT EXISTS `sql_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `statement` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `sql_stat`
--
INSERT INTO `sql_stat` (`id`, `name`, `statement`) VALUES
(1, 'select', 'SELECT * FROM [nama_tabel]'),
(2, 'insert', 'INSERT INTO [nama_tabel] SET [nama_field]=[parameter_pemberi]');

Second :


Just Copy and Paste this code and save it with name : index.php
and then open your browser, call it -> exp : localhost/KIKISNE/dbTOcombobox/index.php
Note :
KIKISNE and dbTOcombobox is the name for the Folder on your htdocs.

<?php
/*  KSNE., ST on Jan 2012 | My BOLTEN
contoh integrasi database dengan combobox */

// untuk koneksi ke server dan database
$knks = mysql_connect("localhost","root","");
if (!$knks) die ('Cannot connect to server...');
$knksDB = mysql_select_db("test");
if (!$knksDB) die ('Cannot find Database...');

// untuk ambil data dan menampilkannya di combobox
$q = mysql_query("SELECT id,name,statement FROM sql_stat");
$jml = mysql_num_rows($q);
if ($jml>=1) {
echo '<select name="sqlStat" id="sqlStat" onChange="ksne();">';
echo '<option value="--">--</option>';
for ($i=0;$i<$jml;$i++) {
$dt = mysql_fetch_object($q);
echo '<option value="'.$dt->statement.'">'.$dt->name.'</option>';
}
echo '</select>';

// untuk menampilkan pilihan combobox di textbox
echo '&nbsp;<input type="text" name="tmpl" id="tmpl" size="100">';
}
?>
<script language="javascript">
function ksne() {
document.getElementById('tmpl').value=document.getElementById('sqlStat').value;
}
</script>

or.. you can download the source here