[Resolved] passing textarea values

proto

how do I pass values from a textarea to a php script?

<html>
<head>
<title>news creation</title>
</head>
<body>
<form action="create_news.php" method="post">
<b>Title:</b>&nbsp;&nbsp;<input type="text" name="title">
<p>
<b>Author Name:</b>&nbsp;&nbsp;<input type="text" name="author">
<p>
<b>Article:</b>&nbsp;&nbsp;<p><textarea rows="10" cols="30" name="article">type here</textarea>
<br>
<input type="submit" value="create">
</form>
</body>
</html>


<?
//connect to db

@ $db=mysql_connect("localhost","news","protox");

if (!$db)
{
	echo("couldn't connect");
	exit;
}

mysql_select_db("news");
$query="insert into articles values
	('".$title."','".$author."','0','".$article."','0')";

$result=mysql_query($query);

if ($result)
{
	echo("article created");
	exit;
}

if (!$result)
{
	echo("could not build");
	exit;
}
?>

HalfaBee

That should work.
Echo out your sql to see what is happening.
You can also do print_r( $GLOBALS ) to see what vars are set.

HalfaBee

proto

its just not working could it be the way the mysql field is set up?

field: type: null: default:
articles text Yes NULL

laserlight

sounds like a register_globals related problem.

You might want to add something like:

if (!empty($_POST['articles']))
	if (magic_quotes_gpc() == 0)
		$articles = addslashes($_POST['articles']);
	else
		$articles = $_POST['articles'];
else
	//some warning message about not entering anything