01.
<?
02.
ini_set
(
'mssql.textlimit'
,
'204800'
);
03.
ini_set
(
'mssql.textsize'
,
'204800'
);
04.
header(
"content-type:image/jpg;"
);
05.
06.
$Conn
= mssql_connect(
"21"
,
"sa"
,
"00"
)
or
die
(
"Error Connect to DB"
);
07.
$DB
= mssql_select_db(
"ims_data"
);
08.
$id
=
$_REQUEST
[
'id'
];
09.
10.
$q
=
"Select * From hr_pic Where emp_id = '110810001'"
;
11.
$Rs
= mssql_query(
$q
,
$Conn
)
or
die
(
" SQL can't display "
);
12.
13.
$row
= mssql_fetch_array(
$Rs
);
14.
$im
=
$row
[
"emp_pic"
];
15.
echo
$im
;
16.
17.
mssql_free_result(
$Rs
);
18.
mssql_close(
$Conn
);
19.
?>