Showing entries 1 to 10 of 110
10 Older Entries »
Displaying posts with tag: Technical Writing (reset)
Filter Data in the MySQL WHERE Clause With Less Than and Greater Than Comparisons

While equality and inequality filter conditions are very common, many times you wish to filter the FROM clause table rows based on values that are less than or greater than another value. MySQL (and SQL in general) supports the less than (<) and greater than (>) operators. Continue reading and see examples of each…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Image by 준원 서 from  …

[Read more]
OpenLampTech issue #39 – Substack Repost

Welcome back to another issue of OpenLampTech, your source for original and curated MySQL, PHP, and LAMP stack content. We have another packed issue this week. Thanks for reading!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #39 we are looking at articles covering:

  • PHP traits
  • MySQL indexes
  • Fetching data with Laravel and AJAX
  • PHP local development tools
  • And much much more.

Get OpenLampTech delivered to your inbox absolutely free with a …

[Read more]
OpenLampTech issue #38 – Substack Repost

We have another massive newsletter for you this week. And OpenLampTech is growing! Thank you for making it a success!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

This week in OpenLampTech issue #38, we have content covering:

  • MySQL Indexes
  • PHP boolean comparisons
  • Yoda Conditions
  • Installing WordPress on LAMP
  • And much more

Get your brand, product, or service the attention it needs with affordable classified ad placement in …

[Read more]
MySQL WHERE Clause Inequality Comparison Operators

Just as you want to filter the rows of data returned in a SELECT query with the equality comparison operator (=), you can also create a conditional filter to test if 2 values are not equal to one another. Learn more in the following article.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Image by Peggy und Marco Lachmann-Anke from  …

[Read more]
OpenLampTech issue #37 – Substack Repost

We are moving right along with the OpenLampTech publication. This week’s issue has a great developer interview, in addition to all the curated MySQL, PHP, and LAMP stack content you’ve come to expect. Let’s get to it. Enjoy OpenLampTech issue #37!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #37, I’m sharing articles on:

  • MySQL Generated Columns
  • PHP solutions to common problems
  • Interview with freelance Laravel web developer Ash Allen
  • PHP cURL library article
[Read more]
CodeIgniter 4 Query Parameter Binding with examples in MySQL

As powerful and useful as the CodeIgniter 4 Query Builder class methods and functions are, there are times when you need to hand-craft your own queries. Perhaps they are complex. Or, you would just rather write the raw SQL. Learn how to safely use the input you need – typically as part of the WHERE clause conditional(s) – using 2 different parameter binding variations with examples in MySQL.

Image by Clker-Free-Vector-Images from Pixabay

[Read more]
What is the LAMP stack? OpenLampTech Repost

Built on time-tested open-source software, the LAMP stack is a popular choice in modern Web Development. Continue reading this OpenLampTech publication report…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

What is the LAMP stack?

The LAMP stack is a well-established combination of 4 pieces of software that form one of the most robust web application architecture stacks.

LAMP is actually an acronym created from the 1st letter of the name of each of the 4 components it is built from:

  1. Linux – The operating system. …
[Read more]
OpenLampTech issue #34 – Substack Repost

These OpenLampTech newsletter editions are some of my favorite to read and I know they are for you as well. We have another packed issue for you this week so enjoy those articles you like most and please share the publication with others…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #34, we have curated content covering:

  • WP-CLI
  • Is Drupal a shark?
  • MySQL backslashes
  • WordPress vs Laravel
  • CodeIgniter 4 CRUD App
  • And much much more

Head over to the …

[Read more]
MySQL SELECT and WHERE Clause Column Existence

I’m sharing another tip for anyone who wants to learn more about MySQL and how to use it. This post covers an example of the differences in columns specified in the WHERE clause but not the SELECT clause and vice-versa.

Image by Drizzt_Do_Urden from Pixabay 

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the …

[Read more]
OpenLampTech issue #32 – Substack Repost

There is a whole lot of great PHP, MySQL, and LAMP-stack content in this week’s OpenLampTech newsletter. But, would you expect any less? Me neither. Enjoy this edition and share with others. Thank you for being a dedicated reader!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Get your brand, product, or service the attention it needs with affordable classified ad placement in the OpenLampTech newsletter. Thank you for your support!

There is most definitely something for everyone in …

[Read more]
Showing entries 1 to 10 of 110
10 Older Entries »