<?php
// Database connection
$servername = "your_server_name";
$username = "your_username";
$password = "your_password";
$dbname = "your_database_name";
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Fetch data from sh_shop table
$sql = "SELECT * FROM sh_shop";
$result = $conn->query($sql);
// Display shop details row-wise
while ($row = $result->fetch_assoc()) {
echo "<h2>" . $row['shop_name'] . "</h2>";
echo "<img src='" . $row['shop_image'] . "' alt='" . $row['shop_name'] . " Image'>";
echo "<button onclick='shareOnWhatsApp(\"" . $row['whatsapp_link'] . "\", \"" . $row['shop_image'] . "\", \"" . $row['shop_name'] . "\")'>Share on WhatsApp</button>";
echo "<hr>";
}
// Close the database connection
$conn->close();
?>
<script>
function shareOnWhatsApp(whatsappLink, shopImage, shopName) {
// Encode the message with shop details
var message = encodeURIComponent("Check out " + shopName + ": " + whatsappLink + "\n\n" + shopImage);
// Create WhatsApp share link
var whatsappURL = "https://api.whatsapp.com/send?text=" + message;
// Redirect to WhatsApp
window.location.href = whatsappURL;
}
</script>
Here many types of latest technology news, many useful (tools, software, apps, website, technical problem solution )If you have any query regrading Site, Advertisement and any other issue, please feel free to contact me