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 "

Installation Guide for " . $row['Year'] . " " . $row['Make'] . " " . $row['Model'] . "

"; echo "Image 1"; if (!empty($row['Image2_URL'])) { echo "Image 2"; } 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(); ?>