Storing Text or Textarea in MySQL

[TenzoR]

I'm having trouble figuring out what is wrong.

I'm trying to store the user's input in text field and text area in to my MySQL db.

It only stores the first word before a space. E.G. Windows 2002 will be store as just Windows.

Do I have to replace the space with

 

I thought this was done automatically

[iceraider]

Can you show us your code?? That will help alot!

[TenzoR]

Inputs

			echo "<tr class=grey>
				<td align=right>Title&nbsp;</td>
				<td align=center><input name=\"eField[0]\" type=text size=23></td>
				<td align=center><input name=\"fField[0]\" type=text size=23></td>
			</tr>
			<tr class=grey>
				<td align=right>Author&nbsp;</td>
				<td align=center><input name=\"eField[1]\" type=text size=23></td>
				<td align=center><input name=\"fField[1]\" type=text size=23></td>
			</tr>
			<tr class=grey>
				<td align=right>Contact&nbsp;</td>
				<td align=center><input name=\"eField[2]\" type=text size=23></td>
				<td align=center><input name=\"fField[2]\" type=text size=23></td>
			</tr>
			<tr class=grey>
				<td align=right>Problem&nbsp;</td>
				<td align=center><textarea name=\"eField[3]\" rows=4 cols=17 wrap=hard></textarea></td>
				<td align=center><textarea name=\"fField[3]\" rows=4 cols=17 wrap=hard></textarea></td>
			</tr>
			<tr class=grey>
				<td align=right>Context&nbsp;</td>
				<td align=center><textarea name=\"eField[4]\" rows=4 cols=17 wrap=hard></textarea></td>
				<td align=center><textarea name=\"fField[4]\" rows=4 cols=17 wrap=hard></textarea></td>
			</tr>
			<tr class=grey>
				<td align=right>Solution&nbsp;</td>
				<td align=center><textarea name=\"eField[5]\" rows=4 cols=17 wrap=hard></textarea></td>
				<td align=center><textarea name=\"fField[5]\" rows=4 cols=17 wrap=hard></textarea></td>
			</tr>

storing into SQL

				$worked = $managePatterns->addPattern($patternid, 1,
					$eField[0], // title
					$eField[1], // author
					$eField[4], // context
					$eField[3], // problem
					$eField[6], // forces - should be NULL
					$eField[5], // solution
					$eField[7], // resulting context - should be NULL
					$eField[8], // symptoms - should be NULL
					$eField[9], // known uses - should be NULL
					$eField[10], // sample code - should be NULL
					$eField[11], // rationale - should be NULL
					$eField[12], // alias - should be NULL
					$eField[13], // acknowledgements - should be NULL
					$eField[14]); // micsellaneous - should be NULL

the function addPattern

	function addPattern(
		$patternid, $lang,     $title,  $author, 
		$context,   $problem,  $forces, $solution, 
		$rcontext,  $symptoms, $uses,   $code, 
		$rationale, $alias,    $ack,    $misc)
	{
		//$look = array("\'", '\"');
		//$replace = array (''','"');
		$title=str_replace($look, $replace, $title);
		$author=str_replace($look, $replace, $author); 
		$context=str_replace($look, $replace, $context);
		$problem=str_replace($look, $replace, $problem);
		$forces=str_replace($look, $replace, $forces);
		$solution =str_replace($look, $replace, $solution);
		$rcontext=str_replace($look, $replace, $rcontext);
		$symptoms=str_replace($look, $replace, $symptoms);
		$uses=str_replace($look, $replace, $uses);
		$code =str_replace($look, $replace, $code);
		$rationale=str_replace($look, $replace, $rationale);
		$alias=str_replace($look, $replace, $alias);
		$ack=str_replace($look, $replace, $ack);
		$misc=str_replace($look, $replace, $misc);
		$date = date ("Y-m-d");
		$version_id = 0.001;
		$states_id = 2;
		$name = $_SESSION['pwzid'];
		$query = "insert into patterns ".
			 "(pattern_id, language_id, version_id, states_id, ".
			 "title, author, context, ".
			 "problem, forces, solution, resulting_context, ".
			 "symptoms, known_uses, sample_code, rationale, ".
			 "alias, acknowledgements, micsellaneous, ".
			 "last_modified_by, last_modified_date) values ".
			 "('$patternid', '$lang', '$version_id', '$states_id', '$title', '$author', ".
			 "'$context', '$problem', '$forces', '$solution', ".
			 "'$rcontext', '$symptoms', '$uses', '$code', ".
			 "'$rationale', '$alias', '$ack', '$misc', '$name', '$date')";
		return mysql_query($query);
	}

[TenzoR]

any help?!

[Weedpacket]

Have you looked in the database to check that "only the first word is being stored"? If not, how are you looking at the database contents? The fault could lie there, and not in the data.

[TheDefender]

Also, you have 6 textareas in your form... but only one being parsed by your replace function (problem, eField[3]), so I assume that's the field in question?!? But, you don't show where the $problem variable is physically being defined... that I can see. Where are you physically defining the $problem variable from the eField[3] input?

[TenzoR]

for ($i=0;$i<6;$i++)
{
	$tempeField = split(" ",$eField[$i]);
	$tempfField = split(" ",$fField[$i]);
	$neweField = implode("&nbsp;",$tempeField);
	$newfField = implode("&nbsp;",$tempfField);
	$eField[$i] = $neweField;
	$fField[$i] = $newfField;
}

Well I tried this code and it works. Now with spaces. I will double check on the database to see if the space were store in the first place.