Guriddo » Topic: How to insert data to mysql database from add dialog in jqgrid

How to insert data to mysql database from add dialog in jqgrid

Guriddo
How to insert data to mysql database from add dialog in jqgrid

This topic has 0 replies, 1 voice, and was last updated 13 years, 8 months ago by hemang.gandhi.

Creator

Topic

November 29, 2012 at 9:03 am #80515

hemang.gandhi

Participant

I am trying to have a jqgrid on my webpage with all the functionality.

Currently I am able to fill the grid with data from mysql database.

Now I have kept add:true in the navgrid option and with the '+' icon it opens

a add dialog box with 3 fields which on submit I need to add to mysql database.

Here's my jqgrid code:

<div class="sfcode"><script type="text/javascript"><br />
jQuery(document).ready(function(){<br />
$("#grid").jqGrid({<br />
// data: mydata,<br />
datatype: &#39;json&#39;,<br />
mtype: &#39;POST&#39;,<br />
url: &#39;showResources.php&#39;,<br />
width: 700,<br />
colNames:["LAB NAME","RESOURCE NAME","DESCRIPTION"],<br />
colModel:[<br />
{name:&#39;lab_name&#39;, index:&#39;lab_name&#39;, width:40,editable:true, edittype: &#39;select&#39;, <br />editoptions:{value:"nccs:NCCS;tcs:TCS;iisc:IISC;icgeb:ICGEB", <br />dataInit:function(elem)<br />
{<br />
$(elem).width(&#39;auto&#39;);<br />
}<br />
}},<br />
{name:&#39;resource_name&#39;, index:&#39;resource_name&#39;, width:50,editable:true, <br />editoptions:{size:&#39;auto&#39;}},<br />
{name:&#39;description&#39;, index:&#39;description&#39;, width:100,editable:true, <br />edittype: &#39;textarea&#39;, editoptions:{rows:"2",cols:"20"}},<br />
],<br />
pager: "#pager",<br />
rowNum:10,<br />
rownumbers: true,<br />
rowList:[10,20,30],<br />
gridview: true,<br />
sortname: &#39;id&#39;,<br />
viewrecords: true,<br />
loadonce: true,<br />
sortorder: "desc",<br />
caption:"Resources",<br />
height: 250,<br />
editurl: &#39;addResource.php&#39;<br />
}).navGrid(&#39;#pager&#39;,{edit:false,add:true,del:false,search:true},{width: &#39;330&#39;, <br />closeAfterAdd: true });<br />
});<br />
</script><br /><br /></div><p>Here url:showResource.php is the page where I have the logic to fetch </p><p>data into grid from mysql, and editurl: &#39;addResource.php&#39; is where my </p><p> logic for adding the row is which is:</p><br />
<p>code:</p><br />

jQuery(document).ready(function(){

$("#grid").jqGrid({

// data: mydata,

datatype: 'json',

mtype: 'POST',

url: 'showResources.php',

width: 700,

colNames:["LAB NAME","RESOURCE NAME","DESCRIPTION"],

colModel:[

{name:'lab_name', index:'lab_name', width:40,editable:true, edittype: 'select', editoptions:{value:"nccs:NCCS;tcs:TCS;iisc:IISC;icgeb:ICGEB", dataInit:function(elem)

{

$(elem).width('auto');

}

}},

{name:'resource_name', index:'resource_name', width:50,editable:true, editoptions:{size:'auto'}},

{name:'description', index:'description', width:100,editable:true, edittype: 'textarea', editoptions:{rows:"2",cols:"20"}},

],

pager: "#pager",

rowNum:10,

rownumbers: true,

rowList:[10,20,30],

gridview: true,

sortname: 'id',

viewrecords: true,

loadonce: true,

sortorder: "desc",

caption:"Resources",

height: 250,

editurl: 'addResource.php'

}).navGrid('#pager',{edit:false,add:true,del:false,search:true},{width: '330', closeAfterAdd: true });

});

</script> </div>Here url:showResource.php is the page where I have the logic to fetch data into grid from mysql, and editurl: 'addResource.php' is where my logic for adding the row is which is:

code:

<div class="sfcode">$lab_name = $_POST[&#39;lab_name&#39;];  //lab_name field from POST above<br />
$resource_name = $_POST[&#39;resource_name&#39;]; //resource_name field from POST above<br />
$description = $_POST[&#39;description&#39;];  //description field from POST above<br />
$tb_name = &#39;tb_systb_resources&#39;;<br />
<br />
$add_query = "INSERT INTO $tb_name (&#39;&#39;,&#39;lab_name&#39;,&#39;resource_name&#39;,&#39;description&#39;) <br />VALUES (&#39;&#39;,$lab_name,$resource_name,$description)";<br />
$result = mysql_query($add_query);<br />
if($result)<br />
{<br />
echo("<br />Input data is succeed");<br />
}<br />
else<br />
{<br />
echo("<br />Input data is fail");<br />
}<br /><br /><br /></div><p>Now when the page is loaded it says</p><br />
<p>Notice: Undefined index: lab_name in /opt/lampp/htdocs/hemang/addResource.php on line 10</p><br />
<p>Notice: Undefined index: resource_name in /opt/lampp/htdocs/hemang/addResource.php on line 11</p><br />
<p>Notice: Undefined index: description in /opt/lampp/htdocs/hemang/addResource.php on line 12</p><br />
<p>which i have printed and the grid is filled, and the data does add  from the </p><p>dialog but does not store to db. So when I refresh the page or  grid it disappears. </p><p>I am not sure of how to pass the 3 fields&#39; values  from the submit button in add dialog box.</p><br />
<p>Please help.</p>

<div class="sfcode">$lab_name = $_POST['lab_name']; //lab_name field from POST above

$resource_name = $_POST['resource_name']; //resource_name field from POST above

$description = $_POST['description']; //description field from POST above

$tb_name = 'tb_systb_resources';

$add_query = "INSERT INTO $tb_name ('','lab_name','resource_name','description') VALUES ('',$lab_name,$resource_name,$description)";

$result = mysql_query($add_query);

if($result)

{

echo(" Input data is succeed");

}

else

{

echo(" Input data is fail");

} </div>Now when the page is loaded it says

Notice: Undefined index: lab_name in /opt/lampp/htdocs/hemang/addResource.php on line 10

Notice: Undefined index: resource_name in /opt/lampp/htdocs/hemang/addResource.php on line 11

Notice: Undefined index: description in /opt/lampp/htdocs/hemang/addResource.php on line 12

which i have printed and the grid is filled, and the data does add from the dialog but does not store to db. So when I refresh the page or grid it disappears. I am not sure of how to pass the 3 fields' values from the submit button in add dialog box.

Please help.

Creator

Topic

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

How to insert data to mysql database from add dialog in jqgrid

Search Forum

Recent Replies

Forum Statistics

UserOnline