function generate($stdUSN, $startDate, $endDate)
{
global $con, $totalSessionsStd;
/*echo 'stdUSN : '.$stdUSN.'<br />';
echo 'startDate : '.$startDate.'<br />';
echo 'endDate : '.$endDate.'<br />';
echo 'totalSessionsStd : '.$totalSessionsStd.'<br />';*/
$totalSessionsStd++;
$sql = "SELECT * FROM activity WHERE usn = '{$stdUSN}' and day >= '{$startDate}' and day <= '{$endDate}'";
$data = mysql_query($sql, $con);
$j = $startDate;
for ($i = $startDate; $i <= $endDate; $i++, $j++) {
//echo 'Day : '.($i).'<br />';
$res = mysql_fetch_array($data);
//echo 'Day : '.$res['day'].'<br />';
//echo 'Seed : '.$res['seed'].'<br />';
$dummy = genDay($res['seed']);
//$kkk = strlen($dummy);
//if($kkk > 550)
//echo 'Hello';
//echo '$dummy len : '.$kkk;
//echo '<br /><br /><br />';
/* Write code to Insert $dummy into DB */
/* One day's activity of stdUSN will be generated by genDay() */
$query = "UPDATE activity SET act = '{$dummy}' WHERE usn = '{$stdUSN}' and day = '{$j}'";
mysql_query($query, $con);
}
/* Update the total sessions of stdUSN */
$q = "UPDATE studentsess SET totalsess = '{$totalSessionsStd}' WHERE usn = '{$stdUSN}'";
mysql_query($q, $con);
}
echo 'Unsuccessfull<br />';
}
$day[$j] = $i + 1;
$seedArr[$j++] = $var;
$seedChangeCounter++;
}
$i++;
$eleName++;
}
}
$totalSessionsStd = $sess;
echo '$totalSessionsStd : ' . $totalSessionsStd . '<br />';
$sql = "SELECT * FROM activity WHERE usn = '{$stdUSN}'";
$data = mysql_query($sql, $con);
for ($j = 0; $j < $seedChangeCounter; $j++) {
$dummy = genDay($seedArr[$j]);
/* Write code to Insert $dummy into DB */
/* One day's activity of stdUSN will be generated by genDay() */
$h = $day[$j];
$query = "UPDATE activity SET act = '{$dummy}' WHERE usn = '{$stdUSN}' and day = '{$h}'";
if (mysql_query($query, $con)) {
echo 'Successfull 2<br />';
} else {
echo 'Un - Successfull 2<br />';
}
}
echo 'Final totalSessionsStd : ' . $totalSessionsStd . '<br />';
$query = "UPDATE studentsess set totalsess = '{$totalSessionsStd}' WHERE usn = '{$stdUSN}'";
mysql_query($query, $con);
header('Location: studentSeed.php');
function genDay($seed)
$arr[0][10] = "day5";
$arr[1][0] = "2sd12cs050";
$arr[2][0] = "2sd12cs068";
$arr[3][0] = "2sd12cs127";
$arr[4][0] = "2sd12cs133";
$sql = "SELECT * FROM activity WHERE usn = '{$stdUSN}'";
$data = mysql_query($sql, $con);
//$res = mysql_fetch_array($data))
for ($j = 1; $arr[$j][0] == $stdUSN; $j++) {
}
for ($i = $startDate + 5; $i <= $endDate + 5; $i++) {
$res = mysql_fetch_array($data);
$var = $res['seed'];
$var = rand(3, $var);
while ($var > 0) {
$dummy = genDay($res['seed']);
/* Write code to Insert $dummy into DB */
/* One day's activity of stdUSN will be generated by genDay() */
$var--;
}
}
for ($i = 0, $column = 'A', $rowCount = 1; $i < 5; $i++, $rowCount++) {
for ($j = 0; $j < 11; $j++, $column++) {
$objPHPExcel->getActiveSheet()->setCellValue($column . $rowCount, $arr[$i][$j]);
}
$column = 'A';
}
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('C:\\xampp\\htdocs\\SPAS\\pages\\RScripts\\Book3.xls');
function genDay($seed)
{
