Questions tagged [jqgrid-php]

Tag for the PHP wrapper of jqGrid.

Description

Tag for the PHP wrapper of jqGrid.

For more information, visit: http://www.trirand.net/default.aspx

199 questions
0
votes
1 answer

Display SUM of each Column , jqGRID

I am using jqGrid and displaying my data in grid I have 5 columns. I want to calculate SUM of each column and display the sum at the end of the column , probably in the footer.![In the below image, the TOTAL is displayed only for Amount col, I want…
Pavy
  • 111
  • 1
  • 11
0
votes
3 answers

JQGrid and Microsoft SQL Server

I am trying to get this awesome JQuery plugin working with SQL Server. I have setup PDO as I use it elsewhere (with MS Access) - I think I have it setup with sql server (2008) now. Here is how I connect: define('DB_DSN',"odbc:Driver={SQL…
Abs
  • 56,052
  • 101
  • 275
  • 409
0
votes
1 answer

jqGrid PHP - exportToPdf/exportToExcel throws Call to Undefined Method

Have run into a problem wiht jqGrid when I try to export a table to PDF, Excel or CSV. Every time I run the code I get "Call to Undefined Method::jqGrid::exportToPdf" (or Excel or CSV, depending on which method I am using. Here is a snip of the…
0
votes
2 answers

set cell value when cell is editable in jqgrid form edit

hi i am using JQGrid and want to set value of a cell to zero when i edit the row and whatever the value of the cell is like if cell value is 103.50 i want to to set to 0 i try editoptions:{dataInit : function (elem){$(elem).val("0");}} and it…
0
votes
1 answer

SELECT WHERE variable not working

I'm working on a table using jqGrid PHP and I'm trying to set my select statement to SELECT with a variable for the WHERE section. I've got the code below: $groupid = isset($_SESSION['group']) ? $_SESSION['group'] : 1; $query = "SELECT MEMBER_ID,…
Josh Allen
  • 987
  • 12
  • 30
0
votes
1 answer

Jqgrid freezes on multi user

I have been using Jqgrid to make an application for multi user ( more than 70 persons ).The grid works perfectly on localhost and even on the server when only one person is using it but as long as there are several person logged on, the application…
Oriana
  • 1
  • 1
0
votes
2 answers

Inject code with nested quotes and apostrophes?

I have this code in my PHP file. var my_edit = "
Edit
"; the variable $upload is…
Jess Stone
  • 677
  • 8
  • 21
0
votes
1 answer

JqGrid PHP: highlight results, when filtering via toolbar

I would like to highlight the search results, when using the filter toolbar. I tried to use the solution Oleg and Abhishek Simon provided here, but it is not working in JqSuite for PHP. grid.php code snippet $highlighting =…
Jess Stone
  • 677
  • 8
  • 21
0
votes
1 answer

Auto-increment field on row edit in JqGrid for PHP?

In JqSuite for PHP, I am trying to auto-increment a field value everytime I submit a row edit. My code is not working though! grid.php excerpt: $custom = <<
Jess Stone
  • 677
  • 8
  • 21
0
votes
1 answer

jqgrid divide a text box value and affect another text box

i using the jqgrid . i have to do a simple calculation on EDIT and ADD modal dialog with text boxes , i have to get a value from one text box and i have to divide by 8 then i have to show an another textbox . I can able get the id of the textboxes…
hserusv
  • 976
  • 1
  • 7
  • 17
0
votes
1 answer

pass value from jqgrid to php and dispaly the data based on the value passed

i have the below two php files and i trying to pass the value from the selected option to the base php file and display the information based on the passed file. fkm_test.php
Carino
  • 3
  • 5
0
votes
1 answer

Hide grouped column headers?

How can grouped column headers be hidden? What I mean is turning this: ... into this: Documentation didn't help unfortunately. Grouping demo
Jess Stone
  • 677
  • 8
  • 21
0
votes
1 answer

JqSuite PHP: get column name or id?

How can I get column info (name or ID) in my custom-format function? Some code in grid.php: $grid->dataType = 'json'; $grid->setColModel(); My custom format function function formatPdfLink(cellValue, options, rowObject) { var cellHtml = "
Jess Stone
  • 677
  • 8
  • 21
0
votes
2 answers

Replace Delete Icon of jqGrid with custom Icon

I wanted to change just the delete Icon of jqGrid in actions column with my own Icon(newTrash-icon.png). I've seen that jqGrid loads Icon from one png icons file. How do I replace the default trashcan Icon with some other trashcan Icon. I tried…
0
votes
1 answer

export jqgrid data to xsl/excel using zend framework

im trying to export a jqgrida data to excel or csv file, and i was following this example php + jqgrid + export to excel, but after i click the button to export the data nothing happens. here goes the code.. this is my list.phtml where i render the…
Hugo Silva
  • 352
  • 8
  • 26