Class
- Tip&Tech
| [¾Ë°í¸®Áò] ¹«ÀÛÀ§ ¹®ÀÚ¿·Î ´Ù·®ÀÇ Å×½ºÆ® °Ô½Ã±Û INSERT | |||||
| ±Û¾´ÀÌ | ³¯ Â¥ | 12-03-30 10:03 | Á¶ ȸ | 1596 | |
|---|---|---|---|---|---|
| °£ÆíURL |
http://www.phpschool.com/link/tipntech/75368
|
||||
| Link1 | http://www.tested.co.kr/exper/code/31 (161) | ||||
| Link2 | http://board.tested.co.kr/board/testtest (128) | ||||
|
ÄÚµå ÇÏÀ̶óÀÌÆ®°¡ ¾ø³×¿ä.
»ö±ÛÀº ¸µÅ© #1¿¡¼ º¸½Ã¸é µË´Ï´Ù. ¸µÅ© #2´Â Àû¿ë ¿¹Á¦ Á¦ VPS ±âÁØÀ¸·Î ¸î¸¸ °ÇÀº Çѹø¿¡ Àß µé¾î°¡´Â µí½Í¾î¿ä. -_- ---- ---- ---- ---- ini_set('max_execution_time', -1); ini_set('memory_limit', '128M'); // DB ¼³Á¤ mysql_connect('localhost', 'user', 'password'); mysql_select_db('db'); mysql_query(' set names euckr; '); // ÇöÀç µî·ÏµÈ ÃÑ °Ô½Ã±Û °³¼ö $row = current(mysql_fetch_row(mysql_query(" select count(*) from ki_write where bo_table = 'testtest'; "))); // ¹«ÀÛÀ§ ¹®ÀÚ¿ $str = "°¡³ª´Ù¶ó¸¶¹Ù»ç¾ÆÀÚÂ÷īŸÆÄÇÏAaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz1234567890"; // Á¦ VPS ±âÁØÀ¸·Î 1500 ÀÌ»óÀÌ¸é ¿À·ù°¡ ¹ß»ýÇÔ $max = 1500; // MAX limit 1500 // $max * $loop = µî·ÏµÉ °Ô½Ã±Û ¼ö $loop = 10; // ½ÃÀÛ ¹øÈ£ $cur = $row + 1; // ³¡ ¹øÈ£ $end = $row + $max; // ³¯Â¥ -_- $date = date('Y-m-d H:i:s', time()); for ($i=1; $i<=$loop; $i++) { // ÇÊµå ¼³Á¤ $sql = "INSERT INTO `ki_write` (`bo_table`, `wr_id`, `wr_subject`, `wr_content`, `wr_datetime`) VALUES"; for ($k=$cur; $k<=$end; $k++) { $len = 76; // ¼³Á¤µÈ ¹«ÀÛÀ§ ¹®ÀÚ¿ ±æÀÌ $sp = array(); while ($len-- > 0) { $sp[] = mb_substr($str, $len, 4, 'EUC-KR'); // ³»¿ëÀÇ ±æÀÌ´Â ¼ýÀÚ 4¸¦ ¼öÁ¤ } shuffle($sp); $content = implode('', $sp); $title = substr($content, 0, 30); // ³»¿ëÀÇ ¾ÕÀÚ¸®¸¦ Á¦¸ñÀ¸·Î $sql .= " ('testtest', ".$k.", '".$title."', '".$content."', '".$date."'),"; } $sql = substr($sql, 0, -1).';'; if (mysql_query($sql)) { echo 'No'.$i.': '.$date.'<br/>'; $cur += $max; $end += $max; } else echo 'Fail'.$i.': '.$date.' - '.mysql_errno().': '.mysql_error().'<br/>'; } // ÃÑ °Ô½Ã±Û ¼ö $total = $row + ($max * $loop); |
|||||
|
|||||
12345678910


