обхождане на данни и запис

embaka · 4 Октомври 2010

здравейте,

трябват ми идеи как да обходя нещо от тоя сорт, значи това е от JS, код, но идеята ми е да го направя с php и да го записвам в база. значи във всеки масив първия запис ми е категория, от там нататък са модели на коли. идеята ми е да ги записвам в база, за да ги направя с категории и под категории, ама се чудя как да го обходя...

var cmm = new Array
(
[
['Acura','','Integra','Mdx','Rl','Rsx','Slx','Tl','Tsx'],
['Aixam','','400'],
['Alfa romeo','','145','146','147','155','156','156 sportwagon','159','164','166','33','75','76','90','Alfetta','Brera','Crosswagon q4','Giulietta','Gt','Gtv','MiTo','Spider','Sprint','Sud'],
]
);

macmen · 4 Октомври 2010

<?php
$arr = array(
"Acura" => "Integra,Mdx,Rl,Rsx,Slx,Tl,Tsx",
"Aixam" => "400",
"Alfa romeo" => "145,146,147,155,156,156 sportwagon,159,164,166,33,75,76,90,Alfetta,Brera,Crosswagon q4,Giulietta,Gt,Gtv,MiTo,Spider,Sprint,Sud"
);
foreach ($arr as $v=>$key) {
echo $v."<br>".$key."<br>" ;
}
?>

hrischo · 4 Октомври 2010

Код:

<?php
$array = <<<EOF
var cmm = new Array
(
[
['Acura','','Integra','Mdx','Rl','Rsx','Slx','Tl','Tsx'],
['Aixam','','400'],
['Alfa romeo','','145','146','147','155','156','156 sportwagon','159','164','166','33','75','76','90','Alfetta','Brera','Crosswagon q4','Giulietta','Gt','Gtv','MiTo','Spider','Sprint','Sud'],
]
);
EOF;
preg_match_all("#^\[(.*)\]#m", $array, $matches);
for($i = 0; $i < count($matches[0]); $i++) {
	preg_match("#^\[(.*)\]#", str_replace("'", "", $matches[0][$i]), $match);
	$parts = explode(",", $match[1]);
	for($t = 1; $t < count($parts); $t++) {
		if(!empty($parts[$t])) {
			$query = "INSERT INTO cars (`car`, `model`) VALUES ('{$parts[0]}', '{$parts[$t]}');";
			echo $query."<br />";
		}
	}
}
?>

:roll:

embaka · 4 Октомври 2010

мерси все пак, ама това не ми помогна въобще

Код:

