sluchajcie zaczalem skladac formularz do uploadu danych do sql'a
na poczatku dzialal sam upload plikow ( ladowane beda pozniej pliki max do 150kb - word dokumenty max 2-5 stron, pozatym wolal bym aby nei byl prosty dostep do nich dlatego ladowane sa do sql )
skrypt do uploadowania dzialal spisany z tad - co duzo mowic z kadys trzeba sie nauczyc smile.gif

teraz zaczalem go laczyc z drugim formularzem, wszystko jest ustawione jak obecnie w skrypcie ponizej, jednak otrzymuje przy tym taki blad:

Warning: fread(): supplied argument is not a valid stream resource in C:\AppServ\www\prolinc\project\content\registry\registry.php on line 29

Warning: fclose(): supplied argument is not a valid stream resource in C:\AppServ\www\prolinc\project\content\registry\registry.php on line 31
Error, query failed

jak widad wylaczylem kilka lini - chcialem ustawic wszystko do podstawowego skryptu i wtedy przetestowac jednak rezultat taki sam - wydawalo mi sie ze nie dodalem wiecej jednak musialem cos na mieszac, moze ktos jakas rade zasugerowac ktora pomoze mi w rozwiazaniu

Dzieki

[HTML] pobierz, plaintext 
  1. <? 
  2. include("config.inc.php");
  3. mysql_connect($host,$user,$password);
  4. @mysql_select_db($database) or die ("Unable to select database");
  5. if(isset($_POST['upload'])) 
  6. { 
  7.         $fileName = $_FILES['userfile']['name']; 
  8.         $tmpName  = $_FILES['userfile']['tmp_name']; 
  9.         $fileSize = $_FILES['userfile']['size']; 
  10.         $fileType = $_FILES['userfile']['type']; 
  11.  
  12.  
  13. #$firstname=$_POST['firstname'];
  14. #$surname=$_POST['surname'];
  15. #$address1=$_POST['address1'];
  16. #$address2=$_POST['address2'];
  17. #$towncity=$_POST['towncity'];
  18. #$mobile=$_POST['mobile'];
  19. #$nationality=$_POST['nationality'];
  20. #$visastatus=$_POST['visastatus'];
  21. #$englishlevel=$_POST['englishlevel'];
  22. #$interested=$_POST['interested'];
  23. #$studentstat=$_POST['studentstat'];
  24. #$experience=$_POST['experience'];
  25. #$addinfo=$_POST['addinfo'];
  26. #$startdate=$_POST['startdate'];
  27.  
  28.         $fp = fopen($tmpName, 'r'); 
  29.         $content = fread($fp, $fileSize); 
  30.         $content = addslashes($content); 
  31.         fclose($fp); 
  32.  
  33.         if(!get_magic_quotes_gpc()) 
  34.         { 
  35.             $fileName = addslashes($fileName); 
  36.         } 
  37.  
  38.  
  39.        # $query = "INSERT INTO registry VALUES ('0','".$fileName."','".$fileSize."','".$fileType."','".$content."','".$firstname."','".$surname."','".$address1."','".$address2."','".$towncity."','".$mobile."','".$nationality."','".$visastatus."','".$englishlevel."','".$interested."','".$studentstat."','".$experience."','".$addinfo."','".$added."','".$startdate."')"; 
  40. $query = "INSERT INTO upload (name, size, type, content ) ".
  41. "VALUES ('$fileName', '$fileSize', '$fileType', '$content')"; 
  42.  
  43.         mysql_query($query) or die('Error, query failed');                     
  44.  
  45.         echo "<br>Thank you for your  $fileName uploaded<br>"; 
  46. }         
  47. ?>
  48. <center><b>Prolinc LTD registry form</b></center>
  49. <form action="" method="post" enctype="multipart/form-data" name="uploadform">
  50. <table width="100%" border="0" cellpadding="3" cellspacing="3">
  51.   <tr>
  52.     <td width="34%" valign="top"><div class="regtitle">1. Personal Information</div></b></td>
  53.     <td width="66%"> </td>
  54.   </tr>
  55.   <tr>
  56.     <td valign="top"><div align="right" class="details">First name</div></td>
  57.     <td><input name="firstname" type="text" value="" size="25" maxlength="25" /></td>
  58.   </tr>
  59.   <tr>
  60.     <td valign="top"><div align="right" class="details">Surname</div></td>
  61.     <td><input name="surname" type="text" value="" size="25" maxlength="25" /></td>
  62.   </tr>
  63.   <tr>
  64.     <td valign="top"><div align="right" class="details">Address1</div></td>
  65.     <td><input name="address1" type="text" value="" size="25" maxlength="25" /></td>
  66.   </tr>
  67.   <tr>
  68.     <td valign="top"><div align="right" class="details">Address2</div></td>
  69.     <td><input name="address2" type="text" value="" size="25" maxlength="25" /></td>
  70.   </tr>
  71.   <tr>
  72.     <td valign="top"><div align="right" class="details">Town/City</div></td>
  73.     <td><input name="towncity" type="text" value="" size="25" maxlength="25" /></td>
  74.   </tr>
  75.   <tr>
  76.     <td valign="top"><div align="right" class="details">Mobile</div></td>
  77.     <td><input name="mobile" type="text" value="" size="25" maxlength="25" /></td>
  78.   </tr>
  79.   <tr>
  80.     <td valign="top"><div align="right" class="details">Nationality</div></td>
  81.     <td><input name="nationality" type="text" value="" size="25" maxlength="25" /></td>
  82.   </tr>
  83.   <tr>
  84.     <td valign="top"><div align="right" class="details">Visa status </div></td>
  85.     <td><label>
  86.       <select name="select">
  87.         </select>
  88.     </label></td>
  89.   </tr>
  90.   <tr>
  91.     <td valign="top"><div align="right" class="details">English level </div></td>
  92.     <td><label>
  93.       <select name="select">
  94.         </select>
  95.     </label></td>
  96.   </tr>
  97.   <tr>
  98.     <td valign="top"><div align="right" class="details">I'm interested in the following industries </div></td>
  99.     <td>
  100.       <label>
  101.         <input type="checkbox" name="admin" value="checkbox" />
  102.         Admin</label><br />
  103. 		  <label>
  104.         <input type="checkbox" name="retail" value="checkbox" />
  105.         Retail</label><br />
  106. 		  <label>
  107.         <input type="checkbox" name="beauty" value="checkbox" />
  108.         Beauty</label><br />
  109. 		  <label>
  110.         <input type="checkbox" name="promotion" value="checkbox" />
  111.         Promotion</label>    </td>
  112.   </tr>
  113.   <tr>
  114.     <td valign="top"><div class="regtitle">2. Attache your CV</div></td>
  115.     <td> </td>
  116.   </tr>
  117.   <tr>
  118.     <td valign="top"><div align="right" class="details">Submit your file </div></td>
  119.     <td> 
  120.  <input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="userfile" type="file" class="box" id="userfile">
  121.  
  122.  </td>
  123.   </tr>
  124.   <tr>
  125.     <td valign="top"><div class="regtitle">3.Additional information</div></td>
  126.     <td> </td>
  127.   </tr>
  128.   <tr>
  129.     <td valign="top"><div align="right" class="details">How soon can you start</div></td>
  130.     <td> </td>
  131.   </tr>
  132.   <tr>
  133.     <td valign="top"><div align="right">Are you a student </div></td>
  134.     <td>
  135.       <label></label>
  136.       <p>
  137.         <label>
  138.           <input type="radio" name="yes" value="radio" />
  139.           Yes</label>
  140.  
  141.         <label>
  142.           <input type="radio" name="no" value="radio" />
  143.           No</label>
  144.       </p>
  145.       </td>
  146.   </tr>
  147.   <tr>
  148.     <td valign="top"><div align="right" class="details">Preview experience</div></td>
  149.     <td><label>
  150.       <select name="select">
  151.         </select>
  152.     </label></td>
  153.   </tr>
  154.   <tr>
  155.     <td valign="top"><div align="right" class="details">Additional Information </div></td>
  156.     <td>
  157.       <label>
  158.       <textarea name="textarea" cols="30" rows="5"></textarea>
  159.         </label>
  160.       </td>
  161.   </tr>
  162.   <tr>
  163.     <td valign="top"> </td>
  164.     <td><input name="upload" type="submit" class="box" id="upload" value=" Submit your CV " /></td>
  165.   </tr>
  166.   <tr>
  167.     <td valign="top"> </td>
  168.     <td> </td>
  169.   </tr>
  170.   <tr>
  171.     <td valign="top"> </td>
  172.     <td> </td>
  173.   </tr>
  174.   <tr>
  175.     <td valign="top"> </td>
  176.     <td> </td>
  177.   </tr>
  178. </table>
  179. </form>
[HTML] pobierz, plaintext


witajcie znowu ja sluchajcie znalazlem problem ktory mi siedzi cos jest niby nie tak przy dodawaniu pliku do bazy ;/ wspomoze ktos