Tutorials

This tutorial will teach you on how to create a content pager using PHP/MySQL. I uses PDO query to retrieve the data from database table. This tutorial is useful when you have multiple data from the database. This code divide the content and display by page. To start this tutorial fallow the steps bellow:

Creating Our Database

First we are going to create our database which stores our data. To create a database: 1. Open phpmyadmin 2. Then create database and name it as "pdo_ret". 3.

SQL Attack is rampant now a days, this is the way of hacking a site using SQL injection. Reading this tutorial will teach you on how to protect your queries from SQL injection attack using PDO Query. PHP Data Objects (PDO) Query executes an SQL statement in a single function call, returning the result set (if any) returned by the statement as a PDOStatement object. This is code will help you on how to retrieve data from Database table using PDO query.

This program was created in Microsoft Visual Basic 2010 Express to demonstrate how to draw a rubberband rectangle in a picture box.

One of the most common control used in visual basic is a text box. The main purpose of textbox is that, it allows user to input text information to be used by the program. By default, text box takes a single line of text. But using visual basic, you can set the property to accept a multiple line of text and even with a scroll bar. This time, open visual basic and create a new project called “Textbox”. Then drag a six text box and six label from the toolbox.

This tutorial is a continuation of our last topic called “Creating the Stock Master”. This time we're going to focus on loading, Updating and Deleting of an Item. To start in this lesson, open first our project named “Stockinven”.

In this tutorial, I’m going to show you how to create a stock master. This stock master will cater all the data entry for the new acquired stocks or Item(s). And the loading, updating and deleting of a specific stocks or Items. To start in this lesson, first we need to open our project called “Stockinven”. Then, were going to add new form and we will name it as “Stock Master”. To do this, go to solution explorer right click the project name, then point the mouse pointer to “Add” then choose “Windows Form”.

This tutorial is a continuation of previous topic called "How to Create a Stocks Inventtory System". At this time, we’re going to focus on how to set up our database connection. In setting database connection, there are two way on how to do it. First is using the IDE of visual by specifying the data source of the database.

In this tutorial, I'm going to teach how to create a Stocks Inventory System in a phase to phase basis. This system will be developed using Visual Basic 2008 and Microsoft Access Database 2003 for database. Here’s the outline for this topic:

• Setting the Database tables
• Setting Database connection
• Creating a Stock Master

Registering new stocks
Updating stock
Removing stocks

• Creating a transaction

Releasing of stocks
Returning of stocks

In this tutorial, I'm going to show you how to create a simple Login-Logout system using Visual basic.net and MySQl Database. To start with this application, open Visual Basic->Create a New Project->Save it as “Login”. This time, let’s add objects to our windows form and these objects are the following: four Labels, two Textbox,two buttons and a Groupbox.

This tutorial is a continuation of our our previous topic called “Creating MySQL Database tables using Visual Basic. Net”. This time, we're going to focus on displaying and dropping of MySQL Database Tables using Visual Basic.Net. In this application, we need to add two buttons and a datagridview.