RTFM...
http://www.mysql.com/doc/en/Pattern_matching.html
Håkan wrote:
I'm trying to make a small and simple search function, but it only works for
exact searches, and I can't figure out how to make a wildcard search, if I
do it in the php or in the mysql_query, can't really find anything about
You'll do it in the database, not PHP.
Look into using LIKE in your query...
SELECT * FROM yourtable WHERE column LIKE '%searchterm%'
The % characters are wildcards that'll match any amount of characters.
You can use _ to match a single character.
You could also look at FULL-TEXT indexing in M
That's because this is a MySQL-specific question and you should be reading
the MySQL documentation or asking on the MySQL list.
-Rasmus
On Mon, 11 Nov 2002, Håkan wrote:
> I'm trying to make a small and simple search function, but it only works for
> exact searches, and I can't figure out how to
> If you're only executing one-liners and get all the
> results back you're
> better off using shell_exec(). popen() lets you open
> a pipe to a
> command--that way, you can funnel data to it as if
> you were typing from the keyboard.
That's what I'll do then: use shell_exec().
> Permissions wou
If you're only executing one-liners and get all the results back you're
better off using shell_exec(). popen() lets you open a pipe to a
command--that way, you can funnel data to it as if you were typing from
the keyboard.
Permissions would be a problem with readdir() as well.
Marco
--
<>
These are fine. I'm not going to use Windows for a
server. Won't the same problem in relation to
directory permissions stop me even if I just did a
simple readdir()? The only one I'm too worried about
is the safe mode thing. It works for now, though. The
next server I'm moving to will hopefully
Mako Shark wrote...
> Didn't know of shell_exec() until now. It works, though. Thanks!
>
> Is there any reason why it wouldn't work? If I changed servers, say, and there
> were some ports blocked and etc. etc., is there a risk that I should know?
My understanding is that many security-conscious
Well, as a general rule, it won't work if you're not using a UNIX o/s or
if PHP has been set up with safe mode on, or if you don't have the right
permission to see that folder. That's probably a non-inclusive list, but
there should be ways around each of these problems (depending on the
degree of c
<<$a = explode (' ', shell_exec ("ls $foldername/*.html"));>>
Didn't know of shell_exec() until now. It works, though. Thanks!
Is there any reason why it wouldn't work? If I changed servers, say, and there were
some ports blocked and etc. etc., is there a risk that I should know?
--
> -Original Message-
> From: Mako Shark [mailto:phpman2000@;yahoo.com]
> do I have to do a
> readdir() and read the filename of every file until I find an
> HTML or until all files have been read.
This is what the shell expression supplied by Marco Tabini actually does;
doing it in PHP (re
How about:
$a = explode (' ', shell_exec ("ls $foldername/*.html"));
This should return an array that contains the name of all the *.html
files in the folder $foldername, if any.
Hope this helps.
Cheers,
Marco
-
php|architect -- The Monthly Magazine For PHP Professionals
Come vi
11 matches
Mail list logo