<?php
include("config.php"); //Mysql bağlantı
if($_POST){
$title = $_POST['title'];
$lyric = $_POST['lyric'];
$ekleyen = $_POST['ekleyen'];
$tip = $_POST['tip'];
$artist = $_POST['artist'];
$sorgu = mysql_query("insert into sarki_tablosu (title, lyric, ekleyen, tip, iid) VALUES ('$title', '$lyric', '$ekleyen', '$tip', '$artist')");
echo "<p>Şarkı eklendi.</p>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<title>Şarkı Ekleme Formu</title>
</head>
<body>
<form name="form1" method="post" action="ekle_sarki.php">
<table width="99%" border="0">
<tr>
<td colspan="2"><strong>Şarkı Ekleme Formu </strong></td>
</tr>
<tr>
<td width="14%"><strong>Şarkı Adı </strong></td>
<td width="86%"><input name="title" type="text" id="title"></td>
</tr>
<tr>
<td valign="top"><strong>Şakkı Sözü </strong></td>
<td><textarea name="lyric" cols="50" rows="8" id="lyric"></textarea></td>
</tr>
<tr>
<td><strong>Ekleyen (Yazar)</strong></td>
<td><input name="ekleyen" type="text" id="ekleyen"></td>
</tr>
<tr>
<td><strong>Tip</strong></td>
<td><select name="tip" id="tip">
<option value="1" selected>Türkçe</option>
<option value="2">Yabancı</option>
</select></td>
</tr>
<tr>
<td><strong>Artist</strong></td>
<td><select name="artist" id="artist">
<?php
$artistsorgu = mysql_query("select * from artist_tablon order by id");
while($artistsatir = mysql_fetch_array($artistsorgu)){
$artistid = $artistsatir['id'];
$artistadi = $artistsatir['artist'];
?>
<option value="<?php echo $artistid; ?>"><?php echo $artistadi; ?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Şarkı Ekle"></td>
</tr>
</table>
</form>
</body>
</html>