Last active
August 29, 2015 14:17
-
-
Save devpruthvi/743bbf5740ac2f6332f7 to your computer and use it in GitHub Desktop.
project help for varma bro inserting multiple questions at once
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$con=mysql_connect("localhost","root",""); | |
mysql_select_db("project",$con); | |
$allQues = $_POST['ques']; | |
$individualQues = explode(',', $allQues); | |
foreach($individualQues as $key => $quesToInsert) | |
{ | |
insert_question($quesToInsert); | |
} | |
function insert_question($thisQues) | |
{ | |
$ar=$thisQues; | |
$ex=explode(" ",$ar); | |
$bl=array("Assemble"=>"Synthesize","act"=>"Synthesize","blend"=>"Synthesize","categorize"=>"Synthesize","combine"=>"Synthesize","compile"=>"Synthesize","compose"=>"Synthesize","construct"=>"Synthesize","creat"=>"Synthesize","devise"=>"Synthesize","design"=>"Synthesize","develope"=>"Synthesize","explain"=>"Synthesize","forecast"=>"Synthesize","formulate"=>"Synthesize","generate"=>"Synthesize","integrate"=>"Synthesize","invent"=>"Synthesize","improve"=>"Synthesize","imagine"=>"Synthesize","modify"=>"Synthesize","make"=>"Synthesize","organize "=>"Synthesize","originate "=>"Synthesize","perform"=>"Synthesize","plan"=>"Synthesize","prepare"=>"Synthesize","produce"=>"Synthesize","predict"=>"Synthesize","rearrange"=>"Synthesize","reconstruct"=>"Synthesize","relate"=>"Synthesize","reorganize"=>"Synthesize","revise"=>"Synthesize","rewrite"=>"Synthesize","summarize"=>"Synthesize","setup"=>"Synthesize","tell"=>"Synthesize","write"=>"Synthesize", | |
"appraise"=>"Evaluate","argue"=>"Evaluate","assess"=>"Evaluate","choose"=>"Evaluate","compare"=>"Evaluate","conclude"=>"Evaluate","contrast"=>"Evaluate","critique"=>"Evaluate","debate"=>"Evaluate","decide"=>"Evaluate","deduce"=>"Evaluate","defend"=>"Evaluate","describe"=>"Evaluate","determine"=>"Evaluate","discriminate"=>"Evaluate","evaluate"=>"Evaluate","explain"=>"Evaluate","interpret"=>"Evaluate","infer"=>"Evaluate","justify"=>"Evaluate","judge"=>"Evaluate","measure"=>"Evaluate","predict"=>"Evaluate","prioritize"=>"Evaluate","prove"=>"Evaluate","probe"=>"Evaluate","rank"=>"Evaluate","rate"=>"Evaluate","relate"=>"Evaluate","revise"=>"Evaluate","recommend"=>"Evaluate","reject"=>"Evaluate","score"=>"Evaluate","summarize"=>"Evaluate","support"=>"Evaluate","select"=>"Evaluate","validate"=>"Evaluate","value"=>"Evaluate", | |
"appraise"=>"Analyzing","analyze"=>"Analyzing","arrange"=>"Analyzing","break down"=>"Analyzing","characterize"=>"Analyzing","classify"=>"Analyzing","compare"=>"Analyzing","contrast"=>"Analyzing","calculate"=>"Analyzing","criticize"=>"Analyzing","debate"=>"Analyzing","deconstruct"=>"Analyzing","deduce"=>"Analyzing","detect"=>"Analyzing","diagram"=>"Analyzing","differentiate"=>"Analyzing","discriminate"=>"Analyzing","dissect"=>"Analyzing","distinguish"=>"Analyzing","draw"=>"Analyzing","examine"=>"Analyzing","experiment"=>"Analyzing","group"=>"Analyzing","identify"=>"Analyzing","illustrate"=>"Analyzing","infer"=>"Analyzing","inquire"=>"Analyzing","inspect"=>"Analyzing","investigate"=>"Analyzing","outline"=>"Analyzing","order"=>"Analyzing","probe"=>"Analyzing","question"=>"Analyzing","relate"=>"Analyzing","research"=>"Analyzing","select"=>"Analyzing","separate"=>"Analyzing","sequence"=>"Analyzing","survey"=>"Analyzing","test"=>"Analyzing", | |
"apply"=>"Applying","adapt"=>"Applying","change"=>"Applying","collect"=>"Applying","choose"=>"Applying","compute"=>"Applying","calculate"=>"Applying","construct"=>"Applying","draw"=>"Applying","dramatize"=>"Applying","demonstrate"=>"Applying","exhibit"=>"Applying","interview"=>"Applying","illustrate"=>"Applying","interpret"=>"Applying","make"=>"Applying","manipulate"=>"Applying","operate"=>"Applying","prepare"=>"Applying","produce"=>"Applying","practice"=>"Applying","role-play"=>"Applying","select"=>"Applying","show"=>"Applying","solve"=>"Applying","sequence"=>"Applying","transfer"=>"Applying","translate"=>"Applying","use"=>"Applying", | |
"account for"=>"Understanding","annotate"=>"Understanding","associate"=>"Understanding","comprehend"=>"Understanding","covert"=>"Understanding","conclude"=>"Understanding","define"=>"Understanding","defend"=>"Understanding","describe"=>"Understanding","distinguish"=>"Understanding","demonstrate"=>"Understanding","discuss"=>"Understanding","estimate"=>"Understanding","explain"=>"Understanding","extend"=>"Understanding","generalize"=>"Understanding","gives"=>"Understanding","examples"=>"Understanding","infer"=>"Understanding","interpret"=>"Understanding","identify"=>"Understanding","illustrate"=>"Understanding","observe"=>"Understanding","outline"=>"Understanding","paraphrase"=>"Understanding","predict"=>"Understanding","rewrite"=>"Understanding","report"=>"Understanding","restate"=>"Understanding","retell"=>"Understanding","research"=>"Understanding","review"=>"Understanding","recognize"=>"Understanding","reorganize"=>"Understanding","summarize"=>"Understanding","translate"=>"Understanding", | |
"tell"=>"Understanding", | |
"choose"=>"Remembering","count"=>"Remembering","cite"=>"Remembering","define"=>"Remembering","describe"=>"Remembering","distinguish"=>"Remembering","draw"=>"Remembering","find"=>"Remembering","group"=>"Remembering","identify"=>"Remembering","know"=>"Remembering","label"=>"Remembering","list"=>"Remembering","listen"=>"Remembering","locate"=>"Remembering","match"=>"Remembering","memorize"=>"Remembering","name"=>"Remembering","outline"=>"Remembering","quote"=>"Remembering","read"=>"Remembering","recall"=>"Remembering","relate"=>"Remembering","recognize"=>"Remembering","reproduce"=>"Remembering","repeat"=>"Remembering","recite"=>"Remembering","review"=>"Remembering","record"=>"Remembering","select"=>"Remembering","state"=>"Remembering","sequence"=>"Remembering","show"=>"Remembering","sort"=>"Remembering","tell"=>"Remembering","underline"=>"Remembering","write"=>"Remembering"); | |
$priorities = array( | |
"Synthesize" => 6, | |
"Evaluate" => 5, | |
"Analyzing" => 4, | |
"Applying" => 3, | |
"Understanding" => 2, | |
"Remembering" => 1); | |
$n=count($ex); | |
$j=0; | |
for($i=0;$i<$n;$i++) | |
{ | |
foreach($bl as $x => $x_value) | |
{ | |
$a=strcasecmp($ex[$i],$x); | |
if($a==0) | |
{ | |
$b[$j]=$x_value; | |
$j++; | |
} | |
} | |
} | |
$g=array_count_values($b); | |
$maximumValue = max($g); | |
$maxKeys = array_keys($g,$maximumValue); | |
if(sizeof($maxKeys) > 1) | |
{ | |
$maxpri = 0; | |
foreach($maxKeys as $currkey => $value) | |
{ | |
if($priorities[$value] > $maxpri) | |
$maxpri = $priorities[$value]; | |
} | |
$r=array_search($maxpri,$priorities); | |
} | |
else | |
{ | |
$r=$maxKeys[0]; | |
} | |
//echo $r; | |
$s=$_POST['subject']; | |
$q="create table $s (questions varchar(500),label varchar(20))"; | |
$re=mysql_query($q); | |
$qu="INSERT INTO $s (questions, label) VALUES('$thisQues', '$r')"; | |
$res=mysql_query($qu); | |
$quer="select * from $s where label='$r'"; | |
$res=mysql_query($quer); | |
if(mysql_num_rows($res)==0) | |
{ | |
header('Location:fail.php'); | |
} | |
else | |
{ | |
header('Location:success.php'); | |
} | |
} | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment