Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 cause for the error. FisherC says: I have the same problem, but I'm not sure for the same reasons. I installed the standard 1.5 installation package. I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...

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

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

25 February 2010 Similar looking websites where layouts/colour schemes can be adapted Explain accessibility and usability industry standards. (includes iPhone compatibility and disabled access) Explain balance of scope, quality, time and cost. (focusing on one element...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was connected via three usb extension cables. The middle one wasn't connected to anything on either end....

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

07 September 2015 via Joomla Extension Update Manager corrected. - Date Uploaded: Wed, 4th Jun 2014 3.0.1 ThomasM - Fixed Bug: Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. -...

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

Submit form as a server and not the client with cURLhttps://www.joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

20 February 2015 the server IP address. We're going to use a PHP script with the cURL function to receive and send the data. cURL is a standard feature on most LAMP setups. If not you can install it from here: http://curl.haxx.se/download.html I'm demonstrating this...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

05 October 2015 Information(s): StackOverflow: Split string by comma, but ignore commas inside quotes WhatWG.org - XMLHttpRequest Standard

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

CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

04 September 2015 Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard would be: v_CrmTime = "2021-01-01T01:23:45+01:00"; v_CreatorTime = v_CrmTime.getPrefix("T") + " " +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0,...

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