snipt

Ctrl+h for KB shortcuts

PHP

Update wordpress db

<?php

// This script is to solve the problem of doing database search and replace
// when developers have only gone and used the non-relational concept of
// serializing PHP arrays into single database columns.  It will search for all
// matching data on the database and change it, even if it's within a serialized
// PHP array.

// The big problem with serialised arrays is that if you do a normal DB
// style search and replace the lengths get mucked up.  This search deals with
// the problem by unserializing and reserializing the entire contents of the
// database you're working on.  It then carries out a search and replace on the
// data it finds, and dumps it back to the database.  So far it appears to work
// very well.  It was coded for our WordPress work where we often have to move
// large databases across servers, but I designed it to work with any database.
// Biggest worry for you is that you may not want to do a search and replace on
// every damn table - well, if you want, simply add some exclusions in the table
// loop and you'll be fine.  If you don't know how, you possibly shouldn't be
// using this script anyway.

// To use, simply configure the settings below and off you go.  I wouldn't
// expect the script to take more than a few seconds on most machines.

// BIG WARNING!  Take a backup first, and carefully test the results of this code.
// If you don't, and you vape your data then you only have yourself to blame.
// Seriously.  And if you're English is bad and you don't fully understand the
// instructions then STOP.  Right there.  Yes.  Before you do any damage.

// USE OF THIS SCRIPT IS ENTIRELY AT YOUR OWN RISK.  I/We accept no liability from its use.

// Written 20090525 by David Coveney of Interconnect IT Ltd (UK)
// http://www.davesgonemental.com or http://www.interconnectit.com or
// http://spectacu.la and released under the WTFPL
// ie, do what ever you want with the code, and I take no responsibility for it OK?
// If you don't wish to take responsibility, hire me through Interconnect IT Ltd
// on +44 (0)151 709 7977 and we will do the work for you, but at a cost, minimum 1hr
// To view the WTFPL go to http://sam.zoy.org/wtfpl/ (WARNING: it's a little rude, if you're sensitive)

// Credits:  moz667 at gmail dot com for his recursive_array_replace posted at
//           uk.php.net which saved me a little time - a perfect sample for me
//           and seems to work in all cases.

//  Start TIMER
//  -----------
$stimer = explode( ' ', microtime() );
$stimer = $stimer[1] + $stimer[0];
//  -----------

// Database Settings

$host = 'localhost';        // normally localhost, but not necessarily.
$usr  = 'yourdbuser';       // your db userid
$pwd  = '';                 // your db password
$db   = 'yourdb';           // your database

// Replace options

$search_for   = 'replace';  // the value you want to search for
$replace_with = 'replace';  // the value to replace it with

$cid = mysql_connect($host,$usr,$pwd); 

if (!$cid) { echo("Connecting to DB Error: " . mysql_error() . "<br/>"); }

// First, get a list of tables

$SQL = "SHOW TABLES";
$tables_list = mysql_db_query($db, $SQL, $cid);

if (!$tables_list) {
    echo("ERROR: " . mysql_error() . "<br/>$SQL<br/>"); } 


// Loop through the tables

while ($table_rows = mysql_fetch_array($tables_list)) {
    
    $count_tables_checked++;
    
    $table = $table_rows['Tables_in_'.$db];
    
    echo '<br/>Checking table: '.$table.'<br/>***************<br/>';  // we have tables!
   
    $SQL = "DESCRIBE ".$table ;    // fetch the table description so we know what to do with it
    $fields_list = mysql_db_query($db, $SQL, $cid);
    
    // Make a simple array of field column names
    
    $index_fields = "";  // reset fields for each table.
    $column_name = "";
    $table_index = "";
    $i = 0;
    
    while ($field_rows = mysql_fetch_array($fields_list)) {
                
        $column_name[$i++] = $field_rows['Field'];
        
        if ($field_rows['Key'] == 'PRI') $table_index[$i] = true ;
        
    }

//    print_r ($column_name);
//    print_r ($table_index);

// now let's get the data and do search and replaces on it...
    
    $SQL = "SELECT * FROM ".$table;     // fetch the table contents
    $data = mysql_db_query($db, $SQL, $cid);
    
    if (!$data) {
        echo("ERROR: " . mysql_error() . "<br/>$SQL<br/>"); } 


    while ($row = mysql_fetch_array($data)) {

        // Initialise the UPDATE string we're going to build, and we don't do an update for each damn column...
        
        $need_to_update = false;
        $UPDATE_SQL = 'UPDATE '.$table. ' SET ';
        $WHERE_SQL = ' WHERE ';
        
        $j = 0;

        foreach ($column_name as $current_column) {
            $j++;
            $count_items_checked++;

//            echo "<br/>Current Column = $current_column";

            $data_to_fix = $row[$current_column];
            $edited_data = $data_to_fix;            // set the same now - if they're different later we know we need to update
            
//            if ($current_column == $index_field) $index_value = $row[$current_column];    // if it's the index column, store it for use in the update
    
            $unserialized = unserialize($data_to_fix);  // unserialise - if false returned we don't try to process it as serialised
            
            if ($unserialized) {
                
//                echo "<br/>unserialize OK - now searching and replacing the following array:<br/>";
//                echo "<br/>$data_to_fix";
//                
//                print_r($unserialized);
            
                recursive_array_replace($search_for, $replace_with, $unserialized);
                
                $edited_data = serialize($unserialized);
                
//                echo "**Output of search and replace: <br/>";
//                echo "$edited_data <br/>";
//                print_r($unserialized);        
//                echo "---------------------------------<br/>";
                
              }
            
            else {
                
                if (is_string($data_to_fix)) $edited_data = str_replace($search_for,$replace_with,$data_to_fix) ;
                
                }
                
            if ($data_to_fix != $edited_data) {   // If they're not the same, we need to add them to the update string
                
                $count_items_changed++;
                
                if ($need_to_update != false) $UPDATE_SQL = $UPDATE_SQL.',';  // if this isn't our first time here, add a comma
                $UPDATE_SQL = $UPDATE_SQL.' '.$current_column.' = "'.mysql_real_escape_string($edited_data).'"' ;
                $need_to_update = true; // only set if we need to update - avoids wasted UPDATE statements
                
            }
            
            if ($table_index[$j]){
                $WHERE_SQL = $WHERE_SQL.$current_column.' = "'.$row[$current_column].'" AND ';
            }
        }
        
        if ($need_to_update) {
            
            $count_updates_run;
            
            $WHERE_SQL = substr($WHERE_SQL,0,-4); // strip off the excess AND - the easiest way to code this without extra flags, etc.
            
            $UPDATE_SQL = $UPDATE_SQL.$WHERE_SQL;
            echo $UPDATE_SQL.'<br/><br/>';
            
            $result = mysql_db_query($db,$UPDATE_SQL,$cid);
    
            if (!$result) {
                    echo("ERROR: " . mysql_error() . "<br/>$UPDATE_SQL<br/>"); } 
            
        }
        
    }

}

