MySQL UPDATE from a SELECT WHERE query
How to do a MySQL table UPDATE from a SELECT WHERE query. A handy command which uses JOIN inside an UPDATE. This command will update the status table and set…
Tag: MYSQL
Full install & setup of Apache, PHP 8, MySQL and SSL on Ubuntu 20.04
Installing and setting up a LAMP stack on Ubuntu 20.04 x64. This post covers installing Apache with the brand new PHP 8, a MySQL server and finally enabling SSL with…
Difference between Primary key and Unique key; MySQL
The differences between two very common MySQL keys which is the Primary key compared to the Unique key. Primary key Identifies a unique row in the table, as a default…
Installing XAMPP and HeidiSQL; A lamp stack for Windows
This post is a guide for installing and setting up a lamp stack on Windows. Thus making it a wamp stack. Windows, Apache, MySQL & PHP. Having a local webserver…
DataTables example with PHP and PDO MySQL
DataTables is an advanced table plugin for jQuery which easily brings features like pagination, searching and ordering for many data sources. This post is showing how to use DataTables with…
HTML MySQL Table edit with no page reloading via Ajax
An example of updating or editing an HTML table from MySQL data without reloading or changing pages thanks to Jquery and Ajax. The Ajax requests are done API style to…
Displaying data from MySQL without a page reload using Ajax
Displaying data from MySQL without reloading the page can be done with an on-click event which does an Ajax request that then fills elements with the returned data. This is…
The simple PHP PDO MySQL fetch (SELECT) types
The basics for PHP MySQL PDO fetch types, whether it be returning just one row, one column or looping through a full table SELECT call. The common 3 fetch types:…
The MySQL soundex function; Selecting names
Soundex is the algorithm for indexing names by sound or as pronounced. The MySQL SOUNDEX() function returns a Soundex string from a string supplied. It can also be used to…
HTML form input auto complete with PHP and MySQL
How to Autofill or auto-complete an HTML input form using JQuery with PHP and MySQL. This method uses LIKE in a MySQL query for the typed in characters and returns…