Alguém sabe de algum sistema assim?
Abraço a todos!!!!
Edição feita por: rogeriodias, 23/09/2011, 12:05.
Posted 23/09/2011, 12:05
Edição feita por: rogeriodias, 23/09/2011, 12:05.
Posted 23/09/2011, 14:23
Posted 23/09/2011, 16:44
Felipe Antunes - Front-End
www.felipeantunes.com.br - clickeducacao.com.br - cyberconcurseiro.com.br - cybervestibular.com.br - pluc.com.br
Posted 23/09/2011, 17:25
Pagando bem, que mal tem...
Posted 28/09/2011, 10:53
CREATE TABLE `tbl_player` ( `id_musica` int(11) NOT NULL auto_increment, `titulo_musica` varchar(150) NOT NULL default '', `artista_musica` varchar(150) NOT NULL default '', `musica` varchar(255) NOT NULL default '', `copyright` varchar(50) NOT NULL default '', `status` varchar(10) NOT NULL default '', PRIMARY KEY (`id_musica`) ); ----- CRIA A TABELA DOS USUÁRIOS ----- CREATE TABLE `tbl_usuarios` ( `id` int(11) NOT NULL auto_increment, `nome` varchar(150) NOT NULL default '', `email` varchar(150) NOT NULL default '', `senha` varchar(50) NOT NULL default '', `status` varchar(10) NOT NULL default '', PRIMARY KEY (`id`) ); INSERT INTO `tbl_usuarios` VALUES (1,'Administrador','teste','123456','1');
<? session_start(); if (empty($_SESSION['usuario_id'])) { echo "Acesso negado!"; exit; }else{ include('config/conexao.php'); $usuario_id = $_SESSION['usuario_id']; $usuario_nome = $_SESSION['usuario_nome']; } ?> <? // PEGA OS DADOS DO USUÁRIO $query = "SELECT * FROM tbl_usuarios where id = '$usuario_id'"; $resultado = mysql_query($query); $campo = mysql_fetch_array ($resultado); $usuario_nome = $campo ['nome']; ?> <HTML> <HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <STYLE type=text/css>.titulos { FONT-SIZE: 16px; COLOR: #b09014; FONT-FAMILY: Arial, Helvetica, sans-serif } </STYLE> <title>.:: ADMINISTRAÇÃO ::.</title></HEAD> <BODY bgColor=#6c6c7d leftMargin=0 topMargin=0> <form action="script_player.php?acao=cadastrar" Method="post" enctype="multipart/form-data"> <TABLE cellSpacing=1 cellPadding=0 width=777 align=center bgColor=#000000 border=0> <TBODY> <TR> <TD bgColor=#d7dbe1> <TABLE cellSpacing=0 cellPadding=0 width=775 border=0> <TBODY> <TR> <TD> <TABLE cellSpacing=0 cellPadding=0 width=775 border=0> <TBODY> <TR> <TD width=12> </TD> <TD vAlign=middle width=145> <div align="center"><a href="principal.php" target="_top">LOGOTIPO</a></div> </TD> <TD vAlign=bottom width=76> </TD> <TD> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD align=right height=36> <TABLE cellSpacing=0 cellPadding=0 width=518 border=0> <TBODY> <TR> <TD class=top1><SPAN class=nome><font color="#000000" face="Verdana, Arial, Helvetica, sans-serif" size="2">Olá</font> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> <? echo "$usuario_nome"; ?> </font></SPAN><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> | ADMINISTRAÇÃO DO SISTEMA</font></TD> <TD width=61><A href="logout.php"><IMG height=14 src="imagens/res_bt-sair.gif" width=51 border=0></A></TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TD align=right> </TD> </TR> </TBODY> </TABLE> </TD></TR></TBODY></TABLE> <TABLE class=res-bg cellSpacing=0 cellPadding=0 width=775 border=0><TBODY> <TR> <TD align=middle> <TABLE cellSpacing=0 cellPadding=0 width=747 border=0> <TBODY> <TR> <TD><IMG height=2 src="imagens/extranet/res_linhas.gif" width=747></TD> </TR> <TR> <TD align=middle height=30> <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">efetue abaixo o cadastro de uma nova música.</font></div> </TD> </TR> <TR> <TD> <TABLE cellSpacing=0 cellPadding=0 width=747 border=0> <TR> <TD vAlign=bottom> <TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#4fa9c7 border=0> <TBODY> <TR> <TD width=10> </TD> <TD width=665><STRONG><FONT color=#ffffff> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">CADASTRAR MÚSICA </font></FONT></STRONG></TD> <TD align=right width=14> </TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TD bgColor=#ffffff valign="top"> <TABLE cellSpacing=0 cellPadding=4 width="100%" border=0> <TBODY> <TR> <TD valign="top"> <table width="100%" border="0" cellpadding="2" cellspacing="2" class="textoVerdanaPreto" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <tr bgcolor="#FFFFFF"> <td width="18%"> <div align="right"><span class='TextoPretoPequeno'>Título:</span></div> </td> <td> <input name="titulo_musica" type="text" class="formAzul" id="titulo_musica" size="20"> </td> <td> <div align="right">Artista:</div> </td> <td> <input name="artista_musica" type="text" class="formAzul" id="artista_musica" size="20"> </td> </tr> <tr bgcolor="#FFFFFF"> <td width="18%"> <div align="right"><span class='TextoPretoPequeno'>Ativo:</span></div> </td> <td> <select name='ativo' class='formAzul' id='ativo'> <option value="1" selected>SIM</option> <option value="0" >NÃO</option> </select> </td> <td> <div align="right">Música:</div> </td> <td> <input type="file" name="nome_arquivo" id="nome_arquivo"> </td> </tr> <tr bgcolor="#FFFFFF"> <td colspan="4"> <div align="center">(Inserir somente formato .mp3 (ex.: caravana.mp3)</div> </td> </tr> <tr bgcolor="#FFFFFF"> <td colspan="4"> <div align="center"> <input name="copyright" type="hidden" id="copyright" value=""> <input type=image src="imagens/bt_confirmar3.gif" border=0 name='submit'> </div> </td> </tr> </table> </TD> </TR> </TBODY> </TABLE> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD> </TD> </TR> </TBODY> </TABLE> </TD> </TR> </TABLE> </TD> </TR> <TR> <TD></TD> </TR> </TBODY> </TABLE> </TD> </TR></TBODY></TABLE> </TD> </TR></TBODY></TABLE></TD></TR></TBODY></TABLE> </form> </BODY></HTML>
<object type="application/x-shockwave-flash" data="dewplayer.swf" width="200" height="20" id="dewplayer" name="dewplayer"> <param name="wmode" value="transparent" /><param name="movie" value="dewplayer.swf" /> <param name="flashvars" value="mp3=teste.mp3" /> </object>
<?php include 'admin/config/conexao.php'; $mysql_query = "SELECT * FROM `tbl_player` LIMIT 0, 30 "; $resultado = mysql_query($query); $campo = mysql_fetch_array ($resultado); $titulo_musica = $campo ['titulo_musica']; $artista_musica = $campo ['artista_musica']; $musica = $campo ['musica']; $query = sprintf("SELECT titulo_musica, artista_musica, musica from `tbl_player`", mysql_real_escape_string($titulo_musica), mysql_real_escape_string($artista_musica), mysql_real_escape_string($musica)); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } while ($row = mysql_fetch_assoc($result)) { echo $row['titulo_musica']; echo $row['artista_musica']; echo $row['musica']; } mysql_free_result($result); ?>
Edição feita por: rogeriodias, 28/09/2011, 10:54.
Posted 28/09/2011, 13:42
<!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Untitled Document</title> </head> <body><?php include 'admin/config/conexao.php'; $mysql_query = "SELECT * FROM `tbl_player` LIMIT 0, 30 "; $resultado = mysql_query($query); $campo = mysql_fetch_array ($resultado); $titulo_musica = $campo ['titulo_musica']; $artista_musica = $campo ['artista_musica']; $musica = $campo ['musica']; $query = sprintf("SELECT titulo_musica, artista_musica, musica from `tbl_player`", mysql_real_escape_string($titulo_musica), mysql_real_escape_string($artista_musica), mysql_real_escape_string($musica)); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } while ($row = mysql_fetch_assoc($result)) { echo $row['artista_musica']; echo $row['musica']; ?> <table width="708" border="0"> <tr> <td width="95"><strong>musica</strong></td> <td width="603"><?php echo $row['titulo_musica'];?></td> </tr> <tr> <td><strong>artista</strong></td> <td><?php echo $row['artista_musica'];?></td> </tr> <tr> <td colspan="2"> </td> </tr> </table><?php } mysql_free_result($result); ?> </body> </html>
Posted 28/09/2011, 15:15
<table border="0" cellpadding="0" cellspacing="0"> <?php include 'admin/config/conexao.php'; $mysql_query = "SELECT * FROM `tbl_player` LIMIT 0, 30 "; $resultado = mysql_query($query); $campo = mysql_fetch_array ($resultado); $titulo_musica = $campo ['titulo_musica']; $artista_musica = $campo ['artista_musica']; $arquivo = $_FILES ['musica']; $query = sprintf("SELECT titulo_musica, artista_musica, musica from `tbl_player`", mysql_real_escape_string($titulo_musica), mysql_real_escape_string($artista_musica), mysql_real_escape_string($musica)); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } while ($row = mysql_fetch_assoc($result)) { ?> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['titulo_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['artista_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['musica']?></td> </tr> <?php } ?> <tr> <td> </td> </table>
<td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['musica']?></td>
<object type="application/x-shockwave-flash" data="dewplayer.swf" width="200" height="20" id="dewplayer" name="dewplayer"> <param name="wmode" value="transparent" /><param name="movie" value="dewplayer.swf" /> <param name="flashvars" value="mp3=teste.mp3" /> </object>
Posted 28/09/2011, 15:49
<script language="JavaScript" src="audio-player.js"></script> <object type="application/x-shockwave-flash" data="player.swf" id="audioplayer1" height="24" width="290"> <param name="movie" value="player.swf"> <param name="FlashVars" value="playerID=audioplayer1&soundFile=<?php echo $avarialdamusicaaqui?>"> <param name="quality" value="high"> <param name="menu" value="false"> <param name="wmode" value="transparent"> </object>
<object type="application/x-shockwave-flash" data="dewplayer.swf" width="200" height="20" id="dewplayer" name="dewplayer"> <param name="wmode" value="transparent" /><param name="movie" value="dewplayer.swf" /> <param name="flashvars" value="diretorio_da_musica/<?php echo $row['musica']?>" /> </object>
Edição feita por: Diego Bezerra, 28/09/2011, 15:53.
Posted 28/09/2011, 16:25
Posted 28/09/2011, 16:32
value="diretorio_da_musica/<?php echo $row['musica']?>"
Posted 28/09/2011, 16:42
<script language="Javascript" src="audio-player.js"></script> <table border="0" cellpadding="0" cellspacing="0"> <?php include 'admin/config/conexao.php'; $mysql_query = "SELECT * FROM `tbl_player` LIMIT 0, 30 "; $resultado = mysql_query($query); $campo = mysql_fetch_array ($resultado); $titulo_musica = $campo ['titulo_musica']; $artista_musica = $campo ['artista_musica']; $arquivo = $_FILES ['musica']; $query = sprintf("SELECT titulo_musica, artista_musica, musica from `tbl_player`", mysql_real_escape_string($titulo_musica), mysql_real_escape_string($artista_musica), mysql_real_escape_string($musica)); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } while ($row = mysql_fetch_assoc($result)) { ?> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['titulo_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['artista_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><object type="application/x-shockwave-flash" data="/dewplayer/dewplayer.swf" width="200" height="20" id="dewplayer" name="dewplayer"> <param name="wmode" value="transparent" /><param name="movie" value="dewplayer.swf" /> <param name="flashvars" value="musicas/<?php echo $row['musica']?>"" /> </object></td> </tr> <?php } ?> <tr> <td> </td> </table>
Edição feita por: rogeriodias, 28/09/2011, 16:43.
Posted 28/09/2011, 16:48
<script language="Javascript" src="audio-player.js"></script> <table border="0" cellpadding="0" cellspacing="0"> <?php include 'admin/config/conexao.php'; $mysql_query = "SELECT * FROM `tbl_player` LIMIT 0, 30 "; $resultado = mysql_query($query); $campo = mysql_fetch_array ($resultado); $titulo_musica = $campo ['titulo_musica']; $artista_musica = $campo ['artista_musica']; $arquivo = $_FILES ['musica']; $query = sprintf("SELECT titulo_musica, artista_musica, musica from `tbl_player`", mysql_real_escape_string($titulo_musica), mysql_real_escape_string($artista_musica), mysql_real_escape_string($musica)); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } while ($row = mysql_fetch_assoc($result)) { ?> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['titulo_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['artista_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"> <object type="application/x-shockwave-flash" data="dewplayer/dewplayer.swf" width="200" height="20" id="dewplayer" name="dewplayer"> <param name="wmode" value="transparent" /> <param name="movie" value="dewplayer.swf" /> <param name="flashvars" value="musicas/<?php echo $row['musica']?>" /> </object></td> </tr> <?php } ?> <tr> <td> </td> </table>
Edição feita por: Diego Bezerra, 28/09/2011, 16:50.
Posted 28/09/2011, 16:52
Posted 28/09/2011, 17:03
<script language="Javascript" src="audio-player.js"></script> <?php #CONEÇÃO $d = 'test'; /// Name of database to be used. $h = 'localhost'; /// The hostname of the database server $u = 'root'; /// The username which is used to connect to the database server. $s = ''; $db = mysql_connect($h, $u, $s); mysql_select_db($d); $query = ("SELECT titulo_musica, artista_musica, musica from `tbl_player`"); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } while ($row = mysql_fetch_assoc($result)) { ?><table border="0" cellpadding="0" cellspacing="0" width="500"> <tr> <td><?php echo $row['titulo_musica']?></td> </tr> <tr> <td><?php echo $row['artista_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"> <script language="Javascript" src="audio-player.js"></script> <object type="application/x-shockwave-flash" data="player.swf" id="audioplayer1" height="24" width="290"> <param name="movie" value="player.swf"> <param name="FlashVars" value="playerID=audioplayer1&soundFile=<?php echo $row['musica']?>"> <param name="quality" value="high"> <param name="menu" value="false"> <param name="wmode" value="transparent"> </object> </td> </tr> <?php } ?> <tr> <td> </td> </table>
Posted 29/09/2011, 10:12
<object type="application/x-shockwave-flash" data="dewplayer/dewplayer-vol.swf" width="200" height="20" id="dewplayer-vol" name="dewplayer-vol"> <param name="wmode" value="transparent" /> <param name="movie" value="dewplayer-vol.swf" /> <param name="flashvars" value="mp3=musicas/<?php echo $row['musica']?>" /> </object>
<?php $d = 'banco'; $h = 'localhost'; $u = 'user'; $s = 'senha'; $db = mysql_connect($h, $u, $s); mysql_select_db($d); $query = ("SELECT titulo_musica, artista_musica, musica from `tbl_player`"); $result = mysql_query($query); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } ##### - Paginação $conn = mysql_connect("localhost","user","senha"); $banco = mysql_select_db("banco"); $busca = "SELECT * FROM tbl_player"; $total_reg = "3"; // número de registros por página if (!$pagina) { $pc = "1"; } else { $pc = $pagina; } $inicio = $pc - 1; $inicio = $inicio * $total_reg; $limite = mysql_query("$busca LIMIT $inicio,$total_reg"); $todos = mysql_query("$busca"); $tr = mysql_num_rows($todos); // verifica o número total de registros $tp = $tr / $total_reg; // verifica o número total de páginas // vamos criar a visualização while ($row = mysql_fetch_assoc($result)) { ?><table border="0" cellpadding="0" cellspacing="0" width="500"> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['artista_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"><?php echo $row['titulo_musica']?></td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"> <object type="application/x-shockwave-flash" data="/dewplayer/dewplayer-vol.swf" width="200" height="20" id="dewplayer" name="dewplayer"> <param name="wmode" value="transparent" /> <param name="movie" value="dewplayer-vol.swf" /> <param name="flashvars" value="mp3=musicas/<?php echo $row['musica']?>" /> </object> </td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"> </td> </tr> <tr> <td style="font-family:Verdana, Geneva, sans-serif; font-size:10;"> </td> </tr> <?php } ?> </table> <? $anterior = $pc -1; $proximo = $pc +1; if ($pc>1) { echo " <a href='?pagina=$anterior'><- Anterior</a> "; } echo "|"; if ($pc<$tp) { echo " <a href='?pagina=$proximo'>Próxima -></a>"; } ?>
0 membro(s), 0 visitante(s) e 0 membros anônimo(s)