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

  1. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    Anything to add? I welcome any suggestions/improvements to the above. Just add a comment to this page. Also if you want to share your nightmare project takeovers, they're always fun to hear about.

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

    If you're not an IT person, you may want to avoid 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be done on the respective social network's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. Vertically align an asterisk on a linehttps://www.joellipman.com/articles/cms/website-development/css/vertically-align-an-asterisk-on-a-line.html

    So I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  6. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the field to understand this as "no one entered anything", treat it as empty. this.value.split(' ').join('') -- split this...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  7. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    across the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); //...

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

    This example specifically displays the time remaining on an access_token which is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated and how long ago was the last token...

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

    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 with no glass) and for all the flashy stuff, to only appear...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  10. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    do not have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    error with using either "SimpleXMLElement" or "simplexml_load_string". Returning the XML with cURL isn't a problem, but I want to convert it to JSON and I usually use a PHP function to load the data into an XML array and use the built-in PHP function:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    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 clicking on the big fat refresh...

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

    Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. 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

    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 ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N...

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

    run two VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open...

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

    then click on "My Products": Scroll down to SSL Certificates and click on the "Manage" button alongside the domain you want to install the SSL certificate for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and...

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

    opportunity record, it puts the end customer in the Account field (maps Deal Account Name to Quote Account Name). How? We want this to happen as soon as a CRM user clicks on the plus symbol or "Add New" in the quotes related list section of the Deal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. On Gui Resize Eventhttps://www.joellipman.com/component/content/article/on-gui-resize-event.html?catid=48&Itemid=165

    In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose responds to when you close...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  19. CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-hide-reset-button-on-form.html

    goes: Why? Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want the button to show so... How? Well edit the HTML... Now to do this, follow the below steps: Find the CSS class name of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 241 - 260 of 280