GearLog-IT-Asset-Tracker

KO | EN

gitlite — search

#python #hacktoberfest #llm #go #android #deep-learning #linux #nodejs #cli #awesome-list #vue #pytorch #openai #ios

GearLog-IT-Asset-Tracker

(★ 20)

GearLog an IT Asset Tracker with search feature

GearLog-IT-Asset-Tracker Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# GearLog — IT Asset Tracker

A PHP/MySQL web application for tracking IT hardware inventory.  
Built with vanilla PHP, PDO, and MySQL. No frameworks required.

---

## 📁 File Structure

```
gearlog/
├── admin_login.php       — Login page
├── dashboard.php         — Main inventory dashboard (search, delete)
├── add_asset.php         — Register a new device
├── edit_asset.php        — Edit an existing device  
├── logout.php            — Session logout           
├── db.php                — Database connection
├── generate_hash.php     — Password hash utility
└── web_server_session.sql — Database schema + seed data
```

---

## 🚀 Setup Instructions (XAMPP / WAMP)

### Step 1 — Import the Database
1. Start Apache and MySQL in XAMPP/WAMP.
2. Open **phpMyAdmin** → click **Import**.
3. Select `web_server_session.sql` and click **Go**.
4. This creates the `gearlog_db` database with all tables and a default admin.

### Step 2 — Place Files
Copy all `.php` files into your web server's root folder:
- **XAMPP:** `C:/xampp/htdocs/gearlog/`
- **WAMP:** `C:/wamp64/www/gearlog/`

### Step 3 — Configure Database (if needed)
Open `db.php` and update credentials if your MySQL setup differs:
```php
$user = 'root';
$pass = '';   // no password set
```

### Step 4 — Open in Browser
Navigate to: `http://localhost/gearlog/admin_login.php`

---

## 🔑 Default Login

| Field    | Value                 |
|----------|-----------------------|
| Email    | admin@gearlog.com     |
| Password | password              |

---

## 🐛 Login Still Not Working?

The most common cause is a mismatched password hash in the database.

**Fix:**
1. Open `http://localhost/gearlog/generate_hash.php` in your browser.
2. Copy the generated hash.
3. In phpMyAdmin, run:
   ```sql
   UPDATE admins SET password = 'PASTE_HASH_HERE' WHERE email = 'admin@gearlog.com';
   ```
4. Try logging in again.

---

## ✨ Features

- 🔐 Secure session-based admin login (`password_hash` / `password_verify`)
- 📊 Live dashboard with asset count and total inventory value
- 🔍 Search assets by name or serial number
- ➕ Register new hardware with category, price, and status
- ✏️ Edit existing asset details
- 🗑️ Delete assets with confirmation prompt
- 🛡️ SQL injection protection via PDO prepared statements
- 🎨 Glassmorphism UI with responsive layout

---

## License

MIT — see `LICENSE` file

GearLog-IT-Asset-Tracker

GearLog-IT-Asset-Tracker Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

GearLog-IT-Asset-Tracker

GearLog-IT-Asset-Tracker Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README