hi!
(B
(BI am first question of php in this news group. I would like to ask my (Bquestion about
(Bphp + mysql. Now I am programming php+mysql. I put word, excel, mpeg and (Bany binaries into
(Bthe mySQL database using php on linux server,But I can take out these binay (Bfrom mySQL database. I would like to see the files and save my pc from (Bserver. So how can I take out from
(Bthese binaries? If you know it how to take out and show it, please teach (Band help me how!!.
(BThe information table of mySQL is "objects." So here is the program below;
(B
(B// database information
(Bcreate table objects
(B b_col blob,
(B name varchar(30),
(B file_size varchar(30),
(B file_date datetime
(B}
(B// it works from "insert" SQL abc.php
(B $db = mysql_connect("*****", "***", "****");
(B mysql_select_db("***",$db);
(B $sql_insert = "INSERT INTO objects(b_col, file_name, file_size, (Bfile_type,file_date) VALUES (B('$UploadedFile','$UploadedFile_name','$UploadedFile_size','$UploadedFile_type',now())";
(B
(B mysql_query($sql_insert);
(B
(B//
(B// But it does not work at. I can not see anything in my browser
(B $sql_select = "select b_col, file_name, file_size, file_type, file_date (Bfrom objects where file_name like 'gball.gif'";
(B if(!($result=mysql_query($sql_select,$db))){
(B die;
(B }
(B
(B $file_name = mysql_result ($result,0,"file_name");
(B echo $file_name; (B
(B
(B
(BRegards,
(Bjames
(B
(B_________________________________________________________________
$BM'C#$H(B24$B;~4V%[%C%H%i%$%s!V(BMSN $B%a%C%;%s%8%c!http://messenger.msn.co.jp (B
(B-- (BPHP Database Mailing List (http://www.php.net/)
(BTo unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to