Forum

July 12th, 2025
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Strange behavior of $grid->SelectCommand
05/09/2011
13:09
Avatar
aljosa
New Member
Members
Forum Posts: 1
Member Since:
05/09/2011
sp_UserOfflineSmall Offline

HI,

I have strange problem. If I use "SELECT filed1, field2.... FROM some_table WHERE field1 LIKE 'something'" in "$grid->SelectCommand", everything is working as it should, but if I use variable "SELECT filed1, field2.... FROM some_table WHERE field1 LIKE '$get_variable'" I do not get expected result.

The strange is that I check this variable like this:

$query1 = "......some_table WHERE field1 LIKE 'something'";

$query2 = "......some_table WHERE field1 LIKE '$get_variable'";

if ($query1 == $query2) { echo "OK"; } else { echo "NOT OK"; }

-----------

I get "OK", but if I use it in "$grid->SelectCommand" I am not getting the same result (at $query2 I do not get any records).

The funiest is that if I define this variable like $get_variable = "something"; its working, but if I get this variable like $get_variable = ($_GET['get_variable']) ? $_GET['get_variable'] : $_POST['get_variable']; then it I do not get any result.

Any ideas?

05/09/2011
19:39
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

Please post your problem here.

http://www.trirand.net/forum/

It seems You use the commertial PHP component.

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information