mysql + php

From: Date: Mon, 08 Dec 2003 20:10:15 +0000
Subject: mysql + php
Groups: php.db 
Request: Send a blank email to php-db+get-31939@lists.php.net to get a copy of this message
hi! I am first question of php in this news group. I would like to ask my question about php + mysql. Now I am programming php+mysql. I put word, excel, mpeg and any binaries into the mySQL database using php on linux server,But I can take out these binay from mySQL database. I would like to see the files and save my pc from server. So how can I take out from these binaries? If you know it how to take out and show it, please teach and help me how!!. The information table of mySQL is "objects." So here is the program below; // database information create table objects
         b_col blob,
         name varchar(30),
         file_size varchar(30),
         file_date datetime
} // it works from "insert" SQL abc.php $db = mysql_connect("*****", "***", "****"); mysql_select_db("***",$db); $sql_insert = "INSERT INTO objects(b_col, file_name, file_size, file_type,file_date) VALUES ('$UploadedFile','$UploadedFile_name','$UploadedFile_size','$UploadedFile_type',now())"; mysql_query($sql_insert); // // But it does not work at. I can not see anything in my browser $sql_select = "select b_col, file_name, file_size, file_type, file_date from objects where file_name like 'gball.gif'"; if(!($result=mysql_query($sql_select,$db))){
     			die;
     	}
              $file_name = mysql_result ($result,0,"file_name");
              echo $file_name; 
Regards, james _________________________________________________________________ 友達と24時間ホットライン「MSN メッセンジャー」、今すぐダウンロード! http://messenger.msn.co.jp

« previous php.db (#31939) next »