ime uploadovanog fajla se pravi na osnovu:
Code:
$name = "pesma_" . $songId . "." . $extension[1];
$name = "pesma_" . $songId . "." . $extension[1];
i na osnovu toga se dobije fajl recimo pesma_95.mp3
a ja bih hteo da se u ime pesme doda i ime benda ali mi nikako ne uspeva.
Evo stranice na kojoj se uploaduje pesma:
Code:
<?php
include("head.php");
?>
<?
if(isset($_GET['del']))
{
mysql_query("DELETE FROM music_songs WHERE musicId=" . $_GET['del']);
}
if(isset($_POST['upload']))
{
if(is_uploaded_file($_FILES['song']['tmp_name']))
{
if($_FILES['song']['size'] < 5000000)
{
$extension = explode("." , $_FILES['song']['name']);
$name=$_FILES['song']['name'];
$dt=date("Y-m-d");
if(($extension[1] == "mp3")||($extension[1] == "MP3"))
{
$sql="INSERT INTO music_songs VALUES('' , '" . $_COOKIE['userId'] . "', 'song','$extension[0]','".$_POST['description']."','$dt','z')";
mysql_query($sql);
//print $sql;
$songId = mysql_insert_id();
$name = "pesma_" . $songId . "." . $extension[1];
print $name;
if(!move_uploaded_file($_FILES['song']['tmp_name'] , "song/" . $name))
{
echo "Copy is failed due to some error";
}
else
{
mysql_query("UPDATE music_songs SET name='" . $name . "' WHERE musicId = " . $songId);
}
}
}
}
}
?>
<?php
include("head.php");
?>
<?
if(isset($_GET['del']))
{
mysql_query("DELETE FROM music_songs WHERE musicId=" . $_GET['del']);
}
if(isset($_POST['upload']))
{
if(is_uploaded_file($_FILES['song']['tmp_name']))
{
if($_FILES['song']['size'] < 5000000)
{
$extension = explode("." , $_FILES['song']['name']);
$name=$_FILES['song']['name'];
$dt=date("Y-m-d");
if(($extension[1] == "mp3")||($extension[1] == "MP3"))
{
$sql="INSERT INTO music_songs VALUES('' , '" . $_COOKIE['userId'] . "', 'song','$extension[0]','".$_POST['description']."','$dt','z')";
mysql_query($sql);
//print $sql;
$songId = mysql_insert_id();
$name = "pesma_" . $songId . "." . $extension[1];
print $name;
if(!move_uploaded_file($_FILES['song']['tmp_name'] , "song/" . $name))
{
echo "Copy is failed due to some error";
}
else
{
mysql_query("UPDATE music_songs SET name='" . $name . "' WHERE musicId = " . $songId);
}
}
}
}
}
?>
i evo stranice na kojoj je displey informacija o bendu:
Code:
<?php
include("head.php");
?>
<?php
$fp = fopen("id.php","r");
$id = fread($fp,"10");
$db = mysql_query("SELECT * FROM music_user WHERE userId=" . $id);
$fet = mysql_fetch_array($db);
$db1 = mysql_query("SELECT * FROM music_homepage WHERE userId=" . $id);
$fet1 = mysql_fetch_array($db1);
$db2 = mysql_query("SELECT * FROM music_songs WHERE userId=" . $id);
?>
<style type="text/css">
<!--
.style2 {
font-size: medium;
font-weight: bold;
}
.style3 {
color: #FF0000;
font-weight: bold;
}
-->
<?php
include("foot.php");
?>
<?php
include("head.php");
?>
<?php
$fp = fopen("id.php","r");
$id = fread($fp,"10");
$db = mysql_query("SELECT * FROM music_user WHERE userId=" . $id);
$fet = mysql_fetch_array($db);
$db1 = mysql_query("SELECT * FROM music_homepage WHERE userId=" . $id);
$fet1 = mysql_fetch_array($db1);
$db2 = mysql_query("SELECT * FROM music_songs WHERE userId=" . $id);
?>
<style type="text/css">
<!--
.style2 {
font-size: medium;
font-weight: bold;
}
.style3 {
color: #FF0000;
font-weight: bold;
}
-->
<?php
include("foot.php");
?>
znaci trebalo bi negde u generisanje imena pesme da se ubaci i
Code:
$fet['bandname']
ali nikako ne uspevam u tome..$fet['bandname']
konstruktivna pomoc je dobrodosla
[Ovu poruku je menjao sweepunk dana 30.10.2006. u 23:37 GMT+1]
Doctors say that i'll be getting out real soon
Doctors say that I've been making big breakthroughs
Doctors say that I've been making big breakthroughs