# GreenStreets

**Repository Path**: DYX021210/green-streets

## Basic Information

- **Project Name**: GreenStreets
- **Description**: 2023 Start-upc UQ & China
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2023-06-22
- **Last Updated**: 2024-06-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

HELLO MONKEYS

Here is what you do to host your own local website.

1. Download a server hosting program. WAMP for Windows, XAMPP for Mac.
2. Create My_SQL database named greenstreets
3. Create 'user' table

Run this SQL in greenstreets database you jus created

CREATE TABLE IF NOT EXISTS `users` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `username` varchar(50) NOT NULL,
 `email` varchar(50) NOT NULL,
 `password` varchar(50) NOT NULL,
 `trn_date` datetime NOT NULL,
 PRIMARY KEY (`id`)
 );

 here is a tutorial for full login/registration: https://www.allphptricks.com/simple-user-registration-login-script-in-php-and-mysqli/

4. Create a rubbishlocation table, with fields
camear id (key), integer
photoid (key, auto-incriment) integer
latitude (float)
longitude (float)
time (datetime)

5. Download all html and php fiels in my website project folder, and place them in your
apache server directory.
This goes in
C:/wamp64/www/project/