Automatisk opret MySQL table
Hejsa,jeg har følgende data som jeg ønsker at oprette en tabel ud fra.
Den skal lave alle disse felter som VarChar(500) hvordan gøres dette? Udover det, skal der være "id" som er autoincrement og index derpå.
Men hvordan splitter jeg mine $_SESSION['postVars'] og får værdierne frem og tilføjer som en MySQL table?
$_SESSION['postVar'] er:
Array
(
[0] => Array
(
[nova] => 0
[mileage] => Array
(
[1] => 25
)
[bpm] => 0
[fiscalepk] =>
[estax] => 0
[kmguarantypersonal] => 0
[kmguarantydetails2] => on
[kmguarantydetails4] => on
[kmguarantydetailsnote] => 3
[carcolourid] => 8m
[carcolourcode] => blå som lort
[lakglans] => 1
[cabincolourid] => 1
[stelno] => 232323
[plates] => 0
[regno] => 34
[sidstsynetmonth] => 1
[sidstsynetyear] => 1995
[synes] => 0
[boughtasnew] => 0
[previousowners] => -1
[ownertype] => 9
[imported] => 1
[importcountry] => LU
[steeringWheelSide] => 0
[debt] => 1
[submit] => Fortsæt »
)
[1] => Array
(
[equipasr] => on
[equipesp] => on
[equipairbag] => 0
[equipnecksupportback] => 0
[equipsportsseats] => on
[equipwood] => on
[equipseats] => 1
[equipadjstrwheel] => 0
[equipelecadjseats] => on
[equipspeedpilot] => on
[equipclima] => 1
[equipmusic] => 0
[equipsunroof] => 0
[equipcentrallock] => 0
[equipelecwindows] => 0
[equiplowered] => on
[equiproofedge] => on
[equiptractive] => 0
[equipwheels] => 1
[wheeltype] => 1
[wheelsize] => 16
[tirequalityfront] => 2
[tirequalityback] => 2
[equipextrawheels] => 0
[wheeltypeextra] => 2
[wheelsizeextra] => 15
[tirequalityfrontextra] => 2
[tirequalitybackextra] => 2
[equipothernote] => asdadsd
[equipextcostprice] => 23444
[n] => Fortsæt »
)
[3] => Array
(
[cabinstat] => 2
[cabinsmoke] => 0
[cabindog] => 0
[cabindefects] => 1
[cabindefectseatholes] => on
[cabindefectseatworn] => on
[cabindefectnotes] => asdsd
[lightsintact] => 0
[lightsfrontstatus] => 0
[lightsfogstatus] => 0
[lightsbackstatus] => 0
[frontrudeintact] => 0
[frontrudestatus] => 4
[bulerfronthjelm] => 0
[ridserfronthjelm] => 0
[rustfronthjelm] => 0
[stenslagfronthjelm] => 0
[standkofangerfor] => 0
[bulerfrontpanel] => 0
[rustfrontpanel] => 0
[stenslagfrontpanel] => 0
[bulervenstreforskaerm] => 0
[ridservenstreforskaerm] => 0
[rustvenstreforskaerm] => 0
[stenslagvenstreforskaerm] => 0
[bulervenstrefordoer] => 0
[ridservenstrefordoer] => 0
[rustvenstrefordoer] => 0
[stenslagvenstrefordoer] => 0
[standvenstresidespejl] => 0
[bulervenstredoerpanel] => 0
[rustvenstredoerpanel] => 0
[stenslagvenstredoerpanel] => 0
[bulervenstrebagdoer] => 0
[ridservenstrebagdoer] => 0
[rustvenstrebagdoer] => 0
[stenslagvenstrebagdoer] => 0
[bulervenstrebagskaerm] => 0
[ridservenstrebagskaerm] => 0
[rustvenstrebagskaerm] => 0
[stenslagvenstrebagskaerm] => 0
[bulerbagklap] => 0
[ridserbagklap] => 0
[rustbagklap] => 0
[standkofangerbag] => 0
[bulerbagpanel] => 0
[rustbagpanel] => 0
[stenslagbagpanel] => 0
[bulerhoejrebagskaerm] => 0
[ridserhoejrebagskaerm] => 0
[rusthoejrebagskaerm] => 0
[stenslaghoejrebagskaerm] => 0
[bulerhoejrebagdoer] => 0
[ridserhoejrebagdoer] => 0
[rusthoejrebagdoer] => 0
[stenslaghoejrebagdoer] => 0
[bulerhoejredoerpanel] => 0
[rusthoejredoerpanel] => 0
[stenslaghoejredoerpanel] => 0
[standhoejresidespejl] => 0
[bulerhoejrefordoer] => 0
[ridserhoejrefordoer] => 0
[rusthoejrefordoer] => 0
[stenslaghoejrefordoer] => 0
[bulerhoejreforskaerm] => 0
[ridserhoejreforskaerm] => 0
[rusthoejreforskaerm] => 0
[stenslaghoejreforskaerm] => 0
[bulertag] => 0
[ridsertag] => 0
[rusttag] => 0
[stenslagtag] => 0
[rustmotorrum] => 0
[rustbund] => 0
[exteriornotes] => asdd
[u] => Fortsæt »
)
[4] => Array
(
[omlakeret] => 1
[omlakeretstatus] => 1
[laknotes] => sdfdf
[earlierdamage] => 1
[earlierdamagenotes] => sdfdf
[earlieraccident] => 1
[earlieraccidentrepprice] => 1
[earlieraccidentfrontleft] => on
[earlieraccidentfrontmid] => on
[earlieraccidentfrontright] => on
[earlieraccidentsideleft] => on
[earlieraccidentsideright] => on
[earlieraccidentbackleft] => on
[earlieraccidentbackmid] => on
[earlieraccidentbackright] => on
[totaldamage] => 1
[damagecalculation] => 1
[mechdefects] => 1
[mechdefectmotor] => on
[mechdefectsteering] => on
[mechdefectnotes] => df
[elecdefects] => 1
[elecdefectignitionsystem] => on
[elecdefectelectricparts] => on
[elecdefectnotes] => sdf
[servicebook] => 1
[allservice] => 3
[servicenotes] => dsf
[servicekm] => 23
[nextservicekm] => 123
[tandremchanged] => 1
[tandremchangedkm] => 2323
[undervognsbehandlet] => 1
[exhaustchanged] => on
[willingtohavecarchecked] => 0
[submit] => Fortsæt »
)
)
