Hi,
As i'm working on local machine i cant send you the testpage but here is the code.......
Following is the php page on which i'm using Ajax
[PHP]
<?php
//print_r($_REQUEST);
require("connection.php");
foreach($_POST['compt'] as $compt)
{
$dele="delete from TCOMPONENTTYPE where ComponentTypeName='$compt'";
//mysql_query($dele);
print("<br>");
}
$sql="select ComponentTypeName from TCOMPONENTTYPE";
//echo $sql;
$result = mysql_query($sql);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#82B6D7">
<br><br>
<center>
<?php print("<form name=\"comptform\" action=\"adminframes801.php\" method=\"POST\" onSubmit=\"javascript
: return confirm_delete();\">"); ?>
<table border="1" align="center" id="ctypedelete">
<caption>Delete Component Type(s)</caption>
<?php
while(list($ComptName)=mysql_fetch_array($result))
{
print("<tr><td><input type=\"radio\" name=\"compt[]\" value='$ComptName'>$ComptName</td></tr>");
}
?>
<tr><td><input type="submit" value="delete" ><input type="button" value="cancel" onClick="javascript
: window.open('blankdefault.php','frm_form');"></td></tr>
</table>
</form>
</center>
<script>
<!--
function confirm_delete()
{
var agre=confirm('are you sure you want to delete the data???') ;
if(!agre) return false;
else if(!confirm_use())
{
return true;
}
else
{
return true;
}
}
function confirm_send(ustr)
{
var http = getHTTPObject();
http.open('GET', ustr, true);
alert(ustr);
http.onreadystatechange = function()
{
if (http.readyState==4)
{
alert('Ready donut');
alert(http.responseText);
}
}
http.send(null);
}
function confirm_use()
{
var tbl=document.getElementById("ctypedelete");
for(i=0;i<tbl.tBodies[0].rows.length-1;i++)
{
var cBox=document.getElementsByName('compt[]')[i];
if(cBox.checked)
{
alert(cBox.value);
url='checkuse.php?ctname='+cBox.value;
alert(url);
confirm_send(url);
}
}
return false;
}
function getHTTPObject()
{
var xmlhttp;
if (window.ActiveXObject)
{
try
{
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
catch (E)
{
xmlhttp = false;
}
}
}
else
{
xmlhttp = false;
}
if (window.XMLHttpRequest)
{
try
{
xmlhttp = new XMLHttpRequest();
}
catch (e)
{
xmlhttp = false;
}
}
return xmlhttp;
}
-->
</script>
</body>
</html>
[/PHP]
And following is the background PHP script.
[PHP]
<?php
require('connection.php');
$CompTName=$_GET['ctname'];
$query="select Flag from TCOMPONENTTYPE where ComponentTypeName='$CompTName'";
//echo $query;
list($result)=mysql_fetch_row(mysql_query($query)) ;
if($result>0)
{
echo 0;
}
else
{
echo 1;
}
//echo $result;
?>
[/PHP]
Now what i'm doing is...... On first page user will get the option for deleting some values.... If they are used somewhere in database then the user wont be allowed to delete it. and i need to prompt a message regarding the same.......
Regards,
RP
188
