diff options
| author | nice | 2014-08-27 16:33:06 +0530 |
|---|---|---|
| committer | nice | 2014-08-27 16:33:06 +0530 |
| commit | 6930246145a5df0d9e7864ea0ded7180a0329437 (patch) | |
| tree | 219b20ccf6223933137763252209b1f46f4ab039 /static/website/completed_workshops.php | |
| parent | 4fef619a1e01aae3a885d398205041f186a68822 (diff) | |
| download | pyfoss-6930246145a5df0d9e7864ea0ded7180a0329437.tar.gz pyfoss-6930246145a5df0d9e7864ea0ded7180a0329437.tar.bz2 pyfoss-6930246145a5df0d9e7864ea0ded7180a0329437.zip | |
major changes done from server
Diffstat (limited to 'static/website/completed_workshops.php')
| -rw-r--r-- | static/website/completed_workshops.php | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/static/website/completed_workshops.php b/static/website/completed_workshops.php new file mode 100644 index 0000000..4abfe13 --- /dev/null +++ b/static/website/completed_workshops.php @@ -0,0 +1,60 @@ +<html> + <head> + <link href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" rel="stylesheet"> + <style> + .pylogo { + width: 100px; + } + .pytitle { + display: inline; + } + </style> + </head> +</html> +<body> +<?php + $connection = mysql_connect("176.9.7.40", "scilabuser", "SciLab203*user"); + if(!$connection) { + die("Database connection failed" . mysql_error()); + } + $mysql_select = mysql_select_db("workshop_info", $connection); + if(!$mysql_select) { + die("Database selection failed" . mysql_error()); + } + $query = "select wr.id, wr.workshop_code, wr.cfm_wkshop_date, wr.foss_category, ac.institution_name, ac.city, wd.no_of_participants from workshop_requests wr, academic_center ac, workshop_details wd where wr.foss_category='Python' and wr.status=2 and ac.academic_code=wr.academic_code and wd.workshop_code=wr.workshop_code"; + $result = mysql_query($query); +?> + <div class="container"> + <center> + <br><br> + <img class="pylogo" src="http://python.fossee.in/static/website/images/pylogo.png"><h3 class="pytitle"> Python - Conducted Workshop List</h3> + <br><br> + </center> + + <table class="table table-striped table-bordered"> + <thead> + <th>#</th> + <th>Workshop Date</th> + <th>Institution Name</th> + <th>City</th> + <th>No. of participants</th> + </thead> + <tbody> + <?php + $count = 1; + while($row = mysql_fetch_object($result)) { + echo "<tr>"; + echo "<td>{$count}</td>"; + echo "<td>{$row->cfm_wkshop_date}</td>"; + echo "<td>{$row->institution_name}</td>"; + echo "<td>{$row->city}</td>"; + echo "<td>{$row->no_of_participants}</td>"; + echo "</tr>"; + $count++; + } + ?> + </tbody> + </table> + </div> +</body> +</html> |