JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

21 entries / Personal Home Page

Clear filters
PHP Script: Make your own Thumbnail Generator via API
Personal Home Page 38200

PHP Script: Make your own Thumbnail Generator via API

Looking for an online tool that will take an image and make a thumbnail copy? This article is for me if I ever want to recreate an online tool capable of receiving an image URL and which both generates and outputs a thumbnail image and makes it downloadable via URL.

Read note
URL Alias uniqueness with PHP & MySQL
Personal Home Page 33912

URL Alias uniqueness with PHP & MySQL

So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this:When I save a record in JoomlaCMS or WordpressCMSIt creates a unique name to use in URLsI want...

Read note
Foreign Characters create symbols in PHP and MySQL
Personal Home Page 37790

Foreign Characters create symbols in PHP and MySQL

Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case.

Read note
Convert XML UTF-16 to JSON UTF-8 with PHP cURL
Personal Home Page 63271

Convert XML UTF-16 to JSON UTF-8 with PHP cURL

This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load the received XML with SimpleXML and use the built-in PHP JSON_encode function. I ran into the following errors: Warning: SimpleXMLElement::__construct() [si...

Read note
PHP: First name and Initial of Surname
Personal Home Page 18981

PHP: First name and Initial of Surname

A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How?

Read note
htaccess Rewrites SEF URL and submits to PHP
Personal Home Page 30907

htaccess Rewrites SEF URL and submits to PHP

A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How?

Read note

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

25 Years in IT
1990 CRM clients
798 Site articles
24.4m+ Reads / hits