PHP and MongoDB Programming By Example

by Agus Kurniawan 21. September 2014 13:26
I just finished my new book “PHP and MongoDB Programming by Example” . It helps you how to get started with PHP and MongoDB. Several code examples are provided to illustrate how to work PHP and MongoDB. Table of Content 1. Setup Development Environment 1.1 Windows Platform 1.1.1 Web Server 1.1.2 Deploying PHP on IIS 1.2 Linux Platform 1.3 Database MongoDB 1.4 MongoDB Driver for PHP 1.5 Development Tools 2. Hello World - PHP and MongoDB 2.1 Connecting to MongoDB 2.2 Writing PHP Code 2.3 Running 2.4 MongoDB with Authentication 3. Manipulating Database 3.1 Creating Database 3.2 Getting A List of Database 3.3 Deleting Database 4. CRUD Collection Operations 4.1 Collections 4.1.1 Creating Collection 4.1.2 Getting Collection 4.1.3 Deleting Collection 4.2 Creating Data 4.3 Reading Data 4.4 Update Data 4.5 Deleting Data 5. Working with Identity, Date and Time 5.1 Identity 5.2 Date and Time 6. Finding and Querying Data 6.1 Finding Data 6.2 Query Data 7. Working with Image and Blob Data 7.1 Image and Blob Data 7.2 Uploading Image 7.3 Listing Image Data 8. Data Modeling 8.1 Collection Relationships 8.2 Demo: Working with Collection Relationships 9. Embedded Document 9.1 Simple Embedded Document 9.2 Embedded Document Collection   How to Buy You can get this book on the following bookstore: Lulu, http://www.lulu.com/shop/agus-kurniawan/php-and-mongodb-programming-by-example/ebook/product-21815954.html  Kobo, http://store.kobobooks.com/en-US/ebook/php-and-mongodb-programming-by-example  Google Play Books, https://play.google.com/store/books/details?id=9YqSBAAAQBAJ  Amazon Kindle, http://www.amazon.com/dp/B00NRUMXRS   iBookStore, http://itunes.apple.com/us/book/isbn9781312538580   

Tags:

Books | Database | PHP

PHP and SQL Server Programming By Example

by Agus Kurniawan 24. March 2014 11:29
I have finished my new book “PHP and SQL Server Programming By Example”. This book provides alternative approach to build PHP application with Windows platform and database SQL Server.  It describes how to work with PHP and SQL Server and illustrates their use with code examples. The last chapter author explains how PHP to access Windows Azure SQL Database. Table of Content 1. Setup Development Environment 1.1 System Environment 1.2 Deploying PHP on IIS 1.3 SQL Server Driver for PHP 1.4 Database SQL Server 1.5 Development Tools 2. Hello World - PHP and SQL Server 2.1 Connecting to SQL Server 2.2 Creating PHP 2.3 Running 2.4 Windows Authentication 3. CRUD Operations 3.1 CRUD Operations 3.2 Creating Data 3.3 Reading Data 3.4 Update Data 3.5 Deleting Data 4. Working with Image and Blob Data 4.1 Image and Blob Data 4.2 Uploading Image 4.3 Listing Image Data 5. Transaction 5.1 PHP and SQL Server Transaction 5.2 Demo 6. Stored Procedures 6.1 Stored Procedures 6.2 Calling Stored Procedure 6.3 Calling Stored Procedure with Parameter 6.4 Calling Stored Procedure with Input and Output Parameters 7. Windows Azure SQL Database 7.1 Windows Azure SQL Database 7.2 Creating Windows Azure SQL Database 7.3 Connecting to Windows Azure SQL Database 7.4 Inserting Data 7.5 Retrieving Data How to Buy You can buy this book on the following online stores: Lulu, http://www.lulu.com/shop/agus-kurniawan/php-and-sql-server-programming-by-example/ebook/product-21542832.html Amazon Kindle, http://www.amazon.com/dp/B00J72LGFK Google Play Books, https://play.google.com/store/books/details?id=ugolAwAAQBAJ  iBookStore, http://itunes.apple.com/us/book/isbn9781304972026  Kobo, http://store.kobobooks.com/en-US/ebook/php-and-sql-server-programming-by-example 

Tags:

Books | Database | PHP

A Sample CRUD code for MySQL and C#

by Agus Kurniawan 12. December 2013 00:03
I just released a sample code to illustrate how to work with MySQL using C#. This code provides CRUD (Create, Read, Update, Delete) sample operations written in C#. Download this code on https://github.com/agusk/crud-mysql-cs .

