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

  1. Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  2. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    2011-03-04 12:00:00 - 2011-03-04 10:00:00 = 2.00 2011-03-08 00:30:00 - 2011-03-08 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  3. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    $str); // removes numeric entities? $str = preg_replace('//i', '', $str); // removes MS Office style html comments (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove carriage returns, line feeds, tabs...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  4. 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

    be prompted for the total range (eg. $A1:$W36000) ' And then prompted for the number of rows per sheet (eg. 3000) ' Run everything Sub RunAll() Call SplitData Call InsertRow Call CopyToAllSheets Call Splitbook End Sub ' Split data to sheets Sub...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  5. 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

    > /path_to/backup.sql // and in your cnf file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: using external file, suffixing date and compressing: mysqldump --defaults-file=/full-path-to/.my.cnf my_db | gzip >...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *

  6. How to put MediaWiki into Debug modehttps://www.joellipman.com/articles/cms/mediawiki/how-to-put-mediawiki-into-debug-mode.html

    By adding the following line to your LocalSettings.php file, you will be able to log everything that WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB

  7. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  8. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    WHERE 'user' = 'Fred'"); $a2=$mysqli->affected_rows(); //Check 1 row affected by each query if ($a1==1 && $a2==1) { //Everything looks OK, commit changes $mysqli->commit(); } else //Something went wrong. Roll back to before begin_transaction()...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB

  9. The Sandpithttps://www.joellipman.com/component/content/article/the-sandpit.html?catid=115&Itemid=165

    I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 21 - 29 of 29