TRENDING:

Upgrade: Security Notice: Adobe Sign is ending support ...
Example: CSS Between Media Query
VueJS/Laravel Address Book app
Quickly back up a MySQL or MariaDB table
Freelance web developer in Preston
  • Home
  • Web applications
  • Web design
  • Contact
  • LinkedIn
  • GitHub
  • Prices

Select Page

Month: November 2018

MySQL Enum field not ordering correctly

Posted by wp.edmunds | Nov 20, 2018 | MySQL - MariaDB |

Thats because: It will order in the order the enum values are defined at table level – not the actual varchar/int/etc value. Fix: SELECT CAST(a.enumfield AS CHAR(255)) AS enumfield, a.* FROM `mytable` a ORDER BY...

Read More

PHP: Always redirect to the non-www and https version of the current page

Posted by wp.edmunds | Nov 16, 2018 | Hosting/Servers, PHP, Webmaster |

<?php if(empty($_SERVER[‘HTTPS’]) || $_SERVER[‘HTTPS’] == “off”){ //check for non secure connections $redirect = ‘https://’ . str_replace(‘www.’, ”,...

Read More

Recent Posts

  • Fix: Authorize.net / Omnipay – “The ‘AnetApi/xml/v1/schema/AnetApiSchema.xsd:customerProfileId’ element is invalid”
  • Yii 1.1 MySql error 1364 Field doesn’t have a default value fix
  • Creating a Filemaker server demo signup process
  • Portfolio: Brochure website for software company
  • Portfolio: Creative writers platform + CMS

Categories

  • API
  • CSS/Design
  • Education
  • Filemaker
  • Front end
  • Hosting/Servers
  • Laravel
  • MySQL – MariaDB
  • PHP
  • Portfolio
  • React
  • Symfony
  • Uncategorized
  • Vue
  • Webmaster

Pages

  • Home
  • Web applications
  • Web design
  • Contact
  • LinkedIn
  • GitHub
  • Prices

Archives

  • September 2020
  • June 2020
  • February 2020
  • October 2019
  • July 2019
  • June 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • September 2018

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Designed by Elegant Themes | Powered by WordPress