Skip to content

Instantly share code, notes, and snippets.

@devpruthvi
Last active August 29, 2015 14:17
Show Gist options
  • Save devpruthvi/743bbf5740ac2f6332f7 to your computer and use it in GitHub Desktop.
Save devpruthvi/743bbf5740ac2f6332f7 to your computer and use it in GitHub Desktop.
project help for varma bro inserting multiple questions at once
<?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