multipart/form-data

guym · October 6, 2013

Hi all I've been having issues making this code, I'm a huge noob and have been watching youtube videos for the past couple of days and trying to create a website with a database of my movies.(I know there are programs for this but I would like to make my own) This site is only going to be running on localhost. I'm having issues uploading my info(mainly the image for Poster) and if anyone could look at my code/database setup and help me out that would be great

First here is a screenshot of what my database looks like.

http://i.imgur.com/14DQTCh.jpg

Next here is my index.html file

<html>

<head><title>Add Movie or Tv show</title></head>
<body>


<form enctype="multipart/form-data" id="myForm" action="addedinfo.php" method="post">
<h1 align="center"><strong>Add Movie or TV Show to Database</strong></h1>
<p> </p>
<p>Movie Name:
  <input type="text" name="Movie_Name" /><br />
</p>
<p><label> Poster</label>
          <input type="FILE" name="Poster"> ><br>
  </p>
<p>Genre:
  <select multiple name="Genre" id="Genre">
    <option value="All" style="text-indent: 0px;" selected="selected">All</option>
    <option value="Action" style="text-indent: 0px;">Action</option>
    <option value="Adventure" style="text-indent: 0px;">Adventure</option>
    <option value="Animation" style="text-indent: 0px;">Animation</option>
    <option value="Biography" style="text-indent: 0px;">Biography</option>
    <option value="Comedy" style="text-indent: 0px;">Comedy</option>
    <option value="Crime" style="text-indent: 0px;">Crime</option>
    <option value="Documentary" style="text-indent: 0px;">Documentary</option>
    <option value="Drama" style="text-indent: 0px;">Drama</option>
    <option value="Family" style="text-indent: 0px;">Family</option>
    <option value="Fantasy" style="text-indent: 0px;">Fantasy</option>
    <option value="Film-Noir" style="text-indent: 0px;">Film-Noir</option>
    <option value="History" style="text-indent: 0px;">History</option>
    <option value="Horror" style="text-indent: 0px;">Horror</option>
    <option value="Mystery" style="text-indent: 0px;">Mystery</option>
    <option value="Romance" style="text-indent: 0px;">Romance</option>
    <option value="Sci-Fi" style="text-indent: 0px;">Sci-Fi</option>
    <option value="Short" style="text-indent: 0px;">Short</option>
    <option value="Sport" style="text-indent: 0px;">Sport</option>
    <option value="Thriller" style="text-indent: 0px;">Thriller</option>
    <option value="War" style="text-indent: 0px;">War</option>
    <option value="Western" style="text-indent: 0px;">Western</option>
  </select>
</p>
<p>
  <label>IMDB Rating:</label>
  <select name="IMDB_Rating" id="IMDB_Rating">
    <option value="0" style="text-indent: 0px;" selected="selected">All</option>
    <option value="9.9" style="text-indent: 0px;">10</option>
    <option value="9" style="text-indent: 0px;">9+</option>
    <option value="8" style="text-indent: 0px;">8+</option>
    <option value="7" style="text-indent: 0px;">7+</option>
    <option value="6" style="text-indent: 0px;">6+</option>
    <option value="5" style="text-indent: 0px;">5+</option>
    <option value="4" style="text-indent: 0px;">4+</option>
    <option value="3" style="text-indent: 0px;">3+</option>
    <option value="2" style="text-indent: 0px;">2+</option>
    <option value="1" style="text-indent: 0px;">1+</option>
  </select>
  </p>
<p>Quality:
  <label class="label">Quality:</label>
  <select name="Quality" id="Quality">
    <option value="All" style="text-indent: 0px;" selected="selected">All</option>
    <option value="1080p" style="text-indent: 0px;">1080p</option>
    <option value="3D" style="text-indent: 0px;">3D</option>
    <option value="480p" style="text-indent: 0px;">480p</option>
    <option value="720p" style="text-indent: 0px;">720p</option>
    <option value="DVD" style="text-indent: 0px;">DVD</option>
    <option value="HDRip" style="text-indent: 0px;">HDRip</option>
  </select>
</p>
<p>
  Year: 
  <input type="text" name="Year" /><br />
  
  </p>
<p>Trailer:
  <input type="text" name="Trailer" /><br />
  
</p>
<button id="sub">Submit</button>
</form>


<span id="result"></span/


</body>
</html>

As you can see I'm trying to post the following information Movie Name, Poster of the movie, Genre, Rating, Quality, Year, and the Trailer

Next I have my connection script db.php
<?php
$conn = mysql_connect("localhost", "root", "spencer");
$db = mysql_select_db('movies');
?>

Next my addinfo.php

<?php
include_once('db.php');

$Movie_Name = $_POST['Movie_Name'];
$Poster = $_POST['Poster'];
$Genre = $_POST['Genre'];
$IMDB_Rating = $_POST['IMDB_Rating'];
$Quality = $_POST['Quality'];
$Year = $_POST['Year'];
$Trailer = $_POST['Trailer'];

if (mysql_query ("INSERT INTO movieinfo VALUES ('','$Movie_Name','$Poster', '$Genre', '$IMDB_Rating', '$Quality', '$Year', '$Trailer')"))
echo "Successfull";
else
echo "Failed"
?>
and lastly I have a little javascript my_script.js
$("#sub").click( function() {
$.post( $("#myForm").attr("action"),
$("#myForm :input").serializeArray(),
function(info){ $("#result").html(info);
});
clearInput();
});

$("#myForm").submit( function() {
return false;
});