Tags:

.NET | Database

Book: SQL Server for Node.js

by Agus Kurniawan 4. November 2013 03:28
I just released my new book with title SQL Server for Node.js. This book helps you how to get started with Node.js and SQL Server. It covers how to prepare your development environment. Table of Content 1. Preparing Development Environment 1.1 SQL Server Driver for Node.js 1.2 System Requirements 1.3 Installing and Configuring 1.3.1 Operating System 1.3.2 Microsoft Windows SDK 1.3.2.1 Windows 7 1.3.2 Windows 8 and Windows 8.1 1.3.3 Compiler - Visual C++ 1.3.4 Node.js 1.3.5 node-gym 1.3.6 Python 1.3.7 SQL Server Native Client 1.4 Building msnodesql Source Code 2. Hello World - Connecting to Database Server 2.1 Database Configuration 2.1.1 User Login 2.2 Development Tools 2.3 Connectivity Testing 2.3.1 Writing Code 2.3.2 Testing 3. Database Table Operations 3.1 What are Table Operations? 3.2 Database Connection String 3.3 Inserting Data 3.3.1 Inserting a Single Data 3.3.2 Inserting Many Data 3.4 Reading Data 3.5 Updating Data 3.6 Deleting Data 3.7 Finding Data 4. Stored Procedures 4.1 Creating Stored Procedure 4.2 Executing a Stored Procedure 4.3 Stored Procedure with Parameters 4.3.1 Creating A Stored Procedure 4.3.2 Executing Stored Procedure from Node.js 4.3.3 Stored Procedure with Two Parameters or More 5. Working with Image and Binary Data 5.1 Image and Binary Data 5.2 Inserting Data 5.3 Reading Data 5.4 Deleting Data 6. Transactions 6.1 What is a Transaction? 6.2 Case 1 - Data Processing without Transaction 6.3 Case 2 - Data Processing with Transaction   How to Buy You can buy this book by following online website: Lulu: http://www.lulu.com/shop/agus-kurniawan/sql-server-for-nodejs/ebook/product-21281951.html Amazon Kindle: in progress http://www.amazon.com/dp/B00GF3L8M0 Kobo: in progress http://store.kobobooks.com/ebook/sql-server-for-node-js iBookStore: in progress http://itunes.apple.com/us/book/isbn9781304592651  NOOK: in progress http://www.barnesandnoble.com/w/sql-server-for-nodejs-agus-kurniawan/1117537574  Google Play Books https://play.google.com/store/books/details?id=CY-HAgAAQBAJ 

Tags:

Books | Database | Node.js

Database Programming Using Matlab

by Agus Kurniawan 9. June 2013 13:11
I just released my new book, Database Programming using Matlab. This book helps you how to write Matlab code and access database server: MySQL, SQL Server, and Oracle. Table of Content 1. Preparing Development Environment 1.1 Database Toolbox 1.2 Testing Environment 2. Hello World - Connecting to Database Server 2.1 Database Configuration 2.1.1 MySQL 2.1.2 Microsoft SQL Server 2.1.3 Oracle 2.2 Connectivity Testing 2.2.1 Testing for Matlab and MySQL 2.2.2 Testing for Matlab and Microsoft SQL Server 2.2.3 Testing for Matlab and Oracle 3. Database Table Operations 3.1 What are Table Operations? 3.2 Inserting Data 3.3 Reading Data 3.4 Updating Data 3.5 Deleting Data 3.6 Finding Data 4. Stored Procedures 4.1 Creating Stored Procedure 4.1.1 MySQL 4.1.2 SQL Server 4.1.3 Oracle 4.2 Executing a Stored Procedure 4.2.1 MySQL and MS SQL Server 4.2.2 Oracle 4.3 Stored Procedure with Parameters 4.3.1 Creating A Stored Procedure 4.3.2 Executing Matlab and MySQL/SQL Server 4.3.3 Executing Matlab and Oracle 5. Working with Image and Binary Data 5.1 Image and Binary Data 5.2 Inserting Data 5.3 Reading Data 6. Transactions 6.1 What is a Transaction? 6.2 Case 1 - Transaction without Committing 6.3 Case 2 - Transaction with Committing 6.4 Case 3 – Rollback How to Buy Lulu, http://www.lulu.com/shop/agus-kurniawan/database-programming-using-matlab/ebook/product-21061104.html Amazon http://www.amazon.com/dp/B00DA1NZRQ  Kobo in progress http://www.kobobooks.com/ebook/Database-Programming-Using-Matlab/book-R48L76sSIUm5MfB684rV_w/page1.html iBookstore in progress http://itunes.apple.com/us/book/isbn9781304118639 Nook in progress http://www.barnesandnoble.com/w/database-programming-using-matlab-agus-kurniawan/1115867340

