Maintain Your Computer and Use it More Effectively
to Design a Web Site and Make Money on the Web

About BTH User Agreement Privacy Site Map Contact Advertise Here News Feeds

Hello World! Computer Programming for Kids and Other Beginners

This book provides a gentle but thorough introduction to computer programming. It's written in language a kid can follow, but anyone who wants to learn how to program a computer can use it. Even adults.

Teaches using the powerful object-oriented but easy-to-use open source Python programming language.

Click Here

Program a Visual Basic MySQL Database

By Stephen Bucaro

MySQL is a powerful relational database management system used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau. The best thing about MySQL is that it is open source software available free of charge for non-commercial use under the open source GNU public License.

In my previous article "A Free Windows Graphical Interface to MySQL" we used MySQLGUI for executing SQL queries on our example database. While MySQLGUI is a great tool for learning SQL and performing database administration tasks, it is not an application that you would provide to the average user.

In this article I show you how to program a simple MySQL database browser using Visual Basic. I assume that you already know how to program a simple Visual Basic .EXE project. By the way, Janus Software provides a free application for Windows and Linux that is very similar to Visual Basic.

In this example we will use Microsoft's ActiveX Data Object with a MySQL ODBC driver. The first thing to do is download a MySQL ODBC driver from:

www.mysql.com/downloads/api-myodbc.html.

On that Web page click on the link for "MyODBC 2.50 -- stable release". This takes you to the download page for a Windows 95/98/Me driver, a Windows NT/2000/XP driver, and a Linux driver.

For my Windows 98 system, I downloaded myodbc-2.50.39-win95.zip and expanded it into a new subfolder under the C:\mysql folder. To install a driver on Windows you must "register" it. Basically you create an entry in the Windows Registry. These drivers come with a setup program that does the registration for you.

Start Visual Basic and create a new Standard .EXE Project. In Project References, set the checkbox next to [x] Microsoft ActiveX Data Objects 2.0 Library.

This example presents the minimal code required to make a simple database browser, in fact, as you can see, I didn't even put labels for the text boxes. I'm sure that starting with this bare-bones code, you can program a much nicer looking application with more features.

This program will be designed specifically to browse the database created in the previous article (firstdb). It contains one table named address with four fields named; name, address, city, and state. Layout the form with three command buttons and four text boxes as shown below.

Programming Sections

Active Server Pages

Java

MySQL

Visual Basic Programming

XML

RSS Feed

MySQL

Run PHP From Flash Key With Server2go
Creating Webpages with PHP
Introduction to Variables in PHP
Working With Strings in PHP
Working With Numbers in PHP
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
Getting Started With MySQL Database
A Free Windows Graphical Interface to MySQL
Program a Visual Basic MySQL Database

PHP Solutions: Dynamic Web Design Made Easy

You want to make your websites more dynamic by adding a feedback form, creating a private area where members can upload images that are automatically resized, or perhaps storing all your content in a database. The problem is, you're not a programmer and the thought of writing code sends a chill up your spine. Or maybe you've dabbled a bit in PHP and MySQL, but you can't get past baby steps.

If this describes you, then you've just found the right book. Most PHP books either expect you to be an expert already or force you to go through endless exercises of little practical value. In contrast, this book gives you real value right away through a series of practical examples that you can incorporate directly into your sites, adding functionality such as file uploading, email feedback forms, image galleries, content management systems, and much more.

Click here for more information.