keep me on track...(please)

lukeurtnowski

Im trying to create a mysql table so i can add about 6 images and a bunch of other data from a form.
(http://scasp.com/testing/request.shtml)
I have no idea how to set up the MySQL table to be linked to this form (heres what I have so far.
CREATE TABLE PROVIDER (
ID INT(5) NOT NULL auto_increment,
ASP_Real_Name VARCHAR,
ASP_Name VARCHAR(20),
ASP_Phone VARCHAR(15),
Display_Phone VARCHAR(2),
ASP_Email VARCHAR(30),
Display_Email VARCHAR(2),
ASP_Website VARCHAR(30),
ASP_Ethnicity VARCHAR(20),
ASP_Age VARCHAR(5),
ASP_Eye VARCHAR(10),
ASP_Hair_Length VARCHAR(10),
ASP_Build VARCHAR(10),
ASP_Height VARCHAR(10),
ASP_Bust VARCHAR(6),
ASP_Cup VARCHAR(4),
ASP_Implants VARCHAR(2),
ASP_Waist VARCHAR(5),
ASP_Hips VARCHAR(5),
ASP_Grooming VARCHAR(20),
On_Time VARCHAR(2),
ASP_Rate VARCHAR(10),
Availability VARCHAR(10),
Services VARCHAR(200),
Rules VARCHAR(100),
Piercings VARCHAR(10),
Tatoos VARCHAR(10),
Reviews_URL VARCHAR(30),
Who TEXT,
Attire VARCHAR,
Image_1 VARCHAR,
Image_2 VARCHAR,
Image_3 VARCHAR,
Image_4 VARCHAR,
Image_5 VARCHAR,
Image_6 VARCHAR,
PRIMARY KEY (ID)
)
Please take a look and let me know if I'm on the right track...Thanks

Houdini

CHAR VARCHAR and INT types need a size and not sure what some of your varchar values should be and can be adjusted for the common terms used by your users. So here is a suggestion with sizes of fields, you might also want an id field or make one of the fields a PRIMARY KEY (it need to be unique, so usually it would be an id field).

CREATE TABLE PROVIDER
(ASP_Real_Name VARCHAR(40),
ASP_Name VARCHAR(30),
ASP_Phone VARCHAR(15),
Display_Phone VARCHAR(15),
ASP_Email VARCHAR(50),
Display_Email VARCHAR(50),
ASP_Website VARCHAR(50),
ASP_Ethnicity VARCHAR(15),
ASP_Age SMALLINT(3),
ASP_Eye VARCHAR(15),
ASP_Hair_Length VARCHAR(15),
ASP_Build VARCHAR(15),
ASP_Height VARCHAR(15),
ASP_Bust VARCHAR(10),
ASP_Cup VARCHAR(10),
ASP_Implants VARCHAR(10),
ASP_Waist VARCHAR(15),
ASP_Hips VARCHAR(15),
ASP_Grooming VARCHAR(25),
On_Time VARCHAR(15),
ASP_Rate VARCHAR(15),
Availability VARCHAR(15),
Services VARCHAR(35),
Rules VARCHAR(35),
Piercings VARCHAR(25),
Tatoos VARCHAR(25),
Reviews_URL VARCHAR(50),
Who VARCHAR(50),
Attire VARCHAR(40),
Image_1 VARCHAR(40),
Image_2 VARCHAR(40),
Image_3 VARCHAR(40),
Image_4 VARCHAR(40),
Image_5 VARCHAR(40),
Image_6 VARCHAR(40)
)

lukeurtnowski

Made some changes

CREATE TABLE PROVIDER (
ID INT(5) NOT NULL auto_increment,
ASP_Real_Name VARCHAR,
ASP_Name VARCHAR(20),
ASP_Phone VARCHAR(15),
Display_Phone VARCHAR(2),
ASP_Email VARCHAR(30),
Display_Email VARCHAR(2),
ASP_Website VARCHAR(30),
ASP_Ethnicity VARCHAR(20),
ASP_Age VARCHAR(5),
ASP_Eye VARCHAR(10),
ASP_Hair_Length VARCHAR(10),
ASP_Build VARCHAR(10),
ASP_Height VARCHAR(10),
ASP_Bust VARCHAR(6),
ASP_Cup VARCHAR(4),
ASP_Implants VARCHAR(2),
ASP_Waist VARCHAR(5),
ASP_Hips VARCHAR(5),
ASP_Grooming VARCHAR(20),
On_Time VARCHAR(2),
ASP_Rate VARCHAR(10),
Availability VARCHAR(10),
Services VARCHAR(200),
Rules VARCHAR(100),
Piercings VARCHAR(10),
Tatoos VARCHAR(10),
Reviews_URL VARCHAR(30),
Who TEXT,
Attire VARCHAR(15),
Image_1 VARCHAR(40),
Image_2 VARCHAR(40),
Image_3 VARCHAR(40),
Image_4 VARCHAR(40),
Image_5 VARCHAR(40),
Image_6 VARCHAR(40),
PRIMARY KEY (ID)
)
that ok?
How do I ensure the image is either a jpg or gif (and not too big in terms of file size and dimensions?)

Houdini

Are you planning on storing images in the database or using just a link to the folder and filename?

lukeurtnowski

Well, what do you recommend? I thought the 2nd way was the only way.

Houdini

I would store the link to the file in the database, otherwise you would have to use a BLOB data type for the images or possibly a LARGEBLOB (Binary Large Object), so your structure right now is alright, then you would use file functions to check for filesize parameters and possibly a regex for allowing only gif or jpeg or jpg files, but I would possibly also allow also png files for images.

You could use this simple preg_match() function to check for gifs or jpg (jpeg). Use it after a file has been uploaded (if it is not too large).

$url="http://somewhere.com/images/test.jpeg";
if (preg_match("/(.+?).(gif|jpg|jpeg)/i",$url)){
echo $url. "<br /> Is a jpeg or jpg or gif.";
//or do something here with the file.
}
	else {
  	echo$url."<br /> Is not a jpeg or jpg or gif.";
  	//or do something different

Oops you also have one flaw in this line

ASP_Real_Name VARCHAR,

It need a size also (15) or something that wont truncate.

liquorvicar

I'm not sure Houdini's solution for checking the file type is very robust - I could create any file with a .jpeg extension and upload it, it wouldn't necessarily be a jpeg file. You'd be better off using exif to check the file format.