php replace array key with square brackets to array value

Question

I have a string that contain a mysql query:

$string = "UPDATE [table1] SET value = 1 WHERE id = 1";

I would like to change [table1] with the value of this array:

$table['table1']='pages';
$table['table2']='products';
etc

The result should be:

mysql_query( $string ); // "UPDATE pages SET value = 1 WHERE id = 1"

I already tried the following but nothing:

mysql_query( str_replace( '[', '$table[', $string ));
mysql_query( str_replace( array_keys( "[$table]" ), array_values( $table ), $string ));
mysql_query( str_replace( array_keys( "[".$table."]" ), array_values( $table ), $string ));

EDIT This way works, but there is no a easiest way?

str_replace( explode( ',', ( '['.implode( '],[',array_keys( $table ) ) .']' ) ), $table, $string );

Roms · Accepted Answer · 2016-12-22 11:01:46Z

1

What about this

$table['table1']='pages';
$table['table2']='products';

$string = "UPDATE [table1] SET value = 1 WHERE id = 1";

foreach($table as $key => $value){
    $string = str_replace('['.$key.']', $value, $string);
}

answered Dec 22, 2016 at 11:01

Roms

1058 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paladin · Accepted Answer · 2016-12-22 10:48:20Z

0

What about the simple approach?

$string = "UPDATE ".$table['table1']." SET value = 1 WHERE id = 1";

answered Dec 22, 2016 at 10:48

Paladin

1,63715 silver badges29 bronze badges

1 Comment

ipel Over a year ago

No I cannot do that, I have to convert the [table1] with the value of $table[table1]

Collectives™ on Stack Overflow

php replace array key with square brackets to array value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related