Soboxpert Control Panel

ai.soboxpert.in · Residential & Commercial Property Management

266

Residential Projects

4

Commercial Projects

14

Contact Submissions

19

Seed Records Ready

All Pages

Residential Cards

Admin CRUD + Seed from JSON

Commercial Cards

Admin CRUD for commercial properties

Legacy Admin

Original residential admin panel

Card Display

Public card grid with filters

Search Bar

Public search + region tags

Luxury Properties

Public filtered listings

Properties

Public properties showcase

Residential API

JSON endpoint · action=read

Commercial API

JSON endpoint · action=read

Seed Data to DB

1

Open Residential Cards Admin

Go to residential_cards.php or click "Residential Cards" above.

2

Click "Seed from JSON"

Green button in the header. Reads residential_seed.json and bulk-inserts.

3

Review Toast Notification

Shows "Inserted: X, Skipped: Y". Duplicates by project_name are auto-skipped.

4

Verify in Table + Stats

The table auto-refreshes. Stats panel at top shows total count.

5

Test Public-Facing Pages

Open 1_Searchbar.php or cards.php to see the seeded cards live.

Verify Data in DB

1

Check via API (JSON)

Open Residential_api.php?action=read in browser. All projects returned as JSON.

2

Check Count on This Page

The stats cards at the top of this page show live DB counts. Refresh to update.

3

MySQL Direct Query

Run SELECT COUNT(*) FROM projects; in phpMyAdmin or MySQL CLI.

4

Spot-Check Individual Record

Run SELECT * FROM projects WHERE Region = 'Thane'; to see all Thane entries.

5

Test Public Filters

On 1_Searchbar.php, select "Thane" city, click "Ghodbunder Road" tag — should filter correctly.

API Reference

Endpoint Method Action Description
Residential_api.php GET action=read Fetch all residential projects
Residential_api.php GET action=seed Bulk-insert from residential_seed.json
Residential_api.php POST action=create Insert a new residential project
Residential_api.php POST action=update Update an existing project by id
Residential_api.php POST action=delete Delete a project by id
api_commercial.php GET action=read Fetch all commercial projects
api_commercial.php POST action=create Insert a new commercial project

Soboxpert Control Panel · Database: u293520579_version_7 · Table: projects