Auf Thema antworten 2026

Beitrag

<blockquote data-quote="richy149" data-source="post: 2230793">AW: php + mysql: bildupload in ext. verzeichnis + bildnamen in datenbank speichern, wHi,ich habe eine ähnliches Script Problem.Ich habe ein Upload-Formuluar gestaltet, wo User Ihren Namen, Ihre Mail und eben eine Foto uploaden können.Diese Daten werden in einen SQL DB gespeichert. Das funktioniert auch alles - bis eben auf den Dateinamen der hochgeladenen Datei, dieses Feld in der SQL-DB bleibt leer.Ich hab das ganze mit dem phpFormGenerator erstellt. Vielleicht kann mir hier jemand helfen. Ich bin was PHP &amp; SQL angeht nicht sehr bewandert <img src="/styles/default/xenforo/smilies/zwinker.gif"&nbsp; class="smilie" loading="lazy" alt=";)" title="Wink&nbsp; &nbsp; ;)" data-shortname=";)" />Das hochladen der Datei selbst klappt. Aber der Dateiname wird nicht gespeichert.Meine form.html[HTML]&nbsp; &nbsp; &lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot;&gt;&nbsp; &nbsp; &lt;html&gt;&nbsp; &nbsp; &lt;head&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;title&gt;Upload - created by phpFormGenerator&lt;/title&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot;&gt;&lt;link href=&quot;style.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- calendar stuff --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;calendar/calendar-blue2.css&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot; src=&quot;calendar/calendar.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot; src=&quot;calendar/calendar-en.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot; src=&quot;calendar/calendar-setup.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- END calendar stuff --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- expand/collapse function --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;SCRIPT type=text/javascript&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!--&nbsp; &nbsp; &nbsp; &nbsp; function collapseElem(obj)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var el = document.getElementById(obj);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; el.style.display = &#039;none&#039;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; function expandElem(obj)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var el = document.getElementById(obj);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; el.style.display = &#039;&#039;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //--&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/SCRIPT&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- expand/collapse function --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- expand/collapse function --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;SCRIPT type=text/javascript&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!--&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // collapse all elements, except the first one&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function collapseAll()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var numFormPages = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for(i=2; i &lt;= numFormPages; i++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; currPageId = (&#039;mainForm_&#039; + i);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; collapseElem(currPageId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //--&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/SCRIPT&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- expand/collapse function --&gt;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;!-- validate --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;SCRIPT type=text/javascript&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!--&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function validateField(fieldId, fieldBoxId, fieldType, required)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldBox = document.getElementById(fieldBoxId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj = document.getElementById(fieldId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(fieldType == &#039;text&#039;&nbsp; ||&nbsp; fieldType == &#039;textarea&#039;&nbsp; ||&nbsp; fieldType == &#039;password&#039;&nbsp; ||&nbsp; fieldType == &#039;file&#039;&nbsp; ||&nbsp; fieldType == &#039;phone&#039;&nbsp; || fieldType == &#039;website&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(required == 1 &amp;&amp; fieldObj.value == &#039;&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;class&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;className&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.focus();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else if(fieldType == &#039;menu&#039;&nbsp; || fieldType == &#039;country&#039;&nbsp; || fieldType == &#039;state&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(required == 1 &amp;&amp; fieldObj.selectedIndex == 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;class&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;className&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.focus();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else if(fieldType == &#039;email&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if((required == 1 &amp;&amp; fieldObj.value==&#039;&#039;)&nbsp; ||&nbsp; (fieldObj.value!=&#039;&#039;&nbsp; &amp;&amp; !validate_email(fieldObj.value)))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;class&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;className&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.focus();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function validate_email(emailStr)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; apos=emailStr.indexOf(&quot;@&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dotpos=emailStr.lastIndexOf(&quot;.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (apos&lt;1||dotpos-apos&lt;2) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function validateDate(fieldId, fieldBoxId, fieldType, required,&nbsp; minDateStr, maxDateStr)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; retValue = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldBox = document.getElementById(fieldBoxId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj = document.getElementById(fieldId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dateStr = fieldObj.value;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(required == 0&nbsp; &amp;&amp; dateStr == &#039;&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(dateStr.charAt(2) != &#039;/&#039;&nbsp; || dateStr.charAt(5) != &#039;/&#039; || dateStr.length != 10)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; retValue = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; // format&#039;s okay; check max, min&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; currDays = parseInt(dateStr.substr(0,2),10) + parseInt(dateStr.substr(3,2),10)*30&nbsp; + parseInt(dateStr.substr(6,4),10)*365;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //alert(currDays);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(maxDateStr != &#039;&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; maxDays = parseInt(maxDateStr.substr(0,2),10) + parseInt(maxDateStr.substr(3,2),10)*30&nbsp; + parseInt(maxDateStr.substr(6,4),10)*365;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //alert(maxDays);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(currDays &gt; maxDays)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; retValue = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(minDateStr != &#039;&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; minDays = parseInt(minDateStr.substr(0,2),10) + parseInt(minDateStr.substr(3,2),10)*30&nbsp; + parseInt(minDateStr.substr(6,4),10)*365;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //alert(minDays);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(currDays &lt; minDays)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; retValue = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(retValue == false)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;class&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.setAttribute(&quot;className&quot;,&quot;mainFormError&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fieldObj.focus();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //--&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/SCRIPT&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- end validate --&gt;&nbsp; &nbsp; &lt;/head&gt;&nbsp; &nbsp; &lt;body onLoad=&quot;collapseAll()&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;mainForm&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;formHeader&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;formInfo&quot;&gt;Upload&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;formInfo&quot;&gt;1...2...3... mein Genussklick:So einfach kann gewinnen sein! &lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;BR/&gt;&lt;!-- begin form --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;form method=post enctype=multipart/form-data action=processor.php onSubmit=&quot;return validatePage1();&quot;&gt;&lt;ul class=mainForm id=&quot;mainForm_1&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;mainForm&quot; id=&quot;fieldBox_1&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label class=&quot;formFieldQuestion&quot;&gt;Name&amp;nbsp;*&lt;/label&gt;&lt;input class=mainForm type=text name=field_1 id=field_1 size=&#039;20&#039; value=&#039;&#039;&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;mainForm&quot; id=&quot;fieldBox_2&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label class=&quot;formFieldQuestion&quot;&gt;E-Mail&amp;nbsp;*&lt;/label&gt;&lt;input class=mainForm type=email name=field_2 id=field_2 size=20 value=&quot;&quot; style=&quot;background-image:url(imgs/email.png); background-repeat: no-repeat;&nbsp; padding: 2px 2px 2px 25px;&quot;&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;mainForm&quot; id=&quot;fieldBox_3&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label class=&quot;formFieldQuestion&quot;&gt;Bild-Upload&amp;nbsp;*&lt;/label&gt;&lt;input class=mainForm type=file name=field_3 id=field_3 value=&quot;&quot;&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;mainForm&quot; id=&quot;fieldBox_4&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label class=&quot;formFieldQuestion&quot;&gt;Ich bin der Urheber des Bildes und erteile dem Sigibaldus e.V. die Nutzungsrechte&amp;nbsp;*&lt;/label&gt;&lt;span&gt;&lt;input class=mainForm type=checkbox name=field_4[] id=field_4_option_1 value=&quot;Ja&quot; /&gt;&lt;label class=formFieldOption for=&quot;field_4_option_1&quot;&gt;Ja&lt;/label&gt;&lt;/span&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- end of this page --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- page validation --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;SCRIPT type=text/javascript&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!--&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function validatePage1()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; retVal = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (validateField(&#039;field_1&#039;,&#039;fieldBox_1&#039;,&#039;text&#039;,1) == false)&nbsp;retVal=false;if (validateField(&#039;field_2&#039;,&#039;fieldBox_2&#039;,&#039;email&#039;,1) == false)&nbsp;retVal=false;if (validateField(&#039;field_3&#039;,&#039;fieldBox_3&#039;,&#039;file&#039;,1) == false)&nbsp;retVal=false;if (validateField(&#039;field_4&#039;,&#039;fieldBox_4&#039;,&#039;checkbox&#039;,1) == false)&nbsp;retVal=false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(retVal == false)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; alert(&#039;Please correct the errors.&nbsp; Fields marked with an asterisk (*) are required&#039;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return retVal;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //--&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/SCRIPT&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- end page validaton --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- next page buttons --&gt;&lt;li class=&quot;mainForm&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input id=&quot;saveForm&quot; class=&quot;mainForm&quot; type=&quot;submit&quot; value=&quot;Submit&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- end of form --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- close the display stuff for this page --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/ul&gt;&lt;/div&gt;&lt;div id=&quot;footer&quot;&gt;&lt;p class=&quot;footer&quot;&gt;&lt;a class=footer href=http://phpformgen.sourceforge.net&gt;Generated by phpFormGenerator&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;&nbsp; &nbsp; &lt;/body&gt;&nbsp; &nbsp; &lt;/html&gt;[/HTML]Meine processer.php[PHP]&lt;?php$where_form_is=&quot;http://&quot;.$_SERVER[&#039;SERVER_NAME&#039;].strrev(strstr(strrev($_SERVER[&#039;PHP_SELF&#039;]),&quot;/&quot;));// File upload handlingif($_FILES[&#039;field_3&#039;][&#039;name&#039;]!=&#039;&#039;){$field_3_filename = &quot;file_3_&quot;.date(&quot;sihdmY&quot;).substr($_FILES[&#039;field_3&#039;][&#039;name&#039;],strlen($_FILES[&#039;field_3&#039;][&#039;name&#039;])-4);if(!move_uploaded_file($_FILES[&#039;field_3&#039;][&#039;tmp_name&#039;], &quot;./files/&quot;.$field_3_filename)){die(&quot;File &quot; .&nbsp; $_FILES[&#039;field_3&#039;][&#039;name&#039;] . &quot; was not uploaded.&quot;);}}// Checkbox handling$field_4_opts = $_POST[&#039;field_4&#039;][0];include(&quot;config.inc.php&quot;);$link = mysql_connect($db_host,$db_user,$db_pass);if(!$link) die (&#039;Could not connect to database: &#039;.mysql_error());mysql_select_db($db_name,$link);$query = &quot;INSERT into `&quot;.$db_table.&quot;` (field_1,field_2,field_3,field_4) VALUES (&#039;&quot; . $_POST[&#039;field_1&#039;] . &quot;&#039;,&#039;&quot; . $_POST[&#039;field_2&#039;] . &quot;&#039;,&#039;&quot; . $_POST[&#039;field_3&#039;] . &quot;&#039;,&#039;&quot; . $_POST[&#039;field_4&#039;] . &quot;&#039;)&quot;;mysql_query($query);mysql_close($link);include(&quot;confirm.html&quot;);?&gt;[/PHP]SQL-Struktur:</blockquote>

