Install Guides
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Get the selected Year, Make, and Model from user input (e.g., from Shopify form submission)
$selectedYear = $_POST['year'];
$selectedMake = $_POST['make'];
$selectedModel = $_POST['model'];
// Prepare the SQL query
$stmt = $conn->prepare("SELECT * FROM Guides WHERE Year = ? AND Make = ? AND Model = ?");
$stmt->bind_param("sss", $selectedYear, $selectedMake, $selectedModel);
$stmt->execute();
$result = $stmt->get_result();
// Display the installation guide information
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
echo "
";
if (!empty($row['Image2_URL'])) {
echo "
";
}
echo "
Installation Guide for " . $row['Year'] . " " . $row['Make'] . " " . $row['Model'] . "
"; echo "Installation Instructions:
"; echo "" . $row['Instructions'] . "
"; echo "Additional Information:
"; echo "" . $row['Info'] . "
"; echo "Wire Colors:
"; echo "Positive Wire: " . $row['Positive'] . "
"; echo "Ground Wire: " . $row['Ground'] . "
"; echo "Module Type:
"; echo "" . $row['Module'] . "
"; } else { echo "Installation guide not found."; } // Close the database connection $stmt->close(); $conn->close(); ?>