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

09 March 2011 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); $sql = "SELECT * FROM...

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

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 following shortcuts in the address bar: Type a search term, then press Enter. Performs a search using your default search engine. Type a search engine keyword, pressSpace, then Tab when prompted, type a search term, and press Enter. Performs a search...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Polka Dot Pop Art Post-Impressionism Psychedelic Punk Rainbow Realism Sketch Steampunk Sticker Surreal Synthwave Unreal Engine Vector Line Watercolor Painting Whimsical Yellowist Zombie Lighting Ambient Light Artificial Lighting Back Light Blacklight...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 `Column3` int(11) NOT NULL, `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- To CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11)...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias //...

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

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be indexed in global...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 disabled access) Explain balance of scope, quality, time and cost. (focusing on one element means less on another) Search Engine Optimization constraints and standards Domain Registration This is so that you as the client retain overall control of the...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 How? You need to set the database to single-user mode. In SSMS, connect to an instance of the SQL Server Database Engine, and then expand that instance. Right-click the database to change, and then click Properties. In the Database Properties dialog...

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

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

13 June 2016 on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 a collection of digits that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 €...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that has an out-of-date listing for this site - you have no access to this page If difficulties persist, please contact the...

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

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

14 December 2016 mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine that supports transactions ie. InnoDB. Don't be silly like me and spend hours wondering why your transactions aren't...

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