StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POuploading form and image with php to mysql odd error
primarykey
Id
11771071
data
AcceptedAnswerId
11771190
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-08-02T04:30:45.877
FavoriteCount
0
LastActivityDate
2012-08-02T04:46:56.527
LastEditDate
LastEditorUserId
0
OwnerUserId
1570257
ParentId
0
PostTypeId
1
Score
0
ViewCount
423
LastEditorDisplayName
text
Body
<p>I'm trying to upload a form with an image using PHP to MySQL. I keep however, getting this error - </p> <pre><code>Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/03/6455003/html/leakfaucet/submitAlbumForm.php on line 17 </code></pre> <p>I've been staring at this one for quite a while now and just can't figure out what the issue is, any help would be greatly appreciated!</p> <p>Form-</p> <pre><code><?php include "base.php"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Submit an Album</title> </head> <body> <table> <tr> <td align="center">Submit an Album</td> </tr> <tr> <td> <table> <form enctype="multipart/form-data" action="submitAlbumForm.php" method="post"> <tr> <td>Artist Name</td> <td><input type="text" name="artistName" size="20"> </td> </tr> <tr> <td>Album Name</td> <td><input type="text" name="albumName" size="20"> </td> </tr> <tr> <tr> <td>Release Date</td> <td><input type="text" name="releaseDate" size="20"> </td> </tr> <tr> <tr> <td>Leak Date</td> <td><input type="text" name="leakDate" size="20"> </td> </tr> <tr> <tr> <td>Where It Leaked</td> <td><input type="text" name="whereItLeaked" size="20"> </td> </tr> <tr> <tr> <td>Album Cover</td> <td><input type="file" name="albumCover"> </td> </tr> <tr> <td></td> <td align="right"><input type="submit" name="submit" value="Add"></td> </tr> </table> </td> </tr> </table> </body> </html> </code></pre> <p>Upload script</p> <pre><code><?php include "base.php"; //Setting up images directory $target = "images/"; $target = $target . basename( $_FILES['photo']['name']); $albumCover=($_FILES['photo']['name']); //inserting data order $order = "INSERT INTO albums (artistName, albumName, releaseDate, leakDate, whereItLeaked, albumCover) VALUES ('$_POST[artistName]', '$_POST[albumName]', '$_POST[releaseDate]', '$_POST[leakDate]', '$_POST[whereItLeaked]', '($_FILES['albumCover']['name'])')"; /*this is the line where the error keeps occurring. I've tried a number of variations and still can't seem to get it right*/ if(move_uploaded_file($_FILES['albumCover']['tmp_name'], $target)) { //Tells you if its all ok echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; } else { //Gives an error if its not echo "Sorry, there was a problem uploading your file."; } //declare in the order variable $result = mysql_query($order); //order executes if($result){ echo("<br>Thank you for submitting!"); } else{ echo("<br>Sorry, something went wrong! Please try again!"); } ?> </code></pre> <p>My base.php file with connect info</p> <pre><code><?php session_start(); $dbhost = ""; $dbname = ""; $dbuser = ""; $dbpass = ""; mysql_connect($dbhost, $dbuser, $dbpass) or die("MySQL Error: " . mysql_error()); mysql_select_db($dbname) or die("MySQL Error: " . mysql_error()); ?> </code></pre>
Tags
<php><mysql><image><forms>
Title
uploading form and image with php to mysql odd error
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USuser1570257
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.