/webserver/setsuden/mobile/crediets.php
https://bitbucket.org/yutof/gamificationofresearchenvironment_iphone · PHP · 77 lines · 35 code · 5 blank · 37 comment · 3 complexity · 61dd7e0637ccf971e9cf9323a35474f3 MD5 · raw file
- <?php
- require_once 'mbl_vertical_header.php';
- $selected_num = 4;
- ?>
- <div id="header"><a>Credits</a></div>
- <div id="wrapper">
- <div id="scroller">
- <ul id="thelist">
- <?php
-
- $link = mysql_connect($dburl, $fb_dbusr, $fb_dbpass);
- if (!$link) {die('Could not connect: ' . mysql_error());}
- mysql_select_db($dbname);
- mysql_set_charset('utf8',$link);
- $query = "SELECT Contributor_Title, Contributor_Name, Contributor_Description From Contributor Order By Contributor_Priority DESC, Contributor_Timestamp DESC;";
- // $charset = mysql_client_encoding($link);
- $result = mysql_query($query) or die('Query failed: ' .$query. mysql_error());
- mysql_close($link);
- // echo "<table class='credietsTable'><thead></thead>";
- // echo "<tfoot></tfoot>";
- // echo "<tbody>";
- while ($row = mysql_fetch_array($result, MYSQL_NUM))
- {
- echo "<li><div class='ctrbtr_role'>";
- //for($j=0; $j < 4; $j++)
- if(strlen($row[0]))
- echo "$row[0]";
- else
- echo "No Name";
- echo "</div></li>";
- // echo "<td class='credietsTable'> ";
- //
- echo "<li><div class='ctrbtr_name'> ";
- echo strip_tags($row[1]);
- // echo "</td>";
- //echo "<td>".$row[2]."</td>";
- echo "</div></li>";
- }//end of while
-
- /*
- $link = mysql_connect($dburl, $fb_dbusr, $fb_dbpass);
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db($dbname);
- $query = "SELECT name, score, reportTime From StrategyReport Order By reportID DESC LIMIT 0 , 30";// LIMIT 0 , 30
- $result = mysql_query($query) or die('Query failed: ' .$query. mysql_error());
- mysql_close($link);
- while ($row = mysql_fetch_array($result, MYSQL_NUM))
- {
- echo "<li>";
- echo "<div class='li_column1'>";
- $date = new DateTime($row[2]);
- echo $date->format('n/j/y g:i');
-
- echo "</div><div class='li_column2'>";
- if(strlen($row[0]))
- echo "$row[0]";
- else
- echo "No Name";
- echo " ";
- echo "</div><div class='li_column3'>";
- printf("%3.02f%%",$row[1]);
- echo "</div></li>";
- }//end of while
- */
- ?>
- </ul>
- </div>
- </div>
- <?php
- require_once 'mbl_footer.php';
- ?>