Hi there.
i have 4 textarea's....one for each CD disk - the user can enter the tracklisting of each disk into it . each track on a new line , this is then exploded into an array which then gets inserted in a table in mySQL each track on a new row.
basically my problem is, it doesnt get past the first text area.
please help !
<BODY><HEAD><link rel="stylesheet" href="http://216.74.114.212/styles.css" TYPE="text/css"><TITLE>Klone recordings : Add a release</TITLE></HEAD>
<font face="verdana" size="2">
<?php
// If the user wants to add a review
if (isset($addreview)) {
?>
<center>
<table cellpadding="3" cellspacing="1" width="90%" height="100%" bgcolor="#000000">
<tr bgcolor="#4A769F" height="20">
<td colspan="2" valign="middle" align="center">
<font face="verdana" size="1" color="#FFFFFF">
Klone release centre</td></tr>
<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD=POST enctype="multipart/form-data">
<tr><td bgcolor="#FFFFFF" width="50%" height="20">
<font face="verdana" size="2">Title of release :
</td>
<td bgcolor="#FFFFFF" width="50%" height="20">
<input type="text" name="title">
</td></tr>
<tr>
<td bgcolor="#FFFFFF" width="50%">
<font face="verdana" size="2">Cat number :</td>
<td bgcolor="#FFFFFF" width="50%">
<input type="text" name="catnum">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="50%">
<font face="verdana" size="2">Release type :</td>
<td bgcolor="#FFFFFF" width="50%">
<select name="cat">
<option>CD singles : £5.50</option>
<option>single albums : £13.50</option>
<option>double albums : £15.50</option>
<option>4cd box sets : copybx1,2,5 £15.50</option>
<option>copybx 3,4 £12.00</option>
</select>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="50%">
<font face="verdana" size="2">Main pic :</td>
<td bgcolor="#FFFFFF" width="50%">
<input type='file' name='img1'>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="50%">
<font face="verdana" size="2">Thumb :</td>
<td bgcolor="#FFFFFF" width="50%">
<input type='file' name='img2'>
</td>
</tr>
<tr bgcolor="#4A769F">
<td align="center" colspan="2">
<font face="verdana" size="1" color="#FFFFFF">
Track Listing
</font>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" align="center">DISK 1 <br>
<textarea name="no_of_tracks" ROWS=10 COLS=40 WRAP></textarea>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" align="center">DISK 2 <br>
<textarea name="no_of_tracks2" ROWS=10 COLS=40 WRAP></textarea>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" align="center">DISK 3 <br>
<textarea name="no_of_tracks3" ROWS=10 COLS=40 WRAP></textarea>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" align="center">DISK 4 <br>
<textarea name="no_of_tracks4" ROWS=10 COLS=40 WRAP></textarea>
</td>
</tr>
<tr><td valign="middle" bgcolor="#4A769F" colspan="2" height="20">
<center>
<INPUT TYPE=SUBMIT NAME="submitrelease" VALUE="SUBMIT"></center>
</td></tr></table></FORM></center>
<?php
}
else {
// If a review has been submitted,
// add it to the database.
if ("SUBMIT" == $submitrelease) {
include("/home/klone/db.inc");
$date = date("d : m : Y");
$img1=stripslashes($img1);
$img2=stripslashes($img2);
$title=addslashes($title);
$cat=addslashes($cat);
echo("$cat");
copy("$img1", "/home/klone/public_html/images/releases/$img1_name")
or die("Couldn't copy the file!");
//RESIZE
$new_w=150;
$new_h=150;
$dst_img=ImageCreate($new_w,$new_h);
$src_img=ImageCreateFromGif("/home/klone/public_html/images/releases/$img1_name");
ImageCopyResized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,ImageSX($src_img),ImageSY($src_img));
ImageGif("$dst_img","/home/klone/public_html/images/releases/$img1_name");
//END
copy("$img2", "/home/klone/public_html/images/releases/$img2_name")
or die("Couldn't copy the file!");
//RESIZE
$new_w=70;
$new_h=70;
$dst_img=ImageCreate($new_w,$new_h);
$src_img=ImageCreateFromGif("/home/klone/public_html/images/releases/$img1_name");
ImageCopyResized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,ImageSX($src_img),ImageSY($src_img));
ImageGif("$dst_img","/home/klone/public_html/images/releases/$img1_name");
//END
mysql_query("INSERT INTO releases SET
date='$date',
title='$title',
mainpic = 'http://216.74.114.212/images/releases/$img1_name',
thumb = 'http://216.74.114.212/images/releases/$img2_name',
cat='$cat',
catnum='$catnum'
");
//GET ID OF REVIEW, THEN ADD TRACKS
//IF DISKS EXIST, ADD EM
if (isset($no_of_tracks)) {
$insert_id = mysql_insert_id();
$track_array = explode("\n",$no_of_tracks);
$intLength = sizeof($track_array);
for ($i=0;$i<$intLength;$i++) {
mysql_query("INSERT INTO releases_tl SET
ID = '$insert_id',
track_number ='$i',
disk='1',
track_name = '$track_array[$i]'");
}
}
if (isset($no_of_tracks2)) {
$track_array = explode("\n",$no_of_tracks2);
$intLength = sizeof($track_array);
for ($i=0;$i<$intLength;$i++) {
mysql_query("INSERT INTO releases_tl SET
ID = '$insert_id',
disk='2',
track_number ='$i',
track_name = '$track_array[$i]'");
}
}
if (isset($no_of_tracks3)) {
$track_array = explode("\n",$no_of_tracks3);
$intLength = sizeof($track_array);
for ($i=0;$i<$intLength;$i++) {
mysql_query("INSERT INTO releases_tl SET
ID = '$insert_id',
disk='3'
track_number ='$i',
track_name = '$track_array[$i]'");
}
}
if (isset($no_of_tracks4)) {
$track_array = explode("\n",$no_of_tracks4);
$intLength = sizeof($track_array);
for ($i=0;$i<$intLength;$i++) {
mysql_query("INSERT INTO releases_tl SET
ID = '$insert_id',
disk='4',
track_number ='$i',
track_name = '$track_array[$i]'");
}
}
echo("<P>Your release has been added.</P>");
}
}
//confirm delete
if ($confirmdelete==1) {
echo("Are you sure you want to delete this release ? <br>
<br><hr noshade color='#000000'>
$title
<br><hr noshade color='#000000'>
<br>
<form action='$PHP_SELF?deletereview=1&ID=$ID' METHOD='post'><input type='submit' name='deletereview' value='Yes'> <a href='addr.php'>No! take me back please</a></form>");
exit();
}
// If a review has been deleted,
// remove it from the database.
if (isset($deletereview)) {
$sql = "DELETE FROM releases " .
"WHERE ID=$ID";
if (mysql_query($sql)) {
echo("<P>The release has been deleted. Below is the revised list of releases</P>");
} else {
echo("<P>Error deleting release: " .
mysql_error() . "</P>");
}
}
if (!isset($addreview)) {
include("/home/klone/db.inc");
echo("<P><A HREF='$PHP_SELF?addreview=1'> Add a release</A></P>");
echo("<P> Here are all the releases " .
"in the database: <hr noshade><br><br>
<table width='90%' bgcolor='#000000' cellpadding='3' cellspacing='1'>
<tr bgcolor='#4A769F' height='20'>
<td align='center' width='71'><font face='verdana' size='1' color='#FFFFFF'>Thumb</font>
</td>
<td align='center'><font face='verdana' size='1' color='#FFFFFF'>Release title</font>
</td>
</tr>
");
// Request the text of all the reviews
$result = mysql_query(
"SELECT ID, thumb, title FROM releases ORDER by ID DESC");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}
// Display the text of each review in a paragraph
while ( $row = mysql_fetch_array($result) ) {
$title=stripslashes($row[title]);
$thumb=$row[thumb];
echo("
<tr bgcolor='#FFFFFF'>
<td valign='center' width=71><img src='$thumb'></td>
<td><font face='verdana' size='2'>$title</td>
</tr>
<tr> <td colspan='2' bgcolor='#C0C0C0'><font face='verdana' size='2' color=#FFFFFF>
<a href='http://216.74.114.212/releases/release.php?ID=$row[ID]' target='new'>view it</a> :
<a href='editrelease.php?ID=$row[ID]'>edit it</a> :
<a href='tracklisting.php?ID=$row[ID]'>add links to track listing</a> :
<a href='$PHP_SELF?ID=$row[ID]&confirmdelete=1&title=$title'>delete it</a>
</td></tr>
");
}}
?>
</BODY></font>
thanx.
j