Tags:

Books | Database | MATLAB

MongoDB Management Studio

by Agus Kurniawan 18. March 2013 04:01
I just released my open source project, MongoDB Management Studio. It can be used to manage MongoDB local and remote servers. You can download source code and application on http://daun.codeplex.com/.

Tags:

.NET | Database

Book “MongoDB for VB.NET”

by Agus Kurniawan 11. November 2012 16:36
I just released my new book, MongoDB for VB.NET. The book aims to give you illustration in code how to implement MongoDB programming using Visual Basic .NET. It contains lots of detailed sample code that can be followed a long with as you read. Table of Content     Preface          1. Development Environment              1.1 MongoDB         1.2 C# and Development Tools         1.3 MongoDB Driver for C#            2. Connecting to MongoDB          3. Create and Delete Database              3.1 Create Database         3.2 List of Database         3.3 Delete Database                   4. Create, Read and Delete Database Collection              4.1 Create Database Collection         4.2 Read Database Collection         4.3 Delete Database Collection       5. Create, Read, Update and Delete Collection Data         5.1 Create Collection Data         5.2 Read Collection Data         5.3 Update Collection Data         5.4 Delete Collection Data       6. Finding and Querying Data             6.1 Finding Data         6.2 Query         6.3 Query and Remove       7. Binary and Image Collection Data         7.1 Insert Image/Binary File         7.2 Mapping GridFS and Collection Data         7.3 Read GridFS Data         7.4 Delete Data       8. Embedded Document         8.1 Preparation         8.2 Simple Embedded Document         8.3 Embedded Document Collection       9. LINQ         9.1 Preparation         9.2 Query LINQ       Contact and Source Code          Buy You can buy this book directly from you Kindle, http://www.amazon.com/MongoDB-VB-NET-Example-ebook/dp/B00A5A4N76/ You don’t have Kindle, you still buy it from Lulu, [V] iBookstore: http://itunes.apple.com/us/book/isbn9781300395461  KOBO: http://www.kobobooks.com/ebook/MongoDB-for-VB-NET-Example/book-eU2vCTisnUa7L29CKxHLMQ/page1.html Google Play Books https://play.google.com/store/books/details?id=TOOHAgAAQBAJ    

Tags:

.NET | Books | Database

Book “Object-Relational Mapping (ORM): MongoDB, Mongoosejs and Node.js By Example”

by Agus Kurniawan 17. September 2012 13:58
Just released my book “Object-Relational Mapping (ORM): MongoDB, Mongoosejs and Node.js By Example”. The book aims to give you illustration in code how to implement ORM for MongoDB. It contains lots of detailed sample code that can be followed a long with as you read. Table of Content Preface 1. Development Environment 1.1 MongoDB 1.2 Node.js and Development Tools 1.3 MongoDB Driver for Node.js 1.4 ORM MongoDB 2. Schemas and Models 3. Create, Read, Update and Delete Documents 3.1 Preparation 3.2 Create 3.3 Read 3.4 Update 3.5 Delete 4. Finding and Querying Data 4.1 Preparation 4.2 Finding 4.3 Querying 5. Binary and Image Collection Data 5.1 GridFs and Mongoosejs 5.1.1 Insert 5.1.2 Read 5.1.3 Delete 5.2 Working with File 5.2.1 Insert 5.2.2 Read 5.2.3 Delete 5.3 Getting List of GridFs File 6. Embedded Document 6.1 Embedded Document 6.2 Create 6.3 Read 6.4 Update 6.5 Delete 7. Validation 7.1 Method 1 7.2 Method 2 7.3 Method 3 8. Database Relationship 8.1 Database Relationship 8.2 Create 8.3 Read 8.4 Update 8.5 Delete Contact and Source Code   Buy You can buy this book directly from you Kindle, http://www.amazon.com/dp/B009BRNLJA/ You don’t have Kindle, you still buy it from Lulu, [V]  iBookStore, http://itunes.apple.com/us/book/isbn9781300202455  Kobo, http://store.kobobooks.com/en-US/ebook/object-relational-mapping-orm-mongodb-mongoosejs-and-node-js-by-example  NOOK, http://www.barnesandnoble.com/w/object-relational-mapping-agus-kurniawan/1113498563  Google Play Books https://play.google.com/store/books/details?id=jkfHAgAAQBAJ 

