Webucator's Blog

|

Data Types in VBA

When declaring variables in VBA, you also assign a data type. But there is a trick to it: you want to choose a data type that uses the least amount of memory. In the VB Editor, which is found in the VBA help menu, I found a great chart of the data types, including what they are used for and how much memory they use.

Continue Reading »

|

Dreamweaver CS5 with PHP and MySQL

Have you ever wanted to use Dreamweaver CS5 to run PHP pages? What about displaying data in a PHP page from a MySQL database? Well, it is a lot easier than you might think! I have written a series of 5 blogs to take you step-by-step through the connection and testing process. To achieve total success, go through the blogs in the order listed below.

Continue Reading »

|

Using Dreamweaver CS5 to Enter Data into a MySQL Database

Getting data into a MySQL database is actually easy! It is the connectivity that is confusing. I have written a few blogs on the topic: PHP Installation through XAMPP, MySQL Configuration, and Dreamweaver CS5 and PHP Connectivity test. Those blogs will take you step-by-step through the connection process. The fun part is creating a form and submitting data into your database. To do this, you must create a page that inserts the data using a form, and then displays a record set of the same table where the data was inserted. It is the whole round-trip! Let’s get started:

Continue Reading »

|

Dreamweaver CS5 and Database Connectivity

After you have successfully installed PHP and MySQL, it is time to open Dreamweaver CS5 and connect to MySQLMake sure that every window is closed except Dreamweaver CS5. When inserting data into a database, or retrieving data from a database, it is best to have that database application closed. Continue Reading »

|

Creating PHP Pages using Dreamweaver CS5: Part Two

In order to use PHP and MySQL with Dreamweaver CS5, you need to download PHPMySQL, and you should also download phpMyAdmin. This is done easily by downloading XAMPP, which will download all three applications for you! See my other blog, “PHP Installation through XAMPP,” for detailed instructions on downloading XAMPP. Once downloaded, open the XAMPP console and start MySQL, and then start XAMPP. Now, we can configure MySQL. Continue Reading »

|

Using JavaScript to Blur a TextBox

How can you keep a user from changing the contents of a textbox? It is easy to do using HTML Event Handlers. Try the code below. It works like this…

Click the button and type in a color. We’ll use green. Then, click “ok”. The background color will turn green and the word “green” will display itself in the FavColor text box. Try to change the contents of the FavColor text box and you can’t! That is because of the HTML Event Handler: onfocus = “this.blur();”
Continue Reading »