Guriddo » Topic: Ask: Integrated Search Toolbar->PHP-Mysql syntax

Ask: Integrated Search Toolbar->PHP-Mysql syntax

Guriddo
Ask: Integrated Search Toolbar->PHP-Mysql syntax

This topic has 2 replies, 2 voices, and was last updated 16 years, 3 months ago by admin.

Creator

Topic
January 14, 2010 at 2:37 pm #75199

admin
Keymaster

Dear all,

I want to use integrated earch toolbar on my jggrid. I want to modificate your PHP-MYSQL
Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies
January 14, 2010 at 8:35 pm #92089

newperson
Participant

$searchOn = Strip($_REQUEST['_search']);

there is a function called Strip that will remove slashes from the user typed text

foreach( $sarr as $k=>$v) {

more or less this is pretty much saying for every value that the user entered in *note that the $v is data that comes out of your Strip function which as I mentioned it removes slashes from the user typed fields.

$wh .= ” AND “.$k.” LIKE '”.$v.”%'”;

If you noticed, your MYSQL syntax has .$wh at the end of it….and it needs this for searching basically this constructs a where clause that gives appends AND id, invdate,name,note plus a LIKE statement and since id,invdate,name,note are integer,text fields you are able to use the LIKE operator as opposed to float values such as amount, tax,total that is why you don't see the LIKE operator in

January 16, 2010 at 7:57 am #92130

admin
Keymaster

To newperson,

Thx for your explanation. But I still have problem on it.

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;}

I can not find the strip function on php manual but I find stripslashes, is it similar?because if i use Strip function it causes error.

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;}

if i run PHP-MYSQL example code with IE, the code do not work,could you help me find where is my error lies?

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;}

<?php

include 'config/connect.php';
Author

Replies