DEV Community

Cover image for PHP Supabase Comments
Santhosh Veer
Santhosh Veer

Posted on

PHP Supabase Comments

Hi all! 😊

After a long year, I’m finally publishing a post on dev.to!

I’ve created a simple comment system built using PHP and Supabase. This project was inspired from Supacomments dev by @mcnaveen - Blazing fast comment system with Sveltejs and Supabase

Features

  • PHP (7.4 to 8.x.x) support
  • Supabase for storing comments in the database
  • Pagination for comments
  • Modern and responsive UI using Bulma CSS
  • Comprehensive security for input forms and spam prevention
  • Cloudflare Turnstile for additional spam protection

This project is completely free and open-source! Feel free to fork the GitHub repository and customize according it to your needs. 😊

GitHub logo mskian / php-supabase-comments

A Simple Comment system built using PHP and Supabase.

PHP Supabase Comments

A simple comment system built with PHP and Supabase.

Features

  • PHP (7.4 to 8.x.x) support
  • Supabase for storing comments in the database
  • Pagination for comments
  • Modern and responsive UI using Bulma CSS
  • Comprehensive security for input forms and spam prevention
  • Cloudflare Turnstile for additional spam protection

setup

-- Create the table with necessary fields
CREATE TABLE user_comments (
    id SERIAL PRIMARY KEY,            -- Auto-incrementing primary key
    name VARCHAR(255) NOT NULL,        -- Name of the user (max length 255)
    comment TEXT NOT NULL,            -- Comment field to store user input
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- Timestamp with timezone
);
Enter fullscreen mode Exit fullscreen mode
## Supabase
supabaseUrl=https://example.supabase.co
apiKey=
pkey=
table=comments
## Cloudflare turnstile
secretKey=
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up

Retry later