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 note is required, the following 299 results were found.

  1. Generate a Timesheet in MySQL https://joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    example is using a small table with very little sample data so do not expect it to reconcile with the requirement example. Note that we have two events on the Thursday. A few things we have to deal with still: We have lost the rows with days that have...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Difference between two dates - the midnight hourhttps://joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    ---------------- -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  3. What's the problem? Amusing computer issueshttps://joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the users screen. Three...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    expression matches 'DEF' in the string: abcDEFghi The expression does not return a match for the following string: abcdefghi Note that the character class must occur within a character list, so the character class is always nested within the brackets...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. List of Font Awesomehttps://joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    don't appear on this page, it is because I have only copied over some of the entire directory (the icons I want to use). Note, change the width of your browser if the below list is not displaying nicely. 4.4  fa-500px []  fa-adjust []...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  6. CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

    note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  7. Three boxes, two roll over, one falls outhttps://joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  8. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example specifically displays the time remaining on an access_token which is...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  9. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  10. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    isn't accepting the file type you are trying to upload, or the file is too big, or this feature just isn't available to you. Note: The temporary file gets deleted when the script finishes. So the file shouldn't exist if you check after the script has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. 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

    CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); $data = utf8_decode(curl_exec($ch)); // note the utf8_decode function applied here curl_close($ch); return $data; } $file_content = get_data(...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  13. 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
  14. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Thu, 31st Oct 2013 3.0 - Fixed Bug: Version compatible with Joomla v3 - Enhancement: Added thumbnail folder finder to debug notes. - Date Uploaded: Mon, 16th Sep 2013 2.4 SimonB - Fix Bug: Change for PHP v5.4 - Date Uploaded: Sun, 15th Dec 2013 2.3...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  15. 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

    #1: The HTML form: Sender: Receiver: Script #2: Send to third-party in XML format: (because that's the format they accept) Note that in the following example, the XML is sent as a url encoded value paired with a key (posted variables must be...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  16. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    were complaining it became too convoluted and cramped when refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the hassle of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  17. Excel: Find values in one column that are not in anotherhttps://joellipman.com/component/content/article/excel-find-values-in-one-column-that-are-not-in-another.html?catid=110&Itemid=165

    A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  18. 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

    an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook() Dim xPath As String xPath = Application.ActiveWorkbook.Path...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  19. 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: *
  20. AutoHotkey Ternary Operatorhttps://joellipman.com/component/content/article/autohotkey-ternary-operator.html?catid=48&Itemid=165

    Just a quick note for the moment on how to use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
Results 241 - 260 of 299