[QUOTE="richy149, post: 2230793"] [b]AW: php + mysql: bildupload in ext. verzeichnis + bildnamen in datenbank speichern, w[/b] Hi, ich habe eine ähnliches Script Problem. Ich habe ein Upload-Formuluar gestaltet, wo User Ihren Namen, Ihre Mail und eben eine Foto uploaden können. Diese Daten werden in einen SQL DB gespeichert. Das funktioniert auch alles - bis eben auf den Dateinamen der hochgeladenen Datei, dieses Feld in der SQL-DB bleibt leer. Ich hab das ganze mit dem phpFormGenerator erstellt. Vielleicht kann mir hier jemand helfen. Ich bin was PHP & SQL angeht nicht sehr bewandert ;) Das hochladen der Datei selbst klappt. Aber der Dateiname wird nicht gespeichert. Meine form.html [HTML] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Upload - created by phpFormGenerator</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"><link href="style.css" rel="stylesheet" type="text/css">  <link rel="stylesheet" type="text/css" href="calendar/calendar-blue2.css" /> <script type="text/javascript" src="calendar/calendar.js"></script> <script type="text/javascript" src="calendar/calendar-en.js"></script> <script type="text/javascript" src="calendar/calendar-setup.js"></script>   <SCRIPT type=text/javascript>  </SCRIPT>   <SCRIPT type=text/javascript>  </SCRIPT>   <SCRIPT type=text/javascript>  </SCRIPT>  </head> <body onLoad="collapseAll()"> <div id="mainForm"> <div id="formHeader"> <h2 class="formInfo">Upload</h2> 1...2...3... mein Genussklick: So einfach kann gewinnen sein! </div>  <form method=post enctype=multipart/form-data action=processor.php onSubmit="return validatePage1();"><ul class=mainForm id="mainForm_1"> <li class="mainForm" id="fieldBox_1"> <label class="formFieldQuestion">Name *</label><input class=mainForm type=text name=field_1 id=field_1 size='20' value=''></li> <li class="mainForm" id="fieldBox_2"> <label class="formFieldQuestion">E-Mail *</label><input class=mainForm type=email name=field_2 id=field_2 size=20 value="" style="background-image:url(imgs/email.png); background-repeat: no-repeat; padding: 2px 2px 2px 25px;"></li> <li class="mainForm" id="fieldBox_3"> <label class="formFieldQuestion">Bild-Upload *</label><input class=mainForm type=file name=field_3 id=field_3 value=""></li> <li class="mainForm" id="fieldBox_4"> <label class="formFieldQuestion">Ich bin der Urheber des Bildes und erteile dem Sigibaldus e.V. die Nutzungsrechte *</label><input class=mainForm type=checkbox name=field_4[] id=field_4_option_1 value="Ja" /><label class=formFieldOption for="field_4_option_1">Ja</label></li>   <SCRIPT type=text/javascript>  </SCRIPT>  <li class="mainForm"> <input id="saveForm" class="mainForm" type="submit" value="Submit" /> </li> </form>   </ul></div><div id="footer"><a class=footer href=http://phpformgen.sourceforge.net>Generated by phpFormGenerator</a></div> </body> </html>[/HTML]Meine processer.php [PHP]<?php $where_form_is="http://".$_SERVER['SERVER_NAME'].strrev(strstr(strrev($_SERVER['PHP_SELF']),"/")); // File upload handling if($_FILES['field_3']['name']!=''){ $field_3_filename = "file_3_".date("sihdmY").substr($_FILES['field_3']['name'],strlen($_FILES['field_3']['name'])-4); if(!move_uploaded_file($_FILES['field_3']['tmp_name'], "./files/".$field_3_filename)){ die("File " . $_FILES['field_3']['name'] . " was not uploaded."); } } // Checkbox handling $field_4_opts = $_POST['field_4'][0]; include("config.inc.php"); $link = mysql_connect($db_host,$db_user,$db_pass); if(!$link) die ('Could not connect to database: '.mysql_error()); mysql_select_db($db_name,$link); $query = "INSERT into `".$db_table."` (field_1,field_2,field_3,field_4) VALUES ('" . $_POST['field_1'] . "','" . $_POST['field_2'] . "','" . $_POST['field_3'] . "','" . $_POST['field_4'] . "')"; mysql_query($query); mysql_close($link); include("confirm.html"); ?>[/PHP]SQL-Struktur: [/QUOTE]

Bilder bitte hier hochladen und danach über das Bild-Icon (Direktlink vorher kopieren) platzieren.

Authentifizierung

Wenn ▲ = 5, ▼ = 2 und ■ = 7, was ist ▲ × ▼ + ■?