I previously wrote a tutorial on creating a simple PHP Contact form; this is Part 2 of 2 where I go over some more advanced techniques. Issue: Who is the email from? So far we can send an email, but it comes “from” whatever the default configuration was set up as. By this, I mean that…

This is a basic tutorial will show you how to create a Contact Form for your website that will send you an email. This is commonly used to collect feedback from users without them having to open their email client manually to send you an email. …

Using a sequence of keyboard shortcuts to copy a formula across multiple rows/columns in Excel- instead of a mouse- is the greatest time saver I have. My most common use-case is when I have a formula at the top right of my data that I need to paste it downwards…

You can get the last cell in Excel using the following line of VBA code: ActiveCell.SpecialCells(xlLastCell).Select However if your dataset was modified (specifically, if you deleted rows), then doing that won’t get the right value. It’ll return what the value was before the data was modified. Instead, I use the…

When I was first starting to write PHP, most tutorials I found placed the HTML output inside of the PHP. It’ll have an entire block of code that is only PHP, and it prints out HTML (and CSS and JavaScript for that matter). There’s a better way though. Take a…

A best practice in how to organize your PHP files. A friend of mine needed a PHP template, where he can easily modularize different parts of this site. By this, I mean he’d have a separate file for the “navigation” and he can just include that file in his code…

I have a dataset that I needed to compare “current month” against the average of the past three months. In this specific case, I wanted to compare February 2023 vs the average of November 2022 + December 2022 + January 2023. First I wanted to dynamically find the latest date…

I’ve heard about the COALESCE() function, but never had a use for it. As defined by W3 Schools: The COALESCE() function returns the first non-null value in a list. I recently had a situation where it was needed. Why Use COALESCE() ? Let’s assume I have the following dataset of “Points Per Employee,” which…

Maybe my Google searching skills aren’t as good as I thought; I had trouble finding this exact solution! As indicated by the headline, these were my objectives: Allow the user to upload a CSV file to a MySQL database, with PHP. Bonus points for Ajax. The number of columns are…