<?php 
    include "mysql.php"; 
  function getir($baslangic, $son, $cekilmek_istenen) 
  {    @preg_match_all('/' . preg_quote($baslangic, '/') . 
      '(.*?)'. preg_quote($son, '/').'/i', $cekilmek_istenen, $m);    return @$m[1];} 
  $tarih = date("d/m/Y H:i"); 
    echo '   <form action="kaydet.php" name="link" method="GET" id="form1"><div class="datagrid"><table><thead> 
  <tr><td>Firma</td><td>Pazaryeri</td><td>Adet</td><td>Tarih</td></tr></thead><tfoot><tr><td colspan="4"><div id="paging"><ul><li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=117734321&url=kaydet.php" data-href="kaydet.php"><span>Kaydet</span></a></li></ul></td></tr></tfoot><tbody>'; 
   while($kayit=mysql_fetch_array($sorgu)){ 
      echo '<tr>'; 
      echo '<td>'.$kayit["Firma_adi"].'</td>'; 
      echo '<td><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=117734321&url='.$kayit["Link"].'" target="_blank" data-href="'.$kayit["Link"].'" target="_blank">'.$kayit["Py_adi"].'</a></td>'; 
      echo '<td>';if($Py_adi=XX)   { 
         $url = $kayit["Linl"]; 
  $icerik = file_get_contents($url); 
  $urun_adedi = getir('<meta itemprop="numberOfItems" content="','">',$icerik); 
  echo "". $urun_adedi[0]; }  
    if($Py_adi=YY){ 
          $url = $kayit["Link"]; 
  $icerik = file_get_contents($url); 
  $urun_adedi = getir('<div class="totalItems">',' ürün var</div>',$icerik); 
  echo "" .$urun_adedi[0];}      '</td>'; 
      echo '<td>'.$tarih.'</td>'; 
      echo '</tr>';} 
   echo '</tbody></table></div> 
      
     <button type="submit" form="form1" value="Submit">Gönder</button></center>';   
     
      
  echo mysql_error(); ?>

 
  <?php 
  include("mysql.php"); 
     
  $kaydet = mysql_query("insert into example_autoincrement (id, Firma_id, Py_id, urun_adedi, cur_timestamp) values ('', '$Firma_adi', '$Py_adi', '$urun_adedi', '$tarih')"); 
            
  if($kaydet){ 
     header(sprintf("Location: " .$_SERVER['HTTP_REFERER'])); 
   } 
   else{ 
       echo "İşlem başarısız.."; 
       } 
   echo mysql_error(); 
  ?>