Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming quick is required, the following 248 results were found.

  1. Preg_Replace all strings between two tagshttps://joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    my understanding with regular expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  2. htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  3. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

    What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string()....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  4. Mouseover Links in AutoHotkeyhttps://joellipman.com/component/content/article/mouseover-links-in-autohotkey.html?catid=48&Itemid=165

    If you copy the above code into an AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with their mouseovers and mouseouts, then the GUI will sometimes leave the link as blue despite the mouse cursor not being...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  5. Format Numbers in AutoHotkey with Commashttps://joellipman.com/component/content/article/format-numbers-in-autohotkey-with-commas.html?catid=48&Itemid=165

    a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  6. Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  7. Thank You!https://joellipman.com/component/content/article/thank-you.html?catid=50&Itemid=165

    submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Sun-Dried Tomato Basil Couscous Recipehttps://joellipman.com/component/content/article/sun-dried-tomato-basil-couscous-recipe.html?catid=96&Itemid=165

    I've recently been making couscous a lot and this is the simplest recipe I use on the net. Simple and quick couscous is flavored with sun-dried tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  9. Xero API: Send Multiple Invoiceshttps://joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  10. Submit form as a server and not the client with cURLhttps://joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  11. MS Excel - Sort pivottable column headings by datehttps://joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. MS Excel: Convert a text to a numberhttps://joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  13. Excel: convert degrees minutes seconds to decimalhttps://joellipman.com/component/content/article/excel-convert-degrees-minutes-seconds-to-decimal.html?catid=110&Itemid=165

    A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    the below into the developer window. Ensure that your mouse cursor has focus in the first subroutine "RunAll". Here's a quick summary of what the below script does: Splits one spreadsheet to several sheets within the same workbook. Inserts a blank row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  15. Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  16. GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  17. Make bootstrap carousel responsive to swipehttps://joellipman.com/articles/cms/website-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

    A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Bootstrap
    • Language: *
  18. Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

    A very quick article on a small client script to set the Account field on the Quote from a lookup field on the Deal record. Why? The use-case here is that I have a client who is a supplier. The opportunity (aka Deal) will be in the end customer's name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. A for loop within a for loop in MS-DOShttps://joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  20. Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 181 - 200 of 248