[Catalyst] How to insert from form to MySQL with autoincrement primary key?

Martin Ellison m.e at acm.org
Sun Dec 9 16:52:09 GMT 2007


WWVzLCBJIGhhZCBhIGZvcm0gZmllbGQgd2l0aCB0aGUgc2FtZSBuYW1lIGFzIHRoZSB0YWJsZSBr
ZXksIGJlY2F1c2UsIHdoZW4gSQpkbyBhbiB1cGRhdGUgb24gYW4gZXhpc3Rpbmcgb2JqZWN0LCBJ
IHdhbnQgdG8gc2F2ZSBpdHMga2V5IHZhbHVlIHNvbWV3aGVyZS4KLi4uSSd2ZSBwdXQgaW4gYSB0
ZXN0LCBzbyBpdCBvbmx5IGluY2x1ZGVzIHRoZSBmaWVsZCB3aGVuIEkgd2FudCB0byBkIGFuCnVw
ZGF0ZS4gU28gbm93IGl0IGlzIGZvcm11bGF0aW5nIHRoZSBJTlNFUlQgd2l0aG91dCB0aGUga2V5
IGZpZWxkLCB3aGljaCBpcwpnb29kLiBIb3dldmVyICRvYmotPmlkIGlzIHJldHVybmluZyB6ZXJv
LCBpbXBseWluZyB0aGF0IHRoZSBtb2RlbCBpcyBub3QKYmVpbmcgdXBkYXRlZCBhZnRlciB0aGUg
aW5zZXJ0LgoKU28gbm93IEkgYW0gdHJ5aW5nIHRvIHdvcmsgb3V0IGhvdyB0byBnZXQgdGhlIGxh
c3QgaW5zZXJ0IGlkLiBJIHRoaW5rIGlmIEkKY2FuIHJldHJpZXZlIHRoZSByZWxldmFudCBEQkl4
OjpTY2hlbWEgSSBzaG91bGQgYmUgYWJsZSB0byAgdXNlCiRzY2hlbWEtPnN0b3JhZ2UtPmxhc3Rf
aW5wdXRfaWQsIGJ1dCBJJ20gc3RpbGwgdHJ5aW5nIHRvIGZpbmQgb3V0ICBob3cgdG8KZ2V0IHRv
IHRoZSBzY2hlbWEuCgpBcyB0byB0aGUgbGF0ZXN0IGluIENhdGFseXN0IG1vZHVsZXMsIEkgd2Fz
IHVzaW5nIHdoYXQgdGhlIGRvY3VtZW50YXRpb24KcmVjb21tZW5kZWQuIEkgZG9uJ3Qgd2FudCB0
byByZXdyaXRlIGV2ZXJ5dGhpbmcgaW4gYW5vdGhlciBtb2R1bGUgbm93LgoKT24gMDkvMTIvMjAw
NywgQ2FybCBGcmFua3MgPGZpcmVhcnRpc3RAZ21haWwuY29tPiB3cm90ZToKPgo+IE9uIDA5LzEy
LzIwMDcsIE1hcnRpbiBFbGxpc29uIDxtLmVAYWNtLm9yZz4gd3JvdGU6Cj4gPiBTb3JycnksIHRo
aXMgaXMgYW5vdGhlciBuZXdiaWUgcXVlc3Rpb24uCj4gPgo+ID4gSSBhbSB1c2luZyBIVE1MOjpX
aWRnZXQgYW5kIERCSXg6OkNsYXNzIHRvIGRvIHNpbXBsZSBDUlVEIG9uIHNvbWUgTXlTUUwKPiA+
IHRhYmxlcy4gSSBoYXZlIGRlZmluZWQgYW4gYXV0by1pbmNyZW1lbnQgcHJpbWFyeSBrZXkgb24g
b25lIG9mIG15Cj4gdGFibGVzLAo+ID4gYW5kIEkgd2FudCB0byB1c2UgYW4gSFRNTCBmb3JtIHRv
IHBvcHVsYXRlIGFuZCBjcmVhdGUgYSBuZXcgb2JqZWN0LiBJCj4gdGhlbgo+ID4gd2FudCB0byBy
ZXRyaWV2ZSB0aGUgbmV3bHktZ2VuZXJhdGVkIGtleS4KPiA+Cj4gPiBTdXBbcG9zZSB0aGUgU1FM
IGhhczoKPiA+Cj4gPiBDUkVBVEUgVEFCTEUgbXl0YWJsZSAoCj4gPiAgICAgICAgIG15dGFibGVf
aWQgU01BTExJTlQgVU5TSUdORUQgTk9UIE5VTEwgQVVUT19JTkNSRU1FTlQsCj4gPiAgICAgICAg
dGl0bGUgVkFSQ0hBUig2NCkgTk9UIE5VTEwsCj4gPiAgICAgICAgIGRhdGUgVkFSQ0hBUigxMCkg
Tk9UIE5VTEwsCj4gPiAgICAgICAgUFJJTUFSWSBLRVkgKG15dGFibGVfaWQpOwo+ID4KPiA+IEhh
dmluZyByZWFkIHRoZSBleGFtcGxlcywgSSB0aG91Z2h0IHRoYXQgYWxsIEkgaGFkIHRvIGRvIGlz
Ogo+ID4KPiA+ICAgICAgICAgICAgIG15ICRvYmogPQo+ID4gJGMtPm1vZGVsKHF7TXlBcHBEQjo6
TXlUYWJsZX0pLT5uZXcoe30pOwo+ID4gICAgICAgICAgICAgICRvYmotPnBvcHVsYXRlX2Zyb21f
d2lkZ2V0KCRyZXN1bHQpOwo+ID4gICAgICAgICAgICAgbXkgJG5ld2lkID0gJG9iai0+bXl0YWJs
ZV9pZDsKPiA+Cj4gPiBidXQgSSBhbSBmaW5kaW5nIHRoYXQgdGhlIGdlbmVyYXRlZCBTUUwgaXMg
aW4gZmFjdCBzZXR0aW5nIHRoZSBrZXkgZmllbGQKPiB0bwo+ID4gemVybywgYW5kIHRoZW4gdGhl
IGxhc3QgbGluZSBvZiB0aGUgYWJvdmUgY29kZSBpcyBnZXR0aW5nIGFuIHVuZGVmaW5lZAo+IHZh
bHVlCj4gPiBiYWNrLgo+Cj4gSSBjYW4ndCByZW1lbWJlciBmb3Igc3VyZSBob3cgcG9wdWxhdGVf
ZnJvbV93aWRnZXQoKSB3b3JrcywgYnV0IEkKPiBzdXNwZWN0IHRoYXQgeW91J3ZlIGEgZmllbGQg
aW4geW91ciBmb3JtIGNvcnJlc3BvbmRpbmcgdG8gdGhlIHRhYmxlJ3MKPiAnaWQnIGNvbHVtbi4g
SWYgdGhhdCdzIGVtcHR5LCBwb3B1bGF0ZV9mcm9tX2Zvcm1mdSgpIG1heSBiZSB0cnlpbmcgdG8K
PiBibGFuayB0aGF0IGNvbHVtbiAoIiIpLCBhbmQgbXlzcWwncyBjb252ZXJ0aW5nIGl0IHRvIGEg
emVyby4KPiBZb3UgY2FuIHNlZSB0aGF0IGV4YWN0IFNRTCB0aGF0J3MgYmVpbmcgaXNzdWVkLCBi
eSBzZXR0aW5nIHRoZQo+IGVudmlyb25tZW50IHZhcmlhYmxlIERCSUNfVFJBQ0U9MQo+IElmIHRo
aXMgaXMgbmV3IGRldmVsb3BtZW50LCBIVE1MOjpXaWRnZXQgaXMgZGVwcmVjYXRlZCBpbiBmYXZv
dXIgb2YKPiBIVE1MOjpGb3JtRnUuCj4gSWYgeW91IGRlY2lkZSB0byBsb29rIGF0IEhUTUw6OkZv
cm1GdSwgdGFrZSBub3RlIHRoYXQKPiBEQkl4OjpDbGFzczo6SFRNTDo6Rm9ybUZ1IGlzIGFib3V0
IHRvIGJlIHJlcGxhY2VkIGJ5Cj4gSFRNTDo6Rm9ybUZ1OjpNb2RlbDo6REJJQywgd2hpY2ggaXMg
c3RpbGwgaW4gc3ZuLCBhbmQgd2lsbCBiZSByZWxlYXNlZAo+IHRvIGNwYW4gYXQgc29tZSBwb2lu
dCB0aGlzIG1vbnRoLgo+Cj4gQ2hlZXJzLAo+IENhcmwKPgo+IF9fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gTGlzdDogQ2F0YWx5c3RAbGlzdHMuc2NzeXMu
Y28udWsKPiBMaXN0aW5mbzogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4vbWFpbG1h
bi9saXN0aW5mby9jYXRhbHlzdAo+IFNlYXJjaGFibGUgYXJjaGl2ZToKPiBodHRwOi8vd3d3Lm1h
aWwtYXJjaGl2ZS5jb20vY2F0YWx5c3RAbGlzdHMucmF3bW9kZS5vcmcvCj4gRGV2IHNpdGU6IGh0
dHA6Ly9kZXYuY2F0YWx5c3QucGVybC5vcmcvCj4KCgoKLS0gClJlZ2FyZHMsCk1hcnRpbgoobS5l
QGFjbS5vcmcpCklUOiBodHRwOi8vbWV0aG9kc3VwcG9ydC5jb20gUGVyc29uYWw6IGh0dHA6Ly90
aGVyZWlzbm9lbmQub3JnCi0tLS0tLS0tLS0tLS0tIG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpB
biBIVE1MIGF0dGFjaG1lbnQgd2FzIHNjcnViYmVkLi4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lz
LmNvLnVrL3BpcGVybWFpbC9jYXRhbHlzdC9hdHRhY2htZW50cy8yMDA3MTIxMC8wNjU2MTVmZC9h
dHRhY2htZW50Lmh0bQo=


More information about the Catalyst mailing list