Thanks for helping;
I can understand my mistake. My zip files size larger than 64 k because of
this if i use blob field my zip does nt works.
My script is :
For upload
----------------------------------------------------------------------------
------------------
<?php
include("dblib.php");
if ( $submit){
$data_1 = addslashes( fread ( fopen ( $fupload, "r" ),
filesize($fupload) ) );
$result=mysql_query("INSERT INTO $mysql_table1_name (data) VALUES
('$data_1')",$link);
if ( ! $result ) die ("Hata" .mysql_error());
$id= mysql_insert_id();
}
?>
<html>
<title>Usa Rice Veri Girisi</title>
<body>
<form action="<?php print $PHP_SELF ?>" enctype="multipart/form-data"
method="POST">
<input type="hidden" name="actionflag" value="upload">
Data<br>
<input type="file" name="fupload">
<br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
----------------------------------------------------------------------------
------------------------
For retrieve
----------------------------------------------------------------------------
----------------------
<?
header ("Content-type: application/x-zip-compressed");
include ("dblib.php");
$result = mysql_query("SELECT * FROM $mysql_table1_name WHERE id=$id",
$link);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
ob_start();
echo $row[data];
ob_end_flush();
?>
----------------------------------------------------------------------------
-----------------------
-----Original Message-----
From: Tim Endres [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 6:19 PM
To: Aziz Durmaz; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Problem in BLOB Field with zips
What size are the ZIP files? The default BLOB field has a size
limit of 64KB. If your ZIP files are larger, they are being clipped.
Use MEDIUMBLOB or whatever is most appropriate for your needs.
tim.
> How we can import a zip file into the blob field ?
>
> I can import zip file into mysql but when i export it. The zip files
doesnt
> works. And its size becames smaller.
>
> Is there anybody can help me???
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
