Hello,
I would like to create a model name list. Could you help me to make that ?
Regards,
François
<?php
$brand_names = array();
$db = new mysqli($host,$user,$pass,$db);
$res = $db->query("SELECT * FROM TeraWurflMerge");
while($row = $res->fetch_assoc()){
$capabilities = unserialize($row['capabilities']);
$brand_names[] = $capabilities['product_info']['brand_name'];
}
sort($brand_names,SORT_STRING);
?>
<?php
$model_names = array();
$db = new mysqli($host,$user,$pass,$db);
$res = $db->query("SELECT * FROM TeraWurflMerge");
while($row = $res->fetch_assoc()){
$capabilities = unserialize($row['capabilities']);
$model_names[] = $capabilities['product_info']['brand_name'].' '.$capabilities['product_info']['model_name'];
}
$model_names = array_unique($model_names,SORT_STRING);
?>
<?php
$model_names = array();
$db = new mysqli($host,$user,$pass,$db);
$res = $db->query("SELECT * FROM TeraWurflMerge");
while($row = $res->fetch_assoc()){
$capabilities = unserialize($row['capabilities']);
if(array_key_exists('product_info',$capabilities) && array_key_exists('brand_name', $capabilities['product_info'])){
$model_names[] = $capabilities['product_info']['brand_name'].' '.$capabilities['product_info']['model_name'];
}
}
$model_names = array_unique($model_names,SORT_STRING);
?>
Users browsing this forum: No registered users and 2 guests