Databases

By PHP Builder Staff on March 2, 2012 Of course, what most people want to do with PHP is view database records, or perhaps insert database records. There are a few fundamental things you have to do to. First, of course, install and set up your database program, whether it’s…

Learn how to manage hierarchical data using MySQL and PHP. Specifically, explore the relative pros and cons of the adjacency list and nested set models.

In this article, Gigi Sayfan shows you how to take advantage of Google’s Platform as a Service (PaaS) in order to create a scalable, highly available and secure PHP web application.

Learn how to store binary data like images and HTML files directly in your MySQL database using PHP.

Learn how to store binary data like images and HTML files directly in your MySQL database using PHP.

Every computer system has a backup. Nevertheless, the number of problems caused by a lack of a recent backup is huge. One of the reasons for that may be the fact that the backup process is not entirely automated. So, let’s see how to automate the database backup process in PHP.

Since quality assurance takes a significant amount of project time and resources, we are always looking for ways to improve its efficiency. One testing process improvement is to programmatically create sample testing data. To achieve this, we will use a popular PHP library called Faker.

Although MySQL is the most commonly used database software in web applications, there are many other database systems that are also popular and provide good solutions in certain use-cases. In this article, we will discuss these systems and their advantages and disadvantages.

The standard edition of Symfony PHP framework comes integrated with Doctrine, an object-relational mapper (ORM) and a database abstraction layer (DBAL) which makes working with databases very easy. This tutorial will focus on using Doctrine in Symfony–querying object relationships.

The standard edition of Symfony PHP framework comes integrated with Doctrine, an object-relational mapper (ORM) and a database abstraction layer (DBAL) which makes working with databases very easy. This tutorial will focus on using Doctrine in Symfony–how to create models of database tables and its relations, how to query the data, and more.