function clearInput() {
$("#myForm :input").each( function() {
$(this).val('');
});
}

The error I get is:

Notice: Array to string conversion in C:\xampp\htdocs\movies\addedinfo.php on line 12
Successfull

When I look at the database I notice a couple of things: 1 the image is 5B so I don't think it uploads right, along with in the Genre only seems to pick up the last selection of the multiple selection

My overall goal is to make a website that I can use to have a database of all my movies and tv shows on that I can add too and search through to find something to watch. So right now I'm making code to upload movies to the database, later I will make a site that will show all of the different movies I have and will be searchable through the movie name, genre, rating, quality and or year.

I appreciate any help very much!

Edited October 18, 2013 by fenway
code tags

cyberRobot · October 6, 2013

When uploading files, you would use the http://php.net/manual/en/reserved.variables.files.php'>$_FILES variable instead of $_POST. Perhaps the following tutorial will help:

http://www.tizag.com/phpT/fileupload.php

guym · October 6, 2013

When uploading files, you would use the $_FILES variable instead of $_POST. Perhaps the following tutorial will help:

http://www.tizag.com/phpT/fileupload.php

Opps sorry, I posted my older code I have fixed that small mistake.

cyberRobot · October 6, 2013

No problem. When posting the newer code, please surround each code block with

tags. They make the code (and your post) easier to read. :happy-04:

guym · October 6, 2013

Sorry I'll do that next time. I know I'll be asking for more help with this project, and I really do appreciate help I receive.

What I would like to do is to if possible is have the information I submit fill in a blank template page.

That way when I submit the movie info it would create a new page for that movie with the information that's being submitted. Would you be able to point me in the right direction to learn how I should go about this?

Also I'm still returning an error of

Notice: Array to string conversion in C:\xampp\htdocs\movies\addedinfo.php on line 12
Successfull

and when I look in my database I notice I only get one selection from Genre where I can select multiple in the selection box.

Thank you again.

guym · October 6, 2013

I've updated my addinfo.php - I'm not receiving any error, now however I'm also not getting anything sent to my database now.

 <?php
include_once('db.php');
 
$Movie_Name = $_POST['Movie_Name'];
$Poster = $_FILES['Poster'];
if (isset ($_POST['Genre'])){
$skillsArray = $_POST['Genre'];
$i = 0;
foreach ($skillsArray as $key => $value) {
$i++;
}
exit();
}
$IMDB_Rating = $_POST['IMDB_Rating'];
$Quality = $_POST['Quality'];
$Year = $_POST['Year'];
$Trailer = $_POST['Trailer'];
 
if (mysql_query ("INSERT INTO movieinfo VALUES ('','$Movie_Name','$Poster', '$Genre', '$IMDB_Rating', '$Quality', '$Year', '$Trailer')"))
echo "Successfull";
else
echo "Failed"
?>

Edited October 6, 2013 by guym

mac_gyver · October 6, 2013

you need to slow down and work on one thing at a time. your last posted code isn't actually checking if your form was submitted at all and contains an exit() statement that is killing your code at that point, which is probably why you aren't getting any output.

1) to start with, you need a conditional statement around all your form processing code so that it only executes when a form has been submitted. because you are trying to upload a file, the $_POST and $_FILES arrays can be empty due to one particular upload size error and you need to test some other value besides a $_POST or $_FILES element to detect that a form was submitted. the best way is to check if($_SERVER['REQUEST_METHOD'] == 'POST'){ all your form processing code goes here... }

2) next, for ALL of your form fields, you must validate that they contain expected values before you use any of the data. for the upload file field you will also need to verify that the upload worked before you can test or use any of the uploaded file information. you should report back to the visitor exactly what is wrong with the data they submitted for each form field.

3) your insert query statement should be of the form that list the columns. this will prevent a bunch of problems, will let you leave out the id field value, and let anyone looking at your code know what your table/query is actually doing - INSERT INTO table_name (columns,...) VALUES (values,...)

4) you either need to escape your string data before putting it into the query or use a prepared query, to prevent query errors and sql injection.

5) lastly, the mysql_ database library is depreciated starting in php5.5 and all new code, or anyone learning how to do this, should be using either the mysqli or PDO database libraries.

since uploading files seems to be a popular subject lately, see the following thread for info about uploaded files - http://forums.phpfreaks.com/topic/282596-how-to-handle-file-from-multiple-upload/?do=findComment&comment=1452535

Edited October 6, 2013 by mac_gyver

mac_gyver · October 6, 2013

as to your Notice: Array to string conversion ... error message, the reason it went-a-way is because you added an exit(); statement to stop your code from running. the error is because $_FILES['Poster'] is an array and you are trying to put it into your query statement. you are going to need to research more about what happens when php receives an uploaded file before you will be able to do this in your code. here's the php.net section on processing uploaded files (reading the whole section would be useful) - http://us1.php.net/manual/en/features.file-upload.php

guym · October 6, 2013

Thanks for the help, I'm trying to learn more before I ask anything else.

I believe I have everything saving in the database right now.

Now I'm just trying to learn how to make my submit insert the information saved into a template page with place holders for that information, so each time new data is submitted a new page is created with all that movie data that was just added.

Sign In

multipart/form-data

Recommended Posts

guym

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

guym

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

guym

Link to comment

Share on other sites

guym

Link to comment

Share on other sites

mac_gyver

Link to comment

Share on other sites

mac_gyver

Link to comment

Share on other sites

guym

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information