echo '</td>'; echo '<td>'; echo '<a class="video_link" href="#" id="video_link" data-type="textarea" data-pk="' . $rank . '" data-url="mysql_chart_update.php" data-title="Edit official Video link">' . $value['video_link'] . '</a>'; echo '<a href="' . $value['video_link'] . '" target="_blank"><span class="glyphicon icon-link-widgetapi"></span></a>'; echo '</td>'; echo '</tr>'; $rank++; } echo '</tbody>'; echo '</table>'; echo '<script type="text/javascript"> $(document).ready(function(){ '; echo '$(\'.itunes_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});'; echo '$(\'.amazon_phys_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});'; echo '$(\'.amazon_dwn_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});'; echo '$(\'.video_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});'; echo '}); </script>'; /** END Manage Charts Tab */ } ?> </div> </div> </div> <!--Exa get new Charts Tab --> <div class="tab-pane " ng-class="exasolTab"> <div class="row"> <div class="col-md-12"> <h4>
function get_chart($modul_id = 101, $time_unit = 'W', $time_key = 0) { global $mysql_db_dsn; $mysql_db = MDB2::connect($mysql_db_dsn); if (MDB2::isError($mysql_db)) { die($mysql_db->getMessage()); } $time_key = $time_key == 0 ? get_max_default_key() : $time_key; $ar = array(); $query = "SELECT * FROM `GE_CHART` WHERE modul_id = {$modul_id} and time_unit = '" . $time_unit . "' and time_key = " . $time_key . " ORDER BY rank asc"; $quid = $mysql_db->query($query); if (MDB2::isError($quid)) { die("Error in query: " . $query); } else { while ($row = $quid->fetchRow(MDB2_FETCHMODE_ASSOC)) { $ar[] = array('rank' => $row['rank'], 'titel' => $row['titel'], 'artist' => $row['artist'], 'itunes_link' => $row['itunes_link'], 'amazon_phys_link' => $row['amazon_phys_link'], 'amazon_dwn_link' => $row['amazon_dwn_link'], 'video_link' => $row['video_link']); } return $ar; } $mysql_db->disconnect(); }