Databases
StackOverflow2013
Postsdbo
POpreg_match find and replace a string pattern
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpreg_match find and replace a string pattern
    primarykey
    data
    text
    <p>I have a wordpress database which has some embeded iframes from sound cloud. I want the the iframes to be replaced with some sort of shortcode. I have even created a shortcode and it works pretty good.</p> <p>The problem is that i have an old database with approx 2000 posts which has already embeded codes. What i want to do is to write a code so that it would replace the iframe with the shortcode.</p> <p>Here is the code which i am using to find the url from the content but it always returns blank.</p> <pre><code>$string = 'Think Kavinsky meets Futurecop! meets your favorite 80s TV show theme song and you might be pretty close to Swedish producer Johan Bengtsson\'s retro project, &lt;a href="https://soundcloud.com/daataa"&gt;&lt;strong&gt;Mitch Murder&lt;/strong&gt;&lt;/a&gt;. Title track, "The Touch," is genuinely lighthearted and fun, crossing over from 80s synth work into a bit of French Touch influence; also including a big time guitar solo straight out of your dad\'s record collection. B-side "Race Day" could very easily be the soundtrack to a video montage of all of your favorite beach scenes from every 80s movie you\'ve ever watched, or as the PR put it, "quite possibly a contender to be the title screen music to a Wave Race 64 sequel." Sounds awesome to me. Also included in this package out today on &lt;a href="https://soundcloud.com/maddecent/"&gt;Mad Decent&lt;/a&gt;\'s Jeffree\'s sub-label are two remixes of the A-side from Lifelike and Nite Sprite. Download below. &lt;iframe src="https://w.soundcloud.com/player/?url=http%3A%2F%2Fapi.soundcloud.com%2Fplaylists%2F8087281&amp;amp;color=000000&amp;amp;auto_play=false&amp;amp;show_artwork=true" frameborder="no" scrolling="no" width="100%" height="350"&gt;&lt;/iframe&gt;'; preg_match("/url=(.*?)/", $string, $matches); print_r($matches); </code></pre> <p>The above code doesn't work and i am not so familiar with regex so if any one can figure out what is wrong here then it would be great. And also if anyone can guide me the right process to do this then that would be great. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAndy Lester
    1. USNirmal Ram
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POpreg_match find and replace a string pattern
      1. USNirmal Ram
      1. VTBountyStart
    2. VO
      singulars
      1. POpreg_match find and replace a string pattern
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POpreg_match find and replace a string pattern
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO**Don't use regular expressions to parse HTML. Use a proper HTML parsing module.** You cannot reliably parse HTML with regular expressions, and you will face sorrow and frustration down the road. As soon as the HTML changes from your expectations, your code will be broken. See http://htmlparsing.com/php for examples of how to properly parse HTML with PHP modules that have already been written, tested and debugged.
      singulars
      1. POpreg_match find and replace a string pattern
      1. USAndy Lester
    2. COThanks Andy, i will give it a try
      singulars
      1. POpreg_match find and replace a string pattern
      1. USNirmal Ram
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload