(1)write code for "filterdownload.php":
<html>
<head>
<script>
function ajax_post(){
// Create our XMLHttpRequest object
var hr = new XMLHttpRequest();
// Create some variables we need to send to our PHP file
var url = "displaynotes1previous.php";
var fn = document.getElementById("coursename").value;
var en = document.getElementById("semseter").value;
var vars = "coursename="+fn+"&semseter="+en;
hr.open("POST", url, true);
// Set content type header information for sending url encoded variables in the request
hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
// Access the onreadystatechange event for the XMLHttpRequest object
hr.onreadystatechange = function() {
if(hr.readyState == 4 && hr.status == 200) {
var return_data = hr.responseText;
document.getElementById("status").innerHTML = return_data;
}
}
// Send the data to PHP now... and wait for response to update the status div
hr.send(vars); // Actually execute the request
document.getElementById("status").innerHTML = "processing...";
}
function ajax_disp(){
// Create our XMLHttpRequest object
var hr = new XMLHttpRequest();
// Create some variables we need to send to our PHP file
var url = "displaynotes1.php";
var fn = document.getElementById("coursename").value;
var en = document.getElementById("semseter").value;
var pn = document.getElementById("subject").value;
var vars = "coursename="+fn+"&semseter="+en+"&subject="+pn;
hr.open("POST", url, true);
// Set content type header information for sending url encoded variables in the request
hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
// Access the onreadystatechange event for the XMLHttpRequest object
hr.onreadystatechange = function() {
if(hr.readyState == 4 && hr.status == 200) {
var return_data = hr.responseText;
document.getElementById("status").innerHTML = return_data;
}
}
// Send the data to PHP now... and wait for response to update the status div
hr.send(vars); // Actually execute the request
document.getElementById("status").innerHTML = "processing...";
}
</script>
</head>
<body>
<span style="color:#000;">Select Course Name : -</span>
<select name=coursename id="coursename" >
<?php
$con = mysql_connect('localhost', 'root', '');
mysql_select_db("itexam", $con);
$sql="select * from subject group by coursename ";
$result=mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['coursename'].'">';
echo $row['coursename'];
echo '<option>';
}
?>
</select>
<span style="color:#000;">Select Semester : -</span>
<select name=semseter id="semseter" onChange="ajax_post();">
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("itexam",$con);
$sql="select * from subject group by semseter ";
$result=mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['semseter'].'">';
echo $row['semseter'];
echo '<option>';
}
?>
</select>
<!------>
<div id="status">
</div>
<input align="middle" name="myBtn" type="submit" value="Submit Data" onclick="ajax_disp();">
<br /><br /><br /><br />
<?php
ob_flush();
?>
</div>
</center>
</body>
</html>
(2)write code for "displaynotes1previous.php" :
<html>
<head>
</head>
<body>
<?php
$coursename=$_POST['coursename'];
$semseter=$_POST['semseter'];
?>
Subject <select name="subject" id="subject">
<?php
$con = mysql_connect('localhost', 'root', '');
mysql_select_db("itexam", $con);
$sql="select subject from subject where coursename='$coursename' AND semseter='$semseter'";
$result=mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['subject'].'">';
echo $row['subject'];
echo '<option>';
}
?>
</select>
</td></tr>
<tr>
<td>
</tr>
<div id="status1"></div>
</body>
</html>
(3)write code for "displaynotes1.php file":
<?php
ob_start();
?>
<?php
$coursename=$_POST['coursename'];
$semester=$_POST['semseter'];
$subject=$_POST['subject'];
echo '<h3>';
echo '<table border=0>';
echo '<tr> <td>';
echo "CourseName =".$coursename;
echo '</td> <td> </td>';
echo '<td>';
echo "Semester =".$semester;
echo '</td></tr>';
echo '</table>';
echo '</h3>';
//$con=mysql_connect("localhost","root","");
$con = mysql_connect('localhost', 'root', '');
mysql_select_db("itexam", $con);
//mysql_select_db("itexam",$con);
$sql="select * from notes where coursename='$coursename' AND semester='$semester' AND subject='$subject' order by subject";
$result=mysql_query($sql) or die(mysql_error());
echo '<h4>';
echo '<table border=0>';
echo '<tr><td><h2>Subject Name </h2></td><td> </td><td><h2>Unit </h2></td><td> </td> <td> <h2>Download Link</h2></td></tr>';
while($row=mysql_fetch_array($result))
{
echo ' <tr><td>"'.$row['subject'].'" </td><td> </td><td>"'.$row['unit'].'" </td><td> </td>
<td>
<button ><a href=../proudct_images/'.$row['file'].'>
Download file</a></button> </td></tr>';
}
echo '</table>';
?>
<?php
$sql1="select * from downloadall where coursename='$coursename' AND semester='$semester' order by subject";
$result1=mysql_query($sql1) or die(mysql_error());
while($row1=mysql_fetch_array($result1))
{
echo ' <tr>
<td>
<button ><a href=../uploadall/'.$row1['file'].'>
Download All Notes</a></button> </td></tr>';
}
?>
<?php
ob_flush();
?>
<html>
<head>
<script>
function ajax_post(){
// Create our XMLHttpRequest object
var hr = new XMLHttpRequest();
// Create some variables we need to send to our PHP file
var url = "displaynotes1previous.php";
var fn = document.getElementById("coursename").value;
var en = document.getElementById("semseter").value;
var vars = "coursename="+fn+"&semseter="+en;
hr.open("POST", url, true);
// Set content type header information for sending url encoded variables in the request
hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
// Access the onreadystatechange event for the XMLHttpRequest object
hr.onreadystatechange = function() {
if(hr.readyState == 4 && hr.status == 200) {
var return_data = hr.responseText;
document.getElementById("status").innerHTML = return_data;
}
}
// Send the data to PHP now... and wait for response to update the status div
hr.send(vars); // Actually execute the request
document.getElementById("status").innerHTML = "processing...";
}
function ajax_disp(){
// Create our XMLHttpRequest object
var hr = new XMLHttpRequest();
// Create some variables we need to send to our PHP file
var url = "displaynotes1.php";
var fn = document.getElementById("coursename").value;
var en = document.getElementById("semseter").value;
var pn = document.getElementById("subject").value;
var vars = "coursename="+fn+"&semseter="+en+"&subject="+pn;
hr.open("POST", url, true);
// Set content type header information for sending url encoded variables in the request
hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
// Access the onreadystatechange event for the XMLHttpRequest object
hr.onreadystatechange = function() {
if(hr.readyState == 4 && hr.status == 200) {
var return_data = hr.responseText;
document.getElementById("status").innerHTML = return_data;
}
}
// Send the data to PHP now... and wait for response to update the status div
hr.send(vars); // Actually execute the request
document.getElementById("status").innerHTML = "processing...";
}
</script>
</head>
<body>
<span style="color:#000;">Select Course Name : -</span>
<select name=coursename id="coursename" >
<?php
$con = mysql_connect('localhost', 'root', '');
mysql_select_db("itexam", $con);
$sql="select * from subject group by coursename ";
$result=mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['coursename'].'">';
echo $row['coursename'];
echo '<option>';
}
?>
</select>
<span style="color:#000;">Select Semester : -</span>
<select name=semseter id="semseter" onChange="ajax_post();">
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("itexam",$con);
$sql="select * from subject group by semseter ";
$result=mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['semseter'].'">';
echo $row['semseter'];
echo '<option>';
}
?>
</select>
<!------>
<div id="status">
</div>
<input align="middle" name="myBtn" type="submit" value="Submit Data" onclick="ajax_disp();">
<br /><br /><br /><br />
<?php
ob_flush();
?>
</div>
</center>
</body>
</html>
(2)write code for "displaynotes1previous.php" :
<html>
<head>
</head>
<body>
<?php
$coursename=$_POST['coursename'];
$semseter=$_POST['semseter'];
?>
Subject <select name="subject" id="subject">
<?php
$con = mysql_connect('localhost', 'root', '');
mysql_select_db("itexam", $con);
$sql="select subject from subject where coursename='$coursename' AND semseter='$semseter'";
$result=mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['subject'].'">';
echo $row['subject'];
echo '<option>';
}
?>
</select>
</td></tr>
<tr>
<td>
</tr>
<div id="status1"></div>
</body>
</html>
(3)write code for "displaynotes1.php file":
<?php
ob_start();
?>
<?php
$coursename=$_POST['coursename'];
$semester=$_POST['semseter'];
$subject=$_POST['subject'];
echo '<h3>';
echo '<table border=0>';
echo '<tr> <td>';
echo "CourseName =".$coursename;
echo '</td> <td> </td>';
echo '<td>';
echo "Semester =".$semester;
echo '</td></tr>';
echo '</table>';
echo '</h3>';
//$con=mysql_connect("localhost","root","");
$con = mysql_connect('localhost', 'root', '');
mysql_select_db("itexam", $con);
//mysql_select_db("itexam",$con);
$sql="select * from notes where coursename='$coursename' AND semester='$semester' AND subject='$subject' order by subject";
$result=mysql_query($sql) or die(mysql_error());
echo '<h4>';
echo '<table border=0>';
echo '<tr><td><h2>Subject Name </h2></td><td> </td><td><h2>Unit </h2></td><td> </td> <td> <h2>Download Link</h2></td></tr>';
while($row=mysql_fetch_array($result))
{
echo ' <tr><td>"'.$row['subject'].'" </td><td> </td><td>"'.$row['unit'].'" </td><td> </td>
<td>
<button ><a href=../proudct_images/'.$row['file'].'>
Download file</a></button> </td></tr>';
}
echo '</table>';
?>
<?php
$sql1="select * from downloadall where coursename='$coursename' AND semester='$semester' order by subject";
$result1=mysql_query($sql1) or die(mysql_error());
while($row1=mysql_fetch_array($result1))
{
echo ' <tr>
<td>
<button ><a href=../uploadall/'.$row1['file'].'>
Download All Notes</a></button> </td></tr>';
}
?>
<?php
ob_flush();
?>
No comments:
Post a Comment