插入由主键链接的表
我有两张关系表
+----------------------+ +-----------------+
| Shape | | Point_Values |
+----------------------+ +-----------------+
| shape_id (KEY) | | id (KEY) |
| shape_name (VARCHAR) | | point_x (INT) |
+----------------------+ | point_y (INT) |
| shape_id (INT) |
+-----------------+
如何在同一个请求中获得形状和点的同时,如何构建一般的插入或CodeIgniter,这意味着当一个形状完成时,有一个点数组和形状名称/ id。我必须在表中插入,但两者都匹配shape_id。
按要求
排列
(
[name] =>“circle”
[points] =>数组
(
[x] =>数组
(
[0] => 182
[1] => 190
[2] => 215
[3] => 240
[4] => 291
[5] => 328
[6] => 364
[7] => 391
[8] => 425
[9] => 459
[10] => 487
[11] => 512
[12] => 529
[13] => 540
[14] => 551
[15] => 560
[16] => 570
[17] => 581
[18] => 592
[19] => 604
[20] => 617
[21] => 628
[22] => 635
[23] => 639
[24] => 642
[25] => 642
[26] => 640
[27] => 630
[28] => 619
[29] => 606
[30] => 591
)
[y] =>数组
(
[0] => 165
[1] => 159
[2] => 150
[3] => 147
[4] => 144
[5] => 144
[6] => 147
[7] => 152
[8] => 162
[9] => 172
[10] => 184
[11] => 199
[12] => 211
[13] => 219
[14] => 225
[15] => 228
[16] => 231
[17] => 232
[18] => 233
[19] => 233
[20] => 231
[21] => 222
[22] => 204
[23] => 189
[24] => 156
[25] => 133
[26] => 120
[27] => 100
[28] => 85
[29] => 69
[30] => 54
)
)
)
没有找到相关结果
已邀请:
2 个回复
程琶
如果你的情况不需要对钥匙进行严格的测试,我可能会把它变成一个foreach。
破弯
和
之间做出外键约束 首先插入形状表
然后获取last_insert_id
然后转到point_value表
我希望这会帮助你......寻求帮助 谢谢