PHP preg expressions...

CreativeLogic · 01-06-2004, 09:01 PM

I have this file full of text. It was actually a select drop down field. I want to insert everything into the database so I need to seperate everything in it even the optgroups. Ive tried everything I can think of...

Here is the file:Link

Here is an exampe of how I want it to be displayed (its the first one):

Code:

"Automobiles / Vehicles"
4X4/SUVs
Acura
Aston Martin
Audio / Video
BMW
Bugatti
Buick
Cadillac
Chevrolet
Chrysler
Citroen
Classic
Cobra
Convertibles
Electronics
Exotic
Ferrari
Ford
Formula 1
Hummer
Hydrogen Powered
Insurance
Jeeps
Land Rover
Land Rovers
Leased
Lexus
Mazda
Mercedes-Benz
Motorcycles
Muscle Cars
NASCAR
New
Nissan
Peugeot
Pickup Trucks
Pontiac
Porsche
Private Pilot
Racing
Recreational Vehicles (RVs)
Renault
Repair
Rolls Royce
Shopping
Sports Bikes
Taxi
Technology/Engineering
Toyota
Used
Volkswagen
Z cars

adam_uk · 01-07-2004, 12:01 AM

just inser them manually via phpmyadmin, will be alot quick and easier

CreativeLogic · 01-07-2004, 04:09 AM

...Yea right... Would take at least twice as long...

samscripts · 01-07-2004, 07:39 AM

Hi, just use 2 "preg_match_all" function calls and a bit of php inbetween them to build up an array of optiongroups / options:

PHP Code:

  <?php

 
$data = join("", file("http://www.yaproom.com/interests.txt"));

 
$optgroups = array();

 
if( preg_match_all('/<optgroup label="(.*?)">(.*?)<\/optgroup>/is', $data, $matches ) ){

    $cnt = count($matches[1]);

????: NamePros.com http://www.namepros.com/programming/16703-php-preg-expressions.html
    for( $i = 0; $i < $cnt; $i++){

        $optgroups[$matches[1][$i]] = array();

        if( preg_match_all("/<option value='[0-9]*'>(.*?)<\/option>/is", $matches[2][$i], $options) ){

            $cnt2 = count($options[1]);

            for( $j = 0; $j < $cnt2; $j++){

                $option = $options[1][$j];

                $optgroups[$matches[1][$i]][] = $option;

????: NamePros.com http://www.namepros.com/showthread.php?t=16703
            }

        }

    }

}

 
foreach( $optgroups as $n=>$options ){

    echo '"'.$n.'"';

    echo "\n";

    echo join("\n", $options)."\n";    

}

 
?>

That will print out a text list in the format you listed in your post (optgroup name in "" followed by a list of option names, etc)

$optgroups will be an array like this:

array (
"Option Group 1" => array("Option 1", "Option2", etc),
"Option Group 2" => array("Option 1", "Option2", etc),
etc, etc

So you can just step through the array and insert data into mysql with mysql_query()s...

hope that helps,

Sam

CreativeLogic · 01-07-2004, 09:14 AM

Thanks I haven't tested it but that preg expressions looks like what I needed... Thanks...

01-07-2004, 04:09 AM	THREAD STARTER #3 (permalink)
CreativeLogic NamePros Regular Join Date: Sep 2003 Posts: 889	...Yea right... Would take at least twice as long... __________________ Online Time Tracking :)

01-07-2004, 07:39 AM	#4 (permalink)
samscripts NamePros Member Join Date: Jul 2003 Location: Canterbury, UK Posts: 99	Hi, just use 2 "preg_match_all" function calls and a bit of php inbetween them to build up an array of optiongroups / options: PHP Code: <?php $data = join("", file("http://www.yaproom.com/interests.txt")); $optgroups = array(); if( preg_match_all('/<optgroup label="(.?)">(.?)<\/optgroup>/is', $data, $matches ) ){ $cnt = count($matches[1]); ????: NamePros.com http://www.namepros.com/programming/16703-php-preg-expressions.html for( $i = 0; $i < $cnt; $i++){ $optgroups[$matches[1][$i]] = array(); if( preg_match_all("/<option value='[0-9]'>(.?)<\/option>/is", $matches[2][$i], $options) ){ $cnt2 = count($options[1]); for( $j = 0; $j < $cnt2; $j++){ $option = $options[1][$j]; $optgroups[$matches[1][$i]][] = $option; ????: NamePros.com http://www.namepros.com/showthread.php?t=16703 } } } } foreach( $optgroups as $n=>$options ){ echo '"'.$n.'"'; echo "\n"; echo join("\n", $options)."\n"; } ?> That will print out a text list in the format you listed in your post (optgroup name in "" followed by a list of option names, etc) $optgroups will be an array like this: array ( "Option Group 1" => array("Option 1", "Option2", etc), "Option Group 2" => array("Option 1", "Option2", etc), etc, etc So you can just step through the array and insert data into mysql with mysql_query()s... hope that helps, Sam __________________ Free image hosting script Free whois software php whois script

01-07-2004, 09:14 AM	THREAD STARTER #5 (permalink)
CreativeLogic NamePros Regular Join Date: Sep 2003 Posts: 889	Thanks I haven't tested it but that preg expressions looks like what I needed... Thanks... __________________ Online Time Tracking :)

01-07-2004, 12:01 AM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	just inser them manually via phpmyadmin, will be alot quick and easier

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)