SavedMarks

Latest Public Bookmarks

  1. Screenshot of mysql - PHP - Using PDO with IN clause array - Stack Overflow

    mysql - PHP - Using PDO with IN clause array - Stack Overflow

    This seems the most relevant bit... $arr = [1,2,3]; $in = str_repeat('?,', count($arr) - 1) . '?'; $sql = "SELECT * FROM table WHERE foo=? AND column IN ($in) AND bar=? AND baz=?"; $stm = $db->prepare($sql); $params = array_merge([$foo], $arr, [$bar, $baz]); $stm->execute($params); $data = $stm->fetchAll(); ... although I ended up doing the IN with a straight list as I could be sure the items in the list were clean.

    Saved by: Paul on 19 Jun 2020

  2. Screenshot of Video on De-duplicating spreadsheets in OpenOffice

    Video on De-duplicating spreadsheets in OpenOffice

    Highlight the column with the data in that needs de-duplicating. Data > Filter > Standard Filter > Choose column, Value: - not empty - Open "More Options" Choose "No duplication" Click "OK" Highlight all data and copy to another spreadsheet

    Saved by: Paul on 11 Jun 2020

  3. Screenshot of Using Statamic as a CMS alongside a Laravel App

    Using Statamic as a CMS alongside a Laravel App

    Elliot's article about setting up Statamic within an existing Laravel app - will be useful for me to do on a couple of projects

    Saved by: Paul on 5 Jun 2020

  4. Screenshot of GitHub - fogleman/primitive: Reproducing images with geometric primitives.

    GitHub - fogleman/primitive: Reproducing images with geometric primitives.

    A library/way to create images using simple primitives, which are much smaller and can be SVGs. Interesting to have a play with

    Saved by: Paul on 5 Jun 2020

  5. Screenshot of Simple Icons

    Simple Icons

    Free SVG icons for popular brands

    Saved by: Paul on 21 May 2020

  6. Screenshot of Matrix Chat / Wiki / Markdown Syntax

    Matrix Chat / Wiki / Markdown Syntax

    The various bits of markdown supported by Matrix chatrooms

    Saved by: Paul on 21 May 2020

  7. Screenshot of Search operators you can use with Gmail - Gmail Help

    Search operators you can use with Gmail - Gmail Help

    The various searches you can do within Gmail

    Saved by: Paul on 20 May 2020

  8. Screenshot of #LEARNUARY BONANZA - The FULL SET of Robin's first 175 - ONE HUNDRED AND SEVENTY FIVE - How To Think When You WRITE tutorials! - The Etherington Brothers

    #LEARNUARY BONANZA - The FULL SET of Robin's first 175 - ONE HUNDRED AND SEVENTY FIVE - How To Think When You WRITE tutorials! - The Etherington Brothers

    How to Think When You Write tutorials by the same people who do the How to Think When You Draw tutorials and books

    Saved by: Paul on 11 May 2020

  9. Screenshot of Refurbished Desktop PC and laptops - Buy a Cheap Second Hand Laptop UK, Tier1Online.com

    Refurbished Desktop PC and laptops - Buy a Cheap Second Hand Laptop UK, Tier1Online.com

    Good place to buy second hand / refurbished PCs and laptops. As recommended by Michael Mulq.

    Saved by: Paul on 7 May 2020

  10. Screenshot of mysql - MAMP PRO Disable ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE in my.cnf - Stack Overflow

    mysql - MAMP PRO Disable ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE in my.cnf - Stack Overflow

    Where in MAMP to change MySQL settings, and how to change a setting in MySQL 2.7+ which stops DISTINCTs working the way they used to

    Saved by: Paul on 29 Apr 2020