drupal 多数据库切换并导入数据

require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
$sql = "select * from term_data where vid = 3";
$result = db_query($sql);
while($data = db_fetch_object($result)){
$sql1 = "insert collect(collect_id,collect_name,start,end) value ('','".$data->name.',出租出售'."','http://bj.58.com/".$data->description."/zufang/','http://bj.58.com/".$data->description."/zufang/pn*')";
db_query($sql1);
$sql2 = "insert collect(collect_id,collect_name,start,end) value ('','".$data->name.',出租出售'."','http://bj.58.com/".$data->description."/ershoufang/','http://bj.58.com/".$data->description."/ershoufang/pn*')";
db_query($sql2);
$sql3 = "insert collect(collect_id,collect_name,start,end) value ('','".$data->name.',求租求购'."','http://bj.58.com/".$data->description."/qiuzu/','http://bj.58.com/".$data->description."/qiuzu/pn*')";
db_query($sql3);
$sql4 = "insert collect(collect_id,collect_name,start,end) value ('','".$data->name.',二手置换'."','http://bj.58.com/".$data->description."/jujia/','http://bj.58.com/".$data->description."/jujia/pn*')";
db_query($sql4);
$sql5 = "insert collect(collect_id,collect_name,start,end) value ('','".$data->name.',二手置换'."','http://bj.58.com/".$data->description."/jiadian/','http://bj.58.com/".$data->description."/jiadian/pn*')";
db_query($sql5);
}
*/
/*
for($i=0;$i<576;$i++){
echo $i.',';
}
set_time_limit(0);
require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
db_set_active('default');
$sql = "select nid from node";
$result = db_query($sql);
while($data = db_fetch_object($result)){
$node = node_load($data->nid);
$node->nid = '';
db_set_active('mydb');
//node_save($node);
db_set_active('default');
}
Tags: