Showing entries 31 to 40 of 974
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: database (reset)
MySQL Metadata Queries – Find all tables in a Schema

Of course, there are other ways to determine what tables are present in a particular MySQL Database or Schema. You can also find this information if your database user account has permissions for the INFORMATION_SCHEMA database. Continue reading and follow along with an example query…

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 Clker-Free-Vector-Images from  …

[Read more]
OpenLampTech issue #42 – Substack Repost

Welcome to this week’s OpenLampTech newsletter, the newsletter for MySQL and PHP developers. There is always something to learn and share from all the curated sources out there and OpenLampTech has the MySQL, PHP, and LAMP Stack content covered. Thank you 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 #42 we have articles covering:

  • Custom validation rules in Laravel
  • MySQL time-saving Date functions
  • PHP clean code tricks
  • Web scraping with PHP
[Read more]
OpenLampTech issue #41 – Substack Repost

We have another packed issue of OpenLampTech, the newsletter for MySQL and PHP developers, this week. I’m glad to have you here. Thank you!

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

  • Is MySQL COUNT(*) slow?
  • Symfony Twig UX components
  • WordPress vs Drupal
  • Top PHP testing tools
  • And much much more…

Want Friday’s newsletter delivered to your inbox? Great!

Head over to the …

[Read more]
MySQL WHERE Clause Conditional With Numeric Data

We know that when filtering text data in a MySQL WHERE clause conditional, strings are placed in single quotes. In this blog post, learn how to filter numeric data in a MySQL WHERE clause conditional…

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 Gerd Altmann from Pixabay 

[Read more]
OpenLampTech issue #40 – Substack Repost

The OpenLampTech publication is entering its 9th month of publishing and I have you to thank. OpenLampTech continues to grow. Thank you! We have several great articles this week. Enjoy and share 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 #40 we have articles covering:

  • The SQL NULL
  • Custom helper functions in CodeIgniter 4
  • PHP built-in web server
  • MySQL command line
  • And much much more

Be sure and head over to the …

[Read more]
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]
Showing entries 31 to 40 of 974
« 10 Newer Entries | 10 Older Entries »