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

Mengenal Entity Framework 4.0

by Agus Kurniawan 18. March 2011 09:20
Selain menulis artikel Mengenal Teknologi Mobile Qt, gw juga menulis satu artikel di majalah PC Media edisi Maret 2011 yaitu topik Mengenal Entity Framework 4.0. Apa Itu Entity Framework? Pada bulan Juli 2008 Microsoft meluncurkan ADO.NET Entity Framework yang merupakan bagian dari Visual Studio 2008 Service Pack 1 dan .NET Framework 3.5 Service Park 1. Selain itu Microsoft juga memperkenalkan LINQ (Language Integrated Query). Hal ini menunjukkan Microsoft sangat serius untuk meningkatkan produktifitas produksi dalam membangun aplikasi. Kemudian Microsoft meluncurkan Entity Framework bersamaan dengan diluncurnya Visual Studio 2010 dan .NET Framework 4.0. Apa itu Entity Framework? Entity Framework adalah sekumpulan teknologi ADO.NET yang membantu mapping antara pengembangan object-oriented dan database. Metode ini dikenal dengan ORM (Object-Rational Mapping). Kalau diteliti lebih dalam Entity Framework lebih sekedar dari ORM karena Entity Framework juga dapat bekerja sebagai ERM (Entity Relationship Model). Selain Entity Framework, kita juga dapat menjumpai solusi lain yaitu NHibernate. Solusi persistent .NET object ke relational database. NHibernate merupakan hasil porting dari Hibernate java ke .NET Framework SPRING.net. Framework berbasis open source yang merupakan hasil porting Spring Framework dimana ini memungkinkan kita untuk membuat komponen yang terintegrasi kedalam multi-tier application Pada artikel ini penulis akan memaparkan bagaimana memanfaatkan Entity Framework dalam pengolahan database secara object-oritented. Database vs Model Programmer .NET pasti sudah familiar dengan objek DataReader dan DataSets untuk melakukan koneksi ke database dan melakukan melakukan query data kedalamnya. Sebagai ilustrasi kita lihat potongan kode program untuk melakukan koneksi dan query kedalam database SQL Server: using (SqlConnection conn = new SqlConnection(@"server=(local);Database=Northwind;UID=tester;PWD=123")) { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM Products"; using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { // Ambil data } } } } Dengan menggunakan Entity Framework, kita tidak lagi kuatir mengenai database malahan kode program kita jauh lebih sederhana dan kita melakukan query ke tabel tapi query ke objek (entitas) yang mewakili business model. Hasil query-nya adalah objek dan tidak seperti yang dulu sibuk dengan konfigurasi row dan column yang di bind ke objek. Sebagai ilustrasi, skema database Northwind untuk tabel product, categories, dan suppliers dapat dilihat pada gambar 1. Sedangkan hasil model mapping dengan Entity Framework akan menghasil class diagram seperti pada gambar 2. Dengan pendekatan ini, kita sudah tidak melakukan query sql pada kode program kita tapi kita melakukan query ke objek, contohnya sebagai berikut using (var context = new NorthwindEntities()) { var products = from p in context.Products select p; } Teknik query objek ini dengan memanfaatkan LINQ. Gambar 1 Gambar 2   Persiapan Kita tidak perlu melakukan persiapan yang komplek. Seperti kita ketahui bahwa Entity Framework  adalah bagian dari .NET Framework 4.0 oleh karena itu ketika komputer kita sudah terinstall .NET Framework 4.0 maka kita dapat langsung memanfaatkan framework ini. Sedangkan untuk tool IDE, kita dapat menggunakan Visual Studio 2010 yang memang sudah terintegrasi dengan target .NET Framework 4.0. Database yang digunakan adalah SQL Server. Jika pembaca ingin memanfaatkan Entity Framework untuk database selain SQL Server maka kita harus menginstall  tambahan Entity Framework dari database ini. Umumnya pembaca dapat mengunduh di website database tersebut. Lebih lengkapnya dapat dibaca pada majalah PC Media edisi Maret 2011. Semoga berguna

Tags:

Papers | .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

HP 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