danielhpavey.uk

A sorta, kinda, web development and design blog...

Eventbrite API Event Series Query with Ticket Data

Wednesday 22 March 2017

Eventbrite API Event Series Query with Ticket Data I needed to get some data from the Eventbrite API. It took a bit of effort to build the request URL that I needed. The events I wanted the data fro where recurring. I also wanted to know how many tickets where available for

Tags: #web developement #eventbrite #api #php

How do I pull a native DOM element from a jQuery object?

Friday 17 February 2017

How do I pull a native DOM element from a jQuery object? Ruthless plagiarised from the jQuery website A jQuery object is an array-like wrapper around one or more DOM elements. To get a reference to the actual DOM elements (instead of the jQuery object), you have two options. The first (and

Tags: #web development #javascript #jquery

Create Wordpress User in phpMyadmin SQL

Thursday 16 February 2017

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',

Tags: #wordpress #php #web dev

Magento 1 Rest Api Multiple SKU Query

Friday 10 February 2017

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: http://[magento host]/api/rest/products?filter[1][attribute]=sku&filter[1][in][0]=sku1&filter[1][in][1]=sku2

Tags: #magento #web development #php

Find Magento Layout Handle for Current Controller/Action

Friday 3 February 2017

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…

Tags: #magento #web development #php

Magento block caching

Friday 20 January 2017

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

Tags: #magento #web development #php

Selective Git Add

Thursday 19 January 2017

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

Tags: #web developmenat #git

What design is...

Thursday 2 June 2016

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

Tags: #design #bookmarks #tweet

Web Making

Friday 22 April 2016

Web Making 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

Tags: #web development #responsive web design

Change Last Character in String to Uppercase in MySQL

Thursday 11 February 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…

Tags: #mysql #webdev

Next >