php mysql-uploading files with the same id

Question

i am creating an app that upload files in the database. for example i upload 3 files at the same time and i want their IDs to be the same. then i will upload again another batch of files and their IDs should also be the same but the id is now incremented. \

I am using two IDs DM_ID and id. DM_ID is auto incremented while id is not. I want to get the last value of id. DM_ID and id is in one table.

i tried this code but it is not working

$result = mysqli_query($con,"SELECT id from __scannedfiles order by id desc limit 1 ")  OR die(mysqli_error($con));
                $row = mysqli_fetch_array($result);
                $file_id = $row[0];


mysqli_query($con,"INSERT INTO __scannedfiles VALUES ('','$file_id'+1,'$file_title', '$file_name','$file_pic','$file_deptname','$file_doctype','$file_date','$file_desc')");

there is no error message, the id is still not the same for a batch of files. — user2335183
– user2335183, Commented May 9, 2013 at 6:58
Is ID an integer field? Otherwise order won't be as you expect — Fabio
– Fabio, Commented May 9, 2013 at 7:05

Your Common Sense · Accepted Answer · 2013-05-09 07:07:05Z

1

You need to have 2 tables.

One for whatever "batches" One for files

Both with autoincremented identifier. Before inserting into files table, insert into batch table, get an id, and then use it for inserts into files table

This way you will have proper identification.

answered May 9, 2013 at 7:07

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2335183 Over a year ago

how can i do that? i am new to php and mysql.

user2335183 Over a year ago

how can i set the ids to be the same?

Your Common Sense Over a year ago

insert into batch table, get an id, and then use it for inserts into files table

Niche · Accepted Answer · 2013-05-09 07:07:05Z

0

At first sight I might think you're inserting a new row with an empty '' id, which is not permitted. Try specifically stating which attributes you're assigning the values to in the INSERT statement.

mysqli_query($con,"INSERT INTO __scannedfiles(DM_ID, DM_NANE, DM_PIC, DM_DEPTNAME, DM_DOCTYPE, DM_DATE, DM_DESC) VALUES ('$file_id'+1,'$file_title', '$file_name','$file_pic','$file_deptname','$file_doctype','$file_date','$file_desc')");

edited May 9, 2013 at 7:07

answered May 9, 2013 at 6:58

Niche

9676 silver badges23 bronze badges

1 Comment

user2335183 Over a year ago

the empty '' if for DM_ID which is auto incremented.

Collectives™ on Stack Overflow

php mysql-uploading files with the same id

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related