inc.meta_data_converter.php File Reference

Go to the source code of this file.

Functions
	ilMDConvert ($table, $fields, $key)

Function Documentation

ilMDConvert()

ilMDConvert	(		$table,
			$fields,
			$key
	)

Definition at line 3 of file inc.meta_data_converter.php.

{
        global $ilDB;
 
        $where = "WHERE ";
        $where .= implode(" LIKE '%\%' ESCAPE '�' OR ", ilUtil::quoteArray($fields));
        $where .= " LIKE '%\\%' ESCAPE '�'";
 
        $query = "SELECT * FROM ".$table." ".
                $where;
 
        $res = $ilDB->query($query);
        while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
        {
                $query = "UPDATE $table ";
 
                $counter = 0;
                foreach($fields as $field)
                {
                        if($counter++)
                                $query .= ", ";
                        else
                                $query .= "SET ";
 
                        $query .= ($field ." = ".$ilDB->quote(stripslashes($row->$field))." ");
                }
                $query .= (" WHERE ".$key." = ".$ilDB->quote($row->$key));
 
                // Perform the query
                $ilDB->query($query);
        }
}

References $ilDB, $query, $res, $row, DB_FETCHMODE_OBJECT, and ilUtil\quoteArray().

Here is the call graph for this function: