Read WebProNews
With Friends!

MySQL Articles

MySQL Database Handling in PHP

Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data in order for the customer to perform the check – the customer’s personal login details; and the customer’s purchased items. This data can be stored in two types of storage – flat files or databases.

MySQL Partner Program Continues to Grow

MySQL AB has signed a Value-Added Reseller (VAR) agreement with GoldenGate Software who will become a Certified ISV Partner for MySQL.

Save $100 in 5 Minutes Backing Up Your Web Site?

Here’s an easy way to backup your web site’s files and database (worth thousands of dollars, no doubt) that costs $0 to learn and perform. It only takes seven easy steps.

Coding a Simple Guestbook Using PHP and MySQL
· 9

This is a short article which shows you how to make a simple guestbook by capturing the visitor’s input and storing the data in a database using PHP. You’ll need to know a bit of HTML, PHP and MySQL in order to do the task. For a guestbook to work, we’ll need to create 3 pages.

Publishing Newsletter Using PHP & MySQL
· 2

Are you tired of using third-party tools to send out routine notifications and emails to your clients? Or, do you want to send your newsletters with individual names of people in the beginning. This series of articles helps you achieve this.

Setting up Apache, PHP and MySQL on Windows

I’m writing this article assuming you’re running Windows XP on your computer. Even if you are not, you can use this article to setup these three on almost all basic Windows flavors.

PHP and MySQL — Adding data

There comes time when your website tends to transcend the boundaries of mere brochure type looks.

A Simple Web Search Engine

Every user expects a search engine on any Web site they visit. Unfortunately, search engines are extremely complex to develop. They require massive amounts of resources and time to implement. Today I’ll show you how to use a MySQL (or any SQL database) to create your own basic search engine.

MySQL battles the big guys

SAN JOSE, Calif.–MySQL kicked off its first-ever users conference by releasing the source code of its upcoming MySQL 5.0 product and touting its reputation as the little database company that could.

MySQL Open Source Essentials

As noted in last year’s METAspectrum(SM) on database vendors for Unix and Windows (see SIS Deltas 1039 and 1040), the market for enterprise database management is very mature.

Understanding MySQL Privileges in Linux

MySQL has become increasingly popular in the last year because of its ease of use and price. Setting up a MySQL Server on a Windows machine is so easy you may not even realize it is there. Installing MySQL on a Linux machine isn’t quite as easy, but anyone with any experience installing programs on Linux wouldn’t have a problem. So, now that you have your server installed, how do you manage a multi-user environment? This is where your privileges come in.

An Introduction to PHP and MySQL
· 1

Setting up your own Windows e-commerce site may seem like a daunting task at first. There is quite a bit to know, though with a basic understanding of the underpinnings and a few good tools, you’ll be on your way in no time at all.

Servlets, MySQL and JDBC Drivers
· 1

With the “write once, compile once, run anywhere” power that the JDBC offers you, Java’s database connectivity allows you to worry about the translation of relational data into objects instead of worrying about how you are getting the data.

Temporary Tables With MySQL

If you have had problems with MySQL not supporting functionality like sub selects this short article might be of interest for you. This article will explain how to use temporary tables with MySQL.

The juice