Need your blog posts to generate more leads? Looking for tips to turn more readers into loyal email subscribers? In this article, you’ll learn how to combine blog posts and content upgrades into a package that generates warm leads. #1: Review Multiple Platforms to Find Popular Topics To convert more customers through blogging, you need [...]
This post How to Generate More Leads From Your Blog first appeared on .
- Your Guide to the Social Media Jungle
I’ve teamed up with MediaLuv to launch a new One Page Love service creating Explainer Videos to embed in your Landing Pages. They are basically beautiful 45 second videos introducing your website, business, product or idea.
So why? The statistics are overwhelming toward how consumers are shifting to video consumption online opposed to tradition text and images.
These Explainer Videos are perfect to embed at the top of your long-scrolling Landing Page!
We begin with a brief online questionnaire to assess the scope of the project. If we think we can deliver an excellent video, we continue with a quote. Once agreed upon, we start with script writing, then voiceover recording, storyboard, design, animation, 2 rounds of revisions, proofing and finally file hand off.
From questionnaire to final file hand off is approximately 3-4 weeks.
The website header background hero area, in the foreground as a standalone explainer video, within features, website section dividers and of course your social media channels.
I hope you find the new service useful!
NoSQL databases are all the rage these days and probably the preferred back-end for Node.js applications. But you shouldn't architect your next project based on what's hip and trendy, rather the type of database to be used should depend on the project's requirements. If your project involves dynamic table creation, real time inserts etc. then NoSQL is the way to go, but on the other hand, if your project deals with complex queries and transactions, then a SQL database makes much more sense.
In this tutorial, we'll have a look at getting started with the mysql module — a Node.js driver for MySQL, written in JavaScript. I'll explain how to use the module to connect to a MySQL database, perform the usual CRUD operations, before examining stored procedures and escaping user input.
This popular tutorial was updated on 11.07.2017. Changes include updating to ES6 syntax, addressing the fact that the node-mysql module module was renamed, adding more beginner friendly instructions and adding a section on ORMs.
Maybe you've arrived here looking for a quick leg up. If you're just after a way to get up and running with MySQL in Node in as little time as possible, we got you covered!
Here's how to use MySQL in Node in 5 easy steps:
mkdir mysql-test && cd mysql-testpackage.json file: npm init –ynpm install mysql –saveapp.js file and copy in the snippet below.node app.js. Observe a “Connected!” message.
//app.js
const mysql = require('mysql');
const connection = mysql.createConnection({
host: 'localhost',
user: 'user',
password: 'password',
database: 'database name'
});
connection.connect((err) => {
if (err) throw err;
console.log('Connected!');
});
Now let's take a closer look at each of those steps. First of all we're using the command line to create a new directory and navigate to it. Then we're creating a package.json file using the command npm init –y. The -y flag means that npm will use only defaults and not prompt you for any options.
This step also assumes that you have Node and npm installed on your system. If this is not the case, then check out this SitePoint article to find out how to do that: Install Multiple Versions of Node.js using nvm.
After that, we're installing the mysql module from npm and saving it as a project dependency. Project dependencies (as opposed to dev-dependencies) are those packages required for the application to run. You can read more about the differences between the two here.
mkdir mysql-test
cd mysql-test
npm install mysql -y
If you need further help using npm, then be sure to check out this guide, or ask in our forums.
Before we get on to connecting to a database, it's important that you have MySQL installed and configured on your machine. If this is not the case, please consult the installation instructions on their home page.
The next thing we need to do is to create a database and a database table to work with. You can do this using a
graphical interface, such as phpMyAdmin, or using the command line. For this article I'll be using a database called sitepoint and a table called employees. Here's a dump of the database, so that you can get up and running quickly, if you wish to follow along:
CREATE TABLE employees (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50),
location varchar(50),
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
INSERT INTO employees (id, name, location) VALUES
(1, 'Jasmine', 'Australia'),
(2, 'Jay', 'India'),
(3, 'Jim', 'Germany'),
(4, 'Lesley', 'Scotland');
Now, let's create a file called app.js in our mysql-test directory and see how to connect to MySQL from Node.js.
Continue reading %Using MySQL with Node.js and the mysql JavaScript Client%
