Create Wordpress User in phpMyadmin SQL
This simple sql script will create a Wordpress user.
You'll need access to the database via phpMyadmin or another means..
INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status)
VALUES ('username', MD5('password'), 'Firstname Lastname', 'email address', '0');
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities',
Magento 1 Rest Api Multiple SKU Query
It took me a long time to track down this solution to get multiple products by SKU out of the Magento Rest API... But here's the solution I've found:
Open All Files Staged in Git in Vim
vim git status --porcelain | sed -E -e 's/^M|^A//g'
This is working for me in iTerm on my Mac...
Find Magento Layout Handle for Current Controller/Action
I is still getting the hang of the whole Magento layout functionality but have just found a couple of tips that have helped me greatly.
As I understand it the layout handle of and xml file is the node that is called when a particular…
Magento block caching
If you set it to false, Zend cache will get default value of 7200 seconds!! If you want infinite never expired cache set it to 9999999999, which is Zend_Cache maximum value, or something else big enough.
Magento block caching • Inchoo
Selective Git Add
git add -u
This git command looks at the already tracked files and stages the changes to those files if they are different or have been removed...
I found this command when I had a lot of modified files and a good handful of new files, but only wanted to
What Design Is...
Despite popular opinion, design is not about Sketch, style guides, or pushing pixels, it is the act of intentionally solving problems.— Cameron Rogers (@cameron_rogers) June 1, 2016
Loving this tweet...
Web making: 1. Identify core functionality. 2. Make that functionality available using the simplest technology. 3. Enhance! @adactio #aeabos— Jeffrey Zeldman (@zeldman) May 17, 2016
Web Dev Axioms to Live By
Loving this tweet...
web dev axioms to live by: #1 if you can do it in HTML, don’t use CSS#2 if you can do it in CSS, don’t use JS#3 if all else fails use JS— John Allsopp (@johnallsopp) April 12, 2016
How to Change the Last Character in a String to Uppercase in MySQL
I have been working on a project that required the importing of some nasty old, badly formatted data in a nice new MySQL database.
I ended up data in a firstname field with titles and initials, for example; Mr…