Showing entries 21 to 30 of 125
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Technical Writing (reset)
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]
Find All Table’s Current AUTO_INCREMENT Value

I recently wanted to check all tables’ current AUTO_INCREMENT value (if any) for a database dump structure. I wasn’t sure if a tables’ Data Definition Language (DDL) statement contained the current AUTO_INCREMENT value or not. So after I loaded the dump file, I learned of a query to use and find out…

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  …

[Read more]
OpenLampTech issue #31 – Substack Repost

I could barely stuff this week’s OpenLampTech issue #31 into the email client to send out. It is that full!

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 this week’s OpenLampTech issue #31, we are covering articles on:

  • Drupal PWAs
  • What is a WordPress Developer?
  • PHP OOP concepts and definitions
  • WordPress contact form plugin
  • 7 pieces of Linux advice
  • And much, much more.

Original and curated content. PHP, MySQL, and the LAMP stack. All in one place. Every week. …

[Read more]
MySQL WHERE Clause Equality Comparison Operator

We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…

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 kalhh from  …

[Read more]
MySQL DATE() Function with examples

The MySQL DATE() function is a built-in function you use to extract just the date portion from a DATE or DATETIME value. Learn how to use the DATE() function in this blog post…

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 MaeM from Pixabay

MySQL DATE() Function Syntax

The …

[Read more]
Range-based Filtering With the BETWEEN Operator in MySQL

This post covers filtering in the WHERE clause conditional using the MySQL BETWEEN operator. Continue reading this excerpt of premium MySQL content I’m creating for anyone to learn how to use MySQL…

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.

Suggested Reading

Visit any of these MySQL beginner-friendly articles for additional free learning resources:

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