<?php

function writeRecord($alanx1,$akodx1,$aurvx1,$akatx1,$adokx1,$alfkx1,$aortx1,$asokx1,$arubx1,$alokx1,$ahrdx1,$alkpx1,$atolx1,$abeax1,$abebx1,$atxtx1,$apubx1,$anumx1,$alanx2,$akodx2,$aurvx2,$akatx2,$adokx2,$alfkx2,$aortx2,$asokx2,$arubx2,$alokx2,$ahrdx2,$alkpx2,$atolx2,$abeax2,$abebx2,$atxtx2,$apubx2,$anumx2) {



set_time_limit(0);

$db = @mysql_connect("loopback", "soresigv", "Dox.rint") or die("Connection impossible at this time.");

@mysql_select_db("ortnamndb") or die("Selection impossible at this time.");



mysql_set_charset('utf8',$db);



$alanx1 = mysql_real_escape_string(trim($alanx1));

$akodx1 = mysql_real_escape_string(trim($akodx1));

$aurvx1 = mysql_real_escape_string(trim($aurvx1));

$akatx1 = mysql_real_escape_string(trim($akatx1));

$adokx1 = mysql_real_escape_string(trim($adokx1));

$alfkx1 = mysql_real_escape_string(trim($alfkx1));

$aortx1 = mysql_real_escape_string(trim($aortx1));

$asokx1 = mysql_real_escape_string(trim($asokx1));

$arubx1 = mysql_real_escape_string(trim($arubx1));

$alokx1 = mysql_real_escape_string(trim($alokx1));

$ahrdx1 = mysql_real_escape_string(trim($ahrdx1));

$alkpx1 = mysql_real_escape_string(trim($alkpx1));

$atolx1 = mysql_real_escape_string(trim($atolx1));

$abeax1 = mysql_real_escape_string(trim($abeax1));

$abebx1 = mysql_real_escape_string(trim($abebx1));

$atxtx1 = mysql_real_escape_string(trim($atxtx1));

$apubx1 = mysql_real_escape_string(trim($apubx1));

$anumx1 = mysql_real_escape_string(trim($anumx1));



$alanx2 = mysql_real_escape_string(trim($alanx2));

$akodx2 = mysql_real_escape_string(trim($akodx2));

$aurvx2 = mysql_real_escape_string(trim($aurvx2));

$akatx2 = mysql_real_escape_string(trim($akatx2));

$adokx2 = mysql_real_escape_string(trim($adokx2));

$alfkx2 = mysql_real_escape_string(trim($alfkx2));

$aortx2 = mysql_real_escape_string(trim($aortx2));

$asokx2 = mysql_real_escape_string(trim($asokx2));

$arubx2 = mysql_real_escape_string(trim($arubx2));

$alokx2 = mysql_real_escape_string(trim($alokx2));

$ahrdx2 = mysql_real_escape_string(trim($ahrdx2));

$alkpx2 = mysql_real_escape_string(trim($alkpx2));

$atolx2 = mysql_real_escape_string(trim($atolx2));

$abeax2 = mysql_real_escape_string(trim($abeax2));

$abebx2 = mysql_real_escape_string(trim($abebx2));

$atxtx2 = mysql_real_escape_string(trim($atxtx2));

$apubx2 = mysql_real_escape_string(trim($apubx2));

$anumx2 = mysql_real_escape_string(trim($anumx2));



echo "alan1=".$alanx1."\n";

echo "akod1=".$akodx1."\n";

echo "aurv1=".$aurvx1."\n";

echo "akat1=".$akatx1."\n";

echo "adok1=".$adokx1."\n";

echo "alfk1=".$alfkx1."\n";

echo "aort1=".$aortx1."\n";

echo "asok1=".$asokx1."\n";

echo "arub1=".$arubx1."\n";

echo "alok1=".$alokx1."\n";

echo "ahrd1=".$ahrdx1."\n";

echo "alkp1=".$alkpx1."\n";

echo "atol1=".$atolx1."\n";

echo "abea1=".$abeax1."\n";

echo "abeb1=".$abebx1."\n";

echo "apub1=".$apubx1."\n";

echo "anum1=".$anumx1."\n";

echo "atxt1=".$atxtx1."\n\n";



echo "alan2=".$alanx2."\n";

echo "akod2=".$akodx2."\n";

echo "aurv2=".$aurvx2."\n";

echo "akat2=".$akatx2."\n";

echo "adok2=".$adokx2."\n";

echo "alfk2=".$alfkx2."\n";

echo "aort2=".$aortx2."\n";

echo "asok2=".$asokx2."\n";

echo "arub2=".$arubx2."\n";

echo "alok2=".$alokx2."\n";

echo "ahrd2=".$ahrdx2."\n";

echo "alkp2=".$alkpx2."\n";

echo "atol2=".$atolx2."\n";

echo "abea2=".$abeax2."\n";

echo "abeb2=".$abebx2."\n";

echo "apub2=".$apubx2."\n";

echo "anum2=".$anumx2."\n";

echo "atxt2=".$atxtx2."\n\n";



$alfkx2 = addslashes($alfkx2);

$asokx2 = addslashes($asokx2);

$arubx2 = addslashes($arubx2);

$alokx2 = addslashes($alokx2);

$ahrdx2 = addslashes($ahrdx2);

$alkpx2 = addslashes($alkpx2);

$abeax2 = addslashes($abeax2);

$abebx2 = addslashes($abebx2);

$atxtx2 = addslashes($atxtx2);

$apubx2 = addslashes($apubx2);

$anumx2 = addslashes($anumx2);



//$sqlx = "INSERT INTO `edit1ut` SELECT * FROM `sort1in`;";

//$sqlx = "UPDATE `edit1ut` SET `alfk` = 'Blekinge' WHERE `alan` = 'kx';";



//$sqlx = "UPDATE `edit1ut` SET `alfk`='{$alfkx2}',`aort`='{$aortx2}',`asok`='{$asokx2}',`arub`='{$arubx2}',`alok`='{$alokx2}',`ahrd`='{$ahrdx2}',`alkp`='{$alkpx2}',`atol`='{$atolx2}',`abel`='{$abelx2}',`apub`='{$apubx2}',`anum`='{$anumx2}' WHERE (`alan`='{$alanx2}' AND `akod`='{$akodx2}' AND `aurv`='{$aurvx2}' AND `akat`='{$akatx2}' AND `adok`='{$adokx2}');";



//$sqlx = "UPDATE `ortnareg` SET `alfk`='{$alfkx2}',`aort`='{$aortx2}',`asok`='{$asokx2}',`arub`='{$arubx2}',`alok`='{$alokx2}',`ahrd`='{$ahrdx2}',`alkp`='{$alkpx2}',`atol`='{$atolx2}',`abel`='{$abelx2}',`abeb`='{$abebx2}',`atxt`='{$atxtx2}',`apub`='{$apubx2}',`anum`='{$anumx2}' WHERE (`alan`='{$alanx2}' AND `akod`='{$akodx2}' AND `aurv`='{$aurvx2}' AND `akat`='{$akatx2}' AND `adok`='{$adokx2}');";



//$sqlx = "UPDATE `ortnareg` SET `alfk`='{$alfkx2}',`aort`='{$aortx2}',`asok`='{$asokx2}',`arub`='{$arubx2}',`alok`='{$alokx2}',`ahrd`='{$ahrdx2}',`alkp`='{$alkpx2}',`atol`='{$atolx2}',`abea`='{$abeax2}',`abeb`='{$abebx2}',`atxt`='{$atxtx2}',`apub`='{$apubx2}',`anum`='{$anumx2}' WHERE (`alan`='{$alanx2}' AND `akod`='{$akodx2}' AND `aurv`='{$aurvx2}' AND `akat`='{$akatx2}' AND `adok`='{$adokx2}');";



$sqlx = "UPDATE `ortnaweb` SET `alfk`='{$alfkx2}',`aort`='{$aortx2}',`asok`='{$asokx2}',`arub`='{$arubx2}',`alok`='{$alokx2}',`ahrd`='{$ahrdx2}',`alkp`='{$alkpx2}',`atol`='{$atolx2}',`abea`='{$abeax2}',`abeb`='{$abebx2}',`atxt`='{$atxtx2}',`apub`='{$apubx2}',`anum`='{$anumx2}' WHERE (`alan`='{$alanx2}' AND `akod`='{$akodx2}' AND `aurv`='{$aurvx2}' AND `akat`='{$akatx2}' AND `adok`='{$adokx2}');";



echo $sqlx;



$result = mysql_query($sqlx, $db);

if($result){

 echo "\n\nUppdatering gjord!";

}else{

 echo "\n\nUppdateringen misslyckades!";

}

mysql_close($db);

} //Writerecord ends





