As a web programming language, one of PHP’s strengths traditionally has been to make it easy to write scripts that access databases so that you can create dynamic web pages that incorporate database content. This is important when you want to provide visitors with information that is always up-to-date, without hand tweaking a lot of static HTML pages. However, although PHP is easy to use, it includes no general-purpose database access interface. Instead it has a number of specialized ones that take the form of separate sets of functions for each database system. There is one set for MySQL, another for InterBase, and another for PostgreSQL—and others as well.
Read the rest of this entry »

• 0 Comments

There has always been the necessity to have a definitive guide on PHP-Nuke. Due to time constraints, nobody has ever had the will to carry out this operation. Not any more! With this book, PHP-Nuke now posesses the most comprehensive guide on the subject, suitable for newbies and advanced users alike.

PHP-Nuke utilizes as hinge of its own structure the duo PHP+ MySQL, very often being accompanied by the Apache web server. Many modules have integrated many other languages, such as Javascript, Java, Flash and also even systems that serve, through the portal, sounds and films in streaming mode (Online Radio, TV Online, Images, Files…). From version 6.x onwards, the compatibility has been extended to include other databases as well, in order to extend the user base even more vastly.
Read the rest of this entry »

• 0 Comments

Traditionally, Microsoft’s core business has been focused on the Windows platform and the Office suite. Windows and Office, by all means, continue to be the heart of Microsoft. The latest versions of the flagship products, Windows Vista and the Office 2007 System, made available to the public at the end of January 2007, have fueled the vast majority of the company’s most recent fiscal second quarter record financial results of $16.37 billion in revenue, and $6.48 billion in operating income. With Office SP1 out of the way at the end of 2007, Microsoft is currently building Windows Vista Service Pack 1, Windows XP Service Pack 3 and Windows 7 client platforms, as well as putting the finishing touches on Windows Server 2008.
Read the rest of this entry »

• 0 Comments

The Many-to-Many tutorial is ment to learn you how to use the Server Behaviors and the commands that are related to the implementation of many to many relationships between tables. We will also demonstrate easily how to implement the Nested Repeat Region feature in ImpAKT2. The goal of the current application will be the creation of a website that will help us manage a list of students with their associated courses.
Read the rest of this entry »

• 0 Comments

Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per article, then (article, deal- er) is a primary key for the records.
Read the rest of this entry »

• 0 Comments

Not a Linux fan? Looking for a hassle?free way of setting up a PHP environment on your Windows box? Read as Matthew guides us through the process of installing Apache, MySQL and PHP on a Windows based machine, otherwise known as WAMP.

This article is geared towards people who want to code and test their own, or other people’s, php scripts on their Windows box. No advanced technical knowledge is assumed. This tutorial is unsuitable for advanced users. Why Apache and MySQL? Because they are available for free, quite easy to use and reliable. Why windows? Because there are many installation guides written for the Linux user, but Windows generally gets overlooked. And getting it all to work can be a real daunting task.
Read the rest of this entry »

• 0 Comments

In this tutorial, we will assume that our organization has a single LDAP directory containing some information about our
users, while a MySQL database is used to contain further information about users that is accessible via a web
interface. For now, we will simply work toward providing a means for LDAP-ready applications to access data within
the MySQL database used by our web application. This is easily achieved using VDS.

Assumptions
1. VDS is installed and configured properly; VDS is currently running.
2. An LDAP directory such as Active Directory is already installed and accessible from the computer on which VDS is installed.
3. A MySQL database server is already installed and accessible from the computer on which VDS is installed.
4. A MySQL database called “test” has been created, and contains a table called “users” with a schema that contains the following items:
`uid` varchar(25) NOT NULL,
`password` varchar(40) NOT NULL,
`Title` varchar(255) default ”,
`FirstName` varchar(255) default ”,
`LastName` varchar(255) default ”,
`Company` varchar(255) default ”,
`EmailDisplayName` varchar(255) default ”,
`EmailAddress` varchar(255) default ”
5. The MySQL table called “users” is populated with at least one entry.
6. The LDAP directory is accessible on port 389 (default ldap port) and the MySQL server is accessible on port 3306 (default mysql port).
7. Port 3890 is available on the computer in which VDS is installed.

Download pdf Integrating RDBMS into an LDAP Environment

• 0 Comments

Some assessment questions
- Who has used MySQL Proxy?
- Who has read the “getting started” article?
- Who has read the datacharmer blog?
- Who uses MySQL Proxy in production?
Read the rest of this entry »

• 0 Comments