$sotr_id = 2;
$uploaddir = './img/photos/';
If (!empty($_FILES['userfile2']['name'])) {
$uploadfile = $uploaddir .$sotr_id.'_'. basename($_FILES['userfile2']['name']);
  if (move_uploaded_file($_FILES['userfile2']['tmp_name'], $uploadfile)) {
                $content  = file_get_contents($uploadfile); 
 		$sql  = "UPDATE MEDECINS_INFO SET Photo = '$content' where MEDECINS_ID = $sotr_id";
 		$stmt = odbc_exec($conn, $sql);
 };
};

$uploaddir = './img/photos/';

If (!empty($_FILES['userfile2']['name'])) {
$uploadfile = $uploaddir .$sotr_id.'_'. basename($_FILES['userfile2']['name']);

if(file_exists($uploadfile)) {unlink($uploadfile);}; 

if (move_uploaded_file($_FILES['userfile2']['tmp_name'], $uploadfile)) {

list($oldwidth, $oldheight, $type) = getimagesize($uploadfile);

	  switch ($type) {
       case IMAGETYPE_JPEG: $typestr = 'jpeg'; break;
      case IMAGETYPE_GIF: $typestr = 'gif' ;break;
       case IMAGETYPE_PNG: $typestr = 'png'; break;
   }
   
$content = file_get_contents($uploadfile); 
$content = base64_encode($content);

 		$sql  = "EXEC SGZ_WEB_POSTIMG 1, '$content', $sotr_id,'$typestr'";
 		$stmt = odbc_exec($conn, $sql);

};
};

CREATE FUNCTION [dbo].[udfBase64_DecodeChar]
    (@Char char(1))
RETURNS INT
BEGIN
    DECLARE @Val int
    SET @Val = ASCII(@char)
   
    RETURN    (
                SELECT CASE
                    WHEN @Val >= 65 AND @Val <=  90  THEN @Val - 65
                    WHEN @Val >= 97 AND @Val <= 122  THEN @Val - 71
                    WHEN @Val >= 48 AND @Val <=  57  THEN @Val + 4
                    WHEN @Val = 43                     THEN 62
                    WHEN @Val = 47                     THEN 63
                    ELSE NULL
                    END
            )
END

CREATE FUNCTION [dbo].udfBase64_Decode
    (@Base64 VARCHAR(max))
RETURNS VARBINARY(MAX)
AS
BEGIN
    DECLARE @output VARBINARY(MAX)
WHILE LEN(@Base64) > 0
    BEGIN
        DECLARE @CharVal1 INT, @CharVal2 INT, @CharVal3 INT, @CharVal4 INT,
                @Val1 varbinary(1), @Val2 varbinary(1), @Val3 varbinary(1), @Val4 INT
        SELECT    @CharVal1 = [dbo].[udfBase64_DecodeChar](SUBSTRING(@Base64, 1, 1))
                , @CharVal2 = [dbo].[udfBase64_DecodeChar](SUBSTRING(@Base64, 2, 1))
                , @CharVal3 = [dbo].[udfBase64_DecodeChar](SUBSTRING(@Base64, 3, 1))
                , @CharVal4 = [dbo].[udfBase64_DecodeChar](SUBSTRING(@Base64, 4, 1))
        SELECT @Val1 = @CharVal1 * 4 + @CharVal2 / 16
                , @CharVal2 = @CharVal2 - ((@Charval2 / 16) * 16)
        SELECT @Val2 = @CharVal2 * 16 + @CharVal3 / 4
                , @CharVal3 = @CharVal3 - ((@Charval3 / 4) * 4)
        SELECT @Val3 = @CharVal3 * 64  + @CharVal4
        SELECT @Output = ISNULL(@Output,CONVERT(varbinary(max),''))
                        + @Val1
                        + ISNULL(@Val2,CONVERT(varbinary(max),''))
                        + ISNULL(@Val3,CONVERT(varbinary(max),''))
        SET @Base64 = SUBSTRING(@Base64,5,LEN(@Base64))
    END
    RETURN @Output
END

ALTER procedure SGZ_WEB_POSTIMG @type int, @src varchar(MAX), @MEDECINS_ID int, @FILE_EXT varchar(10)
AS
BEGIN

if @type = 1
begin
UPDATE MEDECINS_INFO 
SET PHOTO = dbo.udfBase64_Decode(@src), 
      PHOTO_FILE_EXT = @FILE_EXT  
WHERE MEDECINS_ID = @MEDECINS_ID
end

END