$connection = mysql_connect("ip","id","pw") or die("데이터베이스 연결실패"); 
mysql_query('set character set euckr');
mysql_select_db("test",$connection);

$arr1=array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");
$arr2=array("1","2","3","4","5","6","7","8","9","0");
$count_i = 0;
for ($t = 0; $t < 500; $t++) {
    $str1 = '';
    $str2 = '';
    for ($i = 0; $i < 3; $i++) {
        $j = rand(0, 25);
        $str1 .= $arr1[$j];
    }
    for ($k = 0; $k < 7;$ k++) {
        $j = rand(0,9);
        $str2 .= $arr2[$j];
    }

    $str1 = substr(trim($str1), 0, 3);
    $str2 = substr(trim($str2), 0, 7);
    // echo "str1 : ".$str1."
";
    // echo "str2 : ".$str2."
";
    if (strlen($str1) == 3 && strlen($str2) == 7) {
        $str = $str1.$str2;
    }
    $tmp = str_shuffle($str);
    // echo "tmp3 : ".$tmp3."
";

    if (strlen($tmp) == 10) {
        $query = "INSERT INTO RAND_TEST SET C_RANDNO = '".$tmp."'";
        //  echo "query : ".$query."
";
        mysql_query($query, $connection);
        $count_i++;
    }
    if($t%10000 == 0) {
        flush();
    }
}
echo "count : ".$count_i."
";
mysql_close($connection);

path = $this->result;
		$this->index = 0;

		$xml_parser = xml_parser_create($encoding);
		xml_set_object($xml_parser, &$this);
		xml_set_element_handler($xml_parser, 'startElement', 'endElement');
		xml_set_character_data_handler($xml_parser, 'characterData');

		xml_parse($xml_parser, $data, true);
		xml_parser_free($xml_parser);
	}

	function startElement($parser, $tag, $attributeList) {
		eval("$vars = get_object_vars(".$this->path.");");
		$this->path .= "->".$tag;
		if ($vars && array_key_exists($tag, $vars)) {
			eval("$data = ".$this->path.";");
			if (is_array($data)) {
				$index = sizeof($data);
				$this->path .= "[".$index."]";
			} else if (is_object($data)) {
				eval($this->path." = array(".$this->path.");");
				$this->path .= "[1]";
			}
		}
		eval($this->path." = null;");

		foreach($attributeList as $name => $value)
			eval($this->path."->".$name. " = '".XMLParser::cleanString($value)."';");
	}

	function endElement($parser, $tag) {
		$this->path = substr($this->path, 0, strrpos($this->path, "->"));
	}

	function characterData($parser, $data) {
		eval($this->path." = '".trim($data)."';");
	}
}
?>