Solved: [object HTMLTextAreaElement]

5326 Views 2 Replies 2 Participants Last post by JiminSA, Sep 19, 2014

JiminSA

Discussion Starter · Sep 18, 2014

I am updating a db table with content from a form submitted via Ajax. Within the form are two text areas, the first of which happily gets inserted into the db table field and the second gets supplanted with

[object HTMLTextAreaElement]

HTML:

Code:

<script type="text/javascript">
$(document).ready(function(){
$("#submit_add_video").click(function(){
var title = $("#title_v_a").val();
var video_embed_desc_add = $("#video_embed_desc_add").val();
var event_embed_add = $("#video_embed_code_add").val();
var dataString = 'title='+ title + '&video_embed_desc_add='+ video_embed_desc_add + '&video_embed_code_add='+ video_embed_code_add;
$.ajax({
type: "POST",
url: "video_add_process.php",
data: dataString,
cache: false,
success: function(result){
alert(result);
}
});
return false;
});
});
</script>

db insert

PHP:

	if (isset($_POST))
	{

		$title = addslashes($_POST['title']);
		$desc = addslashes($_POST['video_embed_desc_add']);
		$embed_code = addslashes($_POST['video_embed_code_add']);
		$date_readable = date("D d M Y");  
		$date_internal = strtotime('today');

		mysql_query("INSERT INTO videos (title, description, embed_code, date_readable, date_internal)

		VALUES ('$title', '$desc', '$embed_code', '$date_readable', '$date_internal')")
		or die(mysql_error());

		echo "Anne, the Video was successfully added! Refresh site to view.";

		exit;
	}	
	else
	{
		echo "Anne, We have a problem with add! Inform Jim ...";
	}

I cannot understand how one text area gets into the db alright and the other throws up this anomoly
Any insight would be highly appreciated as I don't have a clue as to what causes this

See less See more

Save

Status: Not open for further replies.

1 - 3 of 3 Posts

Ent

· #2 · Sep 19, 2014

Code:

var [COLOR=Red]event_embed_add[/COLOR] = $("#video_embed_code_add").val(); 
var dataString = 'title='+ title + '&video_embed_desc_add='+ video_embed_desc_add + '&video_embed_code_add='+ [COLOR=Red]video_embed_code_add[/COLOR];

Most likely source of anomaly highlighted.

Personally, I'd rather give my variables different names from the objects they get their data from, probably something like video_embed_code_add_val because I'm unimaginative like that, but either way it should work if you're consistent in what name you give.

Save

JiminSA

Discussion Starter · #3 · Sep 19, 2014

Thanks Josiah - you definitely put me right, when pointed to the var names

have changed the script to

Code:

		<script type="text/javascript">
		$(document).ready(function(){
		$("#submit_add_video").click(function(){
		var title = $("#title_v_a").val();
		var [COLOR="red"]desc[/COLOR] = $("#video_embed_desc_add").val();
		var [COLOR="Red"]embedCode[/COLOR] = $("#video_embed_code_add").val();
		var dataString = 'title='+ title + '&desc='+ desc + '&embedCode='+ embedCode;
		$.ajax({
		type: "POST",
		url: "video_add_process.php",
		data: dataString,
		cache: false,
		success: function(result){
		alert(result);
		}
		});
		return false;
		});
		});
		</script>
<

I have marked my error corrections in red. The problem was in the way that I named the vars i.e. with underscores (a php methodology)!

See less See more

Save

1 - 3 of 3 Posts

Status: Not open for further replies.

Top Contributors this Month