dsbruqxgt820011351 2013-04-25 23:43
浏览 10
已采纳

php mysqli输入行号到备用列

My database is set up like this


article_id     article_name     article_seo

    12            test a         /test-a

I would like for the article_seo to have the article id within it!

$articleseo=$article_id.'/'.$newurltitle.'.html'; // article_id is undefined

so when it is uploaded to the database it will look like this


article_id     article_name     article_seo

    12            test a         12/test-a

So my question is what what the variable $article_id have to be in order to achieve this

  • 写回答

2条回答 默认 最新

  • dsfsdfsdfsdfsdf45454 2013-04-25 23:51
    关注

    is the article_seo artribute the way you show the link to the article page? If so, none of this should be stored in the database in the first place, and instead it should be part of the code. That would help you with your question too, since the link would be created when displaying the data, so there's no need to work around this issue.

    If you want/need to do this anyway, and if you are distributing ids in increments (auto_increment), you can use MySQL Trigger to get the id of the next item assigned, which will correspond to the last article.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 找驱动QTR2774-SU-IBM版本驱动
  • ¥15 NeRF的代码复现以及人工智能入门
  • ¥15 centos如何做一个可以让ikuai连接的openvpn
  • ¥15 Protege 中的Entities下面的界面删除了如何复原
  • ¥15 scrapy爬虫求帮
  • ¥15 imageEnView绘图问题
  • ¥15 关于#python#的问题:您好可以加您一下联系方式吗,在复现的时候确实有点问题难以解决
  • ¥15 联想电脑重装系统时无法发现硬盘
  • ¥15 MATLAB与UR10e实体机械臂建立通讯
  • ¥15 c++题需要快一点不用opencv