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

  1. Submit form as a server and not the client with cURLhttps://www.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: *
  2. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make which I'm documenting here. Basic Example Here's a complete PHP script of a basic example of getting the agencies belonging to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  3. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    upload the report to the server, configure the web application to use the newly uploaded report, export to a Crystal Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to...

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

    I have made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But because the next time this happens, I would have...

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

    116°19′17″E Beijing Tongxian Air Base 39°48′40″N 116°42′30″E Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it,...

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

    I'm all up for any suggestions people might have on how this can be improved but it's the one I'm going on for the moment which works fine.

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  7. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    Noticed a problem with jello. This problem was due to the new propellers I was trying (9" nylons) which I replaced with the stock propellers (8" plastic) and the jello effect went away. I have now equipped it with 9" carbon fibre but notice some jello...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  8. DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

    see the height of our 1 marshall's head. To be honest, the reason I wasn't using my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really strong, I'd doubled the cost of the quadcopter and that's my mate's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  9. List last modified files using FTP Command-linehttps://www.joellipman.com/articles/cms/website-development/ftp/list-last-modified-files-using-ftp-command-line.html

    if you want to change this (leave blank to simply display what current local working directory is). Type dir -S . temp.txt which will output all files including subdirectories to temp.txt in your local working folder. Additional Notes the switch "-S"...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  10. How to make a HTML form post its variables to itselfhttps://www.joellipman.com/articles/cms/website-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

    The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  11. Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/cms/website-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

    Basically I have a menu in a sidebar, I don't want it to overlap the header nor the footer.I have a content page next to it which changes in height dynamically (a separate mootool function to this one). How? So this is my take on it, if anyone has a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: en-GB
  12. How to grow potatoes in potato planter bagshttps://www.joellipman.com/component/content/article/how-to-grow-potatoes-in-potato-planter-bags.html?catid=96&Itemid=165

    I live in a flat but I'm lucky enough to have a balcony which gets some sun. Bought some potato patio planters and found this good video on youtube... {youtube}Q3zoVolI-Sw{/youtube}{youtube}Q3zoVolI-Sw{/youtube}{youtube}Q3zoVolI-Sw{/youtube}

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  13. Mirror's Edge Prologue Speedrun Under 2:00https://www.joellipman.com/component/content/article/mirrors-edge-prologue-speedrun-under-200.html?catid=96&Itemid=165

    Blinding run in Mirror's Edge which is one of my favorite games. Yes it's quick to complete but if you've ever youtube'd the levels, there isn't another game so quick-paced and varied giving you that freedom of completing the game your way. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  14. Sir James Dyson explains his bladeless fanhttps://www.joellipman.com/component/content/article/sir-james-dyson-explains-his-bladeless-fan.html?catid=96&Itemid=165

    that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other countries but this is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  15. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    values (4) */ =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) /* Count the number of unique text and number values in cells B2:B10 (which must not contain blank cells) (7) */ =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) /* Count the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Leap Motion and AR Dronehttps://www.joellipman.com/component/content/article/leap-motion-and-ar-drone.html?catid=113&Itemid=165

    Motion is a USB gesture control device you can connect to a computer which behaves much like a mouse or trackpad but in 3 dimensions. Available July 2013 for public release (you can pre-order if you like @ https://www.leapmotion.com/). It's noted for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  17. DJI Phantom FC40 - First Flighthttps://www.joellipman.com/component/content/article/dji-phantom-fc40-first-flight.html?catid=113&Itemid=165

    I just started another YouTube channel which I'll try to transfer my Joomla videos over to but in the meantime you can be subjected to my quadcopter videos. Here are a few quick ones, the Hubsan H107C and its Q4 Nano, then the DJI Phantom. First up, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
Results 321 - 337 of 337