<?php // 本类由系统自动生成,仅供测试用途 class IndexAction extends Action{ public function index(){ //我的第一个数据库连接 $connect1 = array( 'dbms' => 'mysql', 'username' => 'root', 'password' => '', 'hostname' => 'localhost', 'hostport' => '3306', 'database' => 'sammix' ); //第二个数据库链接, $connect2 = array( 'dbms'=>'mysql', 'username'=>'root', 'password'=>'', 'hostname'=>'localhost', 'hostport'=>'3306', 'database'=>'sammix' ); $key = M("website_key", "AdvModel"); $key->addConnect($connect1,1); $key->addConnect($connect2,2); $key->switchConnect(1); $list = $key->order('ID')->select(); // 查询数据 $this->assign('list',$list); // 模板变量赋值 $key->closeConnect(1); /* $key = D('website_key'); // 实例化模型类 $list = $key->order('ID')->select(); // 查询数据 $this->assign('list',$list); // 模板变量赋值 $table = new Model('website_values'); // 实例化模型类 $tablelist = $table->order('siteid')->select(); // 查询数据 $this->assign('tablelist',$tablelist); // 模板变量赋值 */ $this->display(); } public function insert() { //echo $_REQUEST['gender_boy']; //echo $_REQUEST['gender_girl']; $websitevalues = D('website_values'); // 实例化模型类 $websitevalues->create(); // 创建数据对象 $Demo = new Model('website_key'); // 实例化模型类 $list = $Demo->order('ID')->select(); // 查询数据 for ( $index = 0, $max_count = sizeof( $list ); $index < $max_count; $index++ ) { //echo $list[$index]["name"]."|".$_REQUEST[$list[$index]["name"]]."<br>"; //$date[$list[$index]["name"]] = $_REQUEST[$list[$index]["name"]]; $date["name"] = $list[$index]["name"]; $date["value"] = $_REQUEST[$list[$index]["name"]]; $result = $websitevalues->add($date); // 写入数据库 } $this->redirect('index'); } } ?> <?php return array( //'配置项'=>'配置值' 'APP_DEBUG' => true, // 开启调试模式 'URL_MODEL'=>1, 'DB_TYPE'=>'mysql', 'DB_HOST'=>'localhost', 'DB_USER'=>'root', 'DB_PWD'=>'', 'DB_PORT'=>'3306', 'DB_NAME'=>'sammix', 'DB_PREFIX'=>'mix_', ); ?>