如何同时将上传表主键(ID)插入信息表(ID)？

Question

信息表查询：

CREATE TABLE `info` (
  `id_info` int(10) NOT NULL auto_increment,
  `judul_info` varchar(50) collate latin1_general_ci NOT NULL,
  `konten` varchar(255) collate latin1_general_ci NOT NULL,
  `diubah_oleh` varchar(20) collate latin1_general_ci NOT NULL,
  `id_kategori` int(10) NOT NULL,
  `tgl_buat` timestamp NOT NULL default '0000-00-00 00:00:00',
  `tgl_ubah` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `dibuat_oleh` varchar(20) collate latin1_general_ci NOT NULL,
  `id` int(10) NOT NULL,
  PRIMARY KEY  (`id_info`),
  KEY `id_kategori` (`id_kategori`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=62 ;

上传表查询：

CREATE TABLE `upload` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `deskripsi` text,
  `filetype` varchar(200) default NULL,
  `filedata` longblob,
  `filename` varchar(200) default NULL,
  `filesize` bigint(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

当我发布一个新信息时，我想插入与upload.id相同的info.id。请帮帮我。下面是我的源代码(很抱歉，我不能上传图像，因为我的声誉仍然很低)：

<?php
include "config.php";

$id_info=$_POST['id_info'];
$judul=$_POST['judul_info'];
$konten=$_POST['konten'];
$tgl_ubah=$_POST['tgl_ubah'];
$diubah_oleh=$_POST['diubah_oleh'];
$id_kategori=$_POST['id_kategori'];

// update data in mysql database 
$sql="UPDATE info SET judul_info='$judul', konten='$konten', diubah_oleh='$diubah_oleh', id_kategori='$id_kategori' WHERE id_info='$id_info'";
$result=mysql_query($sql);

// if successfully updated. 
if($result){
echo "Telah diupdate";
echo "<BR>";
echo "<a href='list_info.php'>View result</a>";
}

else {
echo "ERROR";
}

?>

Answer 1

您需要在插入到info表之后使用last_insert_id()或mysql_insert_id()来插入新的id，然后在下一个查询中使用该id，同时将记录插入到上传表中。请参考下面关于如何使用它们的链接。

http://dev.mysql.com/doc/apis-php/en/apis-php-function.mysql-insert-id.html http://php.net/manual/en/function.mysql-insert-id.php last-insert-id