CiviCRM Community Forums (archive)

I searched this topic for "SQL connection" but didn't find what I'm looking for (i.e. how to script a SQL connection).

Basically, I have a whole bunch of similarly-defined databases (i.e. the tables and views are the same, the only thing different is the actual data), and in each of these databases I have a set of multiple  custom fields (all in the same field group) that I want to make view-only -- after I have finished seeding the database with imported data.

I am not able to set the field view-only at the time I define the field, because if I do, the import process will not populate the field with data.

I do not have SSH access to the web server, but I do have FTP access (and of course I can run PHP scripts, I just don't know how to write them).

I need to be able to do the following:

for db in <list of databases>
do
  connect to $db
  for label in <list of labels>
  do
    update civicrm_custom_field set is_view=1 where label='$label'
  done
  connect reset
done

Can someone please point me in the right direction?