Back to Steven's Portfolio Static Preview · Live App Runs on PHP + MySQL
Parsec
Fine-art space photography

Posters from the edge of the observable universe.

A full-stack storefront built in PHP and MySQL: customer and seller accounts, a live product catalogue, cart and checkout with real stock tracking. This page is a static preview of the design; the working app runs locally with a real database behind it.

Built with PHP · MySQL · mysqli (prepared statements)
10Products Seeded
2Account Roles
5Database Tables
100%Real Photography
Under the hood

A real checkout, not a mockup

Every screen below is backed by an actual MySQL database. Customers and sellers log in with bcrypt-hashed passwords, and a checkout writes real order rows and decrements real stock.

Customer

Browse & Checkout

Customers register, browse the catalogue, add prints to a cart, and check out. Checkout inserts an order, logs each line item, and decrements stock, all in prepared statements.

Seller

Manage the Catalogue

Sellers get a separate dashboard to add new listings, monitor stock levels with a low-stock flag, and review every order that's come through.

Data

users · items · cart · orders · order_items

Five related tables with foreign keys, unique constraints and a stock guard that stops orders from overselling a print.

The catalogue

What's in stock

Real astrophotography, priced and tracked in the live database.

Orion Nebula poster

Orion Nebula

A stellar nursery 1,344 light-years away.

€24.0012 in stock
Saturn poster

Saturn in True Color

The ringed giant captured mid-orbit.

€22.009 in stock
Apollo 11 visor poster

The Visor

Buzz Aldrin on the Sea of Tranquility.

€28.004 in stock
Astronaut in zero gravity poster

Zero Gravity

Suspended above Earth's curve.

€26.0010 in stock
Galactic core poster

Galactic Core

The blazing heart of the Milky Way.

€25.007 in stock
Bubble Nebula poster

Bubble Nebula

A star's wind carving a sphere in space.

€24.006 in stock
Falcon 9 launch poster

Falcon Launch

Ignition at Cape Canaveral.

€23.003 in stock
Full moon poster

Full Moon

Every crater in perfect focus.

€18.0020 in stock
Meteor over mountain peaks poster

Meteor Over the Peaks

A lone streak crossing an alpine sky.

€20.008 in stock
Earth at night poster

Earth at Night

The night side, mapped in city lights.

€22.0011 in stock
Seller view

Inventory, at a glance

The seller dashboard pulls straight from the same items table, with a low-stock flag driven by real quantities.

NamePriceStock
Orion Nebula€24.0012
The Visor€28.004
Falcon Launch€23.003
Full Moon€18.0020

Want to see it running?

The full app, with accounts, cart, checkout and a seller dashboard, runs locally on PHP and MySQL. Source available on request.

Get in Touch