snipt

Ctrl+h for KB shortcuts

PHP

Set up wp-config for working with WP locally

<?php
/**
 * The base configurations of the WordPress.
 *
 * This file has the following configurations: MySQL settings, Table Prefix,
 * Secret Keys, WordPress Language, and ABSPATH. You can find more information
 * by visiting {@link http://codex.wordpress.org/Editing_wp-config.php Editing
 * wp-config.php} Codex page. You can get the MySQL settings from your web host.
 *
 * This file is used by the wp-config.php creation script during the
 * installation. You don't have to use the web site, you can just copy this file
 * to "wp-config.php" and fill in the values.
 *
 * @package WordPress
 */


/** The name of the database for WordPress */

$whitelist = array('localhost:8888', 'localhost', '127.0.0.1');

if(!in_array($_SERVER['HTTP_HOST'], $whitelist)){

	define('DB_NAME', 'db_name');

	/** MySQL database username */
	define('DB_USER', 'db_user');

	/** MySQL database password */
	define('DB_PASSWORD', 'db_password');

	/** MySQL hostname */
	define('DB_HOST', 'db_host');

} else {

	// localhost
	define( 'WP_LOCAL_DEV', true );

	define('DB_NAME', 'db_name');

	/** MySQL database username */
	define('DB_USER', 'db_user');

	/** MySQL database password */
	define('DB_PASSWORD', 'db_password');

	/** MySQL hostname */
	define('DB_HOST', 'localhost');

}


# file continues ...

Description

