Fixing PHP OPcache mysql_xdevapi Uncaught Error: Call to a member function limit()
I have Been playing with the X DevApi on MySQL 8. It’s really cool idea and I think I will need to write up about it in the near future. Anyway check it out on PHP Docs, https://www.php.net/manual/en/book.mysql-xdevapi.php and on the MySQL site https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-introduction.html.
Fixing PHP OPcache mysql_xdevapi Uncaught Error: Call to a member function limit()
I have Been playing with the X DevApi on MySQL 8. It’s really cool idea and I think I will need to write up about it in the near future. Anyway check it out on PHP Docs, https://www.php.net/manual/en/book.mysql-xdevapi.php and on the MySQL site https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-introduction.html.
View Post
Setting Up A Testing Environment For PHP Using VirtualBox - Part 4 Installing MySQL
Now we have installed Nginx the next part before we compile and install PHP is to install and configure MySQL. So let’s get to it.
View Post
Setting Up A Testing Environment For PHP Using VirtualBox - Part 3 Installing Nginx
Now we have got our server install it’s time to install Nginx. This is pretty straight forward and I have covered it before but for this series I thought I would make sure I cover this simply.
View Post
Filtering HTML in Zend Framework Using HTML Purifier
If you have forms where you allow users to submit HTML content you will want to filter that so you can be sure that no malicious code gets through, some WYSIWYG editors do this but not all but still as we are paranoid backend developers we don’t trust any input submitted by users.
View Post
Nginx: Using Regex to Configure Dynamic Location Blocks
I love Nginx as a webserver, it’s quick and easy to configure (if you know what you are doing). As a web developer (or should I say programmer), I like to make things as easy as possible in my development environment. As my projects have increased over time I have noticed my Nginx config growing to accommodate each project.
View Post
Gigabyte Brix BXBT-1900 Not Booting without Monitor on Ubuntu Minimal 16.04
I love my Gigabyte Brix BXBT-1900, I have been running it as a headless server since March 2016 and had no problems with it I originally put Ubuntu 14.04 LTS and got to going quite easily. When Ubuntu 16.04 LTS I did an in situ update to Ubuntu 16.04 for which my MySQL keep breaking when Ubuntu kept adding updates for it, I have posted on this before http://www.shaunfreeman.name/ubuntu-16-04-mysql-update-fails/.
View Post
Setting Up A Testing Environment For PHP Using VirtualBox - Part 2 Installing Ubuntu 16.04
In this second part of this tutorial I will show you how to install Ubuntu Server on your virtual machine in VirtualBox. You can take these principles and apply them to a physical machine but if you purchase a cloud instance you normally have all this done for you, so really this is good to know for our testing purposes.
View Post
Setting Up A Testing Environment For PHP Using VirtualBox - Part 1 Installing VirtualBox
In this tutorial I will show you how to download and install VirtualBox for your development environment. This is a software virtualisation package which we install on our computer, and through VirtualBox we can then install other operating systems and run them ‘natively’. So we can run a Linux server on a Windows machine. We do this for a few reasons:
View Post
How to Install MySQL or MariaDB on CentOS 7
As of CentOS 7 the default database is MariaDB and a drop in replacement for MySQL and should be fine for most people but if you need MySQL, there are some features in MySQL and not in MariaDB and vice versa.
View Post
Ubuntu 16.04 mysql update fails
We all been there when an update fails but with an LTS server version you would think this would be something the Ubuntu team would fix quickly. Problem:
View Post