My latest mini-side project is a Chrome Extension that adds two additional methods to search: one via the search bar and one in the right click menu.

Similar to my “Search Funnel” Chrome Extension (also an app for Android and iOS), this saves you the step of visiting the website…

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. …

Screen recording above is in slow motion to demonstrate the concept

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:


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.

Final output of what we’ll be making

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… is a service that can keep track of a company’s cellular activities (ex. phone calls + text messages). I had some trouble connecting with their API using PHP; here’s the basis for how I finally accomplished it.

I wanted to use a database by Planet Scale, and I had some initial trouble setting it up on my Windows machine. Here’s how I got it up-and-running.

Planet Scale offers a database that- similar to Git- you can make changes in a “branch” and them push/deploy it to a…

Many applications require a user to log in. A friend was trying to implement his version, and was concerned how to decrypt the password stored in the database. Below was my advice.

Take the password that the user entered and concatenate it with a standard string (unique to your app…

Steve Sohcot

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store