// Report

$report = $count_tables_checked." tables checked; ".$count_items_checked." items checked; ".$count_items_changed." items changed;";
echo '<p style="margin:auto; text-align:center">';
echo $report;

mysql_close($cid); 

//  End TIMER
//  ---------
$etimer = explode( ' ', microtime() );
$etimer = $etimer[1] + $etimer[0];
printf( "<br/>Script timer: <b>%f</b> seconds.", ($etimer-$stimer) );
echo '</p>';
//  ---------

function recursive_array_replace($find, $replace, &$data) {
    
    if (is_array($data)) {
        foreach ($data as $key => $value) {
            if (is_array($value)) {
                recursive_array_replace($find, $replace, $data[$key]);
            } else {
                // have to check if it's string to ensure no switching to string for booleans/numbers/nulls - don't need any nasty conversions
                if (is_string($value)) $data[$key] = str_replace($find, $replace, $value);
            }
        }
    } else {
        if (is_string($data)) $data = str_replace($find, $replace, $data);
    }
    
} 


?>
https://snipt.net/embed/66e4dfe631a64b3aee140abf14163481/
/raw/66e4dfe631a64b3aee140abf14163481/
66e4dfe631a64b3aee140abf14163481
php
PHP
230
2019-07-19T14:56:53
True
False
False
/api/public/snipt/24677/
update-wordpress-db
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10"> 10</a> <a href="#L-11"> 11</a> <a href="#L-12"> 12</a> <a href="#L-13"> 13</a> <a href="#L-14"> 14</a> <a href="#L-15"> 15</a> <a href="#L-16"> 16</a> <a href="#L-17"> 17</a> <a href="#L-18"> 18</a> <a href="#L-19"> 19</a> <a href="#L-20"> 20</a> <a href="#L-21"> 21</a> <a href="#L-22"> 22</a> <a href="#L-23"> 23</a> <a href="#L-24"> 24</a> <a href="#L-25"> 25</a> <a href="#L-26"> 26</a> <a href="#L-27"> 27</a> <a href="#L-28"> 28</a> <a href="#L-29"> 29</a> <a href="#L-30"> 30</a> <a href="#L-31"> 31</a> <a href="#L-32"> 32</a> <a href="#L-33"> 33</a> <a href="#L-34"> 34</a> <a href="#L-35"> 35</a> <a href="#L-36"> 36</a> <a href="#L-37"> 37</a> <a href="#L-38"> 38</a> <a href="#L-39"> 39</a> <a href="#L-40"> 40</a> <a href="#L-41"> 41</a> <a href="#L-42"> 42</a> <a href="#L-43"> 43</a> <a href="#L-44"> 44</a> <a href="#L-45"> 45</a> <a href="#L-46"> 46</a> <a href="#L-47"> 47</a> <a href="#L-48"> 48</a> <a href="#L-49"> 49</a> <a href="#L-50"> 50</a> <a href="#L-51"> 51</a> <a href="#L-52"> 52</a> <a href="#L-53"> 53</a> <a href="#L-54"> 54</a> <a href="#L-55"> 55</a> <a href="#L-56"> 56</a> <a href="#L-57"> 57</a> <a href="#L-58"> 58</a> <a href="#L-59"> 59</a> <a href="#L-60"> 60</a> <a href="#L-61"> 61</a> <a href="#L-62"> 62</a> <a href="#L-63"> 63</a> <a href="#L-64"> 64</a> <a href="#L-65"> 65</a> <a href="#L-66"> 66</a> <a href="#L-67"> 67</a> <a href="#L-68"> 68</a> <a href="#L-69"> 69</a> <a href="#L-70"> 70</a> <a href="#L-71"> 71</a> <a href="#L-72"> 72</a> <a href="#L-73"> 73</a> <a href="#L-74"> 74</a> <a href="#L-75"> 75</a> <a href="#L-76"> 76</a> <a href="#L-77"> 77</a> <a href="#L-78"> 78</a> <a href="#L-79"> 79</a> <a href="#L-80"> 80</a> <a href="#L-81"> 81</a> <a href="#L-82"> 82</a> <a href="#L-83"> 83</a> <a href="#L-84"> 84</a> <a href="#L-85"> 85</a> <a href="#L-86"> 86</a> <a href="#L-87"> 87</a> <a href="#L-88"> 88</a> <a href="#L-89"> 89</a> <a href="#L-90"> 90</a> <a href="#L-91"> 91</a> <a href="#L-92"> 92</a> <a href="#L-93"> 93</a> <a href="#L-94"> 94</a> <a href="#L-95"> 95</a> <a href="#L-96"> 96</a> <a href="#L-97"> 97</a> <a href="#L-98"> 98</a> <a href="#L-99"> 99</a> <a href="#L-100">100</a> <a href="#L-101">101</a> <a href="#L-102">102</a> <a href="#L-103">103</a> <a href="#L-104">104</a> <a href="#L-105">105</a> <a href="#L-106">106</a> <a href="#L-107">107</a> <a href="#L-108">108</a> <a href="#L-109">109</a> <a href="#L-110">110</a> <a href="#L-111">111</a> <a href="#L-112">112</a> <a href="#L-113">113</a> <a href="#L-114">114</a> <a href="#L-115">115</a> <a href="#L-116">116</a> <a href="#L-117">117</a> <a href="#L-118">118</a> <a href="#L-119">119</a> <a href="#L-120">120</a> <a href="#L-121">121</a> <a href="#L-122">122</a> <a href="#L-123">123</a> <a href="#L-124">124</a> <a href="#L-125">125</a> <a href="#L-126">126</a> <a href="#L-127">127</a> <a href="#L-128">128</a> <a href="#L-129">129</a> <a href="#L-130">130</a> <a href="#L-131">131</a> <a href="#L-132">132</a> <a href="#L-133">133</a> <a href="#L-134">134</a> <a href="#L-135">135</a> <a href="#L-136">136</a> <a href="#L-137">137</a> <a href="#L-138">138</a> <a href="#L-139">139</a> <a href="#L-140">140</a> <a href="#L-141">141</a> <a href="#L-142">142</a> <a href="#L-143">143</a> <a href="#L-144">144</a> <a href="#L-145">145</a> <a href="#L-146">146</a> <a href="#L-147">147</a> <a href="#L-148">148</a> <a href="#L-149">149</a> <a href="#L-150">150</a> <a href="#L-151">151</a> <a href="#L-152">152</a> <a href="#L-153">153</a> <a href="#L-154">154</a> <a href="#L-155">155</a> <a href="#L-156">156</a> <a href="#L-157">157</a> <a href="#L-158">158</a> <a href="#L-159">159</a> <a href="#L-160">160</a> <a href="#L-161">161</a> <a href="#L-162">162</a> <a href="#L-163">163</a> <a href="#L-164">164</a> <a href="#L-165">165</a> <a href="#L-166">166</a> <a href="#L-167">167</a> <a href="#L-168">168</a> <a href="#L-169">169</a> <a href="#L-170">170</a> <a href="#L-171">171</a> <a href="#L-172">172</a> <a href="#L-173">173</a> <a href="#L-174">174</a> <a href="#L-175">175</a> <a href="#L-176">176</a> <a href="#L-177">177</a> <a href="#L-178">178</a> <a href="#L-179">179</a> <a href="#L-180">180</a> <a href="#L-181">181</a> <a href="#L-182">182</a> <a href="#L-183">183</a> <a href="#L-184">184</a> <a href="#L-185">185</a> <a href="#L-186">186</a> <a href="#L-187">187</a> <a href="#L-188">188</a> <a href="#L-189">189</a> <a href="#L-190">190</a> <a href="#L-191">191</a> <a href="#L-192">192</a> <a href="#L-193">193</a> <a href="#L-194">194</a> <a href="#L-195">195</a> <a href="#L-196">196</a> <a href="#L-197">197</a> <a href="#L-198">198</a> <a href="#L-199">199</a> <a href="#L-200">200</a> <a href="#L-201">201</a> <a href="#L-202">202</a> <a href="#L-203">203</a> <a href="#L-204">204</a> <a href="#L-205">205</a> <a href="#L-206">206</a> <a href="#L-207">207</a> <a href="#L-208">208</a> <a href="#L-209">209</a> <a href="#L-210">210</a> <a href="#L-211">211</a> <a href="#L-212">212</a> <a href="#L-213">213</a> <a href="#L-214">214</a> <a href="#L-215">215</a> <a href="#L-216">216</a> <a href="#L-217">217</a> <a href="#L-218">218</a> <a href="#L-219">219</a> <a href="#L-220">220</a> <a href="#L-221">221</a> <a href="#L-222">222</a> <a href="#L-223">223</a> <a href="#L-224">224</a> <a href="#L-225">225</a> <a href="#L-226">226</a> <a href="#L-227">227</a> <a href="#L-228">228</a> <a href="#L-229">229</a> <a href="#L-230">230</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?php</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="c1">// This script is to solve the problem of doing database search and replace</span> </span><span id="L-4"><a name="L-4"></a><span class="c1">// when developers have only gone and used the non-relational concept of</span> </span><span id="L-5"><a name="L-5"></a><span class="c1">// serializing PHP arrays into single database columns. It will search for all</span> </span><span id="L-6"><a name="L-6"></a><span class="c1">// matching data on the database and change it, even if it&#39;s within a serialized</span> </span><span id="L-7"><a name="L-7"></a><span class="c1">// PHP array.</span> </span><span id="L-8"><a name="L-8"></a> </span><span id="L-9"><a name="L-9"></a><span class="c1">// The big problem with serialised arrays is that if you do a normal DB</span> </span><span id="L-10"><a name="L-10"></a><span class="c1">// style search and replace the lengths get mucked up. This search deals with</span> </span><span id="L-11"><a name="L-11"></a><span class="c1">// the problem by unserializing and reserializing the entire contents of the</span> </span><span id="L-12"><a name="L-12"></a><span class="c1">// database you&#39;re working on. It then carries out a search and replace on the</span> </span><span id="L-13"><a name="L-13"></a><span class="c1">// data it finds, and dumps it back to the database. So far it appears to work</span> </span><span id="L-14"><a name="L-14"></a><span class="c1">// very well. It was coded for our WordPress work where we often have to move</span> </span><span id="L-15"><a name="L-15"></a><span class="c1">// large databases across servers, but I designed it to work with any database.</span> </span><span id="L-16"><a name="L-16"></a><span class="c1">// Biggest worry for you is that you may not want to do a search and replace on</span> </span><span id="L-17"><a name="L-17"></a><span class="c1">// every damn table - well, if you want, simply add some exclusions in the table</span> </span><span id="L-18"><a name="L-18"></a><span class="c1">// loop and you&#39;ll be fine. If you don&#39;t know how, you possibly shouldn&#39;t be</span> </span><span id="L-19"><a name="L-19"></a><span class="c1">// using this script anyway.</span> </span><span id="L-20"><a name="L-20"></a> </span><span id="L-21"><a name="L-21"></a><span class="c1">// To use, simply configure the settings below and off you go. I wouldn&#39;t</span> </span><span id="L-22"><a name="L-22"></a><span class="c1">// expect the script to take more than a few seconds on most machines.</span> </span><span id="L-23"><a name="L-23"></a> </span><span id="L-24"><a name="L-24"></a><span class="c1">// BIG WARNING! Take a backup first, and carefully test the results of this code.</span> </span><span id="L-25"><a name="L-25"></a><span class="c1">// If you don&#39;t, and you vape your data then you only have yourself to blame.</span> </span><span id="L-26"><a name="L-26"></a><span class="c1">// Seriously. And if you&#39;re English is bad and you don&#39;t fully understand the</span> </span><span id="L-27"><a name="L-27"></a><span class="c1">// instructions then STOP. Right there. Yes. Before you do any damage.</span> </span><span id="L-28"><a name="L-28"></a> </span><span id="L-29"><a name="L-29"></a><span class="c1">// USE OF THIS SCRIPT IS ENTIRELY AT YOUR OWN RISK. I/We accept no liability from its use.</span> </span><span id="L-30"><a name="L-30"></a> </span><span id="L-31"><a name="L-31"></a><span class="c1">// Written 20090525 by David Coveney of Interconnect IT Ltd (UK)</span> </span><span id="L-32"><a name="L-32"></a><span class="c1">// http://www.davesgonemental.com or http://www.interconnectit.com or</span> </span><span id="L-33"><a name="L-33"></a><span class="c1">// http://spectacu.la and released under the WTFPL</span> </span><span id="L-34"><a name="L-34"></a><span class="c1">// ie, do what ever you want with the code, and I take no responsibility for it OK?</span> </span><span id="L-35"><a name="L-35"></a><span class="c1">// If you don&#39;t wish to take responsibility, hire me through Interconnect IT Ltd</span> </span><span id="L-36"><a name="L-36"></a><span class="c1">// on +44 (0)151 709 7977 and we will do the work for you, but at a cost, minimum 1hr</span> </span><span id="L-37"><a name="L-37"></a><span class="c1">// To view the WTFPL go to http://sam.zoy.org/wtfpl/ (WARNING: it&#39;s a little rude, if you&#39;re sensitive)</span> </span><span id="L-38"><a name="L-38"></a> </span><span id="L-39"><a name="L-39"></a><span class="c1">// Credits: moz667 at gmail dot com for his recursive_array_replace posted at</span> </span><span id="L-40"><a name="L-40"></a><span class="c1">// uk.php.net which saved me a little time - a perfect sample for me</span> </span><span id="L-41"><a name="L-41"></a><span class="c1">// and seems to work in all cases.</span> </span><span id="L-42"><a name="L-42"></a> </span><span id="L-43"><a name="L-43"></a><span class="c1">// Start TIMER</span> </span><span id="L-44"><a name="L-44"></a><span class="c1">// -----------</span> </span><span id="L-45"><a name="L-45"></a><span class="nv">$stimer</span> <span class="o">=</span> <span class="nb">explode</span><span class="p">(</span> <span class="s1">&#39; &#39;</span><span class="p">,</span> <span class="nb">microtime</span><span class="p">()</span> <span class="p">);</span> </span><span id="L-46"><a name="L-46"></a><span class="nv">$stimer</span> <span class="o">=</span> <span class="nv">$stimer</span><span class="p">[</span><span class="mi">1</span><span class="p">]</span> <span class="o">+</span> <span class="nv">$stimer</span><span class="p">[</span><span class="mi">0</span><span class="p">];</span> </span><span id="L-47"><a name="L-47"></a><span class="c1">// -----------</span> </span><span id="L-48"><a name="L-48"></a> </span><span id="L-49"><a name="L-49"></a><span class="c1">// Database Settings</span> </span><span id="L-50"><a name="L-50"></a> </span><span id="L-51"><a name="L-51"></a><span class="nv">$host</span> <span class="o">=</span> <span class="s1">&#39;localhost&#39;</span><span class="p">;</span> <span class="c1">// normally localhost, but not necessarily.</span> </span><span id="L-52"><a name="L-52"></a><span class="nv">$usr</span> <span class="o">=</span> <span class="s1">&#39;yourdbuser&#39;</span><span class="p">;</span> <span class="c1">// your db userid</span> </span><span id="L-53"><a name="L-53"></a><span class="nv">$pwd</span> <span class="o">=</span> <span class="s1">&#39;&#39;</span><span class="p">;</span> <span class="c1">// your db password</span> </span><span id="L-54"><a name="L-54"></a><span class="nv">$db</span> <span class="o">=</span> <span class="s1">&#39;yourdb&#39;</span><span class="p">;</span> <span class="c1">// your database</span> </span><span id="L-55"><a name="L-55"></a> </span><span id="L-56"><a name="L-56"></a><span class="c1">// Replace options</span> </span><span id="L-57"><a name="L-57"></a> </span><span id="L-58"><a name="L-58"></a><span class="nv">$search_for</span> <span class="o">=</span> <span class="s1">&#39;replace&#39;</span><span class="p">;</span> <span class="c1">// the value you want to search for</span> </span><span id="L-59"><a name="L-59"></a><span class="nv">$replace_with</span> <span class="o">=</span> <span class="s1">&#39;replace&#39;</span><span class="p">;</span> <span class="c1">// the value to replace it with</span> </span><span id="L-60"><a name="L-60"></a> </span><span id="L-61"><a name="L-61"></a><span class="nv">$cid</span> <span class="o">=</span> <span class="nb">mysql_connect</span><span class="p">(</span><span class="nv">$host</span><span class="p">,</span><span class="nv">$usr</span><span class="p">,</span><span class="nv">$pwd</span><span class="p">);</span> </span><span id="L-62"><a name="L-62"></a> </span><span id="L-63"><a name="L-63"></a><span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nv">$cid</span><span class="p">)</span> <span class="p">{</span> <span class="k">echo</span><span class="p">(</span><span class="s2">&quot;Connecting to DB Error: &quot;</span> <span class="o">.</span> <span class="nb">mysql_error</span><span class="p">()</span> <span class="o">.</span> <span class="s2">&quot;&lt;br/&gt;&quot;</span><span class="p">);</span> <span class="p">}</span> </span><span id="L-64"><a name="L-64"></a> </span><span id="L-65"><a name="L-65"></a><span class="c1">// First, get a list of tables</span> </span><span id="L-66"><a name="L-66"></a> </span><span id="L-67"><a name="L-67"></a><span class="nv">$SQL</span> <span class="o">=</span> <span class="s2">&quot;SHOW TABLES&quot;</span><span class="p">;</span> </span><span id="L-68"><a name="L-68"></a><span class="nv">$tables_list</span> <span class="o">=</span> <span class="nb">mysql_db_query</span><span class="p">(</span><span class="nv">$db</span><span class="p">,</span> <span class="nv">$SQL</span><span class="p">,</span> <span class="nv">$cid</span><span class="p">);</span> </span><span id="L-69"><a name="L-69"></a> </span><span id="L-70"><a name="L-70"></a><span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nv">$tables_list</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-71"><a name="L-71"></a> <span class="k">echo</span><span class="p">(</span><span class="s2">&quot;ERROR: &quot;</span> <span class="o">.</span> <span class="nb">mysql_error</span><span class="p">()</span> <span class="o">.</span> <span class="s2">&quot;&lt;br/&gt;</span><span class="si">$SQL</span><span class="s2">&lt;br/&gt;&quot;</span><span class="p">);</span> <span class="p">}</span> </span><span id="L-72"><a name="L-72"></a> </span><span id="L-73"><a name="L-73"></a> </span><span id="L-74"><a name="L-74"></a><span class="c1">// Loop through the tables</span> </span><span id="L-75"><a name="L-75"></a> </span><span id="L-76"><a name="L-76"></a><span class="k">while</span> <span class="p">(</span><span class="nv">$table_rows</span> <span class="o">=</span> <span class="nb">mysql_fetch_array</span><span class="p">(</span><span class="nv">$tables_list</span><span class="p">))</span> <span class="p">{</span> </span><span id="L-77"><a name="L-77"></a> </span><span id="L-78"><a name="L-78"></a> <span class="nv">$count_tables_checked</span><span class="o">++</span><span class="p">;</span> </span><span id="L-79"><a name="L-79"></a> </span><span id="L-80"><a name="L-80"></a> <span class="nv">$table</span> <span class="o">=</span> <span class="nv">$table_rows</span><span class="p">[</span><span class="s1">&#39;Tables_in_&#39;</span><span class="o">.</span><span class="nv">$db</span><span class="p">];</span> </span><span id="L-81"><a name="L-81"></a> </span><span id="L-82"><a name="L-82"></a> <span class="k">echo</span> <span class="s1">&#39;&lt;br/&gt;Checking table: &#39;</span><span class="o">.</span><span class="nv">$table</span><span class="o">.</span><span class="s1">&#39;&lt;br/&gt;***************&lt;br/&gt;&#39;</span><span class="p">;</span> <span class="c1">// we have tables!</span> </span><span id="L-83"><a name="L-83"></a> </span><span id="L-84"><a name="L-84"></a> <span class="nv">$SQL</span> <span class="o">=</span> <span class="s2">&quot;DESCRIBE &quot;</span><span class="o">.</span><span class="nv">$table</span> <span class="p">;</span> <span class="c1">// fetch the table description so we know what to do with it</span> </span><span id="L-85"><a name="L-85"></a> <span class="nv">$fields_list</span> <span class="o">=</span> <span class="nb">mysql_db_query</span><span class="p">(</span><span class="nv">$db</span><span class="p">,</span> <span class="nv">$SQL</span><span class="p">,</span> <span class="nv">$cid</span><span class="p">);</span> </span><span id="L-86"><a name="L-86"></a> </span><span id="L-87"><a name="L-87"></a> <span class="c1">// Make a simple array of field column names</span> </span><span id="L-88"><a name="L-88"></a> </span><span id="L-89"><a name="L-89"></a> <span class="nv">$index_fields</span> <span class="o">=</span> <span class="s2">&quot;&quot;</span><span class="p">;</span> <span class="c1">// reset fields for each table.</span> </span><span id="L-90"><a name="L-90"></a> <span class="nv">$column_name</span> <span class="o">=</span> <span class="s2">&quot;&quot;</span><span class="p">;</span> </span><span id="L-91"><a name="L-91"></a> <span class="nv">$table_index</span> <span class="o">=</span> <span class="s2">&quot;&quot;</span><span class="p">;</span> </span><span id="L-92"><a name="L-92"></a> <span class="nv">$i</span> <span class="o">=</span> <span class="mi">0</span><span class="p">;</span> </span><span id="L-93"><a name="L-93"></a> </span><span id="L-94"><a name="L-94"></a> <span class="k">while</span> <span class="p">(</span><span class="nv">$field_rows</span> <span class="o">=</span> <span class="nb">mysql_fetch_array</span><span class="p">(</span><span class="nv">$fields_list</span><span class="p">))</span> <span class="p">{</span> </span><span id="L-95"><a name="L-95"></a> </span><span id="L-96"><a name="L-96"></a> <span class="nv">$column_name</span><span class="p">[</span><span class="nv">$i</span><span class="o">++</span><span class="p">]</span> <span class="o">=</span> <span class="nv">$field_rows</span><span class="p">[</span><span class="s1">&#39;Field&#39;</span><span class="p">];</span> </span><span id="L-97"><a name="L-97"></a> </span><span id="L-98"><a name="L-98"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$field_rows</span><span class="p">[</span><span class="s1">&#39;Key&#39;</span><span class="p">]</span> <span class="o">==</span> <span class="s1">&#39;PRI&#39;</span><span class="p">)</span> <span class="nv">$table_index</span><span class="p">[</span><span class="nv">$i</span><span class="p">]</span> <span class="o">=</span> <span class="k">true</span> <span class="p">;</span> </span><span id="L-99"><a name="L-99"></a> </span><span id="L-100"><a name="L-100"></a> <span class="p">}</span> </span><span id="L-101"><a name="L-101"></a> </span><span id="L-102"><a name="L-102"></a><span class="c1">// print_r ($column_name);</span> </span><span id="L-103"><a name="L-103"></a><span class="c1">// print_r ($table_index);</span> </span><span id="L-104"><a name="L-104"></a> </span><span id="L-105"><a name="L-105"></a><span class="c1">// now let&#39;s get the data and do search and replaces on it...</span> </span><span id="L-106"><a name="L-106"></a> </span><span id="L-107"><a name="L-107"></a> <span class="nv">$SQL</span> <span class="o">=</span> <span class="s2">&quot;SELECT * FROM &quot;</span><span class="o">.</span><span class="nv">$table</span><span class="p">;</span> <span class="c1">// fetch the table contents</span> </span><span id="L-108"><a name="L-108"></a> <span class="nv">$data</span> <span class="o">=</span> <span class="nb">mysql_db_query</span><span class="p">(</span><span class="nv">$db</span><span class="p">,</span> <span class="nv">$SQL</span><span class="p">,</span> <span class="nv">$cid</span><span class="p">);</span> </span><span id="L-109"><a name="L-109"></a> </span><span id="L-110"><a name="L-110"></a> <span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nv">$data</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-111"><a name="L-111"></a> <span class="k">echo</span><span class="p">(</span><span class="s2">&quot;ERROR: &quot;</span> <span class="o">.</span> <span class="nb">mysql_error</span><span class="p">()</span> <span class="o">.</span> <span class="s2">&quot;&lt;br/&gt;</span><span class="si">$SQL</span><span class="s2">&lt;br/&gt;&quot;</span><span class="p">);</span> <span class="p">}</span> </span><span id="L-112"><a name="L-112"></a> </span><span id="L-113"><a name="L-113"></a> </span><span id="L-114"><a name="L-114"></a> <span class="k">while</span> <span class="p">(</span><span class="nv">$row</span> <span class="o">=</span> <span class="nb">mysql_fetch_array</span><span class="p">(</span><span class="nv">$data</span><span class="p">))</span> <span class="p">{</span> </span><span id="L-115"><a name="L-115"></a> </span><span id="L-116"><a name="L-116"></a> <span class="c1">// Initialise the UPDATE string we&#39;re going to build, and we don&#39;t do an update for each damn column...</span> </span><span id="L-117"><a name="L-117"></a> </span><span id="L-118"><a name="L-118"></a> <span class="nv">$need_to_update</span> <span class="o">=</span> <span class="k">false</span><span class="p">;</span> </span><span id="L-119"><a name="L-119"></a> <span class="nv">$UPDATE_SQL</span> <span class="o">=</span> <span class="s1">&#39;UPDATE &#39;</span><span class="o">.</span><span class="nv">$table</span><span class="o">.</span> <span class="s1">&#39; SET &#39;</span><span class="p">;</span> </span><span id="L-120"><a name="L-120"></a> <span class="nv">$WHERE_SQL</span> <span class="o">=</span> <span class="s1">&#39; WHERE &#39;</span><span class="p">;</span> </span><span id="L-121"><a name="L-121"></a> </span><span id="L-122"><a name="L-122"></a> <span class="nv">$j</span> <span class="o">=</span> <span class="mi">0</span><span class="p">;</span> </span><span id="L-123"><a name="L-123"></a> </span><span id="L-124"><a name="L-124"></a> <span class="k">foreach</span> <span class="p">(</span><span class="nv">$column_name</span> <span class="k">as</span> <span class="nv">$current_column</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-125"><a name="L-125"></a> <span class="nv">$j</span><span class="o">++</span><span class="p">;</span> </span><span id="L-126"><a name="L-126"></a> <span class="nv">$count_items_checked</span><span class="o">++</span><span class="p">;</span> </span><span id="L-127"><a name="L-127"></a> </span><span id="L-128"><a name="L-128"></a><span class="c1">// echo &quot;&lt;br/&gt;Current Column = $current_column&quot;;</span> </span><span id="L-129"><a name="L-129"></a> </span><span id="L-130"><a name="L-130"></a> <span class="nv">$data_to_fix</span> <span class="o">=</span> <span class="nv">$row</span><span class="p">[</span><span class="nv">$current_column</span><span class="p">];</span> </span><span id="L-131"><a name="L-131"></a> <span class="nv">$edited_data</span> <span class="o">=</span> <span class="nv">$data_to_fix</span><span class="p">;</span> <span class="c1">// set the same now - if they&#39;re different later we know we need to update</span> </span><span id="L-132"><a name="L-132"></a> </span><span id="L-133"><a name="L-133"></a><span class="c1">// if ($current_column == $index_field) $index_value = $row[$current_column]; // if it&#39;s the index column, store it for use in the update</span> </span><span id="L-134"><a name="L-134"></a> </span><span id="L-135"><a name="L-135"></a> <span class="nv">$unserialized</span> <span class="o">=</span> <span class="nb">unserialize</span><span class="p">(</span><span class="nv">$data_to_fix</span><span class="p">);</span> <span class="c1">// unserialise - if false returned we don&#39;t try to process it as serialised</span> </span><span id="L-136"><a name="L-136"></a> </span><span id="L-137"><a name="L-137"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$unserialized</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-138"><a name="L-138"></a> </span><span id="L-139"><a name="L-139"></a><span class="c1">// echo &quot;&lt;br/&gt;unserialize OK - now searching and replacing the following array:&lt;br/&gt;&quot;;</span> </span><span id="L-140"><a name="L-140"></a><span class="c1">// echo &quot;&lt;br/&gt;$data_to_fix&quot;;</span> </span><span id="L-141"><a name="L-141"></a><span class="c1">// </span> </span><span id="L-142"><a name="L-142"></a><span class="c1">// print_r($unserialized);</span> </span><span id="L-143"><a name="L-143"></a> </span><span id="L-144"><a name="L-144"></a> <span class="nx">recursive_array_replace</span><span class="p">(</span><span class="nv">$search_for</span><span class="p">,</span> <span class="nv">$replace_with</span><span class="p">,</span> <span class="nv">$unserialized</span><span class="p">);</span> </span><span id="L-145"><a name="L-145"></a> </span><span id="L-146"><a name="L-146"></a> <span class="nv">$edited_data</span> <span class="o">=</span> <span class="nb">serialize</span><span class="p">(</span><span class="nv">$unserialized</span><span class="p">);</span> </span><span id="L-147"><a name="L-147"></a> </span><span id="L-148"><a name="L-148"></a><span class="c1">// echo &quot;**Output of search and replace: &lt;br/&gt;&quot;;</span> </span><span id="L-149"><a name="L-149"></a><span class="c1">// echo &quot;$edited_data &lt;br/&gt;&quot;;</span> </span><span id="L-150"><a name="L-150"></a><span class="c1">// print_r($unserialized); </span> </span><span id="L-151"><a name="L-151"></a><span class="c1">// echo &quot;---------------------------------&lt;br/&gt;&quot;;</span> </span><span id="L-152"><a name="L-152"></a> </span><span id="L-153"><a name="L-153"></a> <span class="p">}</span> </span><span id="L-154"><a name="L-154"></a> </span><span id="L-155"><a name="L-155"></a> <span class="k">else</span> <span class="p">{</span> </span><span id="L-156"><a name="L-156"></a> </span><span id="L-157"><a name="L-157"></a> <span class="k">if</span> <span class="p">(</span><span class="nb">is_string</span><span class="p">(</span><span class="nv">$data_to_fix</span><span class="p">))</span> <span class="nv">$edited_data</span> <span class="o">=</span> <span class="nb">str_replace</span><span class="p">(</span><span class="nv">$search_for</span><span class="p">,</span><span class="nv">$replace_with</span><span class="p">,</span><span class="nv">$data_to_fix</span><span class="p">)</span> <span class="p">;</span> </span><span id="L-158"><a name="L-158"></a> </span><span id="L-159"><a name="L-159"></a> <span class="p">}</span> </span><span id="L-160"><a name="L-160"></a> </span><span id="L-161"><a name="L-161"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$data_to_fix</span> <span class="o">!=</span> <span class="nv">$edited_data</span><span class="p">)</span> <span class="p">{</span> <span class="c1">// If they&#39;re not the same, we need to add them to the update string</span> </span><span id="L-162"><a name="L-162"></a> </span><span id="L-163"><a name="L-163"></a> <span class="nv">$count_items_changed</span><span class="o">++</span><span class="p">;</span> </span><span id="L-164"><a name="L-164"></a> </span><span id="L-165"><a name="L-165"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$need_to_update</span> <span class="o">!=</span> <span class="k">false</span><span class="p">)</span> <span class="nv">$UPDATE_SQL</span> <span class="o">=</span> <span class="nv">$UPDATE_SQL</span><span class="o">.</span><span class="s1">&#39;,&#39;</span><span class="p">;</span> <span class="c1">// if this isn&#39;t our first time here, add a comma</span> </span><span id="L-166"><a name="L-166"></a> <span class="nv">$UPDATE_SQL</span> <span class="o">=</span> <span class="nv">$UPDATE_SQL</span><span class="o">.</span><span class="s1">&#39; &#39;</span><span class="o">.</span><span class="nv">$current_column</span><span class="o">.</span><span class="s1">&#39; = &quot;&#39;</span><span class="o">.</span><span class="nb">mysql_real_escape_string</span><span class="p">(</span><span class="nv">$edited_data</span><span class="p">)</span><span class="o">.</span><span class="s1">&#39;&quot;&#39;</span> <span class="p">;</span> </span><span id="L-167"><a name="L-167"></a> <span class="nv">$need_to_update</span> <span class="o">=</span> <span class="k">true</span><span class="p">;</span> <span class="c1">// only set if we need to update - avoids wasted UPDATE statements</span> </span><span id="L-168"><a name="L-168"></a> </span><span id="L-169"><a name="L-169"></a> <span class="p">}</span> </span><span id="L-170"><a name="L-170"></a> </span><span id="L-171"><a name="L-171"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$table_index</span><span class="p">[</span><span class="nv">$j</span><span class="p">]){</span> </span><span id="L-172"><a name="L-172"></a> <span class="nv">$WHERE_SQL</span> <span class="o">=</span> <span class="nv">$WHERE_SQL</span><span class="o">.</span><span class="nv">$current_column</span><span class="o">.</span><span class="s1">&#39; = &quot;&#39;</span><span class="o">.</span><span class="nv">$row</span><span class="p">[</span><span class="nv">$current_column</span><span class="p">]</span><span class="o">.</span><span class="s1">&#39;&quot; AND &#39;</span><span class="p">;</span> </span><span id="L-173"><a name="L-173"></a> <span class="p">}</span> </span><span id="L-174"><a name="L-174"></a> <span class="p">}</span> </span><span id="L-175"><a name="L-175"></a> </span><span id="L-176"><a name="L-176"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$need_to_update</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-177"><a name="L-177"></a> </span><span id="L-178"><a name="L-178"></a> <span class="nv">$count_updates_run</span><span class="p">;</span> </span><span id="L-179"><a name="L-179"></a> </span><span id="L-180"><a name="L-180"></a> <span class="nv">$WHERE_SQL</span> <span class="o">=</span> <span class="nb">substr</span><span class="p">(</span><span class="nv">$WHERE_SQL</span><span class="p">,</span><span class="mi">0</span><span class="p">,</span><span class="o">-</span><span class="mi">4</span><span class="p">);</span> <span class="c1">// strip off the excess AND - the easiest way to code this without extra flags, etc.</span> </span><span id="L-181"><a name="L-181"></a> </span><span id="L-182"><a name="L-182"></a> <span class="nv">$UPDATE_SQL</span> <span class="o">=</span> <span class="nv">$UPDATE_SQL</span><span class="o">.</span><span class="nv">$WHERE_SQL</span><span class="p">;</span> </span><span id="L-183"><a name="L-183"></a> <span class="k">echo</span> <span class="nv">$UPDATE_SQL</span><span class="o">.</span><span class="s1">&#39;&lt;br/&gt;&lt;br/&gt;&#39;</span><span class="p">;</span> </span><span id="L-184"><a name="L-184"></a> </span><span id="L-185"><a name="L-185"></a> <span class="nv">$result</span> <span class="o">=</span> <span class="nb">mysql_db_query</span><span class="p">(</span><span class="nv">$db</span><span class="p">,</span><span class="nv">$UPDATE_SQL</span><span class="p">,</span><span class="nv">$cid</span><span class="p">);</span> </span><span id="L-186"><a name="L-186"></a> </span><span id="L-187"><a name="L-187"></a> <span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nv">$result</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-188"><a name="L-188"></a> <span class="k">echo</span><span class="p">(</span><span class="s2">&quot;ERROR: &quot;</span> <span class="o">.</span> <span class="nb">mysql_error</span><span class="p">()</span> <span class="o">.</span> <span class="s2">&quot;&lt;br/&gt;</span><span class="si">$UPDATE_SQL</span><span class="s2">&lt;br/&gt;&quot;</span><span class="p">);</span> <span class="p">}</span> </span><span id="L-189"><a name="L-189"></a> </span><span id="L-190"><a name="L-190"></a> <span class="p">}</span> </span><span id="L-191"><a name="L-191"></a> </span><span id="L-192"><a name="L-192"></a> <span class="p">}</span> </span><span id="L-193"><a name="L-193"></a> </span><span id="L-194"><a name="L-194"></a><span class="p">}</span> </span><span id="L-195"><a name="L-195"></a> </span><span id="L-196"><a name="L-196"></a><span class="c1">// Report</span> </span><span id="L-197"><a name="L-197"></a> </span><span id="L-198"><a name="L-198"></a><span class="nv">$report</span> <span class="o">=</span> <span class="nv">$count_tables_checked</span><span class="o">.</span><span class="s2">&quot; tables checked; &quot;</span><span class="o">.</span><span class="nv">$count_items_checked</span><span class="o">.</span><span class="s2">&quot; items checked; &quot;</span><span class="o">.</span><span class="nv">$count_items_changed</span><span class="o">.</span><span class="s2">&quot; items changed;&quot;</span><span class="p">;</span> </span><span id="L-199"><a name="L-199"></a><span class="k">echo</span> <span class="s1">&#39;&lt;p style=&quot;margin:auto; text-align:center&quot;&gt;&#39;</span><span class="p">;</span> </span><span id="L-200"><a name="L-200"></a><span class="k">echo</span> <span class="nv">$report</span><span class="p">;</span> </span><span id="L-201"><a name="L-201"></a> </span><span id="L-202"><a name="L-202"></a><span class="nb">mysql_close</span><span class="p">(</span><span class="nv">$cid</span><span class="p">);</span> </span><span id="L-203"><a name="L-203"></a> </span><span id="L-204"><a name="L-204"></a><span class="c1">// End TIMER</span> </span><span id="L-205"><a name="L-205"></a><span class="c1">// ---------</span> </span><span id="L-206"><a name="L-206"></a><span class="nv">$etimer</span> <span class="o">=</span> <span class="nb">explode</span><span class="p">(</span> <span class="s1">&#39; &#39;</span><span class="p">,</span> <span class="nb">microtime</span><span class="p">()</span> <span class="p">);</span> </span><span id="L-207"><a name="L-207"></a><span class="nv">$etimer</span> <span class="o">=</span> <span class="nv">$etimer</span><span class="p">[</span><span class="mi">1</span><span class="p">]</span> <span class="o">+</span> <span class="nv">$etimer</span><span class="p">[</span><span class="mi">0</span><span class="p">];</span> </span><span id="L-208"><a name="L-208"></a><span class="nb">printf</span><span class="p">(</span> <span class="s2">&quot;&lt;br/&gt;Script timer: &lt;b&gt;%f&lt;/b&gt; seconds.&quot;</span><span class="p">,</span> <span class="p">(</span><span class="nv">$etimer</span><span class="o">-</span><span class="nv">$stimer</span><span class="p">)</span> <span class="p">);</span> </span><span id="L-209"><a name="L-209"></a><span class="k">echo</span> <span class="s1">&#39;&lt;/p&gt;&#39;</span><span class="p">;</span> </span><span id="L-210"><a name="L-210"></a><span class="c1">// ---------</span> </span><span id="L-211"><a name="L-211"></a> </span><span id="L-212"><a name="L-212"></a><span class="k">function</span> <span class="nf">recursive_array_replace</span><span class="p">(</span><span class="nv">$find</span><span class="p">,</span> <span class="nv">$replace</span><span class="p">,</span> <span class="o">&amp;</span><span class="nv">$data</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-213"><a name="L-213"></a> </span><span id="L-214"><a name="L-214"></a> <span class="k">if</span> <span class="p">(</span><span class="nb">is_array</span><span class="p">(</span><span class="nv">$data</span><span class="p">))</span> <span class="p">{</span> </span><span id="L-215"><a name="L-215"></a> <span class="k">foreach</span> <span class="p">(</span><span class="nv">$data</span> <span class="k">as</span> <span class="nv">$key</span> <span class="o">=&gt;</span> <span class="nv">$value</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-216"><a name="L-216"></a> <span class="k">if</span> <span class="p">(</span><span class="nb">is_array</span><span class="p">(</span><span class="nv">$value</span><span class="p">))</span> <span class="p">{</span> </span><span id="L-217"><a name="L-217"></a> <span class="nx">recursive_array_replace</span><span class="p">(</span><span class="nv">$find</span><span class="p">,</span> <span class="nv">$replace</span><span class="p">,</span> <span class="nv">$data</span><span class="p">[</span><span class="nv">$key</span><span class="p">]);</span> </span><span id="L-218"><a name="L-218"></a> <span class="p">}</span> <span class="k">else</span> <span class="p">{</span> </span><span id="L-219"><a name="L-219"></a> <span class="c1">// have to check if it&#39;s string to ensure no switching to string for booleans/numbers/nulls - don&#39;t need any nasty conversions</span> </span><span id="L-220"><a name="L-220"></a> <span class="k">if</span> <span class="p">(</span><span class="nb">is_string</span><span class="p">(</span><span class="nv">$value</span><span class="p">))</span> <span class="nv">$data</span><span class="p">[</span><span class="nv">$key</span><span class="p">]</span> <span class="o">=</span> <span class="nb">str_replace</span><span class="p">(</span><span class="nv">$find</span><span class="p">,</span> <span class="nv">$replace</span><span class="p">,</span> <span class="nv">$value</span><span class="p">);</span> </span><span id="L-221"><a name="L-221"></a> <span class="p">}</span> </span><span id="L-222"><a name="L-222"></a> <span class="p">}</span> </span><span id="L-223"><a name="L-223"></a> <span class="p">}</span> <span class="k">else</span> <span class="p">{</span> </span><span id="L-224"><a name="L-224"></a> <span class="k">if</span> <span class="p">(</span><span class="nb">is_string</span><span class="p">(</span><span class="nv">$data</span><span class="p">))</span> <span class="nv">$data</span> <span class="o">=</span> <span class="nb">str_replace</span><span class="p">(</span><span class="nv">$find</span><span class="p">,</span> <span class="nv">$replace</span><span class="p">,</span> <span class="nv">$data</span><span class="p">);</span> </span><span id="L-225"><a name="L-225"></a> <span class="p">}</span> </span><span id="L-226"><a name="L-226"></a> </span><span id="L-227"><a name="L-227"></a><span class="p">}</span> </span><span id="L-228"><a name="L-228"></a> </span><span id="L-229"><a name="L-229"></a> </span><span id="L-230"><a name="L-230"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
db, wordpress