If you use spreadsheets to help staff or team members collect/collate data for database entries, yes I know it’s bad but sadly everyone I know still deals with this somewhere in their workflow when managing websites for clients. Then this trick will vastly improve your productivity when creating said data entry spreadsheets or importing the data to your MySQL tables.
This works in Google Sheets, not Microsoft Excel, because Microsoft Excel is horrible and anyone who isn’t using cloud based office tools is crazy. This snippet will simply auto increment a field, typically you want this to be your “id” field as data is entered into rows in your sheet.
As data is entered in the row and more importantly the next row, this little function will increment the corresponding rows id field automatically. This will make it much much easier to import into MySQL via an import event.
If you hate the clutter and inelegance of the latest iteration of gmail in 2018, than you are not alone, I’m not much of a fan either.
Personally the one thing I truly could not abide in the new gmail was what are known as “attachment chips” which will appear under the subject of every single email that contains attachments, no thanks. I could not find a good reason for these to be filling up half of the screen space in my inbox, so I went looking for a way of turning them off.
If you don’t know what attachment icons or attachment chips are, see the following photos. If you do know what they are and want to get rid of them like me and turn them off, just follow the instructions that are coming up next, super easy, barely an inconvenience.
Ran into this little problem the other day when using someone else’s specific syntax. Returning a complex object using a notation that puts objects brackets onto new lines was throwing an error. I sat there staring at it for maybe like 20 minutes wondering what the hell I’d been drinking recently and why I couldn’t trace the error.
Turns out it was a very simple syntax pit fall I hadn’t come across before, because I’m a Person A in the example below with regards to formatting my scripts.
// Person A's format
function() {
// function bracket on same line as declaration
}
// Person B's format
function()
{
// function bracket on new line
}
You can argue which is better all you want but likely you will run into both forms as a developer, both have their merits, and neither saves compile time.
So if you are a person B or just forced to use that format when defining objects, there is a catch you should know about.
I will keep this post very short and sweet.
You can easily remove file extensions, in this case ‘.php’ from your urls, so that your urls are easy to remember, provide top SEO results and value, look pretty without file extensions, represent your architecture and are easy to change or redirect?
Pretty urls with no .php extension
{code type=html}
www.mysite.com/subsection/
www.mysite.com/subsection/page
{/code}
Ugly urls with extensions
{code type=html}
www.mysite.com/subsection/index.php
www.mysite.com/subsection/page.php
{/code}
If like me you are a bit of perfectionist when it comes to your web-sites and their SEO value, then you may eventually run into this problem.
You have gone to the effort of creating a nice .htaccess file for apache which removes the extensions of your webpages so you get nice pretty urls like
Pretty urls example
{code type=html}
www.mysite.com/subsection/
www.mysite.com/subsection/page
www.mysite.com/subsection/index.php
www.mysite.com/subsection/page.php
{/code}
See this post on how to create those pretty urls above
How to make pretty seo urls via .htaccess
You may also have installed WordPress or may be using it the way I do via an include header
The Problem
{code type=php}
define(‘WP_USE_THEMES’, false);
require($_SERVER[‘DOCUMENT_ROOT’] . ‘/blog/wp-blog-header.php’);
{/code}
Then one day you spidered your own site to make sure Google could index you correctly, all of a sudden you may have been surprised to find all your pretty urls, returning nasty 404 page not found errors in the header of your requests, even though you can browse to them and there are no apparent connection issues.
Well guess what is happening?
