jQuery Grid Plugin - jqGrid - Topic: Reqest simple edit records PHP Example

Candra on Reqest simple edit records PHP Example

Fri, 15 Jan 2010 13:30:16 +0200

To newperson,

Thx for your example code

regards,

Candra

newperson on Reqest simple edit records PHP Example

Wed, 13 Jan 2010 16:17:43 +0200

I think what you are asking is a sample editurl php script so that fields you enter in editable fields are saved onto the database.

Good news is that it is simple and I also downloaded the demos you did and noticed that there is no php code to do this for you in the examples so I will give you what I made up, and you can adjust as necessary. I am new to php so what I created is by no means secure so I wouldn't recommend using it in a production/public environment in other words use at own risk.

editurl: 'someurl.php',

<?php
include("dbconfig.php");

//This contains the unique record to update

$id = $_POST['id'];

//This contains the data that will update the db
$Notes = $_POST['Notes'];

// connect to the database
$db = mysql_connect($dbhost, $dbuser, $dbpassword)
or die("Connection Error: " . mysql_error());

mysql_select_db($database) or die("Error conecting to db.");

mysql_query("UPDATE store_item_monitor SET store_item_monitor.notes='$Notes' where store_item_monitor.record=$id")
or die(mysql_error());

mysql_close($db);

candra on Reqest simple edit records PHP Example

Wed, 13 Jan 2010 15:23:27 +0200

Dear all,

Can anyone help me to give a PHP source code example- how to save/edit record to mysql database, pls?

I need a guidance- how to transfer javascript value to PHP

Regards,

Candra

tony on Reqest simple edit records PHP Example

Sun, 13 Dec 2009 18:12:54 +0200

Hello,

Thank you for this, but this is just examples. Since jqGrid is independend from the server side language it is out of the docs to provide such examples and tuturials for PHP. What would the say people using JSP, ASP and other?

Regards

Tony

linoj on Reqest simple edit records PHP Example

Sun, 13 Dec 2009 09:03:32 +0200

i have the same question. thanks.

hksatay on Reqest simple edit records PHP Example

Wed, 09 Dec 2009 05:56:46 +0200

Hi Tony,

Thanks for ur reply, in fact, i download the demo file from the link: http://www.trirand.com/jqgrid/.....demo36.zip
and lookup a php file: editing.php

I found that it didn't really show how jqGrid handle the server responses if update / delete the records successfully or failure

Can u elaborate it more about that?

Thanks~

tony on Reqest simple edit records PHP Example

Tue, 08 Dec 2009 18:28:18 +0200

Hello,

Welcome.

Also if you download the demo you can see how this is organized and the PHP code too.

Best Regards

Tony

hksatay on Reqest simple edit records PHP Example

Tue, 08 Dec 2009 05:13:05 +0200

Hi all, i am completely new on jqGrid, but it is so powerful. do anyone can show me a simple edit / add records example php?

How jqgrid can get the server response or how php handle the post data?

Thx!