[RESOLVED] Error - parsing blank info to MySQL

simey

Hello there

I just started learning PHP, and created (with some help from tutorials), a small page.

I have installed xampp which is up and running.
The page consist of a html-file, which has a simple form. The content of the form is then sent to a php-script which passes the content to a table in a mysql-database.

The problem is, though, that the data passed into the table is just blank:

The only records (test, nummer2, nummer2) was when I tried assigning $url = "test" instead of $_POST['urlstring']

Here is the html-code:

<html>
<head>
<title>Add URL</title>
</head>

<body>
<b> Add a URL to the database: </b>
	<form action="form.php" mehtod="post">
		<input type="text" name="urlstring" />
		<input type="submit" />
	</form>

</body>
</html>

And the PHP-code:

<?php



$con = mysql_connect("localhost","root","test123");
	if (!$con)
		 {
			 die('Could not connect: ' . mysql_error());
		 }

mysql_select_db("urllist",$con);



$url = $_POST['urlstring'];

mysql_query("INSERT INTO urllist (url) VALUES('$url')");

mysql_close($con);

?>

Do you have any clue to this problem?

bradgrafelman

You misspelled "method" here:

<form action="form.php" mehtod="post">

Also, note that user-supplied data should never be placed directly into a SQL query string. Instead, it must first be sanitized with a function such as [man]mysql_real_escape_string/man.