Need help to implement preg_replace in my import script

PHP
1

Hi!
this is my code for the import:


     if (($handle = $source_file) !== FALSE) { 
        $columns = fgetcsv($handle, 10000, ";"); 
        foreach ($columns as &$column) { 
            $column = str_replace(".","",$column); 
        } 
        $insert_query_prefix = "INSERT INTO table (".join(",",$columns).")\
VALUES";
         while (($data = fgetcsv($handle, 10000, ";")) !== FALSE) { 
            while (count($data)<count($columns)) 
                array_push($data, NULL); 
            $query = "$insert_query_prefix (".join(",",quote_all_array($data)).");";
			 mysql_query($query); 
        } 
        fclose($handle);		
    } 


function quote_all_array($values) { 
    foreach ($values as $key=>$value) 
        if (is_array($value)) 
            $values[$key] = quote_all_array($value); 
        else 
            $values[$key] = quote_all($value); 
    return $values; 
} 

function quote_all($value) { 
    if (is_null($value)) 
        return "NULL"; 

    $value = "'" . mysql_real_escape_string($value) . "'"; 
    return $value; 
}

the value i want to remove before import is (Gå till …) it starts with this (Gå till than more value then close with )
so i need the preg_replace search the code were it starts with (Gå till then delete everything within that ()
example:
in one row this exists:
Hey (Gå till nästa steg) mom. //the value “nästa steg” can be different

should be after preg_replace
Hey mom.

after the preg_replace the sript should import the data

i have tryed to use this kind of code but cant make it work ( dont know were to put it or how to write )


$pattern = '#\\(\\s*Gå till[^)]+\\)#';
$s = preg_replace($pattern, "", $s);
$s = preg_replace('#\\s{2,}#', " ", $s);
2

dont know were to put it

Where is the data that has to be modified stored? In $query ?
Then you could do:

$query  = preg_replace($pattern, "", $query );
3

ok i try but were in my code should i do that?

here?


                array_push($data, NULL);

$query  = preg_replace($pattern, "", $query ); // should i put it here before it run the mysql_query?  

            $query = "$insert_query_prefix (".join(",",quote_all_array($data)).");";
			 mysql_query($query); 
        } 
        fclose($handle);
4

Immediately before you run the query:


   $query = "$insert_query_prefix (".join(",",quote_all_array($data)).");";
   $pattern = '#\\(\\s*Gå till[^)]+\\)#';
   $query  = preg_replace($pattern, "", $query ); 
   mysql_query($query);

By the way, I didn’t test your regex. If you’ve got any problems with that, don’t hesitate to ask.

5

Thanks alot i will try and come back with answer if its working or not

6

Worked !!!
Thanks

Do you know any good tutorials for relational database, rdb?