showTag('examples');

SQL queries to move WordPress

Posted by Admin & filed under , .

UPDATE wp_options SET option_value = replace(option_value, 'http://www.sitename.com', 'https://www.sitename.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.sitename.com','https://www.sitename.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.sitename.com', 'https://www.sitename.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.sitename.com','https://www.sitename.com');

Showing 4 lines of 5 total lines in this snippet.

Simple JSON array

Posted by Admin & filed under .

{"array":[{
"date": "01 Dec 2016",
"title": "Title 1",
"description": "Lorem amet ipsum dolor sit."
},{
"date": "02 Dec 2016",
"title": "Title 2",
"description": "Lorem ipsum amet dolor sit."
},{
"date": "03 Dec 2016",
"title": "Title 3",
"description": "Lorem ipsum sit dolor amet."
},{
"date": "04 Dec 2016",
"title": "Title 4",
"description": "Lorem ipsum dolor amet sit."
},{
"date": "05 Dec 2016",
"title": "Title 5",
"description": "Lorem dolor ipsum sit amet."
}]}

Showing 21 lines of 21 total lines in this snippet.

Single item JSON

Posted by Admin & filed under .

{"text":"<p>Here's some text in html tags in a json element also using \"quotes\"</p>"}

Showing 1 lines of 1 total lines in this snippet.