Assuming joel is required, the following 656 results were found.
-
Strip HTML in MySQLhttps://joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html
Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
F_ck You. Pay Me.https://joellipman.com/articles/cms/website-development/fck-you-pay-me.html
To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco,...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
So I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Just a pretty picture on how hackers have created an infographic of the internet: Source: BitBucket.Org - Internet Census 2012
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
CSS Fieldsethttps://joellipman.com/articles/cms/website-development/css/css-fieldset.html
Add horizontal space between label and fieldset fieldset label.inline { display: inline-block; margin-left: 2em; } Change color of fieldset grouping line fieldset { border: 2px ridge #7abcff; }
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
Applies to: CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser,...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
Why? So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
Why? This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
The Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Quick tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
So I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *