Here i am attaching the code and php file .........i can read the data from the data base .but cant update and delete...
after deletion value still in the database.. please help me..
<html>
<head>
<title>GRID PHP</title>
<link rel="stylesheet" href="CSS/kendo.common.min.css" />
<link rel="stylesheet" href="CSS/kendo.blueopal.min.css" />
<script type="text/javascript" src="JS/jquery.min.js"></script>
<script type="text/javascript" src="JS/kendo.all.min.js"></script>
<script type="text/javascript">
$(function() {
$("#grid").kendoGrid({
dataSource: {
transport: {
read:{
url: "data/Fetch.php",
dataType : "json",
//type: "GET"
},
update: {
url: "data/Update.php",
type: "POST"
},
destroy: {
url: "data/Delete.php",
type: "DEETE"
},
create: {
url: "data/product.php",
type: "PUT"
},
error: function(e)
{
alert(e.responseText);
},
},
//batch: true,
schema: {
data: "data",
model: {
id: "pid",
fields: {
pid: { editable: false },
name: { type: "string",validation: { required: true}},
price: { type: "number",validation: { required: true} },
description: {type: "string"},
}
}
},
pageSize: 10
},
editable: "popup",
height: 400,
selectable : "row",
//filterable: true,
//sortable: true,
pageable: true,
toolbar: ["create","save"],
columns: [
{
field:"pid",
title: "PID",
width:"50"
//filterable: true
},
{
field: "name",
title: "Name",
attributes: {style: "text-align: center; font-size: 14px;"},
},
{
field: "price",
title: "Price",
width:250
},
{
title: "Description",
field: "description"
},
{ command: [{text:"Edit", name:"edit"},
{text:"Delete",name: "destroy"}], title: " ",width:200 }
]
});
function detailInit(e) {
// get a reference to the current row being initialized
//var detailRow = e.detailRow;
// create the datasource
}
});
</script>
</head>
<body>
<div id="grid"></div>
</body>
</html>
after deletion value still in the database.. please help me..
<html>
<head>
<title>GRID PHP</title>
<link rel="stylesheet" href="CSS/kendo.common.min.css" />
<link rel="stylesheet" href="CSS/kendo.blueopal.min.css" />
<script type="text/javascript" src="JS/jquery.min.js"></script>
<script type="text/javascript" src="JS/kendo.all.min.js"></script>
<script type="text/javascript">
$(function() {
$("#grid").kendoGrid({
dataSource: {
transport: {
read:{
url: "data/Fetch.php",
dataType : "json",
//type: "GET"
},
update: {
url: "data/Update.php",
type: "POST"
},
destroy: {
url: "data/Delete.php",
type: "DEETE"
},
create: {
url: "data/product.php",
type: "PUT"
},
error: function(e)
{
alert(e.responseText);
},
},
//batch: true,
schema: {
data: "data",
model: {
id: "pid",
fields: {
pid: { editable: false },
name: { type: "string",validation: { required: true}},
price: { type: "number",validation: { required: true} },
description: {type: "string"},
}
}
},
pageSize: 10
},
editable: "popup",
height: 400,
selectable : "row",
//filterable: true,
//sortable: true,
pageable: true,
toolbar: ["create","save"],
columns: [
{
field:"pid",
title: "PID",
width:"50"
//filterable: true
},
{
field: "name",
title: "Name",
attributes: {style: "text-align: center; font-size: 14px;"},
},
{
field: "price",
title: "Price",
width:250
},
{
title: "Description",
field: "description"
},
{ command: [{text:"Edit", name:"edit"},
{text:"Delete",name: "destroy"}], title: " ",width:200 }
]
});
function detailInit(e) {
// get a reference to the current row being initialized
//var detailRow = e.detailRow;
// create the datasource
}
});
</script>
</head>
<body>
<div id="grid"></div>
</body>
</html>
4 Answers, 1 is accepted
0
Hello Thoams,
Do you receive that ID parameters on the server side successfully?
If you do then removing the item from the database should not be also done without any struggling.
Kind Regards,
Petur Subev
Telerik
Do you receive that ID parameters on the server side successfully?
$rs = mysql_query($con,"DELETE FROM products WHERE pid = " .$Id);If you do then removing the item from the database should not be also done without any struggling.
Kind Regards,
Petur Subev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Thomas
Top achievements
Rank 1
Rank 1
answered on 15 Jan 2014, 05:21 AM
Thank you Petur Subev I got it....
0
Thomas
Top achievements
Rank 1
Rank 1
answered on 17 Jan 2014, 08:14 AM
Hai all
I have another problem ...
I am using Popup editing ....When a user edits an existing record and saves the results, the data will update properly, but the PopUp window will not close
and also i want to refresh the grid after update and create.........help me ....thank u......
0
Hello Thomas,
Are there any JavaScript errors in the console? If they are not, what exactly do you return from the server for that Update request? Do you return the updated record like shown here.
http://docs.kendoui.com/getting-started/using-kendo-with/php/widgets/grid/editing#create-php-file-which-performs-crud-(using-datasourceresult)
If you want to refresh the whole Grid with data from the server (not just the updated record because it will be refreshed automatically) then you should invoke the read() method of the dataSource when the requestEnd event is triggered.
e.g.
Kind Regards,
Petur Subev
Telerik
Are there any JavaScript errors in the console? If they are not, what exactly do you return from the server for that Update request? Do you return the updated record like shown here.
http://docs.kendoui.com/getting-started/using-kendo-with/php/widgets/grid/editing#create-php-file-which-performs-crud-(using-datasourceresult)
If you want to refresh the whole Grid with data from the server (not just the updated record because it will be refreshed automatically) then you should invoke the read() method of the dataSource when the requestEnd event is triggered.
e.g.
function onRequestEnd(e) { this.read();}Kind Regards,
Petur Subev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!