Showing entries 1 to 10 of 232
10 Older Entries »
Displaying posts with tag: code (reset)
OpenLampTech issue #60 – Substack Repost

Thank you so much for reading OpenLampTech and making it the success it is today. Wow! 600 developers reading each week! I am humbled to say the very least.

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

  • Laravel Eloquent and Query Builder tips
  • Drupal’s updated CKEditor 5
  • How Symfony powers Drupal
  • Best SQL Editors
  • WooCommerce Payment Gateways
  • And much more

Want to help OpenLampTech be a success …

[Read more]
CodeIgniter 4 Database Features Overview in 2022 – Substack Repost

CodeIgniter 4 is a solid, well-designed PHP framework and one I enjoy using and exploring every chance I get. In 2022, the CodeIgniter 4 team released many database-related upgrades. Learn more about the ones I found most significant in this OpenLampTech 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.

Head over to the OpenLampTech publication page and read more on this CodeIgniter 4 piece.

Want to support the OpenLampTech publication? …

[Read more]
OpenLampTech issue #54 – Substack Repost

We have another packed issue of OpenLampTech for you this week. And, we have our first sponsor with a smashing deal to help you configure your MySQL servers with ease. Thank you Releem for partnering with OpenLampTech this week!

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

  • SQL Wildcards
  • PHP Magic Methods Explained
  • Managing CSS in WordPress block themes
  • WordPress as a Twitter alternative?
  • And much much more

[Read more]
OpenLampTech issue #13

This week’s issue of OpenLampTech, the newsletter for PHP/MySQL developers is once again loaded to the brim with the best content I can curate for your reading pleasure. I absolutely enjoy running and sharing the newsletter and I hope you are enjoying the content just as much. Thank you!!!!

Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.

Tell me more!

Image by  …

[Read more]
OpenLampTech issue #11 – MySQL LAG()

Wow! Eleven issues so far! Are you ready for your weekly source of original and curated PHP/MySQL content? Ready to learn and grow as a backend developer? Well, you are in luck because OpenLampTech, the newsletter for PHP/MySQL developers, is out and ready for you. Dig in!!!

Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.

Tell me more!

Image by  …

[Read more]
OpenLamp.tech Issue #2

Hey friends over the weekend (Friday actually) I’ve published another issue of my weekly newsletter, OpenLamp.tech. Continue reading for more information…

This issue is full of great curated reads as well as a specific question I’ve asked readers and the community. Looking for some suggestions on planned migrations for upgrades to my WordPress site.

The Newsletter for PHP and MySQL Developers

In this weeks newsletter, there’s information on:

Here’s the full issue for you to read. You can always subscribe (it’s free) and have the weekly issue of OpenLamp.tech delivered directly to your inbox. Just think, no more waiting for me to post it here each Monday.

Visit the sign-up form below to …

[Read more]
Free Medium Series – CodeIgniter 4 CRUD with MySQL

Generally, most all web applications are going to follow the elements of CRUD: Create, Read, Update, and Delete. CodeIgniter 4 is a powerful PHP web development framework that provides a rapid development environment. The CodeIgniter 4 Models come enriched with built-in CRUD functionality, which is covered in this compilation of Medium posts…

Image by Dariusz Sankowski from Pixabay 

Disclaimer: I originally published these articles first over on …

[Read more]
CSV – SQL Import/Export Compilation

CSV or SQL? SQL or CSV? How about together? Without a doubt, CSV’s are one of the most common and familiar data interchange formats. Importing and exporting CSV data into or out of an SQL database is a staple process in most every data workflow. I’ve written numerous blog posts on both importing and exporting CSV data in an SQL environment. In this post, I am including all of these specific posts (as of the time of writing) in one easy-to-read and centralized location…

Image by xresch from  …

[Read more]
How to Retrieve MySQL Last Insert ID in CodeIgniter 4

I use CodeIgniter 4 a great deal for learning, personal projects, and application development. In this post, I cover 2 different methods you can use and retrieve the MySQL Last Insert ID value after executing an INSERT statement in CodeIgniter. Continue reading for more information…

Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

Model Setup

Starting out, I use the CLI Generator feature and create a Model by executing this code in the terminal in the project root:

php spark make:model user --suffix

I have removed much of the …

[Read more]
MySQL Table DDL file with phpMyAdmin

If you need a structure only .sql file of a MySQL tables’ Data Definition Language (DDL), phpMyAdmin makes this super-easy with just a few clicks. Continue reading and learn how…

Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

Why use a DDL file?

Why would you need a structure-only .sql DDL file anyway?

Maybe you want to build out a tables’ structure on another server to bring in different data or something comparable, and want it void of any existing data.

Rather than creating the …

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