Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 echo "Stored in: " . "" . $_FILES["uploaded_file"]["name"]; chmod("" . $_FILES["uploaded_file"]["name"], 0755); } Obviously replace with your full path (eg. /var/www/html/images). My Full Snippet This is the code on the receiving PHP file: /** STUFF FOR...

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

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

25 September 2009 and I am blowing past that quickly with just 1 person (me!) on the site so they just refuse the connnection after a while. Obviously something is not right. I am searching the forums for an answer and if I don't find one I'll repost. I just thought I'd...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 date => sort by date added (most recent or oldest first) hits => sort by hits (number of times clicked on) published => obviously by whether they're published or not... no idea why u would checked_out => sort by checked out (will either display or not...

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the following code...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99). In hindsight, the Ebay one was obviously going to fail (faking the disk size). I got badgered by my colleagues to splash out and get a worthwhile pen. Aside from some...

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

Change the login link in MediaWikihttps://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 Think this is because that module is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior to the module being displayed.

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

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

11 January 2011 1 Welcome This is HP 2 Copyright This site and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT...

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

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

06 April 2011 -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row as an example,...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 Revamp? Signed Off Specification (describing clearly the agreed work to do and expected results) Realistic Cost & Time (obviously agreed with client) Additional Documentation (timesheets, agreements, technical specifications, issue logs, product...

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

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

28 April 2011 a template designed by a 3rd-party company. Received the zip and uploaded it to their homepage. The 3rd-party company had obviously designed the template to work in one browser only: Internet Explorer version 7. The marketing web-gurus were simply using...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 to gets its value based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available Values – Specify values" to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 I will in future. Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 first 100 lines - change this to the number of lines or greater in your file) original_file.txt is your original file (obviously change the name to your file) temp.txt is just a dummy file which should be empty for clarity results_file.txt is the...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 I've called it ajax.form.php and the contents of which are: This just prints back an array of data that was sent to it; obviously you may want to tidy this up but the more basic the receiving data the better. In my example, I'm returning some HTML but...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 not yet available D300 2 Data Not Yet Available D300 3 data not yet available D300 4 Daat oNt EYt Avialable D300 This is obviously a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the same values, so I should go through the database and change all variations to be typed the same way in the same case....

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 long the SQL query would take to recover the data and present it in a report, which would average about 0.4 seconds. We're obviously not interested in shaving off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 deletions should be accompanied by reset of auto-increment -- eg. ALTER TABLE `v34_content` AUTO_INCREMENT = 1 JComments Obviously only do this if you have jComments installed. If I ever get a task to migrate a website with K2, I'll update this article....

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

CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *