PHPackages                             stevecomrie/baserow-php - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [API Development](/categories/api)
4. /
5. stevecomrie/baserow-php

ActiveLibrary[API Development](/categories/api)

stevecomrie/baserow-php
=======================

A PHP Client for the Baserow.io API

0.0.7(3y ago)153453[1 issues](https://github.com/stevecomrie/baserow-php/issues)[1 PRs](https://github.com/stevecomrie/baserow-php/pulls)MITPHPPHP >=7.1

Since Apr 9Pushed 3y ago2 watchersCompare

[ Source](https://github.com/stevecomrie/baserow-php)[ Packagist](https://packagist.org/packages/stevecomrie/baserow-php)[ RSS](/packages/stevecomrie-baserow-php/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (2)DependenciesVersions (9)Used By (0)

Baserow PHP client
==================

[](#baserow-php-client)

A PHP client for the Baserow.io API with human readable table and field names.

Comments, requests or bug reports are appreciated.

Getting started
---------------

[](#getting-started)

This library only manages CRUD operations using the Baserow API.

It can be used with both the SaaS hosted and self hosted versions.

For more information about the Baserow API, please see:

-
-

---

### Installation

[](#installation)

If you're using Composer, you can run the following command:

```
composer require "stevecomrie/baserow-php:main-dev"

```

You can also download the src files directly and extract them to your web directory.

### Add the client to your project

[](#add-the-client-to-your-project)

If you're using Composer, run the autoloader

```
require 'vendor/autoload.php';
```

Or include the Baserow.php file

```
include('../src/Baserow.php');
include('../src/Request.php');
include('../src/Response.php');
```

### Initialize the class

[](#initialize-the-class)

Only the `api_key` parameter is required, the rest are added as a reference.

You can create your API key through your Baserow.io dashboard.

```
use \Scomrie\Baserow\Baserow;

$baserow = new Baserow([
    'api_key' => 'API_KEY', // REQUIRED!!

    // if you are self hosting your own instance of Baserow, use this parameter to
    // point to the proper location on your server. defaults to the SaaS hosted endpoint.
    'api_url' => 'https://api.baserow.io/api/database/rows/table'

    // if set to true, will dump any errors with print_r() and exit on failure
    'debug' => false,

    // map of all tables & fields from auto-generated ###'s to human readable names
    'table_map' => []
]);
```

### Creating a human readable table map

[](#creating-a-human-readable-table-map)

Baserow uses incrementing integers for names when creating new tables and fields.

For example, tables are given IDs like:

- 10001
- 10002
- 10003, etc

And fields within a table are given names like:

- field\_1001
- field\_1002
- field\_1003, etc

This is obviously not ideal for long-term code readability and maintenance, but totally understandable given the current stage of Baserow development.

To make developer life a littler easier, you can configure a `table_map` parameter when creating a new instance of the Baserow client that lets you map these auto-generated IDs to human readable names.

#### Sample table map

[](#sample-table-map)

This is what a sample table map configuration might look like.

```
$table_map = [
	'Customers'  => [ 10001, [
		'firstName' =>  'field_1001',
		'lastName'  =>  'field_1002',
		'active'    =>  'field_1003',
		'projects'  =>  'field_1004',
	]],

	'Projects' => [ 10002, [
		'name'     => 'field_1005',
		'dueDate'  => 'field_1006',
		'customer' => 'field_1007',
	]],
];

```

You can find the table and field IDs generated by Baserow using the [API documentation for your database](https://baserow.io/api/docs/).

When you initialize the Baserow client with a `table_map` you are able to use your new human readable names anywhere that you would have previously used a table #### or field\_####.

The `table_map` parameter is optional, but the rest of the examples in this document will assume that you're using it.

#### Table map recommendations

[](#table-map-recommendations)

You probably don't want to use spaces in your human readable field names.

Your table map configuration will need to be manually updated if you add or remove fields.

In addition to maintaining your sanity when writing code, the table map configuration also make it possible to create a staging / production environment using two separate databases, each with their own table map.

Communicating with the API
--------------------------

[](#communicating-with-the-api)

### Retrieving a "page" of records from a table

[](#retrieving-a-page-of-records-from-a-table)

Get entries from the table "Contacts".

```
$response = $baserow->list( 'Contacts' );

print_r($response);
```

### Using $params to filter & sort records

[](#using-params-to-filter--sort-records)

You don't have to use all the params, they are added as a reference.

```
$params = array(
    "page" => 1,
    "size" => 100,
    "order_by" => "lastName",
    "filter__firstName__equal" => "Steve",
    "include" => "firstName,lastName",
);

$response = $baserow->list( 'Contacts', $params );
print_r($response);
```

The full list of available parameters for use with the `list()` or `all()` functions can be found within the [API documentation](https://baserow.io/api/docs/) that is automatically generated by Baserow for your database.

### Retrieving ALL records within a table

[](#retrieving-all-records-within-a-table)

If you need to return more than a single page of results, you can use the `all()` function to automatically retrieve the entire paginated result set.

```
$response = $baserow->all( 'Contacts', $params );
print_r($response);
```

### Creating a new record

[](#creating-a-new-record)

We will create new entry in the table Contacts

```
$newContact = [
	'firstName' => "Steve",
	'lastName'  => "Comrie",
	'active'    => true,
	'projects'  => [ 2 ],
];

if( $contact = $baserow->create( "Contacts", $newContact ) ) {
	echo "Created new contact: " . $contact->id . "\n";
} else {
	print_r( $baserow->error() );
}
```

### Updating an existing record

[](#updating-an-existing-record)

Use the row ID to update the entry

```
$contactID = 1;
$updatedFields = [
	'firstName' => "Steven",
	'active'    => false,
];

if( $baserow->update( "Contacts", $updatedFields, $contactID ) ) {
	echo "Contact updated!\n";
}
```

### Deleting a record

[](#deleting-a-record)

Use the row ID to delete the entry

```
$deleteContactID = 4;
if( $baserow->delete("Contacts", $deleteContactID ) ) {
	echo "Contact deleted!\n";
}
```

### Accessing API error messages

[](#accessing-api-error-messages)

Any time an API operation fails, you can access the reason for the failure using the `error()` function.

```
$error = $baserow->error();
print_r( $error );
```

Credits
-------

[](#credits)

Copyright (c) 2021 - Programmed by Steve Comrie.

Thanks to Bram Wiepjes for developing Baserow.io and to Sleiman Tanios whose Airtable API Client this library borrows from substantially.

###  Health Score

25

—

LowBetter than 37% of packages

Maintenance19

Infrequent updates — may be unmaintained

Popularity22

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity42

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~108 days

Recently: every ~9 days

Total

6

Last Release

1118d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/04feabe85950a47121653f8b5f37a4e9a96fdec0ff9d0e2e538ff0ed4b766aa3?d=identicon)[stevecomrie](/maintainers/stevecomrie)

---

Top Contributors

[![stevecomrie](https://avatars.githubusercontent.com/u/684903?v=4)](https://github.com/stevecomrie "stevecomrie (8 commits)")

---

Tags

baserowbaserow-apiphpapibaserow

### Embed Badge

![Health badge](/badges/stevecomrie-baserow-php/health.svg)

```
[![Health](https://phpackages.com/badges/stevecomrie-baserow-php/health.svg)](https://phpackages.com/packages/stevecomrie-baserow-php)
```

###  Alternatives

[jstolpe/instagram-graph-api-php-sdk

Instagram Graph API PHP SDK

13998.4k2](/packages/jstolpe-instagram-graph-api-php-sdk)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)