[Resolved] unexpected T_ENCAPSED_AND_WHITESPACE

szym9341

Looking to update a simple two column table (1) "type_id" - auto increment, primary (2) "typetype" - char(20) in a database called "test"... I'm missing something in my php script.... yes, I have no idea what I am doing.

(HTML PAGE "b.html")
<html>
<body>
<form action="b.php" method="post">
<input type="text" name="typetype">
<input type="submit" value="Go">
</form>
</body>
</html>

(PHP PAGE "b.php")
<html>
<body>
<?php
$db = mysql_pconnect("localhost:3306", "root", "mypassword");
mysql_select_db("test");
$query = "INSERT INTO typetypes SET type_id='NULL', typetype='$_POST['typetype']'";
?>
</body>
</html>

leatherback

Hi,

Youd IR value can be left empty: you do not need to specify it:

$query = "INSERT INTO typetypes SET typetype='$_POST['typetype']'";

$result = mysql_query($query);

szym9341

Thanks for the note! I still get the error though 🙁

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\web\b\b.php on line 6

<html>
<body>
<?php
$db = mysql_pconnect("localhost:3306", "root", "mypassword");
mysql_select_db("test");
$query = "INSERT INTO typetypes SET typetype='$_POST['typetype']'";
$result = mysql_query($query);
?>
</body>
</html>

szym9341

not worried about it anymore.. thanks