156 lines
13 KiB
PHP
Executable File
156 lines
13 KiB
PHP
Executable File
<?php
|
|
/*
|
|
stan_standort sid bis 235
|
|
stand_ag_standort agsdi bis 420
|
|
*/
|
|
include("kurs/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
$db = dbconnect();
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Aalen', '1', '00.00.0000', 'V', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Aalen', '2', '00.00.0000', 'V', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Au (bei Freiburg)', '1', '00.00.0000', 'V', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Balingen', '2', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Balingen', '3', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Biberach', '3', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Biberach', '1', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Biberach', '1', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Biberach', '2', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Calw', '1', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Calw', '2', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Friedrichshafen', '2', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Friedrichshafen', '3', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Friedrichshafen', '1', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Göppingen', '1', '00.00.0000', 'P', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Göppingen', '2', '00.00.0000', 'V', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Heidelberg', '1', '00.00.0000', 'P', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Heilbronn', '1', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Heilbronn', '1', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Heilbronn', '2', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Heilbronn', '3', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Karlsruhe', '2', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Karlsruhe', '3', '00.00.0000', 'V', '29')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Karlsruhe', '1', '00.00.0000', 'V', '29')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Karlsruhe', '3', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Karlsruhe', '1', '00.00.0000', 'P', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Karlsruhe', '2', '00.00.0000', 'V', '29')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Konstanz', '1', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Lörrach', '2', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Lörrach', '3', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Lörrach', '2', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Lörrach', '1', '00.00.0000', 'V', '33')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '4')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Ludwigsburg', '2', '00.00.0000', 'P', '34')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Ludwigsburg', '3', '00.00.0000', 'P', '34')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Ludwigsburg', '1', '00.00.0000', 'P', '34')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '5')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Ludwigsburg (Stadt)', '2', '00.00.0000', 'P', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Mosbach', '3', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Mosbach', '1', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Mosbach', '2', '00.00.0000', 'V', '30')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Schwäbisch Hall', '2', '00.00.0000', 'V', '27')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Schwäbisch Hall', '3', '00.00.0000', 'V', '27')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Schwäbisch Hall', '1', '00.00.0000', 'V', '27')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '3')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Stuttgart', '2', '00.00.0000', 'P', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Stuttgart', '3', '00.00.0000', 'P', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Ulm', '1', '00.00.0000', 'V', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '1')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Villingen-Schwenningen', '2', '00.00.0000', 'V', '32')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Villingen-Schwenningen', '1', '00.00.0000', 'V', '25')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Villingen-Schwenningen 2', '1', '00.00.0000', 'V', '32')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '2')");
|
|
$sql = $db->query ("INSERT INTO stan_standort (standort, block, abdatum, pendler,maxteil) VALUES ('Waldshut', '1', '00.00.0000', 'P', '20')");
|
|
$sid = $db->insert_id;
|
|
$sql = $db->query ("INSERT INTO stan_ag_standort (sid, jahr, vbid) VALUES ('$sid', '14', '')");
|
|
|
|
?>
|