public function getWord() { $courses = Courses::all(); foreach ($courses as $course) { $datas = explode(" ", $course->nm_c); foreach ($datas as $data) { $data = str_replace("'", "''", $data); $data = trim(preg_replace('/[^A-Za-z0-9\']/', '', $data)); DB::Insert("INSERT IGNORE INTO `word`(`word`) VALUES ('{$data}')"); } } }