preg_replace help, please

[mrbaseball34]

Got this string:

  $clientorder_active_sql   = "SELECT o.order_id,
                                      o.order_code,
                                      o.order_taskid,
                                      t.task_title as order_taskname,
                                      o.order_qty,
                                      o.order_price,
                                      o.users_id,
                                      o.order_date,
                                      o.order_status
                               FROM clientorder o
                               INNER JOIN task t ON t.task_id = o.order_taskid
                               WHERE o.%field%=%value% AND o.order_status=0";

Now, I'm trying to do this to use the above SQL in multiple places but
am having problems.

  $patterns          = array();
  $patterns[0]       = '%field%';
  $patterns[1]       = '%value%';
  $replacements      = array();
  $replacements[0]   = 'users_id';
  $replacements[1]   = $_SESSION['userid']; // passed value is 32
  $sel_order_active  = preg_replace($patterns, $replacements, $clientorder_active_sql);

This sets $sel_order_active to this:

"SELECT o.order_id,
        o.order_code,
        o.order_taskid,
        t.task_title as order_taskname,
        o.order_qty,
        o.order_price,
        o.users_id,
        o.order_date,
        o.order_status
 FROM clientorder o
 INNER JOIN task t ON t.task_id = o.order_taskid
 WHERE o.%users_id%=%32% AND o.order_status=0"

Why are the % signs not getting replaced?

[dagon]

seems like overkill why not use:

   $clientorder_active_sql   = "SELECT o.order_id,
                                      o.order_code,
                                      o.order_taskid,
                                      t.task_title as order_taskname,
                                      o.order_qty,
                                      o.order_price,
                                      o.users_id,
                                      o.order_date,
                                      o.order_status
                               FROM clientorder o
                               INNER JOIN task t ON t.task_id = o.order_taskid
                               WHERE o.user_id='{$_SESSION['userid']}' AND o.order_status=0";

[mrbaseball34]

It might help if you READ the question, first:

use the above SQL in multiple places

The name of the field and value will change in those multiple places.

[dagon]

mrbaseball34;10970558 wrote:

It might help if you READ the question, first:

i did, you just don't understand the answer:p

you can do the same thing with field and value with out using preg_replace()

[dagon]

$clientorder_active_sql   = "SELECT o.order_id,
                                      o.order_code,
                                      o.order_taskid,
                                      t.task_title as order_taskname,
                                      o.order_qty,
                                      o.order_price,
                                      o.users_id,
                                      o.order_date,
                                      o.order_status
                               FROM clientorder o
                               INNER JOIN task t ON t.task_id = o.order_taskid
                               WHERE $field='$value' AND o.order_status=0"; 

for multiple

create the where clause(s') with a loop

$f=array('a','b','c');
$l=array('d','e','f');
$j=array(' && ',' && ');


foreach ($f as $k=>$v){
$where .=$v.'='."'$l[$k]'".$j[$k];

}

$clientorder_active_sql   = "SELECT o.order_id,
                                      o.order_code,
                                      o.order_taskid,
                                      t.task_title as order_taskname,
                                      o.order_qty,
                                      o.order_price,
                                      o.users_id,
                                      o.order_date,
                                      o.order_status
                               FROM clientorder o
                               INNER JOIN task t ON t.task_id = o.order_taskid
                               WHERE $where AND o.order_status=0"; 

[mrbaseball34]

you just don't understand the answer

Look, I'm experienced enough to know that the answer you provided isn't what I wanted or asked for.

The problem lies tin the fact that I have several places in several scripts that call the same SQL with different fields and vales. I don't want to use the same code just changing the field and value every place I have to do this.

Just forget it, I'll get me answer elsewhere.

[mrbaseball34]

Nevermind, I figured it out myself:

  $patterns[0]       = '{%field%}';
  $patterns[1]       = '{%value%}';

[dagon]

glad to of helped, please mark the thread as resolved use the the "thread tools"