hawkapparel

//SCRIPT PARA CAMBIAR URLS EN WORDPRESS
//Con este script se actualiza las urls de la BD cuando se cambia de servidor un proyecto wordpress
//UPDATE wp_posts SET guid = replace(guid, 'URL_ACTUAL','URL_LOCAL'); 

UPDATE wp_posts SET guid = replace(guid, 'http://tuurldeproduccion.com.pe/','http://localhost/tuproyecto'); 
UPDATE wp_posts SET post_content = replace(post_content, 'http://tuurldeproduccion.com.pe/', 'http://localhost/tuproyecto'); 
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://tuurldeproduccion.com.pe/', 'http://localhost/tuproyecto'); 
UPDATE wp_options SET option_value = replace(option_value, 'http://tuurldeproduccion.com.pe/', 'http://localhost/tuproyecto') 
WHERE option_name = 'home' OR option_name = 'siteurl';

santoshachari

#Steps to install latest Laravel, LEMP on AWS Ubuntu 16.4 version. This tutorial is the improvised verision of this tutorial on Digitalocean based on my experience.

Install PHP 7 on Ubuntu

Run the following commands in sequence.

sudo apt-get install -y language-pack-en-base
sudo LC_ALL=en_US.UTF-8 add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install zip unzip

tawanorg

// Setup arrays for Actual Values, and Placeholders
$values = array();
$place_holders = array();

// Then loop through the the values you're looking to add, and insert them in the appropriate arrays:
foreach($_POST as $key => $value)
{
     array_push($values, $value, $order_id);
     $place_holders[] = "('%d', '%d')" /* In my case, i know they will always be integers */
}

philfreo

// Safari, in Private Browsing Mode, looks like it supports localStorage but all calls to setItem
// throw QuotaExceededError. We're going to detect this and just silently drop any calls to setItem
// to avoid the entire page breaking, without having to do a check at each usage of Storage.
if (typeof localStorage === 'object') {
    try {
        localStorage.setItem('localStorage', 1);
        localStorage.removeItem('localStorage');
    } catch (e) {
        Storage.prototype._setItem = Storage.prototype.setItem;
        Storage.prototype.setItem = function() {};

ashleydw

server {
    listen 80 default_server;

    server_name example.com www.example.com;

    access_log /srv/www/example.com/logs/access.log;
    error_log /srv/www/example.com/logs/error.log;

    root /srv/www/example.com/public;
    index index.php index.html;

Steven-Rose

Select all and delete (actually move to buffer)
:%d

Select all and copy to buffer
:%y

Use p to paste the buffer.