Binary_data table

Anon

I want to store
Binary_data (eg. files, pictures)
into a table that I name binary_data

However..
I know I need some columns to do this.
I got a script (I believe it was

from Daarius) to do this with.

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')");

As I understand I need:
Description (I can use Varchar)
bin_data (Have no idea)
filename (no idea)
filesize (no idea)
filetyps (no idea)

Is there anyone that knows
what to do..
And if so?, can you help me?

I already have a form where
you input: Desciption and
another one where you input the file.

/Chess

Anon

the data type in the db table should be 'blob' in which you are going to store the images etc.

and then in form, you need to have INPUT setup to file type. e.g:
(i will use the () brackets for HTML here, as it gets executed).

(INPUT TYPE="file" NAME="userfile")

and that will enable user to browse to file, and submit it.

make sure, that you then input the $userfile to the binary data type field in the db.

once the file is uploaded, then PHP can get the additional info for the image file you get. so for the following you can use the PHP functions to get the info:

if your NAME tag for the file was $file then we can use:

filename = $file_name;
filesize = $file_size;
filetype = $file_type;

thats it i guess.

Anon

How to script a Blob?

I couldn´t either find it
in my SQL-manual or my PHP-manual.

I couln´t find a script of this
at this page either.

How do I write a BLOB script?

Anon

Hopefully, this answers your question.

i.e.

create table images(
id int unsigned not null primary key,
image blob,
index img_IDX (id)
);

that's it for MySQL part

Anon

I am using Sybase :´(

Anon

ok,
create a table in your db, something like this:

create table images (image_id integer primary key auto_increment,
image blob,
image_name varchar(20),
image_size integer,
image_type varchar(20));

above will be the table in your db to hold the images in it, and their info.

and then in your form, from where you will submit the image, can be something like this:

sumitimage.php

<?php

if ($submit) {
if ($REQUEST_METHOD == 'POST') {

// just do the insert to your table in db
// with something like below ...
$sql = 'INSERT INTO image (image, image_name,
image_size, image_type)
VALUES ('$userfile', '$userfile_name', '$userfile_size', '$userfile_type')

// do the normal db stuff, i.e. connection
// querying etc.. and then close

}
else {
echo 'illegal request!';
}

}

<form ACTION="<?php echo "$PHP_SELF"; ?>" METHOD="POST">
<INPUT TYPE="file" NAME="userfile">
<INPUT TYPE="submit" VALUE="Submit">
</FORM>

thats it!

Daarius ...

Anon

It seems like there is no
auto_increment function in Sybase,
do you know why/how/what to do? 🙂

Im sorry for bugging you with questions
this much!

/Chess

Anon

its ok.. i am newbie too 🙂
this is only my 3rd week using PHP & mySQL.

well, mySQL has this auto_increment type, which increses each time an entry is made to the field. so you dont have to enter an ID value to every record you add. i am sure sybase must have any data type for unique field records. if you cant find, then just use a integer type, and make it primary key, and set it to be the index.

Anon

Sybase hasn´t:
BLOB function,
CHANGE,
auto_increment...

What is positive with Sybase?, apparently
I haven´t find out yet, and
it seems like I´m the only on here using
Sybase.

Anon

do 'have' to use sybase? why dont you switch to mySQL. its great! and free too!

Anon

Nar,
my work wants me to use Sybase.

How can you´ve learnt that much
of PHP in 3 weeks only?

(I´ve been in PHP-programming for 2 weeks)

But I don´t understand much, yet.

Have you some sort of education in PHP?
............

Gosh!, I have like 10-15 errors
on my pages. That won´t run..

BTW:
I´ve done as you said with that script
I shall put in (secured php-page).
But even when I login, I don´t get authorized.
...
/Chess

Anon

there must be something very minor in your script which is still calling the 'illegal attempt' message.

did you check the case sensitivity on your FORM and in your IF statement. do they match?

Anon

Yes, both uses 'post'
not 'POST' or 'Post'....
as you can see:

<form method="post" action= <? $php_self ?>>
(from index.php [LOGIN PAGE])

AND

if (strtolower($REQUEST_METHOD) == 'post') {
(from val.php [SECURED PAGE])

I believe the val.php don´t even feel the
Submit..
I tried to echo $person..
Without result.

Anon

if your varification script is not detecting the submit, then it wont be displaying the illegal message, because the REQUEST method is being check 'inside' the submit IF statement.

Anon

Yea,
but doesn´t that
mean, that...

If val.php don´t detect
Submit (from index.php).
Then it will automatically
jump to ELSE..

And we have the
"Sorry, error"
in the ELSE tag.

Anon

if the val.php doesnt detect submit, then it will jump to the parent IF statement, that says, sorry! cant access this way.. or whatever.

but the REQUEST method IF statement was inside the submit one, and the ELSE of request is being executed, that means the script is passing the submit IF condition.

Anon

Nah, This ELSE statement
is for the IF ($SUBMIT) statement, isn´t it?

<?php
if ($submit) {
if ($REQUEST_METHOD != '$POST'); {
?>

<head><title>Inloggad</title></head>
<body>
<h2>Vad vill du göra?</h2><p>
<a href="komm.htm">Mata</a> in ett kommando till DB?<br>
<a href="store.php">Infoga</a> en fil till DB?<br>
<a href="getdata.php">Mata</a> ut en fil från DB?<br>
<a href="input.php">Skriva</a> in en text till DB?<br>
<?
exit();
}
} else {
echo 'Sorry, Illegeal request';
}
?>
</body>

Anon

you had some minor things other way around!
let me correct it:

<?php
if ($submit) {
if ($REQUEST_METHOD != 'POST'); {
?>

<head><title>Inloggad</title></head>
<body>
<h2>Vad vill du göra?</h2><p>
<a href="komm.htm">Mata</a> in ett kommando till DB?<br>
<a href="store.php">Infoga</a> en fil till DB?<br>
<a href="getdata.php">Mata</a> ut en fil från DB?<br>
<a href="input.php">Skriva</a> in en text till DB?<br>
<?
exit();
} else {
echo 'Sorry, Illegeal request';
}
}
?>
</body>

Note: the POST DOES NOT need $.
and your else was on wrong side, and of course it was giving you errors!! 🙂

Anon

Well..
1st, I got Parse error..
So I deleted the ; on
3rd row (after the if statement).

Now all I get is a blank page.

/Chess

Anon

Try this!

<body>

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

	echo('<head><title>Inloggad</title></head><body>'. 
	'<h2>Vad vill du göra?</h2><p>'. 
	'<a href="komm.htm">Mata</a> in ett kommando till DB?<br> '.
	'<a href="store.php">Infoga</a> en fil till DB?<br> '.
	'<a href="getdata.php">Mata</a> ut en fil från DB?<br> '.
	'<a href="input.php">Skriva</a> in en text till DB?<br>');

exit(); 
}

} else {
echo 'Sorry, Illegeal request';
}
?>

</body>