Delete

Does anyone have an example of implementing actual Delete funtion?

$x->addStandardControl(EyeDataGrid::STDCTRL_DELETE, "alert('Deleting %ID%')");

Currently this just displays an alert popup.

How do you implement it so it actually performs the delete.

Sorry but so far I cannot help you because when I try to test the application I get stopped already on line 28 and if I commentout that line I get parse error on next statement. Perhaps you can give me a hint about what I am doing wrong. The file I mean is class.eyemysqladap.ink.php. I have the latest Apach, Mysql,php from XAMPP. All files are in folder htdocs.
This is the error:
"Parse error: parse error in C:\xampp\htdocs\class.eyemysqladap.inc.php on line 28" and line 28 is this: private $link;

please help, i am in the same situation.

I might be to late for this. But just for sharing purpose:
The solution may look something like this:

$x->addStandardControl(EyeDataGrid::STDCTRL_DELETE, "window.location.replace('yourdeletephpcode.php?&primaryKeyFieldName=%_P%')");

The javascript is written to navigate the page to your delete php script, by passing the value through the variable over the URL (i.e. primaryKeyFieldName). You may write your delete function there (i.e. yourdeletephpcode.php).

You may get the value of the primary key by requesting $_GET["primaryKeyFieldName"] over your delete php script.

Cheers!

create function with parameter... better do with ajax..


ElementID= the html element ID that would take ajax effect
ID= your primary key or the fieldname of your delete condition
handlePage= PHP code that would do the delete code

function deldata(handlePage,ElementID,ID) {
if (xmlhttp.readyState == 4 || xmlhttp.readyState == 0) {
var obj = document.getElementById(ElementID);
var form = obj.innerHTML;
obj.innerHTML = 'Deleting Data, please wait..';
xmlhttp.open('POST', handlePage, true);
xmlhttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4) {
if (xmlhttp.status == 200) {
obj.innerHTML = xmlhttp.responseText + '<br>' + form;
setTimeout(tblReset(), 1000);
} else {
alert('Error : ' + xmlhttp.statusText);
}
}
}
var param = 'ID=' + ID;
xmlhttp.send(param);
}
}


and this is how to call your ajax function

$x->addStandardControl(EyeDataGrid::STDCTRL_DELETE,
"deldata('yourhandlePage.php','yourElementID','%yourprimarykey%')");

to make it easier i'll give you the handlepage example
<?php

$id = $_POST['ID'];
$query = "delete from table where yourID='" . $id . "'";
$result= mysql_query($query);
if ($result)
{
echo 'data has been deleted';
} else
{
echo '<font color="red">Error, CAN NOT DELETE DATA</font>';
}

?>


ajax is easy... cheersssss.........