Jag vet, "Ämnet/Topic" suger. :r
Well.. jag har lagt till ett fält (datum med datetime) i min tabell, men jag vet inte riktigt hur jag ska lägg till det i scriptet.
Därför hoppas jag att någon vänlig själ kan hjälpa mig med detta!!?
Här är scriptet.. (ja, jag vet att det är rörigt).
<?php }elseif($_GET['action'] == "add"){?>
<table border="0" width="<?=$width?>" align="center" cellpadding="3" cellspacing="0">
<form method="post" action="admin_genre.php?action=save" name="dvd" enctype="multipart/form-data" onSubmit="return Check();">
<tr>
<td colspan="2" style="border-bottom: 1px solid #2B60CD"><font size="2"><b>Ny kategori/genre</b></font></td>
</tr>
<tr>
<td><b>Namn på Kategori:</b><br><input type="text" name="genre" style="width:100%"></td>
</tr>
<tr>
<td><b>Artist/grupp:</b><br>
<select name="artist">
<option value="0">Välj artist/grupp</option>
<?php
$sql = "SELECT id, anamn FROM artister ORDER BY anamn";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
echo "<option value=\"{$row['id']}\">{$row['anamn']}</option>\n";
}
?>
</select>
</td></tr>
<tr>
<td><b>Ikon:</b><br><input type="file" name="ikoner" style="width:100%"><br>(Endast <b>offentliga</b> bilder/omslag är tillåtna.)</td>
</tr>
<tr>
<td valign="top"><b>Information:</b><br><textarea name="g_info" style="width:100%" rows="8"></textarea></td>
</tr>
<tr>
<td><input type="submit" name="posta" value="Spara kategori/genre"></td>
</tr>
</form>
</table>
<?php }elseif($_GET['action'] == "save"){
if (isset($_FILES['ikoner']) && is_uploaded_file($_FILES['ikoner']['tmp_name'])) {
// Kolla filändelse
$image_info = getimagesize($_FILES['ikoner']['tmp_name']);
switch ($image_info[2]) {
case 1:
$ext = '.gif';
break;
case 2:
$ext = '.jpg';
break;
case 3:
$ext = '.png';
break;
case 5:
$ext = '.psd';
break;
case 6:
$ext = '.bmp';
break;
}
mysql_query("Insert Into genre_music(
genre,
g_info
)
Values(
'".$_POST['genre']."',
'".$_POST['g_info']."')") or die(mysql_error());
$id = mysql_insert_id();
move_uploaded_file($_FILES['ikoner']['tmp_name'], "ikoner/ikoner_".$id.$ext);
mysql_query("Update genre_music Set ikoner='ikoner_".$id."$ext' Where id='".$id."'")or die(mysql_error());
}
else
{
mysql_query("Insert Into genre_music(
genre,
g_info
) Values(
'".$_POST['genre']."',
'".$_POST['g_info']."')")or die(mysql_error());
}
?>
<script>location.href='admin_genre.php';</script>
<?php }elseif($_GET['action'] == "change"){
$sql = mysql_query("Select * From genre_music Where id='".$_GET['id']."'") or die(mysql_error());
$RS = mysql_fetch_array($sql);?>
<table border="0" width="<?=$width?>" align="center" cellpadding="3" cellspacing="0">
<form method="post" action="admin_genre.php?action=update&id=<?=$RS['id'];?>&sida=<?=$_GET['sida']?>" name="dvd" enctype="multipart/form-data" onSubmit="return Check();">
<tr>
<td colspan="2" style="border-bottom: 1px solid #2B60CD"><font size="2"><b>Ändra kategori/genre <i><?=$RS['genre'];?></i></b></font></td>
</tr>
<tr>
<td><b>Namn på Kategori:</b><br><input type="text" name="genre" style="width:100%" value="<?=$RS['genre'];?>"></td>
</tr>
<tr>
<td><b>Artist/grupp:</b><br>
<select name="artist">
<option value="0">Välj artist/grupp</option>
<?php
$sql = "SELECT id, anamn FROM artister ORDER BY anamn";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
echo "<option value=\"{$row['id']}\">{$row['anamn']}</option>\n";
}
?>
</select>
</td></tr>
<tr>
<td><b>Ikon:</b> <?php if ($RS['ikoner'] != ""){?>(<a href="ikoner/<?=$RS['ikoner'];?>" target="_blank">Bild</a>)<?}?><br><input type="file" name="ikoner" style="width:100%"></td>
</tr>
<tr>
<td valign="top"><b>Information:</b><br><textarea name="g_info" style="width:100%" rows="8"><?=$RS['g_info'];?></textarea></td>
</tr>
<tr>
<td><input type="submit" name="posta" value="Ändra kategori/genre"></td>
</tr>
</form>
</table>
<?php }elseif($_GET['action'] == "update"){
if (isset($_FILES['ikoner']) && is_uploaded_file($_FILES['ikoner']['tmp_name'])) {
// Kolla filändelse
$image_info = getimagesize($_FILES['ikoner']['tmp_name']);
switch ($image_info[2]) {
case 1:
$ext = '.gif';
break;
case 2:
$ext = '.jpg';
break;
case 3:
$ext = '.png';
break;
case 5:
$ext = '.psd';
break;
case 6:
$ext = '.bmp';
break;
}
move_uploaded_file($_FILES['ikoner']['tmp_name'], "ikoner/ikoner_".$_GET['id'].$ext);
mysql_query("Update genre_music Set
genre='".$_POST['genre']."',
g_info='".$_POST['g_info']."'
ikoner='ikoner_".$_GET['id']."$ext'
Where id='".$_GET['id']."'")or die(mysql_error());
}
else
{
mysql_query("Update genre_music Set
genre='".$_POST['genre']."',
g_info='".$_POST['g_info']."'
Where id='".$_GET['id']."'")or die(mysql_error());
}
?>
<script>location.href='admin_genre.php?sida=<?=$_GET['sida']?>';</script>
<?php }elseif($_GET['action'] == "delete"){
$sql = mysql_query("Select * From genre_music Where id='".$_GET['id']."'") or die(mysql_error());
$RS = mysql_fetch_array($sql);
$fil = $RS['ikoner'];
if (file_exists("ikoner/$fil")) {
unlink("ikoner/$fil");
}
mysql_query("Delete From genre_music Where id='".$_GET['id']."'");?>
<script>location.href='admin_genre.php?sida=<?=$_GET['sida']?>';</script>
<?php }elseif($_GET['action'] == "deletePic"){
$sql = mysql_query("Select * From genre_music Where id='".$_GET['id']."'") or die(mysql_error());
$RS = mysql_fetch_array($sql);
$fil = $RS['ikoner'];
if (file_exists("ikoner/$fil")) {
unlink("ikoner/$fil");
}
mysql_query("Update genre_music Set ikoner='' Where id='".$_GET['id']."'") or die(mysql_error());?>
<script>location.href='admin_genre.php?sida=<?=$_GET['sida']?>';</script>