Server : Apache System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64 User : apache ( 48) PHP Version : 8.0.28 Disable Function : NONE Directory :  /var/www/html/venkat/electiveaug22/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
include("sedit.php");
//$truncated = substr($s, 1, 2);
$basket = addslashes($_POST['basket']);
$updatebasket = $basket;
$basketpref = mysql_query("select preference from basket_elective where dept = '$truncated1'") or die ("Invalid Accessesesd !!!");
while($row = mysql_fetch_array($basketpref)) {
	$single_basket = $row['preference'];
}
if($single_basket != 0) {
	$basket = 1;
}

?>

<table width="600" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="seditbasketstore.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Edit your Preference for <font color="red"> Basket  <?php echo($basket); ?> </font> </strong></td>
</tr>
<tr>

<?php

//$truncatedold = $truncated1."1";
$truncatedold = $truncated1."jan21";
if($truncated1 == "bmelectivesubmit") {
	$truncatedold = "melectivesubmitjan21";
}
$truncatedold;
$quer1 = mysql_query("select coursecode, basket, subject from matrix where semester = '$semester' and discipline='$truncated' and basket='$basket'") or die("Invalid Access !!!"); 
$i=0;

while ($row = mysql_fetch_array( $quer1 )) {
	$m[$i]=$row['subject'];
	$coursecode[$i]=$row['coursecode'];
	//$basket[$i] = $row['basket'];
	$quertoold=mysql_query("select name from $truncatedold where rollno='$s' and fes='$m[$i]'") or die("Invalid Access !!!");
	$querdualdegree = mysql_query("select * from dualdegree where course = '$coursecode[$i]' and semester = $semester and discipline = '$dualdegree'") or die("Invalid Access !!!");
	$querdualdegreeres = mysql_query("select * from subjectrestriction where basket = '$basket' and discipline = '$dualdegree'") or die("Invalid Access !!!");
	if(mysql_fetch_array($quertoold) || mysql_fetch_array($querdualdegree)) {

	}
	else {
		$i++;
	}	
}
$ij = 0;
while($rowres = mysql_fetch_array($querdualdegreeres)){
	$m[$ij] = $rowres['subject'];
	$coursecode[$ij] = $rowres['coursecode'];
	$ij++;
	$i = $ij;
}

for ( $j = 0; $j <= $i-1; $j++)	{	
	$sj = $j;
	$sj = $sj+1;
	echo("<td width='200'> Preference $sj</td> <td width='30'>:</td>");
	echo("<td width='400'><select name=$sj id='subject' />");
	echo("<option value='#'>-Select-</option>");
	for ( $k = 0; $k <= $i-1; $k++)	{	
		echo("<option value = $coursecode[$k]>$coursecode[$k]-$m[$k]</option>");
	}
	echo("</select></td> </tr> <tr>");
	echo("<center>");
}









?>
</tr>
<tr>
<input type="hidden" name="basket" value=<?php echo($updatebasket); ?>></td>
<td colspan = "3"><br><input type="submit"  value="Submit"><font color ="red"> If you opt an elective more than once/not opt any subject then you cannot edit. </font></td>
</tr>
</table>
</form>
</table>