data type changed

varchar => VARCHAR
float => FLOAT
New ER Diagram

changed gene_name as primary key
change gene_name as PK

gene_name is the primary key for all tables
updated prepareData.php

Everything works until line 96
Added index.php

dummy website to handle incoming excel data
able to read file

Use regular expression to detect cell format
skip blank cells
added config.php

config.php

1. set database connection parameters
2. establish database connection
change on prepareData.php

added require database connection config.php file
Added createJobID.php

steps:
1. get timestamp
2. generate 4-digit alphanumeric random string as salt
3. combine timestamp and salt as seed
4. generate unique ID from seed
5 cut first 4 digit and last 3 digit as jobID