<?php header('Content-Type: text/html; charset=windows-1251');  ?>
<pre>
<?php
$cmm = Array
(
    Array('Acura','','Integra','Mdx','Rl','Rsx','Slx','Tl','Tsx'),
    Array('Aixam','','400'),
    Array('Alfa romeo','','145','146','147','155','156','156 sportwagon','159','164','166','33','75','76','90','Alfetta','Brera','Crosswagon q4','Giulietta','Gt','Gtv','MiTo','Spider','Sprint','Sud'),
    Array('Aston martin','','.','DBS','Db7','Db9','Rapide','V12 Vantage','V8 Vantage','Vanquish'),
    Array('Audi','','100','200','50','60','80','90','A1','A2','A3','A4','A5','A6','A7','A8','Allroad','R8','Rs4','Rs6','S2','S3','S4','S5','S6','S8','Tt'),
    Array('Austin','','Allegro','Ambassador','Maestro','Maxi','Metro','Mg','Mini','Montego','Princess'),
    Array('Bentley','','Arnage','Azure','Continental','Continental gt','Mulsanne'),
    Array('Berliner','','Coupe'),
    Array('Bmw','','1','116','118','120','1500','1600','1602','1800','2000','2002','3','315','316','318','320','323','324','325','328','330','335','5','5 Gran Turismo','501','518','520','523','524','525','528','530','535','540','545','550','5GT','6','628','630','633','635','645','650','7','700','721','723','725','728','730','732','733','735','740','745','750','760','840','850','Izetta','M','M3','M5','M6','Z1','Z3','Z4','Z8'),
    Array('Borgward','','Hansa'),
    Array('Bugatti','','Veyron'),
    Array('Buick','','Electra','Invicta','Park avenue','Regal','Skylark','Skyline'),
    Array('Cadillac','','Allante','BLS','Brougham','Cts','Deville','Eldorado','Fleetwood','STS','Seville','Srx','Xlr'),
    Array('Chevrolet','','Alero','Astro','Aveo','Beretta','Camaro','Caprice','Cavalier','Cobalt','Corvette','Cruze','Epica','Evanda','Hhr','Impala','Kalos','Lacetti','Lumina','Malibu','Matiz','Nova','Nubira','Silverado','Spark','Ssr','Tacuma','Transsport'),
    Array('Chrysler','','300c','300m','Crossfire','Daytona','Es','Gr.voyager','Gts','Interpid','Lebaron','Neon','New yorker','Pacifica','Pt cruiser','Saratoga','Sebring','Stratus','Vision','Voyager'),
    Array('Citroen','','2cv','Ax','Axel','Berlingo','Bx','C1','C15','C2','C3','C3 Picasso','C3 pluriel','C4','C4 Picasso','C5','C6','C8','Cx','DS3','DS4','Ds','Evasion','Gsa','Gx','Ln','Nemo','Oltcit','Saxo','Visa','Xantia','Xm','Xsara','Xsara picasso','Zx'),
    Array('Corvette','','C06 Convertible','C06 Coupe','Powa','Z06'),
    Array('Dacia','','1100','1300','1304','1307','1310','1350','Liberta','Logan','Nova','Pickup','Sandero','Solenza'),
    Array('Daewoo','','Ace','Chairman','Cielo','Espero','Evanda','Fso','Kalos','Lacetti','Lanos','Leganza','Magnus','Matiz','Nexia','Nubira','Prince','Racer','Rezzo','Super','Tacuma','Tico'),
    Array('Daihatsu','','Applause','Charade','Charmant','Copen','Cuore','Gran move','Hijet','Materia','Move','Sharade','Sirion','Yrv'),
    Array('Daimler','','Double six','Six','Sovereign'),
    Array('Datsun','','Bluebird','Cherry','Stanza'),
    Array('Dkw','','F102'),
    Array('Dodge','','Avenger','Caliber','Caravan','Challenger','Charger','Coronet','Daytona','Interpid','Journey','Magnum','Neon','Ram','Shadow','Stealth','Stratus','Viper'),
    Array('Eagle','','Premire','Talon','Vision'),
    Array('FSO','','Polonez'),
    Array('Ferrari','','348','360 modena','360 spider','458 Italia','599','California','Enzo','F430','F456m','F575m maranello','F612 scaglietti','Mondial 8','Testarossa'),
    Array('Fiat','','1100','124','125','126','127','128','131','132','1400','1500','1800','500','600','650','750','Albea','Argenta','Barchetta','Bertone','Brava','Bravo','Cinquecento','Coupe','Croma','Doblo','Duna','Fiorino','Idea','Linea','Marea','Multipla','Palio','Panda','Punto','Regata','Ritmo','Scudo','Sedici','Seicento','Siena','Stilo','Strada','Tempra','Tipo','Topolino','Ulysse','Uno'),
    Array('Ford','','12m','15m','17m','20m','Aerostar','C-max','Capri','Connect','Consul','Cortina','Cosworth','Cougar','Countur','Courier','Crown victoria','Ecoline','Escort','F150','Fiesta','Focus','Focus c max','Fusion','Galaxy','Granada','Ka','Mondeo','Mustang','Orion','Probe','Puma','Rs','S-Max','Scorpio','Sierra','Sportka','Streetka','Taunus','Taurus','Thunderbird','Windstar','Zephyr'),
    Array('Geo','','Metro','Prizm','Storm'),
    Array('Honda','','Accord','Cbr','Cbx','City','Civic','Civic ballade','Concerto','Cr-v','Crx','Crz','Fit','Fr-v','Hr-v','Insight','Integra','Jazz','Legend','Logo','Nsx','Odyssey','Prelude','Quintet','S2000','Shuttle','Stream'),
    Array('Hyundai','','Accent','Atos','Coupe','Elantra','Excel','Getz','Grace','I10','I20','I30','Lantra','Matrix','Pony','Porter','S','Santamo','Sonata','Stelar','Tb','Trajet','Xg'),
    Array('Ifa','','F9'),
    Array('Infiniti','','Fx45','G','G coupe','G sedan','I','J','M','Q'),
    Array('Innocenti','','Mini'),
    Array('Isuzu','','Gemini','Piazza','Pickup'),
    Array('Jaguar','','Daimler','Daimler double six','Daimler six','S-type','Sovereign','Super v8','X-type','Xf','Xj','Xjr','Xjs','Xjsc','Xk8','Xkr'),
    Array('Kia','','Avella delta','Carens','Carnival','Ceed','Cerato','Clarus','Joecs','Joyce','Magentis','Opirus','Picanto','Pride','Rio','Sephia','Shuma','Soul','Venga'),
    Array('Lada','','1200','1300','1500','1600','2101','21011','21012','21013','21015','2102','2103','2104','21043','2105','21051','21053','2106','21061','21063','2107','21074','2108','21083','2109','21093','21099','2110','21213','Kalina','Nova','Oka','Priora','Samara'),
    Array('Lamborghini','','Countach','Diablo','Gallardo','Murcielago','Reventon'),
    Array('Lancia','','A112','Aurelia','Beta','Dedra','Delta','Kappa','Lybra','Musa','Phedra','Prisma','Thema','Thesis','Unior','Y','Y10','Ypsilon','Zeta'),
    Array('Lexus','','Es','Gs','Is','Ls','Sc'),
    Array('Lincoln','','Continental','Ls','Mark','Mkz','Town car','Zephyr'),
    Array('Lotus','','Elise','Europe','Evora','Exige'),
    Array('Maserati','','3200 gt','Biturbo','Coupe gt','Ghibli','GranCabrio','GranTurismo','Gransport','Quattroporte','Spyder','Zagato'),
    Array('Matra','','Murena','Rancho'),
    Array('Maybach','','57','62'),
    Array('Mazda','','121','2','3','323','5','6','626','929','Demio','Mpv','Mx-3','Mx-5','Mx-6','Premacy','Rx-7','Rx-8','Tribute','Xedos'),
    Array('Mercedes','','110','111','113','114','115','116','123','124','126','126-260','150','170','180','190','200','220','230','240','250','260','280','290','300','320','350','380','380se','420','450','500','560','600','A','A140','A150','A160','A170','A180','A190','A200','A210','Adenauer','B','B150','B170','B180','B200','C','C180','C200','C220','C230','C240','C250','C270','C280','C320','C350','Cl','Clk','Cls320','Cls350','Cls500','Cls55','Cls63','E','E200','E220','E230','E240','E250','E260','E270','E280','E290','E300','E320','E350','E400','E420','E500','E55','E60','R','R320','S','S250','S280','S300','S320','S350','S400','S420','S450','S500','S550','S600','S63','S65','SLR','SLS','Sl','Slk','Smart','V230','Vaneo','Е63'),
    Array('Mercury','','Marauder','Milan','Monarch','Villager'),
    Array('Mg','','Mga','Mgb','Mgf','Tf','Zr','Zs','Zt','Zt-t'),
    Array('Mini','','Clubman','Cooper','Cooper cabrio','Cooper s','Cooper s cabrio','D one','One','One cabrio'),
    Array('Mitsubishi','','3000 gt','Carisma','Colt','Cordia','Eclipse','Galant','Grandis','Lancer','Sapporo','Sigma','Space gear','Space runner','Space star','Space wagon','Starion','Tredia'),
    Array('Morgan','','Aero8'),
    Array('Moskvich','','1360','1361','1500','2136','2138','2140','2141','21412','21417','2142','2715','401','403','407','408','412','426','427','503','Aleko','Иж'),
    Array('Nissan','','100 nx','200 sx','240 z','280 z','300 zx','350z','370Z','Almera','Almera tino','Altima','Bluebird','Cedric','Cherry','Gt-r','Laurel','Maxima','Micra','Note','Pickup','Pixo','Prairie','Primera','Serena','Silvia','Skyline','Stantza','Sunny','Tiida','Versa'),
    Array('Oldsmobile','','Achieva','Alero','Aurora','Bravada','Cutlass','Firenza','Intrigue','Regency','Silhouette','Toronado'),
    Array('Oltsit','','Club'),
    Array('Opel','','Admiral','Agila','Ascona','Astra','Calibra','Combo','Commodore','Corsa','Diplomat','Gt','Insignia','Kadett','Kapitaen','Manta','Meriva','Monza','Omega','Rekord','Senator','Signum','Sintra','Speedster','Tigra','Vectra','Zafira'),
    Array('Perodua','','Kancil','Kelisa','Kembara','Kenari','Nippa','Rusa'),
    Array('Peugeot','','1007','104','106','107','202','204','205','206','207','3008','304','305','306','307','308','309','402','403','404','405','406','407','504','505','508','604','605','607','806','807','Bipper','Partner','RCZ','Range'),
    Array('Pgo','','Cevennes','Speedster'),
    Array('Plymouth','','Acclaim','Barracuda','Breeze','Colt','Grand voyager','Horizon','Laser','Neon','Prowler','Reliant','Road runner','Sundance','Volare','Voyager'),
    Array('Polonez','','Pickup'),
    Array('Pontiac','','Aztec','Bonneville','Fiero','Firebird','Grand am','Grand prix','Gto','Lemans','Solstice','Sunbird','Sunfire','Tempest','Trans am','Trans sport','Vibe'),
    Array('Porsche','','911','924','928','935','944','956','968','993','996','Boxster','Carrera','Cayman','Panamera'),
    Array('Proton','','400','Persone','Satria'),
    Array('Renault','','10','11','12','14','16','18','19','20','21','25','29','30','4','5','8','9','Alpine','Avantime','Bakara','Bulgar','Chamade','Clio','Espace','Express','Fluence','Fuego','Grand espace','Grand scenic','Kangoo','Koleos','Laguna','Laguna Coupe','Megane','Modus','Nevada','Rapid','Safrane','Scenic','Symbol','Twingo','Vel satis'),
    Array('Rolls-Royce','','Ghost','Phantom','Silver Seraph'),
    Array('Rover','','111','114','200','213','214','216','220','25','400','414','416','418','420','45','600','618','620','623','75','800','820','825','827','City','Estate','Maestro','Metro','Mini','Montego','Streetwise'),
    Array('Saab','','9-3','9-5','900','9000'),
    Array('Samand','','LX'),
    Array('Saturn','','Astra','Aura','Sky'),
    Array('Scion','','Tc','Xa','Xb'),
    Array('Seat','','Alhambra','Altea','Arosa','Cordoba','Exeo','Fura','Ibiza','Inka','Leon','Malaga','Marbella','Ronda','Terra','Toledo','Vario'),
    Array('Shatenet','','Stella'),
    Array('Simca','','1307','1308','1309','1510','Aront','Chrysler','Horizon','Shambord','Solara','Special','Versail'),
    Array('Skoda','','100','1000','105','120','125','130','135','136','Fabia','Favorit','Felicia','Forman','Octavia','Rapid','Roomster','Superb','Yeti'),
    Array('Smart','','Forfour','Fortwo','Mc','Roadster'),
    Array('Ssang yong','','Chairman','Rodius'),
    Array('Subaru','','1800','Baja','E12','Forester','G3x justy','Impreza','Justy','Legacy','Libero','Outback','Svx'),
    Array('Suzuki','','Alto','Baleno','Forenza','Ignis','Liana','Maruti','Reno','SX4','Sg','Splash','Swift','Wagon r'),
    Array('Talbot','','1100','1310','Horizon','Matra','Murena','Samba','Simka','Solara'),
    Array('Tata','','Aria','Estate','Indica','Mint','Nano'),
    Array('Tavria','','.','Dana','Kombi','Slavuta'),
    Array('Terberg','','Fl2850','Sl3000'),
    Array('Tofas','','Dogan','Kartal','Sahin'),
    Array('Toyota','','Auris','Avalon','Avensis','Avensis verso','Aygo','Camry','Carina','Celica','Corolla','Corolla verso','Cressida','Crown','IQ','Matrix','Mr2','Paseo','Picnic','Previa','Prius','Scion','Starlet','Supra','Tercel','Verso','Yaris','Yaris verso'),
    Array('Trabant','','600','601','Combi','T 1.1'),
    Array('Triumph','','Acclaim','Dolomite','Herald','Spitfire','Stag','Tr6','Tr7'),
    Array('Volga','','22','24','3110','3111','M 20','M 21','Siber'),
    Array('Volvo','','142','144','145','164','1800 es','240','244','245','262 c','264','340','343','344','345','360','440','460','480','66','740','744','745','760','765','770','780','850','940','960','C30','C70','P 1800','S40','S60','S70','S80','V40','V50','V60','V70','Xc70'),
    Array('Vw','','1200','1300','1302','1303','1500','1600','Bora','Caddy','Corrado','Derby','Eos','Fox','Golf','Jetta','K 70','Karmann-ghia','Lupo','Multivan','New beetle','Passat','Phaeton','Polo','Rabbit','Santana','Scirocco','Sharan','Taro','Touran','Vento'),
    Array('Warszawa','','223','232'),
    Array('Wartburg','','1.3','311','312','353'),
    Array('Wiesmann','','Gt','Mf3','Mf4','Mf5'),
    Array('Xinshun','','XS-D055'),
    Array('Zastava','','600','750','Florida','Gt 55','Koral','Miami','Yugo 45'),
    Array('Zaz','','1102','1103','1105','965','966','968','Tavria'),
    Array('Победа','','М'),
    Array('София','','С'),
    Array('Чайка','','М')
);

