Advertisement
Guest User

Untitled

a guest
May 5th, 2015
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.37 KB | None | 0 0
  1. $array=array(
  2. "listening"=>filter_input(INPUT_POST, 'listening'), //just values like a1,b2,c2 etc...
  3. "reading"=>filter_input(INPUT_POST, 'reading'),
  4. "spoken_interaction"=>filter_input(INPUT_POST, 'spoken_interaction'),
  5. "spoken_production"=>filter_input(INPUT_POST, 'spoken_production'),
  6. "writing"=>filter_input(INPUT_POST, 'writing'),
  7. );
  8. $language=filter_input(INPUT_POST, 'language'); //1 for English etc..
  9.  
  10. $sql2=$db->prepare("INSERT INTO `cv_answer_languages`(`id_cv_language_levels`, `id_cv`, `id_language`, `id_cv_questions`) VALUES
  11. (:id_cv_languages_levels,:id_cv,:id_language,:id_cv_questions);");
  12. $sql2->bindParam(':id_cv_languages_levels',$lang_lev_last_id,PDO::PARAM_INT);
  13. $sql2->bindParam(':id_cv',$cv_id_query,PDO::PARAM_INT);
  14. $sql2->bindParam(':id_language',$language,PDO::PARAM_INT);//broken
  15. $sql2->bindParam(':id_cv_questions',$id_cv_question,PDO::PARAM_INT);
  16. $sql2->execute();
  17.  
  18. CREATE TABLE IF NOT EXISTS `cv_answer_languages` (
  19. `id_cv_language` int(11) NOT NULL,
  20. `id_cv_language_levels` int(11) DEFAULT NULL,
  21. `id_cv` int(11) DEFAULT NULL,
  22. `id_language` int(11) DEFAULT NULL,
  23. `id_cv_questions` int(11) DEFAULT NULL
  24. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
  25.  
  26. CREATE TABLE IF NOT EXISTS `cv_languages_levels` (
  27. `id_cv_language_levels` int(11) NOT NULL,
  28. `listening` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
  29. `reading` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
  30. `spoken_interaction` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
  31. `spoken_production` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
  32. `writing` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL
  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
  34.  
  35. CREATE TABLE IF NOT EXISTS `languages` (
  36. `id_language` int(11) NOT NULL,
  37. `language` varchar(45) COLLATE utf8_slovenian_ci DEFAULT NULL,
  38. `short` varchar(15) COLLATE utf8_slovenian_ci DEFAULT NULL
  39. ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
  40.  
  41. CREATE TABLE IF NOT EXISTS `cv` (
  42. `id_cv` int(11) NOT NULL,
  43. `name` varchar(200) COLLATE utf8_slovenian_ci DEFAULT NULL,
  44. `date` varchar(40) COLLATE utf8_slovenian_ci DEFAULT NULL,
  45. `time` varchar(30) COLLATE utf8_slovenian_ci DEFAULT NULL,
  46. `id_user` int(11) DEFAULT NULL
  47. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement