Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function setOgloszenia($ogloszenia){
- logger("setOgloszenia();\n".$ogloszenia);
- $host = 'db1.blue.pl';
- $port = '5432';
- $dbname = 'hestia_cms';
- $user = 'hestia_cms';
- $password = '4P0TdCiC';
- $connection_string = 'host='.$host.' port='.$port.' dbname='.$dbname.' user='.$user.' password='.$password;
- $conn = pg_connect($connection_string) or die("Brak połączenia");
- if(!$conn){
- return '<?xml version="1.0" encoding="utf-8"?><ROOT><STATUS>-1</STATUS><ERROR>Brak połączenia z bazą.</ERROR></ROOT>';
- }
- $query = "DELETE FROM kallisto._ogloszenia";
- pg_query($query);
- $count = substr_count(preg_replace('/<TAGI>.*?<\/TAGI>/', '', str_replace("\t", "", str_replace("\n", "", str_replace("\r", "", str_replace("\0", "", $ogloszenia))))), '<ITEM>');
- if($count == 0){
- return '<?xml version="1.0" encoding="utf-8"?><ROOT><STATUS>-2</STATUS><ERROR>Brak danych.</ERROR></ROOT>';
- }
- $ogloszenia = xml2array($ogloszenia);
- if($count == 1){
- $query = "INSERT INTO kallisto._ogloszenia (nrref, nstanow, miasto, wojew, o_oczekiw, o_zakresodp, o_coofer) VALUES ('".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['NRREF']['_v'])."', '".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['NSTANOW']['_v'])."', '".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['MIASTO']['_v'])."', '".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['WOJEW']['_v'])."', '".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['OGLOSZENIE']['_c']['OCZEKIW']['_v'])."', '".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['OGLOSZENIE']['_c']['ZAKRESODP']['_v'])."', '".
- trim($ogloszenia['ROOT']['_c']['ITEM']['_c']['OGLOSZENIE']['_c']['COOFER']['_v'])."')";
- pg_query($query);
- }else{
- foreach($ogloszenia['ROOT']['_c']['ITEM'] as $ogloszenie){
- $query = "INSERT INTO kallisto._ogloszenia (nrref, nstanow, miasto, wojew, o_oczekiw, o_zakresodp, o_coofer) VALUES ('".
- trim($ogloszenie['_c']['NRREF']['_v'])."', '".
- trim($ogloszenie['_c']['NSTANOW']['_v'])."', '".
- trim($ogloszenie['_c']['MIASTO']['_v'])."', '".
- trim($ogloszenie['_c']['WOJEW']['_v'])."', '".
- trim($ogloszenie['_c']['OGLOSZENIE']['_c']['OCZEKIW']['_v'])."', '".
- trim($ogloszenie['_c']['OGLOSZENIE']['_c']['ZAKRESODP']['_v'])."', '".
- trim($ogloszenie['_c']['OGLOSZENIE']['_c']['COOFER']['_v'])."')";
- pg_query($query);
- }
- }
- pg_close($conn);
- return '<?xml version="1.0" encoding="utf-8"?><ROOT><STATUS>0</STATUS></ROOT>';
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement