Saving/Reading File from DB???

Anon

How do I do this?

I have tried a couple of examples
for...... 1½ week now, without any sucess.

Is there anyone who knows this better than me
(I bet most of you peeps do)

Thanks thanks.. and thanks
/Chess

Anon

You'll have to specify your problem more clearly please.

Do you want to open a file FROM a db or A DB file?

And, more specificly, what do you want to do with whatever content you have? Save a file TO a db or a whole DB FILE?

Anon

<?php

<HEAD><TITLE>Store</TITLE></HEAD>
<BODY>

<?php

if ($submit) {

$sybase = sybase_connect("a" , "b" , "");
sybase_select_db("c");

$data = addslashes(fread(fopen($form_data,  "r"), filesize($form_data)));

$result=sybase_QUERY( "INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
     "VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");

$id= sybase_num_rows($result);
print  "<p>This file has the following Database ID: <b>$id</b>";

SYBASE_CLOSE();

} else {

<form method="post" action= <?php $PHP_SELF ?>>
File Description:<br>
<input type="text" name="form_description"  size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data"  size="40">
<p><input type="submit" name="submit" value="submit">
</form>

<?php

}

</BODY>

Anon

<?php
if($submit) {
if($id !=''){

$sybase = sybase_connect("a" , "b" , "");
sybase_select_db("c");

$query = "select bin_data, filetype from binary_data where id=$id";
$result = @sybase_QUERY($query);

$data = @sybase_result($result,0, "bin_data");
$type = @sybase_result($result,0, "filetype");

header("Content_type: $type");
echo $data;

}} else {

$idquery = sybase_query("Select * from binary_data");
print "";
print "<head><title>Getdata</title></head>";
print "<body>";
?>

Skriv HELA filnamnet: <input type="Text" name="id"> <br>
<input type="Submit" name="submit" value="Enter Information"><INPUT TYPE=RESET VALUE="Reset Information">
</form>
</body>

<?
}
?>

Anon

So, you want to take any file and put into a sybase db with description or file, size etc.

What is then the problem? PHP? or the DB?
If you've set up the DB correctly then it should be able to accept a file.
The only PHP error I can see from a quick look is the enctype.
It should be
<form ENCTYPE="multipart/form-data" method="post" action= <?php $PHP_SELF ?>>

Anon

Well, I am not sure
in where the problem is..
I get the following error
when I´m trying to run this
script..

Warning: fopen("C:\phptest\1-2.php","r") - No such file or directory in /www/htdocs/testa/kedja/store.php on line 18

Warning: Supplied argument is not a valid File-Handle resource in /www/htdocs/testa/kedja/store.php on line 18

Warning: Sybase message: Invalid column name 'description'. (severity 16) in /www/htdocs/testa/kedja/store.php on line 21

Warning: 0 is not a Sybase result index in /www/htdocs/testa/kedja/store.php on line 23

I´ll try to do what you said now, and change my form!
Thanks!

Anon

🙁

I get the following errors:

Warning: fopen("C:\phptest\1-2.php","r") - No such file or directory in /www/htdocs/testa/kedja/store.php on line 18

Warning: Supplied argument is not a valid File-Handle resource in /www/htdocs/testa/kedja/store.php on line 18

Warning: Sybase message: Invalid column name 'description'. (severity 16) in /www/htdocs/testa/kedja/store.php on line 21

Warning: 0 is not a Sybase result index in /www/htdocs/testa/kedja/store.php on line 23

Anon

Hmmm,
Do you use Apache on win32? If so, make sure you never use / anywhere.
In php.ini do you use the upload_dir? If so:
upload_tmp_dir = c:/temp ;correct
upload_tmp_dir = c:\temp ;incorrect

Does, at all, C:\phptest\1-2.php exist? or is it temporary file?

I had a similar problem when I wanted to copy uploaded images to my server. I changed the \ to / and voila!

Med Vanliga Halsningar, Peter

Anon

Where am I supposed to have had some / in my
script..

And juppies, the C:\phptest\1-2.php
Do exist, and it cannot be wrongspelled
since I use a browse button.
And where to change \ to / ?

(Det e inte latt for en 18-aring att lara sig PHP & Sybase pa 3 veckor pa egen hand)..

Anon

Check your php.ini file and search for upload_tmp and make sure it has no \ .

Anon

Sorry everyone (I will ask in Swedish)

Jag hittar inte php.ini eftersom
den ligger någonstans på nätverket.
Jag har sökt efter den på "Den Här Datorn"
Utan resultat!

/Chess

Anon

Vad har du for server? Vilket platform?

Pa NT ligger den oftast i C:\winnt\system32
Pa Windows98 "" "" " C:\windows\system
Pa Linux "" "" " /etc/....

Det du vill gora ar val att ladda upp en fil och sedan kopiera den till ett temp dir och SEN spara den i db'n? Inte sant?

Anon

Neppz,
besides så när jag söker
på "Den här datorn" Så borde han ju
känna igen den i så fall!

Anon

Hmm.

Du kan alltsa inte hitta php.ini (den kanske ar dold) pa din server dator.
Vem installerade php pa den? Du?

Anon

Nee, det var en kompis

Varför skulle den vara dold?

Anon

PHP3 eller PHP4 fungerar inte utan php.ini. Inte sa vitt jag vet i alla fall.

Anon

Nej, det tordes inte vara så.

Dock har jag gjort en massa exempel
och sidor här.

Och de har alla fungerat.
Så, om PHP e beroende av php.ini
så ligger den här nånstans
(trots att Start/Sök inte hittar honom)
.....
Jag förstår ingenting!