preg_replace / regular expression

[acultism]

Does anybody know how to replace a string not enclosed in single quotes? I have a SQL query and I'd like to replace all field's names (which are strings not enclosed in single quotes) by some values.

E.g.: Replace all title field occurrences in the query below by 'some value'

 [COLOR=blue]select name from Table1 where cod_item = [/COLOR][COLOR=red]13[/COLOR][COLOR=blue] and (title = [/COLOR][COLOR=red]'my title'[/COLOR][COLOR=blue] or title = [/COLOR][COLOR=red]'some title'[/COLOR][COLOR=blue]) and message = [/COLOR][COLOR=red]'this title is weird'[/COLOR] [COLOR=blue]and[/COLOR] [COLOR=red]'that\\'s all'[/COLOR]

See that an escaped single quote is part of the value.

So, it should be:

 [COLOR=blue]select name from Table1 where cod_item = [/COLOR][COLOR=red]13[/COLOR][COLOR=blue] and ([/COLOR][COLOR=red]'some value'[/COLOR] [COLOR=blue] = [/COLOR][COLOR=red]'my title'[/COLOR][COLOR=blue] or [/COLOR][COLOR=red]'some value'[/COLOR] [COLOR=blue] = [/COLOR][COLOR=red]'some title'[/COLOR][COLOR=blue]) and message = [/COLOR][COLOR=red]'this title is weird'[/COLOR] [COLOR=blue]and[/COLOR] [COLOR=red]'that\\'s all'[/COLOR]

I wrote a regular expression that matches patterns within single quotes:

/'(?:(?:(?:\\\\\\\\)*\\\\\')|(?:[^']))+'/

Could it be negated?

Thx in advance.

[dankstick]

I don't understand your SQL. I did understand the last part....

I wrote a regular expression that matches patterns within single quotes:

