Panowie mam kod:
$pdo = new db_connect(); $sql = $pdo->prepare('SELECT * FROM `auta` WHERE `pid` > 0 AND `pid` < 99999 ORDER BY `pid` ASC LIMIT 250'); $sql->execute(); $ile = $sql->rowCount(); $dodajID = ''; $data = ''; while ($row = $sql->fetch()) { $dodajID .= $row['pid'].';'; //zbieramy ID auta $OldDate[] .= $row['data'].','; }
$url = 'https://www.blaeeabla.pl/get&id='.$dodajID; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC); curl_setopt($ch, CURLOPT_USERPWD, "$login:$password"); $output = curl_exec($ch); curl_close($ch);
http://www.php.net/preg_match_all("/<td class='auto_id'>(.*?)<\/td>/", $output, $id_auto); http://www.php.net/preg_match_all("/<td class='data'>(.*?)<\/td>/", $output, $getData); for($i = 0; $i < $ile; $i++){ $pid = http://www.php.net/strip_tags($id_auto[0][$i]); $data = http://www.php.net/strip_tags($getData[0][$i]); if($data != ''){ $addDate = $data; }else{ $addDate = $OldDate[$i]; } try{ $pdo = new db_connect(); $sqlUpd = $pdo->prepare('UPDATE `auta` SET `data` = :data WHERE `pid` =:pid LIMIT 1'); $sqlUpd->bindValue(':pid', $pid, PDO::PARAM_INT); $sqlUpd->bindValue(':data', $data, PDO::PARAM_INT); $sqlUpd->execute(); } catch(PDOException $e) { http://www.php.net/echo 'Błąd: ' . $e->getMessage(); } http://www.php.net/echo $i. ' - ' .$pid.' - '. $data .' }
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)