Practise help!

Maleko

Ok, still learning....

So i wanted to se eif I could just add some data into my database...

seemed easy enough to me...or not...

I keep getting Parse Errors on Line 19
Which is:

echo ;"<form name="guestbook" method="post"

I have tried removing the ; and the echo...

where am i going wrong?
Code:

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<?php
	$user="user";
	$host="host";
	$password="pass";
	$database = "database";
	$connection = mysql_connect($host,$user,$password)
			or die ("Couldn't connect to server");
	$db = mysql_select_db($database,$connection);


echo ;"<form name="guestbook" method="post" action="guestbook.php">
  <p>Name:<br>

<input name="name" type="text" id="name" size="30" maxlength="30" value="$name">
<br>
Email:<br>

  <input name="email" type="text" id="email" size="30" maxlength="40" value="$email">
    <br>
    Website:<br>

  <input name="url" type="text" id="url" size="30" maxlength="25" value="$url">
    <br>
    Message:<br>

  <textarea name="message" cols="40" rows="5" id="message" value="$message"></textarea>
    <br>
    <br>
    <input name="submit" type="submit" id="submit" value="Submit">
    <br>
  </p>
</form>";

{
	$query="INSERT INTO guestbook (name,email,url,message) VALUES
			('$name','$email','$url','$message')";
	$result=mysql_query($query)
		or die ("Couldn't execute query");
		echo "New Message Added";
		}
?>
</body>
</html>

Just trying to create a simple guestbook, where the info is stored in the db, then retrived later on, once ive figured that out 😛

tekky

you cant do this...

echo "this line contains "quotes"";
//if you are want this to work... you need to do this....
echo 'This line contains "quotes"';
//or this...
echo "This line contains \"quotes\"";

note: ;'s ALWAYS are the last thing on a line of code...

Maleko

Excellent, sorted that bit now...

the only prob now is, it wants to execute the command to send the information to the database straight away, as soonm as the web page loads, it wants to submit it.
How can i integrate the code to INSERT it into the database with the submit button? Do i create a seperate .php file with those commands in and link it to the submit button?

Also, when Im dealing the the Values of each field, it displays the value in the text area on the webpage....any ideas on that?

petitduc

You can test for existence of POST data like this :

if (isset($_POST["submit"])) {
//code to execute query
}

the code inside the if will only execute if the submit button (that you called "submit") was pressed.

the $POST is an pre-defined array that keeps all the form data submitted through the $POST method, there is a similar array $_GET for the data submitted through GET.

Maleko

cool, thanks!

any ideas how to stop the values being displayed in the text fields?

petitduc

in HTML code instead of :

value="$name"

write :

value="<?php echo $name; ?>"

Maleko

Still the same problem..this is what happens:

petitduc

I don't know how you generate the form - in PHP or plain HTML.

What you need is an elementary course in PHP.
It looks like you haven't completed your basic training yet, and a forum isn't a good place for this...

Weedpacket

Could we see the real page for ourselves? From the screenshot it looks like you don't have the server configured to use PHP at all.

Maleko

its ok, sorted it 🙂