fork download
copy 
  1. <?php
  2. $string = 'Hello, my name is "{{ @sql(SELECT TOP 1 name FROM table1 WHERE [id] = 5 ) }}" and my title is "{{ @sql(SELECT TOP 1 title FROM table1 WHERE [id] = 5 ) }}"';
  3.  
  4. $regex = '~
  5. 			\{{2}\h*@sql\(    # start of outer part
  6. 			(?P<query>[^()]+) # inner query
  7. 			\)\h*\}{2}        # end of outer part
  8. 		~x';
  9.  
  10. $string = preg_replace($regex, '$1', $string);
  11. echo $string;
  12. ?>
Success #stdin #stdout 0.02s 52432KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Hello, my name is "SELECT TOP 1 name FROM table1 WHERE [id] = 5 " and my title is "SELECT TOP 1 title FROM table1 WHERE [id] = 5 "
https://ideone.com/1qkuaf
language:
PHP (php 7.3.5)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!