// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// bağlantıyı test et

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

} 



$sql = "SELECT * FROM custom_assets";

$result = $conn->query($sql);



 


 ?>

<h3><b><?php echo "Results " . "(".$result->num_rows.")"; ?></b></h3>
<?php if ($result->num_rows > 0) {
  



    // her bir satırı döker

    while($row = $result->fetch_assoc()) {
        
        
        
        echo "<tr>";
        
        
        
        
        echo "<td class=oguz>";
  echo  "  ".$row["id"]."<br>";

echo "</td>";





        echo "<td class=oguz>";
        echo '<img src="'.$row["image_thumb"].'" alt="" class="yuvarlak" />';
        echo  " | ".$row["symbol"]."<br>";
         echo " <small>(" .$row["name"]. ")</small>";
        echo "</td>";
 
 

        
 

echo "<td class=oguz>";
echo '<a target="_blank" href="https://twitter.com/'.$row["twitter"]. '"><img src="https://cdn.cdnlogo.com/logos/t/96/twitter-icon.svg" alt="" class="yuvarlak" />';
echo '&nbsp;';
echo '<a target="_blank" href="https://t.me/'.$row["telegram"]. '"><img src="https://upload.wikimedia.org/wikipedia/commons/thumb/8/82/Telegram_logo.svg/2048px-Telegram_logo.svg.png" alt="" class="yuvarlak" />';
echo '&nbsp;';
echo '<a target="_blank" href="'.$row["website"]. '"><img src="https://toppng.com/uploads/preview/web-png-jpg-transparent-stock-website-icon-blue-11563644926reanjnmk6x.png" alt="" class="yuvarlak" />';        
        
        echo "</td>";

echo "<td class=widget>";
  echo  "  ".$row["widget"]."<br>";

echo "</td>";

 echo "<td class=oguz id=oguz>";
        echo '<a target="_blank" href="https://archeanmarketcap.com/currency/'.$row["slug"]. '">Click to View Detailed
</a>';
        
        echo "</td>";
        
        

        echo "</tr>";
        
        
    }

} else {

    echo "0 results";

}

    




 
$conn->close();


?>