Node.js
- Getting started with Node.js
- Awesome Book
- Awesome Community
- Awesome Course
- Awesome Tutorial
- Awesome YouTube
- Arduino communication with nodeJs
- async.js
- Async/Await
- Asynchronous programming
- Autoreload on changes
- Avoid callback hell
- Bluebird Promises
- Callback to Promise
- Cassandra Integration
- CLI
- Client-server communication
- Cluster Module
- Connect to Mongodb
- Creating a Node.js Library that Supports Both Promises and Error-First Callbacks
- Creating API's with Node.js
- csv parser in node js
- Database (MongoDB with Mongoose)
- Debugging Node.js application
- Deliver HTML or any other sort of file
- Dependency Injection
- Deploying Node.js application without downtime.
- Deploying Node.js applications in production
- ECMAScript 2015 (ES6) with Node.js
- Environment
- Event Emitters
- Eventloop
- Exception handling
- Executing files or commands with Child Processes
- Exporting and Consuming Modules
- Exporting and Importing Module in node.js
- File upload
- Filesystem I/O
- Getting started with Nodes profiling
- Good coding style
- Graceful Shutdown
- grunt
- Hack
- Handling POST request in Node.js
- How modules are loaded
- http
- Installing Node.js
- Interacting with Console
- Keep a node application constantly running
- Koa Framework v2
- Lodash
- Loopback - REST Based connector
- metalsmith
- Mongodb integration
- MongoDB Integration for Node.js/Express.js
- Mongoose Library
- MSSQL Intergration
- Multithreading
- Mysql Connection Pool
- MySQL integration
- Connect to MySQL
- Export Connection Pool
- Query a connection object with parameters
- Query a connection object without parameters
- Return the query when an error occurs
- Run a number of queries with a single connection from a pool
- Using a connection pool
- N-API
- Node JS Localization
- Node server without framework
- Node.js (express.js) with angular.js Sample code
- Node.JS and MongoDB.
- Node.js Architecture & Inner Workings
- Node.js code for STDIN and STDOUT without using any library
- Node.js Design Fundamental
- Node.js Error Management
- Node.js Performance
- Node.js v6 New Features and Improvement
- Node.js with CORS
- Node.JS with ES6
- Node.js with Oracle
- NodeJS Beginner Guide
- NodeJS Frameworks
- Nodejs History
- NodeJs Routing
- NodeJS with Redis
- npm
- nvm - Node Version Manager
- OAuth 2.0
- package.json
- Parsing command line arguments
- Passport integration
- passport.js
- Performance challenges
- PostgreSQL integration
- Project Structure
- Push notifications
- Readline
- Remote Debugging in Node.JS
- Require()
- Restful API Design: Best Practices
- Route-Controller-Service structure for ExpressJS
- Routing ajax requests with Express.JS
- Running node.js as a service
- Securing Node.js applications
- Send Web Notification
- Sending a file stream to client
- Sequelize.js
- Simple REST based CRUD API
- Socket.io communication
- Synchronous vs Asynchronous programming in nodejs
- TCP Sockets
- Template frameworks
- Uninstalling Node.js
- Unit testing frameworks
- Use Cases of Node.js
- Using Browserfiy to resolve 'required' error with browsers
- Using IISNode to host Node.js Web Apps in IIS
- Using Streams
- Using WebSocket's with Node.JS
- Web Apps With Express
- Windows authentication under node.js
- Yarn Package Manager
Node.js MySQL integration Query a connection object with parameters
Example
When you want to use user generated content in the SQL, it with done with parameters. For example for searching user with the name aminadav you should do:
var username = 'aminadav';
var querystring = 'SELECT name, email from users where name = ?';
connection.query(querystring, [username], function(err, rows, fields) {
if (err) throw err;
if (rows.length) {
rows.forEach(function(row) {
console.log(row.name, 'email address is', row.email);
});
} else {
console.log('There were no results.');
}
});