/'(?🙁?🙁?:\\\\)*\\')|(?:[^']))+'/

Could it be negated?

Try this script...

<?
        $word = "I eat 'a very tasty' lunch 'at my desk' everyday 'except on the weekends'.";
        $no_quotes = preg_match_all("('[A-Za-z 0-9]+')",$word,$regs);
        $things_in_quotes_array = $regs[0];
        echo var_dump($things_in_quotes_array);
?>

What it does is give you an array of the single quoted items only. With this example above it will output every portion that was enclosed in single quotes....

array(3) {
  [0]=>
  string(14) "'a very tasty'"
  [1]=>
  string(12) "'at my desk'"
  [2]=>
  string(24) "'except on the weekends'"
}

You can do whatever with this array.

[acultism]

Sorry, there was an error in my query. It should be:

[COLOR=blue]select name from Table1 where cod_item = [/COLOR][COLOR=red]13[/COLOR][COLOR=blue] and (title = [/COLOR][COLOR=red]'my title'[/COLOR][COLOR=blue] or title = [/COLOR][COLOR=red]'some title'[/COLOR][COLOR=blue]) and message = [/COLOR][COLOR=red]'this title is weird'[/COLOR][COLOR=blue] and subject = [/COLOR][COLOR=red]'that\\'s all'[/COLOR]

What I intend to do is replace all occurrences of the title field by for example 'test' string.

[COLOR=blue]select name from Table1 where cod_item = [/COLOR][COLOR=red]13[/COLOR][COLOR=blue] and ([/COLOR][COLOR=orange]'test'[/COLOR][COLOR=blue] = [/COLOR][COLOR=red]'my title'[/COLOR][COLOR=blue] or [/COLOR][COLOR=orange]'test'[/COLOR] [COLOR=blue] = [/COLOR][COLOR=red]'some title'[/COLOR][COLOR=blue]) and message = [/COLOR][COLOR=red]'this title is weird'[/COLOR][COLOR=blue] and subject = [/COLOR][COLOR=red]'that\\'s all'[/COLOR]

So to achieve this I need a pattern which matches a specified string that ISN'T enclosed in single quotes (or else I would replace all 'title'). I know how to do this by doing some php, but I'd like a regular expression that can handle it alone (for performance purposes).

That's why I asked if is possible to negate the pattern I had written.

Hope you, dankstick, or someone else could help me.

[dankstick]

Here is the opposite of my example, it pulls everything not in single quotes out into an array...

<?
        $word = "I eat 'a very tasty' lunch 'at my desk' everyday 'except on the weekends'.";
        $no_quotes = preg_split("('[A-Za-z 0-9]+')",$word);
        echo var_dump($no_quotes);
?>

I don't think you can negate your regexp. It would be nice to put a ^ in front, but oh well.

This won't work...

[^ /'(?:(?:(?:\\\\\\\\)*\\\\')|(?:[^']))+'/]

[acultism]

But your pattern will fail if there are any single quote escaped. See in below:

<?
    $word = "I eat 'a very tasty' lunch 'at Kate\\\\\'s desk' everyday 'except on the weekends'.";
    $no_quotes = preg_split("('[A-Za-z 0-9]+')",$word);
    echo var_dump($no_quotes);
?> 

Which produces:

 array( 4) {
    [0] =>
    string(6) "I eat"
    [1] =>
    string(16) " lunch 'at Kate\\"
    [2] =>
    string(10) " everyday "
    [2] =>
    string(1) "."
}

[acultism]

Maybe explaining the real intention to all this work some PCRE master could help me.

I'm trying to do a library that could extract data information from a table depending on some of their fields values. But all information is in a SQL dump file. In other words I need to construct a file SQL system (which do not suport joins and does exactly pattern match).

eg.:

Suppose a file named 'DATABASE1.table' with the above contents:

  .
  .
  .
  INSERT INTO Users VALUES (39, 'Raphael');

  CREATE TABLE Tabela1 (
    cod_item int not null primary key,
    name char[100] not null,
    title char[100] not null,
    message char[2000] not null
  );

  INSERT INTO Tabela1 VALUES (1,'Andressa','My opinions','I didn\\'t receive any message.');
  INSERT INTO Tabela1 VALUES (2,'The One','Recommended sites','www.google.com');
  INSERT INTO Tabela1 VALUES (6,'William','Books','The Blind Watchmaker');
  INSERT INTO Tabela1 VALUES (9,'Ernesto','Music','Pain of Salvation');
  INSERT INTO Tabela1 VALUES (20,'John','John\\'s Agenda','My Agenda: 8 o\\'clock - sth');

  CREATE TABLE Games (
  .
  .
  .


Suppose now a function called MAGIC which receives the table, wanted field names and a where clause as input. MAGIC returns all respective fields values. This functions use PHP 'eval' function to evaluate the where clause.

Input format:

       $info['TABLE_NAME']['FIELDS'] = array('FIELD_NAME_A', 'FIELD_NAME_C', ...);

   $info['TABLE_NAME']['WHERE'] = "FIELD_NAME_B = 'some value' and FIELD_...";

Eg.:       

       <?php

     $info['Tabela1']['FIELDS'] = array('cod_item', 'title');
     $info['Tabela1']['WHERE'] = "message = 'I didn\\\'t receive any message.'";
     $x = $MAGIC($info);
     print_r($x);

     // $x['cod_item']: 1
     // $x['title']: 'My opinions'

   ?>

I'd like to retrieve all information from a row which message field value is, for example, 'I didn\\'t receive any message.'. It seems very simple, but it isn't. MAGIC musn't be fooled by strings (enclosed in single quotes) having the field name. Also it musn't be fooled by escaped single quotes.

  FIELD_NAME : [COLOR=blue]message[/COLOR]
  FIELD_VALUE: [COLOR=red]'I didn\\'t receive any [/COLOR][COLOR=blue]message[/COLOR][COLOR=red].'[/COLOR]


How I could do this in PHP? For each matched INSERT do:

       <?php
         .
         .

     preg_match_all("/'(?:(?:(?:\\\\\\\\\\)*\\\\\\')|(?:[^']))+'/", $where, $matches);

     $blocks = $matches[0];

     $pat = array("/'(?:(?:(?:\\\\\\\\\\)*\\\\\\')|(?:[^']))+'/",
                  "/=/",
                  "/message/");

     $repl = array("##WEIRD:PATT:WEIRD##",
                   "==",
                   "'I didn\\'t receive any message.'");

     $tmp = preg_replace($pat, $repl, $where);

     foreach($blocos as $curblock)
       $tmp = preg_replace("##WEIRD:PATT:WEIRD##", $curblock, $tmp, 1);

     echo($tmp); // "'I didn\\'t receive any message.' == 'I didn\\'t receive any message.'"

     eval("\$test = (\$tmp);\n");

     if ($test)
       .
       .
       .

   ?>

But if the specified table has too many rows MAGIC would be very slow. So, I ask again: is there a RegExpression which replaces all php code?

Thx.

[acultism]

Maybe explaining the real intention to all this work some PCRE master could help me.

I'm trying to do a library that could extract data information from a table depending on some of their fields values. But all information is in a SQL dump file. In other words I need to construct a file SQL system (which do not suport joins and does exactly pattern match).

eg.:

Suppose a file named 'DATABASE1.table' with the above contents:

  .
  .
  .
  INSERT INTO Users VALUES (39, 'Raphael');

  CREATE TABLE Tabela1 (
    cod_item int not null primary key,
    name char[100] not null,
    title char[100] not null,
    message char[2000] not null
  );

  INSERT INTO Tabela1 VALUES (1,'Andressa','My opinions','I didn\\'t receive any message.');
  INSERT INTO Tabela1 VALUES (2,'The One','Recommended sites','www.google.com');
  INSERT INTO Tabela1 VALUES (6,'William','Books','The Blind Watchmaker');
  INSERT INTO Tabela1 VALUES (9,'Ernesto','Music','Pain of Salvation');
  INSERT INTO Tabela1 VALUES (20,'John','John\\'s Agenda','My Agenda: 8 o\\'clock - sth');

  CREATE TABLE Games (
  .
  .
  .


Suppose now a function called MAGIC which receives the table, wanted field names and a where clause as input. MAGIC returns all respective fields values. This functions use PHP 'eval' function to evaluate the where clause.

Input format:

       $info['TABLE_NAME']['FIELDS'] = array('FIELD_NAME_A', 'FIELD_NAME_C', ...);

   $info['TABLE_NAME']['WHERE'] = "FIELD_NAME_B = 'some value' and FIELD_...";

Eg.:       

       <?php

     $info['Tabela1']['FIELDS'] = array('cod_item', 'title');
     $info['Tabela1']['WHERE'] = "message = 'I didn\\\'t receive any message.'";
     $x = $MAGIC($info);
     print_r($x);

     // $x['cod_item']: 1
     // $x['title']: 'My opinions'

   ?>

I'd like to retrieve all information from a row which message field value is, for example, 'I didn\\'t receive any message.'. It seems very simple, but it isn't. MAGIC musn't be fooled by strings (enclosed in single quotes) having the field name. Also it musn't be fooled by escaped single quotes.

  FIELD_NAME : [COLOR=blue]message[/COLOR]
  FIELD_VALUE: [COLOR=red]'I didn\\'t receive any [/COLOR][COLOR=blue]message[/COLOR][COLOR=red].'[/COLOR]


How I could do this in PHP? For each matched INSERT do:

       <?php
         .
         .

     preg_match_all("/'(?:(?:(?:\\\\\\\\\\\\\\)*\\\\\\\\\\')|(?:[^']))+'/", $where, $matches);

     $blocks = $matches[0];

     $pat = array("/'(?:(?:(?:\\\\\\\\\\\\\\)*\\\\\\\\\\')|(?:[^']))+'/",
                  "/=/",
                  "/message/");

     $repl = array("##WEIRD:PATT:WEIRD##",
                   "==",
                   "'I didn\\'t receive any message.'");

     $tmp = preg_replace($pat, $repl, $where);

     foreach($blocos as $curblock)
       $tmp = preg_replace("##WEIRD:PATT:WEIRD##", $curblock, $tmp, 1);

     echo($tmp); // "'I didn\\'t receive any message.' == 'I didn\\'t receive any message.'"

     eval("\$test = (\$tmp);\n");

     if ($test)
       .
       .
       .

   ?>

But if the specified table has too many rows MAGIC would be very slow. So, I ask again: is there a RegExpression which replaces all php code?

Thx.

[acultism]

The lasts regular expression are incorrect due this forum uses some kind of escaping system. Those in beggining of this thread are ok.

[acultism]

Plz help!!

[rheroux]

Just negate the \ in the expression:

<?php

$word = "I eat 'a very tasty' lunch 'at Kate\\\\'s desk' everyday 'except on the weekends'.";
$no_quotes = preg_split("#('.*[^\\\\\\\\]')#U",$word);
print_r($no_quotes);

?>

The output for this would be:

Array ( [0] => I eat [1] => lunch [2] => everyday [3] => . )