Здравейте, искам да помоля някога да ми помогне да направя Ajax + PHP на тези 2 странички... Примерно, когато кликна на категорията и от долу под категориите да ми изкаврва плейара и т.н.
Категории:
Песните:
Благодаря предварително 
Категории:
Код:
<?php
include "include/functions.php";
functionConnect("pozdrawi");
$i = 0;
$Categorie = mysql_query("SELECT * FROM songs_cat");
echo "<center><a href='javascript: show()'>Categories</a><br />
<div class='playlist' align='left' style='display:none;'>";
while ($play = mysql_fetch_array($Categorie)) {
$i = $i + 1;
$category = $cat['cat_name'];
echo " $i.<a href='song.php?cat=" . $play['id'] . "'>" . $play[cat_name] . "</a><br />";
}
echo "</div>";
?>
Код:
<?php
include "include/functions.php";
$id = (int) $_GET['id'];
$catid = (int) $_GET['cat'];
if ($catid == NULL) {
echo "Променливата е празна !";
} else {
print functionCat("" . $catid . "");
functionConnect("pozdrawi");
$SQL_Song = mysql_query("SELECT * FROM songs WHERE id='$id'");
$row = mysql_fetch_array($SQL_Song);
$url = $row['link'];
$number = explode(":", $url);
$i = substr($number[2], 0, 2);
$link1 = "http://media.vbox7.com/s/$i/$number[2].flv";
if (@fopen("http://media.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media02.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media02.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media03.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media03.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media04.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media04.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media05.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media05.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media06.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media06.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media07.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media07.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media08.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media08.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media09.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media09.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media10.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media10.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media11.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media11.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media12.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media12.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media13.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media13.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media14.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media14.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media15.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media15.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media16.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media16.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media17.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media17.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media18.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media18.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media19.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media19.vbox7.com/s/$i/$number[2].flv";
} elseif (@fopen("http://media20.vbox7.com/s/$i/$number[2].flv", "r")) {
$adres = "http://media20.vbox7.com/s/$i/$number[2].flv";
}
pg_connect("host=127.0.0.1 port=5432 dbname=macrofactor user=factor password=##Factor1");
$PG_Users = mysql_query("SELECT * FROM users_mfuser WHERE usr_ptr_id='71'");
$user = mysql_fetch_array($PG_Users) or die(mysql_error());
if ($id == NULL) {
} elseif ($user['user_song_credits'] == 0) {
print "<center><img src='images/player-disabled.jpg' border='0'/></center>";
} elseif ($user['user_song_credits'] > 0) {
?><br />
<center><div id='mediaspace'>Трябва да имате инсталиран Flash Player за да слушате</div></center>
<script type='text/javascript'>
var so = new SWFObject('player.swf','mpl','350','20','9');
so.addParam('allowfullscreen','true');
so.addParam('allowscriptaccess','never');
so.addParam('wmode','opaque');
so.addVariable('backcolor','8454c6');
so.addVariable('frontcolor','FFFFFF');
so.addVariable('lightcolor','FFFFFF');
so.addVariable('screencolor','0f0f0f');;
so.addVariable('menu','over');
so.addVariable('file','<?= $adres ?>&menu=false');
so.write('mediaspace');
</script><br />
<?php
echo "Сега свири: <b>".$row['author']." - ".$row['name']."</b>";
}
$i = 0;
$Play_Song = mysql_query("SELECT * FROM songs WHERE cat_id='$catid'");
echo "<center>
<a href='javascript: show()'>Playlist</a> <a href='search.php'>Търси Песен</a><br />
<div class='playlist' align='left' style='display:none;'>";
while ($play = mysql_fetch_array($Play_Song)) {
$i = $i + 1;
$song_cat = $play['cat_id'];
$Play_Cat = mysql_query("SELECT * FROM songs_cat WHERE id='$song_cat'");
$cat = mysql_fetch_array($Play_Cat);
$category = $cat['cat_name'];
echo " $i.<a href='song.php?cat=" . $catid . "&id=" . $play['id'] . "'>" . $play[author] . "-" . $play[name] . "</a> - [<i><b>" . $play['sms_code'] . "</i></b>]<br />";
}
echo "</div>";
functionSMSCheck();
}
?>