$new_array = Array();

    foreach($cmm as $tempid=>$cdata){
        if(is_array($cdata))
        
        foreach($cdata as $tid=>$carsdata){
            if($tid==0) $marka = $cdata[$tid];
            if($tid==0){
            mysql_query("INSERT INTO cats (id,url,status,name,parent) VALUES('', '".$cdata[$tid]."', '1', '".$cdata[$tid]."', '0')") or die("opa 1");
            //echo "INSERT INTO test (id,name,parent) VALUES('','".$cdata[$tid]."','0')"."<br>";
            $id = mysql_insert_id();
            }
            
            if($tid>1) $new_array[$marka][] = $cdata[$tid];
            if($tid>1){
            mysql_query("INSERT INTO cats (id,url,status,name,parent) VALUES('', '".$cdata[$tid]."', '1', '".$cdata[$tid]."', '$id')") or die("opa 2");
            //mysql_query("INSERT INTO cats (id,name,parent) VALUES('','".$cdata[$tid]."','".$id."')");
            //echo "INSERT INTO test (id,name,parent) VALUES('','".$cdata[$tid]."','".$id."')"."<br>";
            }
            
        }
    }


print '<pre>';
//print_r($new_array);
print '</pre>';


?>

hrischo · 4 Октомври 2010

embaka каза:
мерси все пак, ама това не ми помогна въобще