//setlocale(LC_ALL, "sv_SE.iso-8859-1");



$x1 = strip_tags($_POST['xx1']);

$x2 = strip_tags($_POST['xx2']);

echo $x1."\n\n";

echo $x2."\n\n";



$arr1 = explode('|', $x1);

//print_r($arr1);

$arr2 = explode('|', $x2);

//print_r($arr2);



$alanx1 = $arr1[0];

$akodx1 = $arr1[1];

$aurvx1 = $arr1[2];

$akatx1 = $arr1[3];

$adokx1 = $arr1[4];

$alfkx1 = $arr1[5];

$aortx1 = $arr1[6];

$asokx1 = $arr1[7];

$arubx1 = $arr1[8];

$alokx1 = $arr1[9];

$ahrdx1 = $arr1[10];

$alkpx1 = $arr1[11];

$atolx1 = $arr1[12];

$abeax1 = $arr1[13];

$abebx1 = $arr1[14];

$atxtx1 = $arr1[15];

$apubx1 = $arr1[16];

$anumx1 = $arr1[17];



$alanx2 = $arr2[0];

$akodx2 = $arr2[1];

$aurvx2 = $arr2[2];

$akatx2 = $arr2[3];

$adokx2 = $arr2[4];

$alfkx2 = $arr2[5];

$aortx2 = $arr2[6];

$asokx2 = $arr2[7];

$arubx2 = $arr2[8];

$alokx2 = $arr2[9];

$ahrdx2 = $arr2[10];

$alkpx2 = $arr2[11];

$atolx2 = $arr2[12];

$abeax2 = $arr2[13];

$abebx2 = $arr2[14];

$atxtx2 = $arr2[15];

$apubx2 = $arr2[16];

$anumx2 = $arr2[17];



writeRecord($alanx1,$akodx1,$aurvx1,$akatx1,$adokx1,$alfkx1,$aortx1,$asokx1,$arubx1,$alokx1,$ahrdx1,$alkpx1,$atolx1,$abeax1,$abebx1,$atxtx1,$apubx1,$anumx1,$alanx2,$akodx2,$aurvx2,$akatx2,$adokx2,$alfkx2,$aortx2,$asokx2,$arubx2,$alokx2,$ahrdx2,$alkpx2,$atolx2,$abeax2,$abebx2,$atxtx2,$apubx2,$anumx2);



echo "\n\n";

//echo date("H:i:s");

//echo date("Y-m-d");

echo date("Y-m-d H:i:s");

?>