How to connect PHP to a Redis instance on ObjectRocket

Introduction PHP, standing for hypertext preprocessor, is an open source scripting language that can easily be embedded into HTML, making it particularly suitable for web development application. Redis, an abbreviation for remote dictionary server, is considered one of the go-to software programs for structured data storing. The Redis program is an open-source key-value store, can … Continued

Update Postgres Data using PHP on ObjectRocket

Introduction If you’re creating a PHP application that interacts with a Postgres instance on ObjectRocket, you might need your application to update Postgres data. Fortunately, this task couldn’t be easier. In this article, we’ll show you how to update Postgres data using PHP on ObjectRocket, and we’ll provide sample code to get you started. Prerequisites … Continued

DELETE Postgres data using PHP on ObjectRocket

Introduction If you’re writing PHP code that will interact with PostgreSQL, it’s important to know how to perform certain database operations. One key operation that you should be able to execute from an application is the deletion of records. In this article, we’ll show you how to delete Postgres data using PHP on ObjectRocket and … Continued

Query Postgres data using PHP on ObjectRocket

Introduction If your PHP applications interact with a PostgreSQL database, you may want the ability to execute some queries from these applications. Fortunately, this task is easy to accomplish. In this article, we’ll explain how to query Postgres data using PHP on ObjectRocket. Our step-by-step instructions are accompanied by code examples to get you started … Continued

Insert Postgres Data using PHP on ObjectRocket

Introduction When you interact with your PostgreSQL database from a PHP application, you’ll probably want to perform some common database operations in your code, such as inserting, updating, deleting and querying data. In this article, we’ll focus on the insert operation. We’ll show you how to insert Postgres data using PHP on ObjectRocket, providing detailed … Continued

Postgres Stored Procedure Call in PHP

Introduction PostgreSQL allows for expansion of database functionality by creating specialized user-defined functions. These functions are often referred to as stored procedures that permit for more effective creation of various customized procedural roles. Once created, stored procedures can then be executed as needed to increase the ease and speed of database workflow applications. This tutorial … Continued

Postgres query in PHP

Introduction The PostgreSQL SELECT statement can be used to obtain data from a single table, multiple tables or viewed as a virtual table. PDO, standing for PHP Data Objects, acts like a data-access layer that uses a unified application programming interface, commonly referred to as an API. The PDO extension is used to define a … Continued

Delete Postgres data using transaction in PHP

Introduction SQL transaction is used to execute one or more statements. If the “transaction” is successful, then all of the changes in the transaction will be applied to the entire table. However, if an error occurs in any one statement in a transaction, any changes made as a result of that transaction will be rolled … Continued

Create a File in PHP and PostgreSQL for Connection Example

Introduction PHP is a general-purpose computer script programming language and interpreter suitable for use with web applications and used primarily on Linux servers. PHP, originally derived from Personal Home Page Tools but now standing for “hypertext preprocessor,” is commonly described as recursive acronym. PostgreSQL is an open source object-relational database management system used to create … Continued

Create a File PHP in Postgres to Insert in Web App

Introduction This PostgreSQL tutorial will explain how to create a HTML file with PHP in Postgres to insert in a web app. The INSERT INTO statement or a query is used to insert data into a table in Postgres, however, an additional function is required to run the query on a PHP file that will … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.