i want to use combobox in a grid using and option tag. data is populated from mysql database. but its show a simple combobox, i.e box is not editable. i have attached my source code
please help me!!
thanks
1. grid.php
Ajax Example
| <a href=javascript:requestInfo(‘showTable.php?mode=new&id=$id’,‘showTable’,’’)>Add New Data | ||||||
| ID | first name | Sur name | Father’s name | Father’s surname |
2. showtable.php
<?php
require “KoolAjax/koolajax/koolajax.php”;
require “koolautocomplete/koolautocomplete.php”;
function service($text)
{
$itemlist = array();
for($i=0;$i<10;$i++)
{
$item = array(“text”=>$text." ".$i);
array_push($itemlist,$item);
}
return $itemlist;
}
$koolajax->enableFunction(“service”);
?>
Ajax Example
<?php
include(“includes/host_conf.php”);
include(“includes/mysql.lib.php”);
$obj=new connect;
$mode=$_GET[“mode”];
echo “
| Data Deleted”; echo “ |
|||||||||||||
| “; | “; | “; | “; | “; | <a href=“javascript:requestInfo(‘showTable.php?mode=list&id=$id’,‘showTable’,’’)”>Cancel | ”;<a href=“javascript:save_data();”>Save | ”;|||||||
| Data Saved”; echo “ |
|||||||||||||
| Data Updated | ”;|||||||||||||
| “; | “; | ”; ?> <?php echo $row['sname']; ?> <?php $strSQL = “SELECT title FROM title ORDER BY title”; $rs = mysql_query($strSQL); while ($row1=mysql_fetch_array($rs)) { echo '<option value=”’.$row1[‘title’].’”’; echo ‘>’. $row1[‘title’] . ‘’.”\n”; } ?> <?php echo " | “;“; | “; | <a href=“javascript:requestInfo(‘showTable.php?mode=list&id=$id’,‘showTable’,’’)”>Cancel | “;<a href=“javascript:update_data();”>Update | ”;“; | ”; | ”; | ”; | ”; | <a href=“javascript:requestInfo(‘showTable.php?mode=update&id=$id’,‘showTable’,’’)” >Modify | “;<a href=“javascript:requestInfo(‘showTable.php?mode=delete&id=$id’,‘showTable’,’’);” onclick=‘return confirmLink(this);’>Delete | ”;
?>
3. script.js
function getHTTPObject() {
var xmlhttp;
if(window.XMLHttpRequest){
xmlhttp = new XMLHttpRequest();
}
else if (window.ActiveXObject){
xmlhttp=new ActiveXObject(“Microsoft.XMLHTTP”);
if (!xmlhttp){
xmlhttp=new ActiveXObject(“Msxml2.XMLHTTP”);
}
}
return xmlhttp;
}
var http = getHTTPObject(); // We create the HTTP Object
/*
Funtion Name=requestInfo
Param = url >> Url to call : id = Passing div id for multiple use ~ as a seprator for eg. div1~div2 :
redirectPage >> if you like to redirect to other page once the event success then
the response text = 1 and the redirectPage not left empty
/
function requestInfo(url,id,redirectPage) {
var temp=new Array();
http.open(“GET”, url, true);
http.onreadystatechange = function() {
if (http.readyState == 4) {
if(http.status==200) {
var results=http.responseText;
if(redirectPage=="" || results!=“1”) {
var temp=id.split("~"); // To display on multiple div
//alert(temp.length);
var r=results.split("~"); // To display multiple data into the div
//alert(temp.length);
if(temp.length>1) {
for(i=0;i<temp.length;i++) {
//alert(temp[i]);
document.getElementById(temp[i]).innerHTML=r[i];
}
} else {
document.getElementById(id).innerHTML = results;
}
} else {
alert(results);
window.location.href=redirectPage;
}
}
}
};
http.send(null);
}
/
Function Name= emptyValidation
Desc = This function is used to validation for the empty field
Param fieldList = This arguments set as a string varialble. you just need to supply the textbox name
if the textbox is multiple then supply with ~ separator for eg. username~password
*/
function emptyValidation(fieldList) {
var field=new Array();
field=fieldList.split(”~”);
var counter=0;
for(i=0;i<field.length;i++) {
if(document.getElementById(field[i]).value==””) {
document.getElementById(field[i]).style.backgroundColor=”#FF0000”;
counter++;
} else {
document.getElementById(field[i]).style.backgroundColor=”#FFFFFF”;
}
}
if(counter>0) {
alert(“The Field mark as red could not left empty”);
return false;
} else {
return true;
}
}
function init_table() {
requestInfo(‘showTable.php?mode=list’,‘showTable’,’’);
}
function save_data() {
var id=document.getElementById(“id”).value;
var fname=document.getElementById(“fname”).value;
var sname=document.getElementById(“sname”).value;
var gfname=document.getElementById(“gfname”).value;
var gsname=document.getElementById(“gsname”).value;
var checkValidation=emptyValidation(‘id~fname~sname~gfname~gsname’);
if(checkValidation==true) {
requestInfo(‘showTable.php?mode=save_new&id=’+id+’&fname=’+fname+’&sname=’+sname+’&gfname=’+gfname+’&gsname=’+gsname,‘showTable’,’’);
}
}
function update_data() {
var prev_id=document.getElementById(“prev_id”).value;
var id=document.getElementById(“id”).value;
var fname=document.getElementById(“fname”).value;
var sname=document.getElementById(“sname”).value;
var gfname=document.getElementById(“gfname”).value;
var gsname=document.getElementById(“gsname”).value;
var checkValidation=emptyValidation(‘id~fname~sname~gfname~gsname’);
if(checkValidation==true) {
requestInfo(‘showTable.php?mode=update_data&id=’+id+’&fname=’+fname+’&sname=’+sname+’&gfname=’+gfname+’&gsname=’+gsname+’&prev_id=’+prev_id,‘showTable’,’’);
}
}
function confirmLink(theLink)
{
var is_confirmed = confirm(‘Are you sure to delete this record?\n\nThis will permanently delete the Record!’);
if (is_confirmed) {
theLink.href += ‘’;
}
return is_confirmed;
}