uploading special characters from excel to mysql and php binary/Image

[matech]

I have a problem with uploading special characters from excel files to
mysql 5. It doesn't matter if I use UTF-8 or iso-8859-1 when uploading
the trademark ™ symbol. htmlspecialchar s() or htmletities() doesn't
help? the database doesn't show the data in the field but replaces it
with the binary/Image information.

the following are examples of how I've tried loading the data along
with UTF-8 or iso-8859-1:
foreach ($SelectFields as $TempSelect) {
if($SelectedFie ldValues[$TempSelect] == ''){
$strSQLQuery .= "'',";
} else {
$strSQLQuery .=
"'".htmlentitie s(addslashes($S electedFieldVal ues[$TempSelect]))."',";
}
}

or

foreach ($SelectFields as $TempSelect) {
if($SelectedFie ldValues[$TempSelect] == ''){
$strSQLQuery .= "'',";
} else {
$strSQLQuery .=
"'".htmlentitie s($SelectedFiel dValues[$TempSelect])."',";
}
}

or

foreach ($SelectFields as $TempSelect) {
if($SelectedFie ldValues[$TempSelect] == ''){
$strSQLQuery .= "'',";
} else {
$strSQLQuery .=
"'".htmlspecial chars(addslashe s($SelectedFiel dValues[$TempSelect]))."',";
}
}

or

foreach ($SelectFields as $TempSelect) {
if($SelectedFie ldValues[$TempSelect] == ''){
$strSQLQuery .= "'',";
} else {
$strSQLQuery .=
"'".htmlspecial chars($Selected FieldValues[$TempSelect])."',";
}
}

[Captain Paralytic]

On 17 Jun, 15:47, matech <robert.mat...@ hotmail.co.ukwr ote:
I have read and re-read this post and I cannot manage to make it make
any sense.

I have a problem with uploading special characters from excel files to
mysql 5.

mysql is an RDBMS. You do not upload special characters to it. You
insert values into fields.

It doesn't matter if I use UTF-8 or iso-8859-1 when uploading
the trademark ™ symbol. htmlspecialchar s() or htmletities() doesn't
help? the database doesn't show the data in the field but replaces it
with the binary/Image information.

What do you mean by this? If I have a VARCHAR field, it can only hold
text. I will not see an image there.

the following are examples of how I've tried loading the data along
with UTF-8 or iso-8859-1:

foreach ($SelectFields as $TempSelect) {
* *if($SelectedFi eldValues[$TempSelect] == ''){
* * * $strSQLQuery .= "'',";
* *} else {
* * *$strSQLQuery .=
"'".htmlentitie s(addslashes($S electedFieldVal ues[$TempSelect]))."',";
* *}

}

Please show us where $SelectFields comes from, what data gets into
$TempSelect, what the table schema is, which field of the table
$TempSelect will be loaded into, what the value is that is found in
the field.

In other words, give us something concrete to work with.

[matech]

The following is the function used to upload the excel file.

function UploadProductTe mp($arrayDetail s) {
global $configTables;
extract($arryDe tails);
$ArrayFieldName = $this->GetFieldName(' product_temp');
foreach($ArrayF ieldName as $key=>$values){
if($values['Field'] != 'productID') $SelectFields[$values['Field']]
= $values['Field'];
}
function GetExcelExtensi on($file){
$revfile=strrev ($file); // Reverse the string for getting the
extension
$arr_t=explode( ".",$revfil e);
$file_type=$arr _t[0];
return strrev($file_ty pe); // File Extension
}
$file_type=GetE xcelExtension($ FilePath);
if($file_type== 'xls' || $file_type=='XL S') $supported=1;
else $supported=2;
if($supported>1 ){
echo "Sorry, File can't be uploaded, Please Upload only excel
file."; exit;
}else{
$Destination = $FilePath;
$Destination = 'upload/product.xls';
$obj=new product();
$objSupp=new supplier();
$data=new Spreadsheet_Exc el_Reader();
$data->read($Destinat ion);
for ($i = $startFrom+1; $i <= $data->sheets[0]['numRows']; $i++)
{
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
foreach ($SelectFields as $TempSelect) {
$sel = 's'.$TempSelect ;
$Selected = $$sel;
if($j==$Selecte d){
$SelectedFieldV alues[$TempSelect] =$data->sheets[0]
['cells'][$i][$j];
}
}
}
if(count($Selec tedFieldValues) 0 && $i>$startFrom){
if($obj->isProductExist s('product_temp ',
$SelectedFieldV alues['catalogNumber'])){
$strSQLQuery = "update bioscience_prod uct set ";
foreach ($SelectFields as $TempSelect) {
$strSQLQuery .=
$TempSelect."=' ".htmlentities( addslashes($Sel ectedFieldValue s[$TempSelect]))."',";
}
$strSQLQuery = rtrim($strSQLQu ery,",");
$strSQLQuery .= "where catalogNumber=' ".
$SelectedFieldV alues['catalogNumber']."'";
}else{
if(($SelectedFi eldValues['productName']!='') and
($SelectedField Values['catalogNumber']!='')) {
$strSQLQuery = "insert into product_temp(";
$strSQLQuery .= implode(",",$Se lectFields);
$strSQLQuery .= ")values(";

foreach ($SelectFields as $TempSelect) {
if($SelectedFie ldValues[$TempSelect] == ''){
$strSQLQuery .= "'',";
}else{
$strSQLQuery .=
"'".htmlentitie s(addslashes($S electedFieldVal ues[$TempSelect]))."',";
}
}
$strSQLQuery = rtrim($strSQLQu ery,",");
$strSQLQuery .= ")";
$this->query($strSQLQ uery, 0);
}
}
}
}
}
}
}