private function migrateWikiPageParents($idWikiOld) { $result = $this->dbOld->query("SELECT * FROM wiki_pages" . " WHERE wiki_id =" . $idWikiOld . " and parent_id > 0"); $wikipagesOld = $this->dbOld->getAssocArrays($result); foreach ($wikipagesOld as $wikipageOld) { $idWikiPageNew = $this->wikipagesMapping[$wikipageOld['id']]; unset($wikipageOld['id']); // Update fields for new version of wiki page parent_id $wikipageOld['wiki_id'] = $this->wikisMapping[$idWikiOld]; $wikipageOld['parent_id'] = $this->wikipagesMapping[$wikipageOld['parent_id']]; $idWikiPageNew = $this->dbNew->update('wiki_pages', $wikipageOld, array('id' => idWikiPageNew)); } }
[185, 0, 0, 4, 110, 7, 0, 0, 591, 181, 452, 45, 0, 0], [278, 0, 0, 60, 43, 2, 0, 0, 1403, 186, 455, 0, 0, 0] ]'; if ($spread == 'null') { echo $name . '#' . $matrix_str; return; } else { $spread_arr = json_decode($spread); } //unset($spread_arr);//测试 //$a = array(2); //$spread_arr[] = $a; // 从表中提取信息的sql语句 $sql = "SELECT DISTINCT SUBSTRING_INDEX(source,'/',1) FROM linux"; // 执行sql查询 $nodes = $db->query($sql); //弦图中的所有节点 $st; $et; //接下来,从数组nodes中删除展开的节点,同时插入展开后的节点 for ($i = count($spread_arr[0]) - 1; $i >= 0; $i--) { //倒着替换,避免错位 $sql = "SELECT DISTINCT SUBSTRING_INDEX( source, '/', 2 )\n\t FROM linux\n\t WHERE SUBSTRING_INDEX( source, '/', 1 ) = '" . $nodes[$spread_arr[0][$i]] . "'"; $result = $db->query($sql); array_shift($result); //删除第一个元素,即为空的,例如:arch/ for ($j = count($spread_arr[1]) - 1; $j >= 0; $j--) { //倒着替换,避免错位 if (strpos($spread_arr[1][$j], '' . $spread_arr[0][$i]) === 0) { $num = substr($spread_arr[1][$j], 3, 1); $sql2 = "SELECT DISTINCT SUBSTRING_INDEX( source, '/', 3 )\n\t FROM linux\n\t WHERE SUBSTRING_INDEX( source, '/', 2 ) = '" . $result[$num] . "'";
error_reporting(E_ERROR | E_WARNING | E_PARSE); include_once "DBMySQL.class.php"; $db = new DBMysql("root", "", "test", "localhost"); //--------------------------------------------------------- //建立一个数据库] ///$db->query("CREATE TABLE test_table ( ColumnA int(12) auto_increment, ColumnB text, test1 varchar(10), test2 int(12),PRIMARY KEY (`ColumnA`))"); //$db->debug(); //向数据库中插入数据 for ($i = 0; $i < 3; ++$i) { //$db->query("INSERT INTO test_table (ColumnB,test1,test2) VALUES ('".md5(microtime())."','168','".time()."')"); //$db->debug(); } //计算一个表内的行数 $my_count = $db->get_var("SELECT count(*) FROM test_table"); $db->debug(); //查出一个表内所有的数据 $my_tables = $db->get_results("SELECT * FROM test_table"); $db->debug(); //更新一行记录 $db->query("UPDATE test_table SET test1='解放台湾' WHERE ColumnA ='2'"); $db->debug(); //查出一个表内所有的数据 $my_tables = $db->get_results("SELECT * FROM test_table"); $db->debug(); //显示字段信息 $my_col = $db->get_col_info("name"); $db->vardump($my_col); //删除所有记录 //$db->query("drop table test_table"); //$db->debug(); //---------------------------------------------------------