OpenLampTech

Share this post

OpenLampTech issue #17

openlamptech.substack.com

OpenLampTech issue #17

PHP constructors; WP comments; Linux one-liners; Laravel Origins; SQL foreign keys; PHP dependency injection

Joshua Otwell
Mar 11, 2022
Share this post

OpenLampTech issue #17

openlamptech.substack.com

Hey glad to have you here! 👍

If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:

Thank you for reading OpenLampTech! Subscribe (it’s free) and receive new posts by email, be part of a great community, and support my work.


Recently from the Digital Owl’s Prose blog

I wholeheartedly believe in repurposing content. Especially if you create a ton of it like me! I reposted an article I first published on my Medium account this week on the Digital Owl’s Prose blog. Check out: MySQL NULL value transformation with COALESCE() - Medium repost


You have to get those wins in where you can. I published a book recommendation article here on the OpenLampTech publication page and the author gave me this shout-out on Twitter.

Woot woot!

Twitter avatar for @billkarwin
Bill Karwin @billkarwin
@j2112o wrote this sweet recommendation for my book!
openlamptech.substack.comBook Recommendation - SQL AntipatternsFind out why SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin is one of my favorite SQL books...
5:32 PM ∙ Mar 5, 2022

Read the article here if you haven’t read it yet.

OpenLampTech
Book Recommendation - SQL Antipatterns
In this book recommendation, I’m sharing my thoughts on one of my favorite SQL books for developers, SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin. I’m labeling this article a book recommendation instead of a book review because a book review would indicate that I have…
Read more
a year ago · Joshua Otwell

I have curated some fantastic reads for you this week. Let’s get to them!

This Week’s Picks

✔️ PHP Constructors Explained

By: Alex Web Develop

#php

Get back to the fundamentals with this article on PHP constructors, learning about:

  • what a constructor is

  • how to use a constructor

  • why use a constructor

  • how to invoke a parent class constructor (if the class is extending another class)

We also learn about a new PHP 8 feature called constructor promotion. With constructor promotion, you can set a class properties' visibility modifier in the constructor itself.

Some friendly advice; the Alex Web Develop website, and newsletter have some excellent content on PHP and I highly recommend getting aquatinted with them both...

➡️ Read this post…

✔️ Websites to learn REST API development with CodeIgniter 4

By: Mario M.

#php #codeigniter

Holy smokes!

Wow!

This is the resource I have been needing. I want to up my API programming skills, knowledge, and understanding some kinda bad. Plus, since I like CodeIgniter 4, this is perfect.

I discovered this list of website articles for Rest API development with CodeIgniter 4 on LinkedIn and had to share it in this OpenLampTech issue.

➡️ Read this post…

✔️ Akismet: The WordPress Comment System Explained: All You Need to Know

By: Simon Keating

#wordpress

We don't much think about the comments section of a WordPress site but, comments are the lifeblood of a site. Comments allow engagement and foster community for a website's audience.

In this post, learn how to access and moderate comments in WordPress. From notifications to clean-up, all of the settings and some best practices are covered.

➡️ Read this post…

✔️ 25 Awesome Linux Command One-Liners

By: Kesk-*-

#linux

I'm an avid Linux user and have used it as my personal driver since 2013. I don't typically search for articles like this (although I probably should) but I happened upon this one and have to bookmark it. 🔖

I wanted to pick 3 of my favorites from this list but couldn't because I like them all. Tell me in the comments which are your 3 favorites

➡️ Read this post…


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 my premium MySQL blog posts and content as I develop and release them, in addition to an actionable MySQL tip each week.

Tell me more!


✔️ This is How I Explained Foreign Keys in SQL to Wizards of Hogwarts

By: TechToFreedom

#mysql

This explanation pretty much tops all the others I've read on the FOREIGN KEY concept. Has a quality entertaining flare but, at the same time, covers the topic well.

I definitely have to locate more material like this... 🙂

➡️ Read this post…

✔️ What Is Dependency Injection in PHP and How You Can Use It to Write Better Code

By: Tomasz Dobrowolski

#php

Dependency Injection (DI) is one of those areas in development I'm still working on understanding and using more in my code.

In this post, the author shares a simple example of DI with an Order and a Payment class.

One of my key takeaways from this article is that DI makes the code reusable, which is enough in itself to make me want to learn more.

➡️ Read this post…

✔️ Laravel Origins: The Documentary

By: OfferZen Origins

#php #laravwl

While I'm not a Laravel developer (yet) I had to include this documentary video I watched on YouTube. It is so interesting to learn about the individual behind one of the most popular and dominant web frameworks ever along with the following of developers who are drawn to it.

Such a good video.

➡️ Watch the video…


⭐⭐⭐ Many of the posts I curate and share in this newsletter, I read and enjoyed on Medium. If you are not yet and member and wish to join the platform, I would be more than grateful if you would use my sign-up link. At no extra cost to you, I will receive a small portion of your membership fee when you sign up. Thank you! 🙏


Support OpenLampTech, my blog, and my work with a coffee if you would like.☕


Newsletter Shoutout 📣

The Saturday Solopreneur



Extra stuff…

  • What Is Oracle's Identity Column

  • 17 Link Building Strategies for Startups and Developers

  • The Ultimate Online Writing Republishing Framework

  • 7 Twitter Templates To Use If You Don’t Know What To Tweet

  • The Ultimate List of Developer Podcasts


Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!

Share


“Reply” or comment and let me know what you think of this issue of OpenLampTech.

What do you want to see more of?!?

What do you want to see less of?!?

I’d love to know!

Also, share with me links to your published blogs and articles so that I can read them and possibly include them here in the newsletter!


Thank you for reading. I hope you have a great rest of your week.

Take care.

Joshua Otwell

Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.

Share OpenLampTech


How can I help you?
  • Are you thinking of starting up a blog? I use WordPress for my blog, Digital Owl’s Prose. Let’s both save money on the plans offered. 💸

  • Grab a Gmail HTML Email Signature template from my Etsy shop and make your emails pop and stand out. ✉️

  • Need hosting for your next web application or WordPress site? I use and highly recommend Hostinger. They have great pricing and service.

  • I enjoy reading Refind: The essence of the web, every morning in your inbox. Subscribe for free. Help me get a premium subscription by signing up yourself with my referral link.

  • Grab a free pack of mobile Creator wallpapers with my referral link.

  • Just getting started or wanting to learn MySQL? Find out about my premium blog posts and MySQL Beginner Series here.


Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰

Tip Jar

Disclosure: Some of the services and products links in this email are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.

Cover photo credits: Image by Clker-Free-Vector-Images from Pixabay

Share this post

OpenLampTech issue #17

openlamptech.substack.com
Comments
TopNewCommunity

No posts

Ready for more?

© 2023 Joshua Otwell
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing