This article present techniques to help prevent the gaming of your MySQL-PHP Website. Some of them rely on shutting down scripts; others try to find the humans who are manually executing this behavior.

Description of many features in MySQL, which work as advertised, but not as those used to other databases may expect.

In the first part, we looked at the basic mechanics of MySQL and Couchbase Server 2.0, and compared the ways in which you would model the data, and how the basic queries and lists of records operate, from the MySQL SQL statement, to the Couchbase Server View.

Moving from a relational database, like MySQL, to a NoSQL database, like Couchbase, requires that you change the perspective on your data. In this article, MC Brown explains the differences between structuring data for a MySQL and a Couchbase database. He also discusses how these differences impact your queries

Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table.

Many web developers consider security a low priority. Security is frequently relegated to the end of the software development life cycle, as little more than an afterthought. Sometimes, software security is neglected entirely, resulting in applications rife with common vulnerabilities. Because such bugs might manifest only under conditions present during an attack, they can be hard to detect prior to such events without knowledge of how the exploitation process works. Using a web application built with jQuery Mobile, PHP, and MySQL, this tutorial shows how many types of vulnerabilities occur along with common methods of exploitation and, most importantly, their respective countermeasures.

In this article we explore how to program foreign keys into a MySQL Server. This is important when your application requires referential integrity and the storage engine you’d like to use, as in the case of MyISAM or NDB (Cluster), does not support this functionality natively. We should note that InnoDB and the upcoming code-named “Falcon” storage engine, both support foreign keys.

In Part 1 of this three-part series, you learned about the salient features of open source technologies such as Firefox, Zend Core, and MySQL. You were introduced to a non-trivial bank scenario that spans across all three tiers of an Ajax application. You also set up the database server, mid-tier server, and Eclipse-based IDE, which are required for end-to-end Ajax application development. In this second part of the series, you will develop some portions of the bank scenario. In particular, you'll create a back-end database using the MySQL database. You'll get exposure to several MySQL command-line tools for connecting, creating, defining, and populating bank-specific data in the database. Then, you will develop a mid-tier PHP module to house the bank's business logic, which uses ODBC to connect to the MySQL database. Finally, you'll develop a bank portal to provide a simple browser UI through which users can interact with this end-to-end application, which will soon be ready to run on Zend Core.

Does MySQL Cluster scale? Does MySQL Cluster rock? This article try to answer these questions with tests of MySQL Cluster 5.1.20.

Rich Internet Applications (RIAs) often utilize different bundled technologies. Choosing the right grouping of technologies can expedite development times and provide users a complete and rich Internet experience. Discover how to use Java™ EE platform components on the server side, the Adobe® Flex™ platform on the client side, and the MySQL® database server for storage persistence.