Sigma Php Ajax framework, Ajax Components, GUI Builder
May 21, 2012, 08:32:54 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: please help me with 2 questions, thanks.  (Read 735 times)
biosrs
Jr. Member
**
Posts: 6


View Profile
« on: July 27, 2009, 01:15:01 AM »

2 questions :

1, how to dynamic search multi columns, e.g. if there are two columns "A" and "B", have data [[A:1, B:abc], [A:2, B:def]], and there is one textbox in webpages, so I hope that if I press 1 or abc into that textbox, row [A:1, B:abc] can be shown, and now we can just search only by one column.
2, if data not from file but from database, how to dynamic search with all data if grid pages , now if we get all data from database, the grid could not pages correctly because when page changed it will reload all data from URL so it is always showing the firstly several rows.

thanks.
Logged
steven
Moderator
Hero Member
*****
Posts: 544



View Profile
« Reply #1 on: July 28, 2009, 12:19:07 AM »

Before I answer your questions, you need to know sigma ajax grid support client side & server side search. You have to do a server search to gain what you want.
1) you need to do get filter info at server side and translate it into sql, say select * from table1 where A like 'abc%' or B like 'abc%'
2) Also you need to get page info and do a limit by sql
Logged

Sigma AJAX Data Grid - Easy to Integrate with PHP, ASP Classic, ASP.NET & Java
Sigma PHP Ajax Framework - WYSIWYG GUI Builder With Tree, Grid, Treegrid, Dialog, Tab & More Component
biosrs
Jr. Member
**
Posts: 6


View Profile
« Reply #2 on: July 28, 2009, 06:38:21 PM »

Before I answer your questions, you need to know sigma ajax grid support client side & server side search. You have to do a server search to gain what you want.
1) you need to do get filter info at server side and translate it into sql, say select * from table1 where A like 'abc%' or B like 'abc%'
2) Also you need to get page info and do a limit by sql


thanks steven, to question 2, I can set remotepage=false and get all data into grid,
to question 1, I hope to know how to do a server filter(or how to set) in sigma grid, there is no demo for it,

another question : if I do dynamic search in server's side, how to page data in server's side at meantime.

thanks.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!