Set up wp-config for working with WP locally so that on server it will use server settings, but local when in development
https://snipt.net/embed/5126c1933ae02cb46c004d43c5e7e6ab/
/raw/5126c1933ae02cb46c004d43c5e7e6ab/
5126c1933ae02cb46c004d43c5e7e6ab
php
PHP
54
2019-07-16T06:10:14
True
False
False
May 13, 2013 at 11:46 PM
/api/public/snipt/61258/
set-up-wp-config-for-working-with-wp-locally
<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></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 class="sd">/**</span> </span><span id="L-3"><a name="L-3"></a><span class="sd"> * The base configurations of the WordPress.</span> </span><span id="L-4"><a name="L-4"></a><span class="sd"> *</span> </span><span id="L-5"><a name="L-5"></a><span class="sd"> * This file has the following configurations: MySQL settings, Table Prefix,</span> </span><span id="L-6"><a name="L-6"></a><span class="sd"> * Secret Keys, WordPress Language, and ABSPATH. You can find more information</span> </span><span id="L-7"><a name="L-7"></a><span class="sd"> * by visiting {@link http://codex.wordpress.org/Editing_wp-config.php Editing</span> </span><span id="L-8"><a name="L-8"></a><span class="sd"> * wp-config.php} Codex page. You can get the MySQL settings from your web host.</span> </span><span id="L-9"><a name="L-9"></a><span class="sd"> *</span> </span><span id="L-10"><a name="L-10"></a><span class="sd"> * This file is used by the wp-config.php creation script during the</span> </span><span id="L-11"><a name="L-11"></a><span class="sd"> * installation. You don&#39;t have to use the web site, you can just copy this file</span> </span><span id="L-12"><a name="L-12"></a><span class="sd"> * to &quot;wp-config.php&quot; and fill in the values.</span> </span><span id="L-13"><a name="L-13"></a><span class="sd"> *</span> </span><span id="L-14"><a name="L-14"></a><span class="sd"> * @package WordPress</span> </span><span id="L-15"><a name="L-15"></a><span class="sd"> */</span> </span><span id="L-16"><a name="L-16"></a> </span><span id="L-17"><a name="L-17"></a> </span><span id="L-18"><a name="L-18"></a><span class="sd">/** The name of the database for WordPress */</span> </span><span id="L-19"><a name="L-19"></a> </span><span id="L-20"><a name="L-20"></a><span class="nv">$whitelist</span> <span class="o">=</span> <span class="k">array</span><span class="p">(</span><span class="s1">&#39;localhost:8888&#39;</span><span class="p">,</span> <span class="s1">&#39;localhost&#39;</span><span class="p">,</span> <span class="s1">&#39;127.0.0.1&#39;</span><span class="p">);</span> </span><span id="L-21"><a name="L-21"></a> </span><span id="L-22"><a name="L-22"></a><span class="k">if</span><span class="p">(</span><span class="o">!</span><span class="nb">in_array</span><span class="p">(</span><span class="nv">$_SERVER</span><span class="p">[</span><span class="s1">&#39;HTTP_HOST&#39;</span><span class="p">],</span> <span class="nv">$whitelist</span><span class="p">)){</span> </span><span id="L-23"><a name="L-23"></a> </span><span id="L-24"><a name="L-24"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_NAME&#39;</span><span class="p">,</span> <span class="s1">&#39;db_name&#39;</span><span class="p">);</span> </span><span id="L-25"><a name="L-25"></a> </span><span id="L-26"><a name="L-26"></a> <span class="sd">/** MySQL database username */</span> </span><span id="L-27"><a name="L-27"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_USER&#39;</span><span class="p">,</span> <span class="s1">&#39;db_user&#39;</span><span class="p">);</span> </span><span id="L-28"><a name="L-28"></a> </span><span id="L-29"><a name="L-29"></a> <span class="sd">/** MySQL database password */</span> </span><span id="L-30"><a name="L-30"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_PASSWORD&#39;</span><span class="p">,</span> <span class="s1">&#39;db_password&#39;</span><span class="p">);</span> </span><span id="L-31"><a name="L-31"></a> </span><span id="L-32"><a name="L-32"></a> <span class="sd">/** MySQL hostname */</span> </span><span id="L-33"><a name="L-33"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_HOST&#39;</span><span class="p">,</span> <span class="s1">&#39;db_host&#39;</span><span class="p">);</span> </span><span id="L-34"><a name="L-34"></a> </span><span id="L-35"><a name="L-35"></a><span class="p">}</span> <span class="k">else</span> <span class="p">{</span> </span><span id="L-36"><a name="L-36"></a> </span><span id="L-37"><a name="L-37"></a> <span class="c1">// localhost</span> </span><span id="L-38"><a name="L-38"></a> <span class="nb">define</span><span class="p">(</span> <span class="s1">&#39;WP_LOCAL_DEV&#39;</span><span class="p">,</span> <span class="k">true</span> <span class="p">);</span> </span><span id="L-39"><a name="L-39"></a> </span><span id="L-40"><a name="L-40"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_NAME&#39;</span><span class="p">,</span> <span class="s1">&#39;db_name&#39;</span><span class="p">);</span> </span><span id="L-41"><a name="L-41"></a> </span><span id="L-42"><a name="L-42"></a> <span class="sd">/** MySQL database username */</span> </span><span id="L-43"><a name="L-43"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_USER&#39;</span><span class="p">,</span> <span class="s1">&#39;db_user&#39;</span><span class="p">);</span> </span><span id="L-44"><a name="L-44"></a> </span><span id="L-45"><a name="L-45"></a> <span class="sd">/** MySQL database password */</span> </span><span id="L-46"><a name="L-46"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_PASSWORD&#39;</span><span class="p">,</span> <span class="s1">&#39;db_password&#39;</span><span class="p">);</span> </span><span id="L-47"><a name="L-47"></a> </span><span id="L-48"><a name="L-48"></a> <span class="sd">/** MySQL hostname */</span> </span><span id="L-49"><a name="L-49"></a> <span class="nb">define</span><span class="p">(</span><span class="s1">&#39;DB_HOST&#39;</span><span class="p">,</span> <span class="s1">&#39;localhost&#39;</span><span class="p">);</span> </span><span id="L-50"><a name="L-50"></a> </span><span id="L-51"><a name="L-51"></a><span class="p">}</span> </span><span id="L-52"><a name="L-52"></a> </span><span id="L-53"><a name="L-53"></a> </span><span id="L-54"><a name="L-54"></a><span class="c1"># file continues ...</span> </span></pre></div> </td></tr></table>
WordPress, dev, local