Untitled @jonathanrcrump-blog - Tumblr Blog

Checklist for your new Shopify eCommerce website

Shopify is an awesome platform, which makes it very easy to start selling online.

But what else should you make sure you set-up?

The list below is some great tips to help get you started:

How to remove the “Powered by Shopify” text in your footer

Add your Google analytics code in the Shopify admin panel

Make sure your site is indexed in Google Search Console, and shows up in Google search results

View On WordPress

How to remove "Powered by Shopify" from the footer of your website.

How to remove “Powered by Shopify” from the footer of your website.

So you’ve launched your new site, everything looks good, but there in the footer is a little piece of text that makes is clear to your customers that you use Shopify.

Powered by Shopify

Not that it isn’t something to be proud of, Shopify is an awesome platform!

However to complete the customisation of your site you can remove that uneccessary text (and the link back to Shopify) if you so wish.

View On WordPress

#ecom #eCommerce #liquid #shopify

When to use the IN operator in your SQL WHERE statement

Sooner or later you will have to create a SQL statement with multiple WHERE conditions, usually AND and OR’s.

If you have three or more conditions your SQL can easily become difficult to read and difficult to understand the logic.

Your brain (and mine) can start to hurt as you wonder…

Are all those WHERE conditions returning the expected results?

Consider the following SQL query a reader…

View On WordPress

How to transfer data from one PHP page to another

If you are starting out in PHP and just learning the basics, you’ll probably just start with one PHP page, but pretty soon you will want to add a second page. If you have a form on the first page, how do you pass that data to a second page.

This was illustrated recently by a question from a reader who emailed me to help with this problem:

Dear…

View On WordPress

Buy the book - MySQL basics for new PHP programmers

Buy the book – MySQL basics for new PHP programmers

Available via LeanPub: https://leanpub.com/mysql-basics-for-new-PHP-programmers

View On WordPress

How many ways are there to output HTML using PHP

The con, the cat and t’e nation! Have you heard of concatenation? No? Stay with me if you haven’t! According to wikipedia: String concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “snow” and “ball” is “snowball”. Concatenation is an import concept in PHP for outputting HTML. Also used in many other programming languages. In this tutorial you…

View On WordPress

#concatenating #concatenation #echo #html #output

Essential tech and tools for a new eCommerce site

Essential tech and tools for a new ecommerce site Assuming you’ve already chosen your eCommerce platform. Below is a list of essentials that you should consider for your new e-commerce store. If you haven’t chosen a platform already. Some of the main contenders are Shopify, WooCommerce with WordPress, Mageneto. If you are selling digital products you could use Gumroad or GoSpaces. If you are a…

View On WordPress

How to access PHP session variables from another PHP page

One of my subscribers sent me an email asking me about problems he was having with sessions. He had already created a session variable in one PHP file. Now he had a second PHP and wanted to access the session variable in it. However he was struggling to access his session variable. He found the only way to access it, was by including the first PHP file in the second PHP file. This is a common…

View On WordPress

How to use PDO to UPDATE data in MySQL using PHP

You need to get data safely updated from a web page to a MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table to store the data in the above database The credentials to above (the host location, username and…

View On WordPress

#CRUD #PDO

How to use PDO to DELETE data from MySQL using PHP

You need to delete data safely from a web page and your MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table to store the data in the above database The credentials to above (the host location, username and…

View On WordPress

#CRUD #PDO

How to use PDO to INSERT data into MySQL using PHP

You need to get data safely from a web page to a MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table to store the data in the above database The credentials to above (the host location, username and…

View On WordPress

#PDO

How to use PDO to SELECT data from MySQL using PHP example

You have a MySQL table of data in your database, you want to display it on a webpage, so it can be displayed and viewed by other people. You need to have a few things in order to accomplish this: A MySQL database A table containing data in the above database The credentials to above (the host location, username and password) Which you can use to create a connection in your PHP page A way to…

View On WordPress

How to check a number is valid when a form is submitted to your PHP code?

You have a form on your website and you are collecting numbers You want to make sure they are valid numbers. How do you make sure they are valid numbers? First, you can validate them client-side in the browser, before the form is submitted to your server With HTML5 you can define the input field type as email and make it a required field, like this: The number input also supports a range of…

View On WordPress

How to check an email address is valid when a form is submitted to your PHP code?

How to check an email address is valid when a form is submitted to your PHP code? You have a form on your website and you are collecting email addresses You want to make sure they are valid email addresses, so that you can make use of them Whether you are replying to a customer inquiry Or using the email addresses for a marketing mailing list How do you make sure they are valid email addresses?…

View On WordPress

#email #form #required #validation

How to call a PHP function (with parentheses)

How to call a function in PHP A reader of my blog recently emailed me, asking me to check over some PHP code Nothing works from my php file except just connecting to the database It’s simple code – I’m not doing anything fancy So here’s the PHP code supplied: function getConnection( ) { $host="host"; $port=3306; $socket=""; $user="me"; $password="mypassword"; $dbname="downloads"; @ $con = new…

View On WordPress

#functions #parentheses #PHP

How to add a subscriber using MailChimps API with PHP

How to add a subscriber using MailChimps API v3.0 with PHP and CURL A quick step-by-step guide with PHP code Here was the problem, my greeting card website (PamitCards.ca) has a list of subscribers sitting in a MySQL database table. Whenever I wanted to use MailChimp to send the list of subscribers an email. I would have to export the email addresses as a CSV file. Then log-in to MailChimp,…

View On WordPress

#mailchimp #members #subscribe

7 tips for using a standing up desk

Interested in getting a stand up desk? If you are used to sitting at your desk, here are 7 tips to help you get started with a standing desk. You can download a print ready PDF of the tips Choose a desk with variable height, such as a Varidesk Make sure you take breaks from standing Wear flat shoes Shift your body position / weight Will your desk be able to support both your monitors? Start your…

View On WordPress

#standing desks #variable height standing desks

Trending Blogs

Recently Viewed Blogs

Untitled