Submitting form to mysql

[mike2098]

Hi I have a form with drop down boxes, tinymce and an ajax file up-loader I want to be able to submit the form and store all the data on a mysql db the trouble I have is I do not know how to reference the tinymce (they have a lack of decent documentation) or I am trying to over complicate things

The idea is a new job will be created and stored in a database for retrieval at a later date I want to be able to show the form contents and links to the files that were submitted

this is my form code

      <div align="center" class="column1a">
    
              	<form method="post" action="<?=$_SERVER['REQUEST_URI']?>"> 
                
	<div>
				<div>
<?     
     echo "<form name=jobinfo>\n";
     echo "Type : : <font id=type><select>\n";
     echo "<option value='0'>== Type ==</option> \n" ;
     echo "</select></font>\n";
     
     echo "Dept : <font id=dept><select>\n";
     echo "<option value='0'>== Dept ==</option> \n" ;
     echo "</select></font>\n";
     
     echo "Priority : <font id=priority><select>\n";
     echo "<option value='0'>==== Priority ====</option> \n" ;
     echo "</select></font>\n";
?>

<script language=Javascript>
function Inint_AJAX() {
   try { return new ActiveXObject("Msxml2.XMLHTTP");  } catch(e) {} //IE
   try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
   try { return new XMLHttpRequest();          } catch(e) {} //Native Javascript
   alert("XMLHttpRequest not supported");
   return null;
};

function dochange(src, val) {
     var req = Inint_AJAX();
     req.onreadystatechange = function () { 
          if (req.readyState==4) {
               if (req.status==200) {
                    document.getElementById(src).innerHTML=req.responseText; //ÃѺ¤èÒ¡ÅѺÁÒ
               } 
          }
     };
     req.open("GET", "include/ajaxlist.php?data="+src+"&val="+val); //ÊÃéÒ§ connection
     req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header
     req.send(null); //Ê觤èÒ
}

window.onLoad=dochange('type', -1);     
</script>
<br />
<br />

<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 60%" class="tinymce"><?php echo $sContent;?></textarea>	
			</textarea>
		</div>

		<!-- Some integration calls -->
	<!--	<a href="javascript:;" onmousedown="$('#elm1').tinymce().show();">[Show]</a>
		<a href="javascript:;" onmousedown="$('#elm1').tinymce().hide();">[Hide]</a>-->
    <div align="left" id="swfupload-control">
	<p>	Upload upto 5 files(jpg, png, gif, doc, docx, pdf,), each having maximum size of 5MB</p>
	<input type="button" id="button" />
	<p id="files" ></p>
	<ol id="log"></ol>
</div>


		<br />
		<input type="submit" name="save" value="Submit" />
		<input type="reset" name="reset" value="Reset" />
	</div>
</form></pre></code>

I don't need to edit text from the tinymce I thought it made a nice text box I could just use a bog standard txtBox, and with regards to the ajax file upload I cannot figure out how to store the file locations

thanks

Mike

[carmarri]

I never used it, but, can't you just capture the data from the textarea?


-------------------------------------
xatcom.net, diseño web

[kovik]

Most WYSIWYG editors simply hide your textarea and allow input into an area with HTML parsing. However, they keep the textarea updated. Like ~carmarri said, you only have to access the actual textarea.

If you do not know what part of the $_POST array it is in, print_r() the array.