Re: [PHP-DB] Insert File in a Database

2001-05-24 Thread Anderson Sone

Didn´t work... i already changed the upload_max_file.
It isn´t inserting large string in a DB... Only 4Kb!


  Miguel Loureiro [EMAIL PROTECTED] escreveu na mensagem 
006501c0e42c$aa66c650$[EMAIL PROTECTED]">news:006501c0e42c$aa66c650$[EMAIL PROTECTED]...
  I think that to upload a bigger files you must change in php.ini the value referent 
of upload_max_file.
  Maybe it solve your problem...
  Este e' portugues. Felicidades...
  Good luck, good code
  CARPE DIEM

  Best Regards
  mailto:[EMAIL PROTECTED]




[PHP-DB] TEXTSIZE and TEXTLIMIT

2001-05-24 Thread Anderson Sone

Where can i configure it?
The defult value is 4096 bytes (4Kb).

I´m using php + Sql Server

Tks.

Anderson



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] TEXTSIZE and TEXTLIMIT

2001-05-24 Thread Anderson Sone

ye...  i had already done it


Miles Thompson [EMAIL PROTECTED] escreveu na mensagem
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Haven't the foggiest idea -- but php.ini would be a good place to start, or
search the manual for these terms.
Miles

At 12:32 PM 5/24/01 -0300, Anderson Sone wrote:
Where can i configure it?
The defult value is 4096 bytes (4Kb).

I´m using php + Sql Server

Tks.

Anderson



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] Here is the code...

2001-05-24 Thread Anderson Sone

What´s wrong?
I did it, but only 4Kb was inserted in a field...
I used field like : NText, Text, Binary... in a Sql Server.

See the code :
__
?

if ($action == upload) {

$arquivo = str_replace(,\\,$arquivo);

// Faz UPLOAD
copy($arquivo,$arquivo_name);

//Abre o arquivo
$data = fopen($arquivo_name, r);
//Le o conteudo do arquivo
$conteudo = fread($data,filesize($arquivo_name));
$conteudo = bin2hex ($conteudo);

$con = mssql_connect(SERVIDOR,sa,);
mssql_select_db(DB, $con);

$result =  mssql_query (INSERT INTO ARQUIVOS (ARQ_NOME,ARQ_DADOS)
VALUES ('$arquivo_name','$conteudo'),$con);

exit;
}

?

html
head
titleUPLOAD/title
/head

body bgcolor=#Fge89j
brbrbrbr brbrbrbr
center
form action=upload.php3 method=POST enctype=multipart/form-data
input type=hidden name=MAX_FILE_SIZE value=9
INPUT TYPE=hidden NAME=action VALUE=upload
bArquivo.: /binput name=arquivo type=file
input type=submit value=Enviar
/form

/body
/html




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] Error message

2001-05-23 Thread Anderson Sone

What it means?? I see it in a SQL Query from MSSQL 2000

Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] Blob or Link?

2001-04-11 Thread Anderson Sone

Blob or link?
Insert just the link is the better way?
Does the security is the same?

Thanks,
Anderson Sone

 No things of all

 Only upload the file, move to the right location and insert the file link
 (location path) into the database.

 READY!

 Bey,
 Daniel Kieviet
 Xsarus Internetservices
 Holland

 - Original Message -
 From: "Lucio Stoco" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, April 11, 2001 4:11 AM
 Subject: Re: [PHP-DB] Uploading file into database


  Have you done the file upload into the database?
  I´m having some problem to put the file (like .doc or .xls) in a
 database...
  I´m using 'text' field type, is it right?
 
  Do you have any example about it?
 
  Tks.
 
  ""Zeus"" [EMAIL PROTECTED] escreveu na mensagem
  01e601c0c26e$6ccded80$735518d2@zeus">news:01e601c0c26e$6ccded80$735518d2@zeus...
  I'm trying to do a filexchange script.
 
  Does anyone know how to upload a file into the database such that when I
 do
  a 'select *' query, I can click on a link the download that file.
 
 
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]
  To contact the list administrators, e-mail: [EMAIL PROTECTED]
 


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]