Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- include "polacz.php";
- $statement = $dbh->prepare("TRUNCATE TABLE `0stan`");
- $statement->execute();
- // Wykonaj proste zapytanie, pobierz wersję
- // MSSQL i ją wyświetl.
- $version = mssql_query('SELECT @@VERSION');
- $row = mssql_fetch_array($version);
- echo '<DIV ALIGN=left><pre>';
- var_dump($row[0]);
- echo '</PRE></DIV>';
- //zaytanie = "SELECT * FROM tw__Towar " ;
- //$wyswietl = mssql_query("SELECT tw_Id,tw_Nazwa,tw_SWW,tw_Symbol FROM tw__Towar where tw_SWW like '%'");
- $wyswietl = mssql_query("SELECT tw_Id,tw_Nazwa,tw_SWW,tw_Symbol FROM tw__Towar ");
- echo 'produktow w bazie: ' . mssql_num_rows($wyswietl).'<br>';
- while($wiersz = mssql_fetch_array($wyswietl))
- {
- $zapstan = mssql_query("SELECT st_Stan FROM tw_Stan where st_TowId like '$wiersz[tw_Id]'");
- $stan = mssql_fetch_array($zapstan);
- $zapcena = mssql_query("SELECT tc_CenaNetto2 ,tc_Cenabrutto2 FROM tw_Cena where tc_IdTowar like '$wiersz[tw_Id]'");
- $cena = mssql_fetch_array($zapcena);
- $rekordy = $dbh->prepare("INSERT INTO `emc_baza`.`0stan` (`symbol`, `nazwa`, `stan`, `dostepne`, `detalicznanetto`, `detalicznabrutto`, `sww`, `hurtowanetto`, `hurtowabrutto`) VALUES ('$wiersz[tw_Symbol]', '$wiersz[tw_Nazwa]', '$stan[st_Stan]', '$stan[st_Stan]', '5', '6', '$wiersz[tw_SWW]', '$cena[tc_CenaNetto2]', '$cena[tc_Cenabrutto2]')");
- $rekordy->execute();
- mssql_free_result($zapstan);
- mssql_free_result($zapcena);
- //echo '<DIV ALIGN=left><pre>';
- //var_dump($cena);
- //echo '</PRE></DIV>';
- //echo $wiersz_sel['nazwa'].'<br>';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement