Data uit een webadres naar een html formulier
http://data.icecat.biz/xml_s3/xml_server3.cgi?ean_upc=8711500354532,8711500354501;lang=EN;output=productcsv
Dit is de data die ik krijg als ik de bovenstaande link in mijn browser aanvraag:
"Requested_prod_id","Requested_GTIN(EAN/UPC)","Requested_Icecat_id","ErrorMessage","Supplier","Prod_id","Icecat_id","GTIN(EAN/UPC)","Category","CatId","ProductFamily","ProductSeries","Model","Updated","Quality","On_Market","Product_Views","HighPic","HighPic Resolution","LowPic","Pic500x500","ThumbPic","Folder_PDF","Folder_Manual_PDF","ProductTitle","ShortDesc","ShortSummaryDescription","LongSummaryDescription","LongDesc","ProductGallery","ProductGallery Resolution","360","EU Energy Label","EU Product Fiche","PDF","Video/mp4","Other Multimedia","ReasonsToBuy","Spec 1","Spec 2","Spec 3","Spec 4","Spec 5","Spec 6","Spec 7","Spec 8","Spec 9","Spec 10","Spec 11","Spec 12","Spec 13","Spec 14","Spec 15","Spec 16","Spec 17","Spec 18","Spec 19","Spec 20","Spec 21","Spec 22"
"","8711500354532","","","Philips","926000000885","3993245","8711500354532|8711500354549","incandescent bulbs","","","","Standard 40W","20140808190953","ICECAT","1","25415","http://images.icecat.biz/img/norm/high/3993245-7010.jpg","358x358","http://images.icecat.biz/img/norm/low/3993245-7010.jpg","","http://images.icecat.biz/thumbs/3993245.jpg","","","Philips Standard 40W","","Philips Standard 40W","Philips Standard 40W","","http://images.icecat.biz/img/gallery/3993245_1262.jpg|http://images.icecat.biz/img/gallery/3993245_2753.jpg|http://images.icecat.biz/img/gallery/3993245_7559.jpg","2000x1952|1788x871|2000x1416","","","","","","","","Performance","Bulb power: 40 W","Bulb shape: A55","Fitting/cap type: E27","Luminous flux: 415 lm","Bulb lifetime: 1000 h","Light colour: Clear","Type finish: Clear","Colour temperature: 2700 K","Colour of product: Transparent","Dimmable: Yes","Color Rendering Index (CRI): 100","Power","Input voltage: 230","Energy efficiency class: E","Weight & dimensions","Weight: 25 g","Width: 6 cm","Depth: 6 cm","Height: 10 cm","Packaging data","Quantity: 1"
"","8711500354501","","","Philips","354501 84","4135316","8711500354501","incandescent bulbs","","","","Standard 25W E27 230V A55 CL 1CT","20130313153027","ICECAT","","10167","http://images.icecat.biz/img/norm/high/4135316-3882.jpg","326x210","http://images.icecat.biz/img/norm/low/4135316-3882.jpg","","http://images.icecat.biz/thumbs/4135316.jpg","","","Philips Standard 25W E27 230V A55 CL 1CT","","Philips Standard 25W E27 230V A55 CL 1CT","Philips Standard 25W E27 230V A55 CL 1CT","","","","","","","","","","","Performance","Bulb power: 25 W","Fitting/cap type: E27","Luminous flux: 220 lm","Bulb lifetime: 1000 h","Colour temperature: 2700 K","Power","Energy efficiency class: E","Power requirements: 230V","","","","","","","","","","","","",""
Gewijzigd op 05/10/2015 17:54:24 door Dennis Ham
Daarna kun je fgetcsv gebruiken
Gewijzigd op 05/10/2015 18:17:37 door Frank Nietbelangrijk
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
$username = "Username";
$password = "Geheim";
$url = "http://www.website.nl/script.php";
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_USERPWD, $username.':'.$password);
$result = curl_exec($ch);
curl_close($ch);
// de output gaan we nu tonen:
echo $result;
?>
$username = "Username";
$password = "Geheim";
$url = "http://www.website.nl/script.php";
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_USERPWD, $username.':'.$password);
$result = curl_exec($ch);
curl_close($ch);
// de output gaan we nu tonen:
echo $result;
?>
Gewijzigd op 05/10/2015 18:36:12 door - Ariën -
Dus $data is de array.
$data[0]
$data[1]
$data[2]
Dat zijn je variabelen.