php - 从另一个表中插入具有一个值的数据 Mysql

Question

我有一个问题， 如何将数据插入到数据库表 (mysql) 中，所有数据都从 php post 表单中检索，1 个数据从另一个表中检索？

PHP 获取:

$nama           = $_POST['nama'];
$alamat         = $_POST['alamat'];
$jenis_kelamin  = $_POST['jenis_kelamin'];
$shift          = $_POST['shift'];

插入查询:

    INSERT INTO test (`id`, `nama`, `alamat`, `jenis_kelamin`, `shift`) VALUES 
('$nama','$alamat','$jenis_kelamin', select id from shift where shift_name = '$shift')"

这是我尝试运行这些代码时的输出:

Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'select id from shift where shift_name = 'pagi')' at line 1

Answer 1

尝试使用 insert into select from

INSERT INTO test ( `nama`, `alamat`, `jenis_kelamin`, `shift`) 
   select '$nama','$alamat','$jenis_kelamin','$shift' from shift where shift_name = '$shift'