make a form with attachment

nectarapricot

Hi everybody,
How can we make attachment in our php form?
When we open the specific record, those attachments can be opened.

many thanks

dagon

nectarapricot;10947892 wrote:
Hi everybody,
How can we make attachment in our php form?
When we open the specific record, those attachments can be opened.

many thanks

are you talking about uploading a file?

if so: Handling file uploads

nectarapricot

thanks dagon,
I have tried this, we can upload file, save in specific table as downloa it whenever we want to
call it.

However what I intend to do is to attach (upload) several files that related to a particular record in a table. When we open those records (SELECT the RECORD), the attached files can be viewed as well.

Thanks for your response

dagon

include the filename\path in the db then you can add links to the file(s) when you show the db record

nectarapricot

thanks Dagon,
Could you please elaborate further details.
help is much appreciated.

dagon

as you can already upload files and add to db, I'm not sure what you need.

nectarapricot

ok,
I have a file, share.php
in this file, users can add details of a lesson plan.
besides they can also attch recources for that lesson plans.

when we access this lesson plan, we can open the attached file.
it seems that the ID of the lesson plan need to be similar to the attached file...
or any other way to do this.
thanks dagon

dagon

so the question is?

nectarapricot

questions
1. in my recent upload file, all details of the file is saved in a table name upload

$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

what I intend to do now is to save the uploaded file to a field name 'resources'-together with 10 other fields in table lesson.
how to uniquely identify the attachment to a specific lesson plan?
(because 1 field holds only one value, compared to table that can has many fields)

to view the details of uploaded file,I did like this
```
 $query = "SELECT id, name FROM upload";
```
,

however how can we do this if there is more that 1 uploded file?
thank you.

niroshan

Hi nectarapricot,

Well the best why i can think of is to have two tables.

lesson_plan

id primary key
-- rest of the fields --

resources

id primary key
plan_id foreign key to the lesson_plan table id field

so when ever someone enter lesson plan details just enter all the details to the lesson_plan table and enter uploaded file details into resources table. so in this way you dont have to worry about the no of resource files.

Hope this helps.

Best regards,
niroshan

nectarapricot

thank you.
I was thinking about this before.
However I did fulltext search from this table.
Therefore I cannot change from MyIsam to Innodb ( as relational database needs us to set the engine to InnoDb as far as I understand)

Anyone know whether this is possible or not?

thanks

niroshan

Hi nectarapricot,

No you dont need to change from MyIsam to Innodb.

as relational database needs us to set the engine to InnoDb as far as I understand

no thats not true. but InnoDb databases are transaction-safe meaning data-integrity is maintained throughout the entire query process.

EDIT::
I think i misunderstood you. your correct in one way. i mean InnoDb has some strong ability for foreign-key constraints. but to have simple relational database like this you dont specifically need to turn all the tables to innoDB.

Regards,
niroshan

nectarapricot

ok,
so I still need to change the engine to Innodb for the table that the foreign key taken from (lesson), isn' it?

it is like an attachment features in this posting screen. any example/script of this?
thanks

djjjozsi

I still need to change the engine to Innodb for the table that the foreign key taken from (lesson), isn' it?

Read the suggestion once, its telling you don't need to use innodb for a simple relation like this.

For a simple relation you can add a new field into the upload table, where you save the current lessonID as a foreign key.