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
function br2nl($text) { return preg_replace('/<br\\s*?\/??>/i', '', $text);}