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

This guide provides an overview of Yahoo! Query Language (YQL) along with information on how to use YQL to retrieve data from Yahoo! Social Directory, MyBlogLog, and data from other Yahoo! Web services. YQL also allows you to retrieve data from external sources such as the New York Times as well as feeds such as RSS and Atom. This guide is intended for software developers who are familiar with SQL, MySQL, or Yahoo! Pipes.
Read the rest of this entry »

• 0 Comments

This manual was compiled by Project A Web Development as a project supported by Jim Teece. It was written by Ethan Townsend as a documented means of migrating our ADO ASP application, SIB (Site­in­a­box), from Microsoft SQL Server 7.0 to an open source database. SIB is a large database­ driven application that includes many views, stored procedures, and complex SQL executed from the ASP pages.
Read the rest of this entry »

• 0 Comments

Welcome to AIT’s DBManager tutorial. This tutorial assumes that you already have MySQL and the DBManager installed onto your Virtual Server. In this tutorial we will create a very simple and small database using the GUI interface the DBManager provides.
Read the rest of this entry »

• 0 Comments

This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that allows you to connect to a MySQL server, run queries, and view the results. mysql may also be used in batch mode: you place your queries in a file beforehand, then tell mysql to execute the contents of the file. Both ways of using mysql are covered here.
To see a list of options provided by mysql, invoke it with the –help option:
shell> mysql –help
Read the rest of this entry »

• 0 Comments

Checking the Installation Obtaining Joomla! Nightly Build Nightly Build SVN Final Preparation Transferring the files A bit more preparation MySQL Details FTP account details Secure Password Thinking Installation Web Browser Installation Step 1 - Language Choice Step 2 - Pre-installation Check Step 4 - Database Configuration Step 5 - FTP Configuration Step 6 - Main Configuration Installing the Default Sample Data Installing a Compatible SQL Script File Installing a Migration SQL Script File from an earlier Joomla! version 1.0.x installation Step 7 - Finish
Read the rest of this entry »

• 0 Comments

It is updated version that replaces Appendix C in the 2 nd edition (16 May 2004) of Web Database Applications with PHP and MySQL by Hugh E. Williams and David Lane. This appendix is copyright O’Reilly Media Inc. We thank Jeanne Pickering, Scott Brown, Matt Starks, and Bill Griffiths for feedback, errata, and suggestions. This appendix is a guide to installing the software used in the book on an Apple MacIntosh OS X platform.
Read the rest of this entry »

• 0 Comments

As you may have read on the project’s web site, the goal of MySQL­HA is oprovide a freely available and community supported clustering tool kit based on MySQL, and focused on service availability. We’ll dissect that sentence to reveal that it’s not just a quick marketing trick, but a real mission statement. Freely available. This is easy to see, since the code is GPL, plus, it’s mostly shell and perl scripts, which is inherently open source. Community supported. This is very important now that the project is sponsored by an IT company. What it means is that it’s not that useful to have a freely available clustering solution if it’s not properly documented and easy to use. We’re working on the easy to use part, by focusing our current development efforts on a better installer. As for the other part, this document is the first on a set of tools we’re developing, along with the code, in order to allow people to make the best of the code with no need for commercial support.
Read the rest of this entry »

• 0 Comments