CSV2MySQL convert from CSV file into MySQL database

How to convert from CSV file into MySQL database using PHP?
Plus how to create a table and fields into database with PHP?
Here it is..
We need 3 files php, and 2 file jpg (the jpg is just for menu).

index.php
http://jawaad.pastebin.com/f6399baf4

upload_csv.php
http://jawaad.pastebin.com/f2c7bdbee

create_table.php
http://jawaad.pastebin.com/f64b250cc


And image files:

Java hex2text convert

Here is the code for converting hex into a normal char.
JAVA CODE:

public static String hex2Text(String str){
if(str == null || str.trim().length() == 0)
return "";
str = str.trim();
str = str.toLowerCase(); //ensures all input is lower case
if(str.matches("[^0-9a-f\\s]")){
/*
User needs to be warned that their input is invalid
Method must terminate
*/
return ""; //Until proper exception can be written
}
StringTokenizer tokenizedStr = new StringTokenizer(str);
StringBuffer text = new StringBuffer();
while(tokenizedStr.hasMoreTokens()){
String hexString = tokenizedStr.nextToken();
int bytelen = hexString.length();
if(bytelen > 4){
//User needs to be told input is not valid
return ""; //Until exception can be written.
}
int decimal = hex2decimal(hexString);
int intValue = 0;
for(int i = 0;i < strlen;++i){
int oneOrZero = decimal % 10;
decimal /= 10;
intValue += Math.pow(2,i) * oneOrZero;
}//end for
char textEquivalent = (char) intValue;
text.append(textEquivalent);
}//end while
return text.toString();
}

private static int hex2decimal(String hex){
int decimal = 0;
for(int i = hex.length() - 1;i >= 0;--i){
int asciiValue = hex.charAt(i);
if(asciiValue >= '0' && asciiValue <= '9')
asciiValue -= 48;
else{
asciiValue -= 87;
}
decimal += Math.pow(16,i) * asciiValue;
}//end for
return decimal;
}//end hex2decimal()

Convert HEX2TEXT

Converting hex into a text or normal string.
PHP CODE

function hex2text($hexstr) {
$hex = explode('%',$hexstr);
array_shift($hex);
$str = '';
foreach($hex as $hexcode) {
$str .= chr(base_convert($hexcode, 16, 10));
}
return $str;
}

PHP insert blob and update blob MySQL

Here is how to insert file BLOB MySQL.
PHP CODE:

if($_POST[submit]){
$file_name = $_FILES['file']['name'];
$tmp_name = $_FILES['file']['tmp_name'];
$file_size = $_FILES['file']['size'];
$file_type = $_FILES['file']['type'];
$fp = fopen($tmp_name, 'r');
$file_content = fread($fp, $file_size) or die("Error: cannot read file");
$file_content = mysql_real_escape_string($file_content) or die("Error: cannot read file");
fclose($fp);
// INSERT
$qu = "INSERT INTO `file`
(`file_content`,`file_name`,`file_type`,`file_size`)
VALUES
('$content','$file_name','$file_type','$file_size')";
$re = mysql_query($qu) or die ("Sorry Cant insert db!");
echo $file_name." inserted succesfully to database";
}
echo "< form method=\"post\" name=\"form1\" enctype=\"multipart/form-data\">";
echo " < input name=\"file\" type=\"file\">";
echo " < input name=\"submit\" type=\"submit\" value=\"Upload\">";
echo "< /form>";

How to Protect from double posting insert MySQL

Submit once even the visitor is refresh the page from browser.
Here is the way to protect.
Use a SESSION.
1. Set a session in the form page

session_start();
$_SESSION[post_only_once] = 1;
echo "
< form method=\"post\">
Name < input type=\"text\" name=\"name\">
< input type=\"submit\" value=\"submit\" name=\"submit\">
< /form>
";


2. Check the session before doing INSERT into MySQL.
session_start();
if($_SESSION[post_only_once] == 1) {
// here doing insert to mysql
}
unset($_SESSION[post_only_once]); // remove the session after insert

How to connect MySQL from PHP

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

PHP br2nl function

PHP CODE