Wordpress access
thelittlecopyshop.net/wp-admin
admin
Bonito98Jeer71Caftan72Winds33


KnewRaysAwardGigged
a99bb0ad_1
https://portal.nexcess.net/login


// SQL for user db

CREATE TABLE messages (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(50) NOT NULL,
email varchar(50) NOT NULL,
phone varchar(20) NOT NULL,
message varchar(400) NOT NULL
)

CREATE TABLE print_order (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(50) NOT NULL,
email varchar(50) NOT NULL,
phone varchar(20) NOT NULL,
print varchar(12) NOT NULL,
qty varchar(5) NOT NULL,
side varchar(1) NOT NULL,
file1 varchar(200) NOT NULL,
file2 varchar(200)
)


CREATE TABLE uploads (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(50) NOT NULL,
email varchar(50) NOT NULL,
file1 varchar(200),
file2 varchar(200)
)

CREATE TABLE users (
user_id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
first_name varchar(20) NOT NULL,
last_name varchar(30) NOT NULL,
email varchar(50) NOT NULL,
pwd varchar (12) NOT NULL,
user_pic_path varchar(200)
)

// SQL for images db
CREATE TABLE images (
image_id	int				AUTO_INCREMENT PRIMARY KEY,
filename	varchar(200)	NOT NULL,
mime_type	varchar(50)		NOT NULL,
file_size	int				NOT NULL,
image_data	mediumblob 		NOT NULL
)

create_user.php
1. db connection Lines 3-4
2. check image validity
3. build image insert sql statement, insert image into images table
4. build insert sql statement, insert user into users table
5. redirect to show_user.php

// Is this acceptable file type?
$file_type = $_FILES[$image_fieldname]['type']; //returns the mimetype
$allowed = array("image/jpeg", "image/gif", "application/pdf");
(in_array($file_type, $allowed)) 
 or	handle_error("You selected a file " .
                  "that isn't valid.",
                  "{$_FILES[$image_fieldname]['tmp_name']} " .
                  "isn't a valid image file.");