PinnedPHP Contact Form Tutorial : Part 2 of 2I 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.Jan 20, 2019161Jan 20, 2019161
PinnedSimple PHP Contact Form Tutorial (Part 1 of 2)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…Jan 20, 20191092Jan 20, 20191092
PinnedThe most valuable trick I know in Excel: a faster way to copy formulasUsing keyboard shortcuts to copy a formula across multiple rows/columns in Excel- instead of a mouse- is the greatest time save I haveApr 26, 20204Apr 26, 20204
PinnedMy #1 Tip for PHP Programmers to Read and Write Code EasierRather than have a block of PHP code that prints out HTML, you can display the code *outside* of the PHP tags. This will make it easier toSep 26, 20202Sep 26, 20202
How to Parse Employee IDs Concatenated with Names Using SQLLearn how to use SQL to extract Employee IDs from fields where they’re concatenated with names in the format: “Employee Name (Employee…Dec 27, 20242Dec 27, 20242
How I Delayed the Loading Indicator in my Web App for a Better User ExperienceJavaScript code used to show a loading indicator for your web app only the user is waiting more than 2 seconds.Dec 20, 20242Dec 20, 20242
PHP Emails Not Sending On GoDaddy? Here’s How I Fixed It.Troubleshooting PHP Email Sending Issues on Shared HostingNov 8, 2024Nov 8, 2024
How I Resolved PHP Maximum Execution Time Error on GoDaddyI was running a PHP script using GoDaddy as the web host, and received the following error:Oct 3, 20241Oct 3, 20241
Trouble getting your site verified in Google Search Console?Struggling to verify your site in Google Search Console? Try this.Sep 13, 20241Sep 13, 20241
Elevate Your Pivot Tables: The Secret to Adding a Calculated Item in ExcelLearn how to add a calculated item in Excel pivot tables to create dynamic, custom columns like a Delta. Perfect for advanced Excel users!Sep 3, 202411Sep 3, 202411
Skip the Asterisk: Why SELECT * is Slowing Down Your SQL QueriesTLDR; Don’t do SELECT * FROM myTable in your query . Explicitly ask for the fields.Aug 11, 2024Aug 11, 2024
SQL to get the filename without an extensionSQL to get the filename, without an extensionJul 18, 2024Jul 18, 2024
How to input data into Google Sheets using PHP + JavaScriptTutorial and sample code on how to insert data into a Google Sheets document using PHP and JavaScriptJun 17, 20241Jun 17, 20241
SQL to generate “Create Table” statements for all tables given a schema in MS SQL ServerNot wanting to use the Import Wizard, I wanted to generate SQL that created my tables that would retain the keys.Jun 4, 20242Jun 4, 20242
SQL Date Issues? Try Removing The TimeDiscover how to resolve SQL date discrepancies by eliminating time components, ensuring accurate data queriesMay 9, 2024May 9, 2024
SQL Totals Using WITHROLLUP When There Is A NULL ValueUsing SQL “WITH ROLLUP” to create a Total, how to account for a NULL valueApr 27, 2024Apr 27, 2024
Using Chrome on a Desktop? Get Search Results Faster.Use this Chrome Extension to search the Internet in 3 steps, not the 4 you’re used to.Apr 13, 2024Apr 13, 2024
Writing PHP Code: After 10+ Years Using Sublime Text, I Changed To VS CodeI’ve been writing PHP Code with Sublime Text code for the past 10 years. Here’s why I transitioned to VS Code.Apr 5, 20241Apr 5, 20241
How to pad data with leading zeros in SQLI needed my value to be 8 characters long; and if it wasn’t that, the first few should be “0” until there were 8 characters.Mar 14, 2024Mar 14, 2024
Creating a Pivot Query with Dynamic Column Headers in SQL ServerI needed to create a pivot table in MS SQL Server with dynamic column headers.Mar 1, 2024Mar 1, 2024