Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $array=array(
- "listening"=>filter_input(INPUT_POST, 'listening'), //just values like a1,b2,c2 etc...
- "reading"=>filter_input(INPUT_POST, 'reading'),
- "spoken_interaction"=>filter_input(INPUT_POST, 'spoken_interaction'),
- "spoken_production"=>filter_input(INPUT_POST, 'spoken_production'),
- "writing"=>filter_input(INPUT_POST, 'writing'),
- );
- $language=filter_input(INPUT_POST, 'language'); //1 for English etc..
- $sql2=$db->prepare("INSERT INTO `cv_answer_languages`(`id_cv_language_levels`, `id_cv`, `id_language`, `id_cv_questions`) VALUES
- (:id_cv_languages_levels,:id_cv,:id_language,:id_cv_questions);");
- $sql2->bindParam(':id_cv_languages_levels',$lang_lev_last_id,PDO::PARAM_INT);
- $sql2->bindParam(':id_cv',$cv_id_query,PDO::PARAM_INT);
- $sql2->bindParam(':id_language',$language,PDO::PARAM_INT);//broken
- $sql2->bindParam(':id_cv_questions',$id_cv_question,PDO::PARAM_INT);
- $sql2->execute();
- CREATE TABLE IF NOT EXISTS `cv_answer_languages` (
- `id_cv_language` int(11) NOT NULL,
- `id_cv_language_levels` int(11) DEFAULT NULL,
- `id_cv` int(11) DEFAULT NULL,
- `id_language` int(11) DEFAULT NULL,
- `id_cv_questions` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- CREATE TABLE IF NOT EXISTS `cv_languages_levels` (
- `id_cv_language_levels` int(11) NOT NULL,
- `listening` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `reading` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `spoken_interaction` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `spoken_production` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `writing` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- CREATE TABLE IF NOT EXISTS `languages` (
- `id_language` int(11) NOT NULL,
- `language` varchar(45) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `short` varchar(15) COLLATE utf8_slovenian_ci DEFAULT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- CREATE TABLE IF NOT EXISTS `cv` (
- `id_cv` int(11) NOT NULL,
- `name` varchar(200) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `date` varchar(40) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `time` varchar(30) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `id_user` int(11) DEFAULT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement