Order SQL results by the MONTH part of the DATE
I needed to display a set of retrieved database results ordered by the MONTH part of the DATE so that the list would be in month order and not by the year. The results...
My Solar Panel Journey, Money Saving Tips, Website Design, DIY Projects and much more...
-
-
Less than 9 years – Solar PV pays for itself!
I knew that I would get a return from my investment in a Solar Panel System… Not only am I now helping the environment, I’m also making some money along the way…
-
500 Error with PDO Statement
I kept getting a 500 Error message after creating a new php script to process a form from a web page. The script was to process a set of instructions before inserting data in...
Use PHP to format date from MySQL
I needed to display a date correctly on a web page that was retrieved from a MySQL database. Although the date was inserted into the database with a British format of dd/mm/yyyy, it is...
A Solar PV Record for March 2020
When I said previously that ‘records are made to be broken’ back in 2018, I really did not expect many more from the ageing Sanyo 2kw PV solar system. It’s now some nine years...
On the Up with another good twelve-months Solar Yield
Following on from a very good 2018 and its breaking of two Solar Generation Records, I was very pleased with 2019’s yield 🙂 Although no records where broken this year, the 2kw system produced...
What to do with all the Windows 7 PCs
Windows 7 End Of Life (EOL) With the windows 7 end of life date looming ever so close what are we to do with all the equipment that’s either too old or to slow...
Stop Showing Index of /directory
Do you get an Index of your website directory files similar to below when something goes wrong? Maybe a spelling mistake / typo or in this case a directory without an index file.. I...
Excel – Paste just the subtotal values?
How can I paste just the subtotal values in Excel Do you need to copy the subtotal result values from Microsoft Excel? When you use the subtotal tool within Excel you often need to...
Two Records Broken – 2018 Solar Generation
Wow what can I say – Records are made to be broken! Another monthly solar record broken in 2018 🙂 This year so far I have seen several solar generation records from my UK...
Can’t remove http:// from string (unserialized key value)
Remove https:// or http:// from a $string using PHP I needed to remove the http:// part of a website address in order to display it correctly on a web page. Therefore I would like;...
PHP on page 301 redirect
I needed to redirect traffic from one page to another without using the .htaccess file. I also wanted to let any search engines know that may have indexed the file of its new location....
Free Electricity To Cut The Grass
Cutting the grass for free! When you have solar panels installed you can cut the grass for nothing or at least a lot less than if you didn’t have some of these electricity generating...
Recent Comments