the person who delivers the fix the fastest get the reward.
tis the the import code :
// Prepare the SQL statement to insert the product into the database
// Prepare the SQL statement to insert the product into the database
$sql = "INSERT INTO viator_product (
webURL, pageUrlName, primaryDestinationUrlName, publishedDate,
userName, attractionAdmission, attractionTransit, attractionOpenHours,
pageTitle, descriptionIntro, overviewSummary, pagePrimaryLanguage,
attractionLatitude, attractionLongitude, attractionStreetAddress,
attractionCity, attractionState, destinationId, thumbnailHiResURL,
photoCount, primaryDestinationId, seoId, productCount,
primaryDestinationName, thumbnailURL, rating, title
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = mysqli_prepare($conn, $sql); // Replace $mysqli with $conn
mysqli_stmt_bind_param($stmt, "ssssssssssssddssssisiiiis",
$product->webURL,
$product->pageUrlName,
$product->primaryDestinationUrlName,
$product->publishedDate,
$product->userName,
$product->attractionAdmission,
$product->attractionTransit,
$product->attractionOpenHours,
$product->pageTitle,
$product->descriptionIntro,
$product->overviewSummary,
$product->pagePrimaryLanguage,
$product->attractionLatitude,
$product->attractionLongitude,
$product->attractionStreetAddress,
$product->attractionCity,
$product->attractionState,
$product->destinationId,
$product->thumbnailHiResURL,
$product->photoCount,
$product->primaryDestinationId,
$product->seoId,
$product->productCount,
$product->primaryDestinationName,
$product->thumbnailURL,
$product->rating,
$product->title
);
the API that needs to be imported ( well the build of the API is in the file included