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

We present a practical protection mechanism against SQL injection attacks. Such attacks target databases that are accessible through a web front-end, and take advantage of flaws in the input validation logic of Web components such as CGI scripts. We apply the concept of instruction-set randomization to SQL, creating instances of the language that are unpredictable to the attacker. Queries injected by the attacker will be caught and terminated by the database parser. We show how to use this technique with the MySQL database using an intermediary proxy that translates the random SQL to its standard language. Our mechanism imposes negligible performance overhead to query processing and can be easily retrofitted to existing systems.
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

Everybody who wants to install a web server database but does not know which software is necessary and how it is installed should benefit from reading this text. This text provides all information necessary to get a SQL database for a web server going; it does not go into any detail of CGI programming, nor does it explain the SQL database language. Excellent books are available on both topics, and it is the intention of this text to provide a working platform based on which a user can then study CGI programming and SQL. For getting a small scale SQL system running (not the notorious example of a major airline booking system, or space mission management database) it will be sufficient to have the software described in this text and the documentation accompanying it. The user manual of msql (a database introduced in this text) provides sufficient information on SQL for building your own database.
Read the rest of this entry »

• 0 Comments

SQL - Structured Query Language
Structured Query Language, is a computer language designed for retrieval and management of data in relational database management systems database schema creation and modification database object access control management.
History:
The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. Standardized in 1986 by ANSI. Subsequent versions of the SQL standard have been released as ISO standards
Read the rest of this entry »

• 0 Comments

This tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. When we are finished, you will know how dynamic sites work and how they serve the content, and you will be ready to serve your own dynamic content from your site.
Read the rest of this entry »

• 0 Comments

MySQL is a Relational Database Management System. A relational database adds speed and flexibility, by storing data in separate tables rather than putting all the data in one area. These tables are linked by defined relations making it possible to combine data fromseveral tables upon request. Using a RDMS means it is possible to add, access, and process the data stored in your database. ‘SQL’ stands for “Structured Query Language” - the most common standardised language used to access databases. MySQL is Open Source software and is freely available at www.mysql.com. Open Source software means that the source code can easily be manipulated and modified by anyone. It is very simple to use.
Read the rest of this entry »

• 0 Comments

Fulltext search QuickPoll
? have used MySQL Fulltext Search in production ?
- have at least tried using MySQL Fulltext search ?
- have used fulltext search in other products ?
? are interested in boolean fulltext search ?
- natural language search ?
- in our future plans for fulltext search ?
? are interested in how to tune and optimize your fulltext search application ?
? are interested in how MySQL Fulltext Search works internally?
- have contributed code to Open Source products ?
Read the rest of this entry »

• 0 Comments