Tags:

Books | Database

Book “MongoDB for C# By Example”

by Agus Kurniawan 20. August 2012 08:43
I just published my book MongoDB for C#. You can buy it directly on Amazon, check it MongoDB for C# by Example- Agus Kurniawan- Amazon.com  If you don't have Kindle device, you can read it on desktop platform, check it, http://www.lulu.com/shop/agus-kurniawan/mongodb-for-c-by-example/ebook/product-20348255.html For iPad/iPhone, you can get it with iBooks app, check http://itunes.apple.com/us/book/mongodb-for-c-by-example/id559886293  Google play books: https://play.google.com/store/books/details?id=teGHAgAAQBAJ  Kobo http://store.kobobooks.com/en-US/ebook/mongodb-for-c-by-example   Table of Content Preface 1. Development Environment 1.1 MongoDB 1.2 C# and Development Tools 1.3 MongoDB Driver for C# 2. Connecting to MongoDB 3. Create and Delete Database 3.1 Create Database 3.2 Delete Database 4. Create, Read and Delete Database Collection 4.1 Create Database Collection 4.2 Read Database Collection 4.3 Delete Database Collection 5. Create, Read, Update and Delete Collection Data 5.1 Create Collection Data 5.2 Read Collection Data 5.3 Update Collection Data 5.4 Delete Collection Data 6. Finding and Querying Data 6.1 Finding Data 6.2 Query 6.3 Query and Remove 7. Binary and Image Collection Data 7.1 Insert Image/Binary File 7.2 Mapping GridFS and Collection Data 7.3 Read GridFS Data 7.4 Delete Data 8. Embedded Document 8.1 Preparation 8.2 Simple Embedded Document 8.3 Embedded Document Collection 9. LINQ 9.1 Preparation 9.2 Query LINQ Contact and Source Code

Tags:

.NET | Books | Database

MongoDB Management Studio

by Agus Kurniawan 20. March 2012 02:10
I just finished open source project with my friend. It’s a database management tool called MongoDB Management Studio. Our codename project is Daun. Here are the highlight features that we're going to deliver Manage local and remote MongoDB Servers Database operations such as view, add, edit, delete Query MongoDB Export & import data Manage MongoDB for Windows Azure Yesterday I released Alpha version of application. You can download application and source codes on http://daun.codeplex.com .

Tags:

.NET | Database

About Agus Kurniawan

Agus Kurniawan

For more detail about me click here [V]

Please entry your name into my guestbook [V]

If you want to contact me, please go here [V]

Go here for my professional services [V]

My Books

Raspberry Pi I/O Programming using Python

Pemrograman Java Tingkat Lanjut PHP and MongoDB Programming By Example

ASP.NET SignalR Programming By Example KnockoutJS Programming by Example

Getting Started with Java ME Embedded 8 and Raspberry Pi XBee IEEE 802.15.4 Programming

Raspberry Pi System Programming for Beginner Backbone.js Programming By Example

PHP and SQL Server Programming By Example AngularJS Programming by Example

jQuery Programming by Example Getting Started with Arduino and Ruby

Raspberry Pi Command Line for Beginner Getting Started with Arduino and Python

MSP430 LaunchPad Programming TypeScript Programming by Example

Getting Started with Matlab Simulink and Arduino SQL Server for Node.js

Pocket Reference: Netduino for Beginner Database Programming using Matlab

Pocket Reference: Basic Sensors in Windows 8 Getting Started with Matlab Simulink and Raspberry Pi

Getting Started with Arduino and Java  Pocket Reference: Raspberry Pi Programming

Getting Started with Arduino and Matlab Getting Started with Arduino and .NET

Pocket Reference: Raspberry Pi Getting Started with Arduino and Node.js

MongoDB for VB.NET Panduan Praktis Windows Azure

Network Forensics: Panduan Analisis Dan Investigasi Paket Data Jaringan Menggunakan Wireshark Object-Relational Mapping (ORM): MongoDB, Mongoosejs and Node.js By Example

Nodejs Programming by Example MongoDB for by Example

Pemrograman Parallel Dengan MPI dan C Panduan Lengkap iPad 2 Untuk Pemula

Pemrograman Jaringan Dengan Java Aplikasi Pilihan iPad Untuk Anak-Anak

Buku lainnya [V]

Agus Kurniawan is Microsoft MVP (Most Valuable Professional)

Agus Kurniawan- Github Profile

Agus Kurniawan- Codeplex Profile

Follow Me

Follow agusk2010 on Twitter

Month List