Hi.
Add Free Music | FMDB.cc | Free Music Database
auf dieser Seite möchte ich, dass User (bzw. Bands, Netlabels, usw.) die Möglichkeit haben, ihre Veröffentlichungen einzutragen.
Was muss ich via PHP schreiben und wo muss dieser PHP-Code hin, damit die eingetragenen Information in 'ne Datenbank gespeichert werden?
Ich habe in Sachen PHP/SQL wenig Ahnung/Erfahrung... :)
derzeitiger HTML-Code
HTML
<div id="container">
<div id="top">
<h7>BLA</h7>
</div>
<div id="leftSide">
<fieldset>
<legend>Release Infos</legend>
<form action="add.php" method="POST" class="form">
<label for="artist">Artist</label>
<div class="div_texbox">
<input name="artist" type="text" class="textbox" id="artist" value="" />
</div>
<label for="releasename">Releasename</label>
<div class="div_texbox">
<input name="releasename" type="text" class="textbox" id="releasename" value="" />
</div>
<label for="Releasetype">Releasetype</label>
<div class="div_texbox">
<input name="Releasetype" type="text" class="textbox" id="Releasetype" value="" />
</div>
<label for="year">Year</label>
<div class="div_texbox">
<input name="year" type="text" class="textbox" id="year" value="" />
</div>
<label for="country">Country</label>
<div class="div_texbox">
<input name="country" type="text" class="textbox" id="country" value="" />
</div>
<label for="language">Language</label>
<div class="div_texbox">
<input name="language" type="text" class="textbox" id="language" value="" />
</div>
<label for="genre">Genre</label>
<div class="div_texbox">
<input name="genre" type="text" class="textbox" id="genre" value="" />
</div>
<label for="cover">Cover</label>
<div class="div_texbox">
<input name="cover" type="text" class="textbox" id="cover" value="" />
</div>
<label for="link_downloads">Download Links</label>
<div class="div_texbox">
<input name="link_downloads" type="text" class="textbox" id="link_downloads" value="" />
</div>
</form>
</fieldset>
<br />
<fieldset>
<legend>Optional Release Infos</legend>
<form action="add.php" method="POST" class="form">
<label for="name">MySpace</label>
<div class="div_texbox">
<input name="name" type="text" class="textbox" id="link_myspace" value="http://" />
</div>
<label for="address">Facebook</label>
<div class="div_texbox">
<input name="address" type="text" class="textbox" id="link_facebook" value="http://" />
</div>
<label for="country">Twitter</label>
<div class="div_texbox">
<input name="country" type="text" class="textbox" id="link_twitter" value="http://" />
</div>
<label for="city">Last.fm</label>
<div class="div_texbox">
<input name="city" type="text" class="textbox" id="link_lastfm" value="http://" />
</div>
<label for="city">Blog URL</label>
<div class="div_texbox">
<input name="city" type="text" class="textbox" id="link_blog" value="http://" />
</div>
</form>
</fieldset>
<input name="Submit" type="button" value="Add This Free Release" class="buttons" />
<input name="Preview" type="button" value="Preview" class="buttons" />
<br /><hr size="1"><br />
</div>
<div id="rightSide">
<p><u>###########
</p></div>
<div class="clear"></div>
</div>dazugehöriger CSS-Code
Code
fieldset {
border:1px dashed #CCC;
padding:10px;
}
legend {
font-family:Arial, Helvetica, sans-serif;
font-size: 90%;
letter-spacing: -1px;
font-weight: bold;
line-height: 1.1;
color:#fff;
background: #666;
border: 1px solid #333;
padding: 2px 6px;
}
h7 {
font-family:Arial, Helvetica, sans-serif;
font-size: 175%;
letter-spacing: -1px;
font-weight: normal;
line-height: 1.1;
color:#333;
}
label {
width:142px;
height:32px;
margin-top:3px;
margin-right:2px;
padding-top:11px;
padding-left:6px;
background-color:#CCCCCC;
float:left;
display: block;
font-family:Arial, Helvetica, sans-serif;
font-size: 115%;
letter-spacing: -1px;
font-weight: normal;
line-height: 1.1;
color:#666;
}
.form {
margin:0;
padding:0;
}
#container {
width:750px;
margin:auto;
padding:10px;
}
#top {
width:680px;
height:50px;
}
#leftSide {
width:530px;
padding-top:30px;
float:left;
}
#rightSide {
background-color:#fff;
width:200px;
padding:5px;
margin-top:40px;
float:right;
border:1px solid #CCC;
font:normal 12px Arial;
color:#666666
}
.clear {
clear:both;
}
.holder {
background-color:#fff;
}
.div_texbox {
width:347px;
float:right;
background-color:#E6E6E6;
height:35px;
margin-top:3px;
padding-top:5px;
padding-bottom:3px;
padding-left:5px;
}
.textbox {
background-image: url(images/16t.png);
background-repeat: no-repeat;
background-position:left;
width:285px;
font:normal 18px Arial;
color: #999999;
padding:3px 5px 3px 19px;
}
.textbox:focus, .textbox:hover {
background-color:#F0FFE6;
}
.username {
background-image: url(images/16m.png);
background-repeat: no-repeat;
background-position:left;
width:285px;
font:normal 18px Arial;
color: #999999;
padding:3px 5px 3px 19px;
}
.username:focus, .username:hover {
background-color:#F0FFE6;
}
.password {
background-image: url(images/16s.png);
background-repeat: no-repeat;
background-position:left;
width:285px;
font:normal 18px Arial;
color: #999999;
padding:3px 5px 3px 19px;
}
.password:focus, .password:hover {
background-color:#F0FFE6;
}
.button_div {
background-color:#fff;
text-align:center;
height:35px;
}
.buttons {
text-align:center;
}Gruß,
STVN!