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…

When you Google something, there are probably millions of results. But they don’t display all of them at once. Pagination is the term web developers use to show only some of the results within a dataset You’re showing only some results, then there will be an option for “go to…

I recently bought a new keyboard, but immediately had to replace it. It worked, but it slowed down my typing. Why Did I Need a New Keyboard? I use my keyboard a lot. In addition to my “day job,” my hobby is making websites/apps. Every few years, part of the keyboard stops working. This time time in…

I entered some data into a database table in the format of: [some text] [space] [hyphen] [space] [some more text] Here’s an example: