File upload help!

[ave_pie]

Okay so, here’s what I’m trying to do… I’m trying to build a code to upload various files and images into the database, and its not working. Please also help with the select option I dont have an idea how to do this along with the admin login authorization. Thank You. Here’s my code:

[code][php]<?php

$as = mysql_connect(“localhost”,“root”,"") or die(mysql_error());
$bs = mysql_select_db(“form1”) or die(mysql_error());
if(isset($_POST[‘Submit3’])){
$upload_file = $_FILES[“file2”][“tmp_name”];
$des = $_FILES[“file2”][“name”];
$des1 =‘Files/’. $des;

if($_FILES[“file2”][“error”]>0)
{
echo “Apologies an error has occured.”;
echo “Error code:”.$_FILES[“file2”][“error”];
}
else
{
move_uploaded_file($upload_file,$des1);
}
$sql = “INSERT INTO notes(id, notes, notes_path) VALUES(’’,’$des’,’$des1’)”;
$qry = mysql_query($sql) or die(mysql_error());}
echo “Notes Inserted”;

?>[/php]

Kite Flames.com

WEBSITE NAME DATE <?php echo DATE("m/d/Y");?> Upload New Image <?php echo DATE("m/d/Y"); ?> Upload Assignment For 7th 5th 3rd 4th 1st 2nd 7th Upload Notes

[/code]

[Topcoder]

I’m not capable of pointing out all of the issues, but I’ll try to help as best as I can.

1. To my knowledge and my understanding it’s best practice to not put the tags before the body element. You should move to below the tag. You should also move your closing Tag above the closing tag. Ideally, you can just wrap the section that you’re concerning with on the post in the form tags, the entire body does not need to be in form tags.

2. I see that you have a close tag, but you don’t have an opening tag. The opening tag should be just below your closing tag.

3. The select option you have is fine, on the post in you PHP code you can grab the value with $_POST[“select”]; Ideally, you should name it something different like “select_assignment”, but that’s your choice.

Once you make the above changes, re-post your code and the description of the issue(s) you are still having.

[ave_pie]

hello Topcoder!

Here’s the changes I’av made with the html select option and the php script… Please help…

<td width="444"><fieldset><legend><span class="style3"> Upload Assignment For</span>
        <select name="select">
          <option>7th</option>
		  <?php
		  $k1 = "Insert Into class(id, seventh, fifth, third) Values('','$upload_assign','','')";
		  $ksql = mysql_query($k1) or die(mysql_error());
		  echo "Assignment for 7th inserted"; 
		  ?>
          <option>7th</option>
          <option>3rd</option>
          <option>2nd</option>
          <option>4th</option>
          <option>5th</option>
          <option>8thth</option>
          <option>9th</option>
          <option>10th</option>
               </select>
        <input type="file" name="file3" />
</legend>
    <input type="submit" name="Submit2" value="Submit" />
</fieldset></td>
</tr>

Php code:

[php]

<?php //assignments upload if(isset($_POST['Submit2'])){ $upload_assign = $_FILES["file3"]["tmp_name"]; $be = $_FILES["file3"]["name"]; $be1 ='Assignments/'. $be; //$k = $_REQUEST['select']; if($_FILES["file3"]["error"]>0) { echo "Apologies an error has occured."; echo "Error code:".$_FILES["file3"]["error"]; } else { move_uploaded_file($upload_assign,$be1); } //$sql = "INSERT INTO (id, image_name, image_path) VALUES('','$de','$de1')"; //$qry = mysql_query($sql) or die(mysql_error()); //echo "Assignment Inserted"; } else{ echo "Error In Upload"; } ?>

[/php]

[ave_pie]

Hey, I have further made some changes and got to work the code myself. The data insertion in database is working but the new problem I’m facing is that the table is “skipping” an “id” after each “submit”. I’m attaching a file for you to have a closer look…
ThankYou

---

[scottlpool2003]

Because when the page loads, that PHP script loads but nothing is selected so nothing is inputted to the database. Then, when you select it, the value changes and inputs to the database. You need to either update it in JS or update it and upload all in 1 go when the form is submitted.

Also, mysql_query BAD… PDO/MySQLi GOOD!

[Topcoder]

Can you post the full code, not pieces of it…

[ave_pie]

Thanks for your help!