ЪЪЪ, как ще ти помогне като в първия пост си дал нещо съввввввввввсем различно, което няма нищо общо с предишия ти пост ? :shock:

macmen · 4 Октомври 2010

ако ти помагне това ето ти марките на колите, на по извесните

Код:

 Acura,     
 Aixam,     
 Alfa Romeo,     
 Alpina,     
 Asia Motors,     
 Aston Martin,     
 Audi,     
 Austin,     
 Austin Healey,     
 Bentley,     
 BMW,     
Borgward,     
Brilliance,     
Bugatti,     
Buick,     
Cadillac,     
Caterham,     
Chevrolet,     
Chrysler,     
Citroën,     
Cobra,     
Corvette,     
Dacia,     
 Daewoo,     
 Daihatsu,     
 DeTomaso,     
 Dodge,     
 Ferrari,     
 Fiat,     
 Ford,     
 GMC,     
 Holden,     
 Honda,     
 Hummer,     
 Hyundai,     
 Infiniti,     
 Isuzu,     
 Iveco,     
 Jaguar,     
 Jeep,     
 Kia,     
 Königsegg,     
 Lada,     
 Lamborghini,     
 Lancia,     
 Land Rover,     
 Landwind,     
 Lexus,     
 Ligier,     
 Lincoln,     
 Lotus,     
 Mahindra,     
 Maserati,     
 Maybach,     
 Mazda,     
 Mercedes-Benz,     
 MG,     
 MINI,     
 Mitsubishi,     
 Morgan,     
 Nissan,     
 NSU,     
 Oldsmobile,     
 Opel,     
 Peugeot,     
 Piaggio,     
 Plymouth,     
 Pontiac,     
 Porsche,     
 Proton,     
 Renault,     
 Rolls Royce,     
 Rover,     
 Saab,     
 Santana,     
 Seat,     
 Škoda,     
 Smart,     
 Spyker,     
 Ssangyong,     
 Subaru,     
 Suzuki,     
 Talbot,     
 Tata,     
 Toyota,     
 Trabant,     
 Triumph,     
 TVR,     
Volkswagen,     
Volvo,     
Wartburg,     
Wiesmann,

embaka · 4 Октомври 2010

hrischo каза:
embaka каза:

мерси все пак, ама това не ми помогна въобще

Увеличете...

ЪЪЪ, как ще ти помогне като в първия пост си дал нещо съввввввввввсем различно, което няма нищо общо с предишия ти пост ? :shock:

кое е различно???, че не те разбрах, различно е ами нали го направих така, за да мога да си натикам всички марки и модели

дадох ви кода, ако на някой му трябва да си го ползва, това са всички марки и модели и вкарването им в таблица

обхождане на данни и запис

embaka

Registered

macmen

Registered

hrischo

Registered

embaka

Registered

hrischo

Registered

macmen

Registered

embaka

Registered