This is a migrated thread and some comments may be shown as answers.

CRUD actions - what should server response be?

14 Answers 956 Views

Grid

This is a migrated thread and some comments may be shown as answers.

14 Answers, 1 is accepted

Accepted

answered on 31 Aug 2012, 10:29 AM

A very simple case of a php kendo grid with crud

Index:

<html>

<head>

<title>GRID PHP</title>

<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.2.710/styles/kendo.common.min.css" />

<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.2.710/styles/kendo.blueopal.min.css" />

<script type="text/javascript" src="http://cdn.kendostatic.com/2012.2.710/js/jquery.min.js"></script>

<script type="text/javascript" src="http://cdn.kendostatic.com/2012.2.710/js/kendo.all.min.js"></script>

<script type="text/javascript">

$(function() {

$("#grid").kendoGrid({

dataSource: {

transport: {

read: "data/fetch.php",

update: {url:"data/update.php", type:"POST"},

create: {url:"data/create.php",type:"POST"},

destroy: {url:"data/destroy.php",type:"POST"}

},

batch: true,

schema: {

model: {

id: "Id",

fields: {

Id: { type: "number" },

Column1: { type: "string"},

Column2: { type: "string" },

}

},

pageSize: 25

},

editable: "inline",

height: 600,

filterable: true,

sortable: true,

pageable: true,

toolbar: ["create"],

columns: [{

field:"Column1",

title: "Column1",

filterable: true

},

{

field: "Column2",

title: "Column2",

},

                                      { command: [{text:"Edit record", name:"edit"}, {text:"Delete record",name:"destroy"}], title: " ", width: "210px" }

]

});

</script>

</head>

<body>

<div id="grid"></div>

</body>

</html>

The data part.
Fetch.php:

<?php

header("Content-type: application/json");

$con = mysql_connect("host", "user", "password");

if (!$con

{

die('Could not connect: '

. mysql_error());

} else {

mysql_select_db("database", $con);

$res = mysql_query("SELECT * From Table");

$arr = array();

while($obj = mysql_fetch_array($res)) {

$arr[] = array(

'Id' => $obj["Id"],

'Column1' => str_replace("\'", "'", $obj["Column1"]),

'Column2' => str_replace("\'", "'", $obj["Column2"])

);

}

mysql_close($con);

print json_encode($arr);

}

?>

Update.php:

<?php

header("Content-type: application/json");

$con = mysql_connect("host", "user", "password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

} else {

mysql_select_db("database", $con);

$rs = mysql_query("UPDATE Table SET Column1 = '" . mysql_real_escape_string($_POST['models'][0]['Column1'], $con) . "', Column2 = '" . mysql_real_escape_string($_POST['models'][0]['Column2'], $con) . "' WHERE Id = " . $_POST['models'][0]['Id']);

if ($rs) {

echo json_encode($rs);

}

else {

header("HTTP/1.1 500 Internal Server Error");

echo "Failed on update: " . $_POST['models'][0]['Column1'];

}

mysql_close($con);

}

?>

Create.php:

<?php

header("Content-type: application/json");

$con = mysql_connect("host", "user", "password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

} else {

mysql_select_db("database", $con);

$rs = mysql_query("INSERT INTO Table(Column1, Column2) VALUES('" . mysql_real_escape_string($_POST['models'][0]['Column1'], $con) . "', '" . mysql_real_escape_string($_POST['models'][0]['Column2'], $con) . "')");

if ($rs) {

echo json_encode($rs);

}

else {

header("HTTP/1.1 500 Internal Server Error");

echo "Failed on insert: " . $_POST['models'][0]['Column1'];

}

mysql_close($con);

}

?>

Destroy.php:

<?php

header("Content-type: application/json");

$con = mysql_connect("host", "user", "password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

} else {

mysql_select_db("database", $con);

$rs = mysql_query("DELETE FROM Table WHERE Id = " . $_POST['models'][0]['Id']);

if ($rs) {

echo json_encode($rs);

}

else {

header("HTTP/1.1 500 Internal Server Error");

echo "Failed on delete: " . $_POST['models'][0]['Column1'];

}

mysql_close($con);

}

?>

answered on 09 Oct 2012, 06:19 PM

date-ok.png

date-edit.png

date-refreshed.png

Hello,

I'm using the example of Nohinn success with one exception.

I receive "null" when I try to use date on create or update

Date is fine when fetching from localhost
After updating and refreshing the page the date column says only "null".

See screenshots!

Any idea of how to fix this?!

answered on 13 Oct 2012, 11:30 PM

inventario-FPBA.zip

HI,

Im working with Kendo UI Grid , PHP and MySql.

I have a grid with remote data from php and mysql in json format, the data is displaying correctly
but the paging (Client / local) is not working well ... it shows the data paged but says "No items to display" and "0" pages,
if i chage the "items per page" it allows navigate and shows the total of pages, and if i refresh the grid turn back to the initial state of error. What can i do for make the client paging works with this configuration (php remote data)?
thank you for helping me

here is the code:
i attach the files php, js, sql

//Grid Code

$("#gridProductos").kendoGrid({/*Grid de productos y su configuracion*/

dataSource : {

type : "json",

transport : {

read : "data/products/products.php",

dataType : "json",

type : "POST"

},

schema : {

model : {

id : "codigo"

},

data : "dsProductos"

},

pageSize : 5

},

columns : [{

title : "Codigo",

field : "codigo"

}, {

title : "Referencia",

field : "referencia"

}, {

title : "Marca",

field : "marca"

}, {

command : "edit",

title : " "

}, {

command : "destroy",

title : " "

}],

navigatable : true,

selectable : "row",

sortable : true,

pageable : {

refresh : true,

pageSizes : true

}

});

<?php

//The php code

include_once("../classes/ez_sql_core.php");

include_once("../classes/ez_sql_mysql.php");

include_once("../config.php");

$db = new ezSQL_mysql($db_user,$db_password,$db_name,$db_host);

$q="SELECT `codigo`, `referencia`, `marca` FROM `productos`";

$productos=$db->get_results($q,ARRAY_A);

header("Content-type: application/json");

echo "{\"dsProductos\":" .json_encode($productos). "}";

?>

//The json data returned

{"dsProductos":[{"codigo":"10","referencia":"Sal","marca":"Refisal"},{"codigo":"11","referencia":"Arroz Blanco","marca":"Diana"},{"codigo":"12","referencia":"Aceite Canola","marca":"Fino"},{"codigo":"13","referencia":"Panela Palestina","marca":"La Palestina"},{"codigo":"14","referencia":"Jabon Lavaplatos Liq","marca":"Axion"},{"codigo":"15","referencia":"Azucar 1lb","marca":"Manuelita"},{"codigo":"16","referencia":"Salsa de tomate Fruc","marca":"Fruco"},{"codigo":"17","referencia":"Mayonesa Fruco","marca":"Fruco"},{"codigo":"18","referencia":"Papas fritas Margari","marca":"Margarita"},{"codigo":"19","referencia":"Papas fritas Margari","marca":"Margarita"},{"codigo":"20","referencia":"Caja Gelatina Gelada","marca":"Gelada"}]}