I'm creating an excel file with a bunch of different data points from information that I'm scraping off the web with Python.
One of those data points is a nested array, which is becoming a string when either it's inserted into the CSV file or read from the PHP file on my server.
The whole idea behind using the nested array is so that I can insert each pair of images and thumbnails into their respective columns in a single row on a separate MySQL table.
Nested Array
images_and_thumbnails = [
['https://images-na.ssl-images-amazon.com/images/I/615JCt72MXL._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/41rExpVS75L._US40_.jpg'],
['https://images-na.ssl-images-amazon.com/images/I/71Ss5tJW-4L._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/41RpAwvZJ5L._US40_.jpg'],
['https://images-na.ssl-images-amazon.com/images/I/6157znz2BeL._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/41mSje9rDSL._US40_.jpg'],
['https://images-na.ssl-images-amazon.com/images/I/815wlLde-gL._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/51jty5d4BpL._US40_.jpg'],
['https://images-na.ssl-images-amazon.com/images/I/71D2gVlCUOL._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/41kCBJYI%2BCL._US40_.jpg'],
['https://images-na.ssl-images-amazon.com/images/I/71EfsMWdx0L._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/41utl4%2B%2B%2BoL._US40_.jpg'],
['https://images-na.ssl-images-amazon.com/images/I/61m4mFpIvVL._UY575_.jpg', 'https://images-na.ssl-images-amazon.com/images/I/41S27BGn0UL._US40_.jpg']
]
PHP Script to Process the Excel File
$str2 = 'INSERT INTO deals_images_and_thumbnails (asin, image, thumbnail) VALUES (:asin, :image, :thumbnail)';
$sta2 = $conn->prepare($str2);
$file = fopen($_SESSION['file'], 'r');
while (!feof($file)) {
while($row = fgetcsv($file)) {
if (count($row) === 31) {
$images_and_thumbnails = $row[8];
foreach ($images_and_thumbnails as $value) {
$sta2->execute([
'asin' => $asin,
'image' => $value[0],
'thumbnail' => $value[1]
]);
}
The issue is that $images_and_thumbnails is a string, which is obviously "an invalid argument" for the foreach loop.
Is there any way to convert the string back to an array?
Will simply removing the double quotes do the job?
images_and_thumbnailsjust create a new variable name for$images_and_thumbnails = $row[8];