How to make search functions? - Page 2

Salathe · 10-06-2007, 03:53 PM

Why bother with using sprintf if you're going to be wrapping the username inside a string in the arguments? If you want to use the function properly (in my eye) then go for something more akin to:

PHP Code:


			
// Note: %% outputs a literal percent character with (s)printf
// See:  http://php.net/sprintf for details
$szSQL = sprintf("SELECT user,id,rank FROM users WHERE user LIKE '%%%s%%' ORDER BY id", $szUsername);

Keep the format string (the query) in one place, and the arguments in another. That's the whole idea of using (s)printf in instances like this.

Haris · 10-06-2007, 04:40 PM

Cool, it works.

Thanks Karl

Haris · 10-06-2007, 04:42 PM

Good point Salathe. :)

Haris · 10-07-2007, 12:24 AM

How would you search query an integer?

PHP Code:


			
            elseif($_POST['areaCode'] != ''){
                $szSQL = sprintf("SELECT id FROM schools WHERE areaCode LIKE '%%%d%%' ORDER BY id", $_POST['areaCode']);
                $iResult = $database->execute($szSQL);
                while($iRow = mysql_fetch_array($iResult, MYSQL_ASSOC)){
                    print_r($iRow);
                }
            }

It prints the array but with an error.
Array ( [id] => 28 ) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Tanax · 10-07-2007, 01:12 AM

PHP Code:


			
elseif($_POST['areaCode'] != ''){

                $szSQL = sprintf("SELECT `id` FROM `schools` WHERE `areaCode` LIKE '%%%d%%' ORDER BY `id`", $_POST['areaCode']);

                $iResult = $database->execute($szSQL);

                while($iRow = mysql_fetch_array($iResult, MYSQL_ASSOC)){

                    print_r($iRow);

                }

            }

Try that..

Haris · 10-07-2007, 01:33 AM

It was another SQL statement causing error. Sorry

Edit: What are those percentage signs for?

How can I search for an integers through the prefix? For example I have 1, I want the query to search the following values:

15346
1546
16436
16347

And not:

5315
3515
53621
64251

Wildhoney · 10-07-2007, 01:54 PM

Take off the percentages from the beginning. So you effectively end up with something like: %d%. The percentage sign is nothing more than a wild-card.