如何在PHP中将附件id与oracle插入的数据id（序列id）链接起来 [英] How to link attachment id with the oracle inserted data id(sequence id) in PHP

问题描述

我正在开发一个在php和后端运行的web开发项目是oracle。我创建了一个表单，将用户提要数据插入到具有唯一序列号的数据库中，并且我有一个单独的表单，允许用户在需要时使用唯一的时间戳ID附加任何附件。

现在我面临的问题是我想从数据库中获取唯一的序列ID（序列号）并使用唯一的时间戳id映射它，以便任何人点击时间戳id它应该打开一个超链接的附件。

请帮帮我们。



我的尝试：



我能够从数据库中获取唯一的时间戳id，但是无法从数据库中获取唯一的序列号（序列ID）。我创建了一个触发器以及一个序列来插入唯一的在将数据插入数据库之前的id。

请帮帮我们。

I am working on a web development projet which runs on php and backend is oracle. I have created a form tat inserts user feed data into database with unique serial numbers and I have a separate form tat allows user to attach any attachment if required with unique timestamp id.
Now the problem tat I am facing is I want to fetch the unique serial id (sequence no.) from the database and the map it with the unique timestamp id so that if anyone clicks on the timestamp id it should open a attachment that is hyperlinked.
Please help me guys.

What I have tried:

I was able to fetch the unique timestamp id from the database but was not able to fetch the unique serial number(sequence id) from the database.I have created a trigger along with a sequence to insert the unique id before inserting data into database.
Please help me out guys.

推荐答案

用户包含附件及其反馈;他/你以后再加上。



你最后一次发送电子邮件并发送附件的时间是什么时候？



其他任何事情都是毫无意义的复杂性。

Users INCLUDE attachments WITH their "feedback"; they / you DON'T ADD IT LATER.

When was the last time you sent an Email and sent the "attachements" LATER?

Anything else is pointless complexity.

这篇关于如何在PHP中将附件id与oracle插入的数据id（序列id）链接起来的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！