Building a SQL query with LIKE and 's

[meiyu]

Hello, I'm trying to build a SQL query for odbc_exec that includes a LIKE clause with wildcards (ie, '%a'). The query never returns results, but if I use a query for a record value (ie, where FIELD = 15678) this works as expected. I've tried to use the addslashes() function and tried using `s instead of 's.
How can I do this? Thanks!
Mei

[egami]

SELECT * FROM table WHERE field LIKE '%s%'

[meiyu]

Thanks egami. I guess I forgot to mention that I'm not a complete idiot!
I can issue the SQL query within all the normal interfaces as you wrote without any problem, but how do I escape out the 's in the like clause to put into a query string for use in odbc_exec? For example, odbc_exec( $conn, "SELECT * FROM table WHERE field LIKE '%s%'" ) doesn't work. Neither does odbc_exec( $conn, addslashes("SELECT * FROM table WHERE field LIKE '%s%'") ). Replacing the 's with `s also has no effect.
The query string is built dynamically using variable values during page execution.
Mei

[Nullsig]

Have you tried echo'ing out the dynamically produced query and executing it on the SQL server (through some method other than utilizing your PHP server)

Sometimes actually reading through the query once it is completely generated helps ascertain what is incorrect about it. From your description (and no knowledge about the content or structure of your database) your query looks correct and the type of slashes should not be causing the problem.

All of this is assuming that you are, as you say, not a complete idiot.

[egami]

After smoking a huge blunt, and taking a couple of vicadine, I think I know what the issue is.

IF your variable that you're doing the search on as a tick or a back-tick in the variable, that will end the "string" to search for, but that leaves one open tick left, and then the script bombs.

$variable = addslashes($variable);

before your query and see if that makes the difference.

[meiyu]

I prefer opium myself but the effect is much the same!
I had tried addslashes() as part of the odbc_exec() function call and also as part of the assignment statement for the variable. Neither had any effect.
A dynamic query that doesn't use the LIKE (which necessitates the 's) works as expected.
Echoing the variable ($sql) and using the result within Management Studio, minus the \s (SELECT * from dbname WHERE field LIKE 'a%'), works as expected. The echoed variable value was SELECT * FROM dbname WHERE field LIKE \'a%\'
I would pull my hair out but they may not recognize me at the opium den and I gots to have some fun!

[Nullsig]

So just to clarify...

The query shows up as:

Code: Select all

SELECT * FROM dbname WHERE field LIKE \'a%\'

When you use addslashes OR does it happen when you don't use addslashes.

If the latter is the case it seems like your server utilizes magic quotes or something of the sort. In which case you would need to use "stripslashes()" and it should work.

[meiyu]

Thanks Nullsig! stripslashes() worked.
FYI, using addslashes() OR not using addslashes() didn't make any difference. The only thing that worked was stripslashes().
Thanks again!
BTW, MagicQuotes is not enabled on the server for this PHP install. There may be something else loaded elsewhere, but it's not in the PHP install.

[ashksngh]

use* '%s%' for building SQL query.

[griffis99]

Link building is an important factor that will determine whether your website can rank high on Google this is why we have so many link building services and buy high PR links services cheap herve leger bandage dress around us. In SEO, link building is a continuous process that should be done by the optimizer. By getting more websites to point back to your site, the link popularity of your website will increase. herve leger pants Google emphasizes a lot on link popularity. A website with high popularity means that it is important and Google will rank it higher on their natural search engine result pages.
So if you want to achieve success in SEO, you need to build links consistently. Now, let me share with you 5 ways to get back links:
1. Write articles and submit to article directories. In your articles, you can include a URL that points back to your website. Once the various article directories approve your articles, you will score a number of back links to your site. Remember to use keywords in the anchor text of your link.
2. Submit your website to various search engine friendly directories, or ask the link building services to do it for you. There are many directories on the internet - both free and paid. Some of these directories have very high link popularity, such as Yahoo Directory, BOTW, and DMOZ. Once your submission is accepted, your website listing with sale herve leger URL will appear on the directory.
3. Create Squidoo pages. Squidoo is a herve leger selfridges free space on the Internet that allows you to create content that you want to share with others. You can set up a lens (or a page) easily and include your website URL within the content.
4. Write unique & quality articles and post them on your website. When your website has good content, it will attract other webmasters to link back to grey herve leger dress your website so that their website visitors can benefit herve leger atlanta from the content. This will turn your website into a link bait and get you a number of back links.
5. Exchange links with your business associates, suppliers, clients, and other webmasters or buy high PR links for your web site. These are possible candidates to consider for link exchange. Let them know that by exchanging links, visitors from both websites can benefit from the valuable content together.
These are just a few ways to get more back links for your website. Remember that link building is a continuous process and taking help of link building services can easily help you with this. To see results from it, you need to do it consistently. So plan your link building work properly and make sure that you are doing at least one link building activity every day.

Related articles:


cheapest Herve Leger on sale (36)