Showing entries 21 to 30 of 974
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: database (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 #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]
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]
OpenLampTech issue #36 – Substack Repost

Hey hey, OpenLampTech is back this week with another packed issue of the best MySQL, PHP, and LAMP stack content I am sharing from the web. Enjoy!

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 #36, we are looking at articles covering:

  • PHP == vs === comparison operators
  • MySQL ALTER TABLE
  • Installing WordPress in a subdirectory.
  • Why developers prefer Linux
  • Getting your website ready to win
  • And much much more

Get your brand, product, or service the attention it needs …

[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 #33 – Substack Repost

The publication is growing and we are sharing the good stuff in this OpenLampTech newsletter issue. Developer interviews, a curated WordPress resource, and the LAMP stack coverage you expect are all coming at ya in issue #33…

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 #33, we have great content covering:

  • Symfony components
  • Is SQL Programming?
  • WordPress FSE vs dynamic templating
  • CakePHP CRUD
  • Linux command-line practice articles
  • And, much much more…
[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]
MySQL Query from JSON

One of my students asked how you could get JSON data out in tabular format. I said they should look at Øystein Grøvlen’s JSON_TABLE – Best of Both Worlds blog post from 2018. Unfortunately, the student wanted another example with the Video Store model that we use in class.

For clarity, all path definitions start with a $ followed by other selectors:

  • A period followed by a name, such as $.website
  • [N] where N is the position in a zero-indexed array
  • The .[*] wildcard evaluates all members of an object
  • The [*] wildcard evaluates all members of an array
  • The prefix and suffix wildcard, **, evaluates to all paths that begin with the named prefix and end with the named suffix

So, here’s a quick supplement to what’s already there. It assumes you created an …

[Read more]
Showing entries 21 to 30 of 974
« 10 Newer Entries | 10 Older Entries »