Ereg function

[Anon]

Hi,
I have a Content management system that we've put together using php. In this there
is a php search facility. The visitor types a "word" in to the search and the results are returned with a description directly from the database it is stored in.

When a user creates a new page via the content management system, the information is stored directly into the database. We needed to tell the system when to translate php commands, so that the user of the system can insert php commands into the editor themselves. In order to do this, we use [php_start] and [php_end] to tell the system that everything between this is php.

However, as our search finds text that matches in the database, all of our scripts are coming through also.

Like Such,

Opinions forum
[php_start] require "/home/www/sites/web/_restrict.php"; [php_end]

I was informed that Ereg replace could help with this, but no matter what i try it seems to fail.

Can anyone can tell me what code I would need to tell it to ignore or replace anything after [ and before ] of the two commands.

Regards
Rufo

[Anon]

Can't be done.

[Anon]

Well the expression that matches the stuff between [php_start] and [php_end] would read:

"[php_start](.*?)[php_end]"

Though I don't understand what you want to do with it once you have matched it.

[theslinky]

If you want to do exclusive searching, you can approach it a couple ways. here is something I thought of just now. If i have more solutions, i'll post.

How exactly are you searching? Do you have the entire file in a database? and you are using a simple mysql query to search?

If so, then you have to do the following:

use ereg replace on the field you are searching for and replace the instances you find with nulls or empty strings "". Then make this in a field itself in mysql using AS in your select query and then in your WHERE clause, you can say something like WHERE newfield LIKE '%$word%'.

NOTE: in the above, you do NOT create a new field in the table. By creating a new field, I meant doing it in the select...

I'll try to come up with the SQL query for this in a little while and post it here or email you.

In the meanwhile, if you can post your current SQL query, that can speed things up for both you and me (for me because i can see what field names you are using and whether you are already doing something weird with them).

-sridhar

[theslinky]

Why didn't i think of this before!

Do this:

SELECT blah blah FROM yourtable WHERE searchfield LIKE '%$word%' AND NOT LIKE '%[php start]%$word%[php end]%'

let me know if the above query works... it may be a tad bit slow, but at least it will run faster than performing a regex and replacing stuff.

-sridhar