[SOLVED] form to insert info into db

[ohdang888]

i want to create a form to insert data into a table.

i'm getting this error:

 

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\create.php on line 15

 

also, that was just a test to insert the same name of the column into that field. But i want to insert $title , etc. how would i do that???

 

heres my code:

 

<?php
  $title= $_POST["title"];
  $type = $_POST["type"];
  $author = $_POST["author"];
  $author_url = $_POST["author_url"];
  $game_picture_url = $_POST["game_picture_url"];
  $instructions = $_POST["instructions"];
  $game_file_name = $_POST["game_file_name"];
  $counter = $_POST["counter"];
  $flash = $_POST["flash"];

  mysql_connect("localhost", "----", "-----") or die(mysql_error());
  mysql_select_db("games") or die(mysql_error());

  mysql_query(INSERT INTO `games`.`game` (`title`, `type`, `author`, `author_url`, `game_picture_url`, `instructions`, 
  `game_file_name`, `counter`, `flash`) VALUES ('title', 'type', 'author', 'author_url', 'game_picture_url', 'instructions', 
  'game_file_name', 'counter', 'flash'))

  
?>


<form method="post" " >
Title of game:  <input type="text" size="80" maxlength="300" name="title"/><br>

Type:  <input type="text" size="80" maxlength="300" name="type"/><br>

author:  <input type="text" size="80" maxlength="300" name="author"/><br>

author url:  <input type="text" size="80" maxlength="300" name="author_url"/><br>

game picture name:<input type="text" size="80" maxlength="300" name="game_picture_url"/><br>

instructions:<input type="text" size="80" maxlength="300" name="instructions"/><br>

Game file name(add .swf):<input type="text" size="80" maxlength="300" name="game_file_name"/><br>

Counter start number:<input type="text" size="80" maxlength="300" name="counter"/><br>


Flash markup of game: (add the file src with gamefile):
<textarea rows="30" cols="80" name="flash"></textarea> <br>


<input type="submit" name="submit" value="submit"/>
</form>

 

and i haven't even used the form yet.

[revraz]

mysql_query(INSERT INTO `games`.`game` (`title`, `type`, `author`, `author_url`, `game_picture_url`, `instructions`,

  `game_file_name`, `counter`, `flash`) VALUES ('$title', '$type', '$author', '$author_url', '$game_picture_url', '$instructions',

  '$game_file_name', '$counter', '$flash'))

 

[p2grace]

Don't forget the semicolon at the end of the query 

[ohdang888]

thanks.

 

but its still saying:

 

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\create.php on line 15

 

what does that even mean?

[revraz]

It was the last line of the code, so a ; really isn't required.

 

 

Don't forget the semicolon at the end of the query 

[ohdang888]

any thoughts about that error????

[p2grace]

It's always good practice to put the semi-colons in.  What's with the `games`.`game`?  That's probably where the syntax issue is.

[ohdang888]

`games` means the database "games"

`game` means the table "game"

 

at least that whats i think it is.

[revraz]

Good practice or not, it's still not required.

 

dbname.tablename, its allowed but not required, would be ok to just make it game.

 

What is line 15?

 

Remove the extra " here

 

<form method="post" " >   <-----

 

[ohdang888]

this is line 15

mysql_query(INSERT INTO `games`.`game` (`title`, `type`, `author`, `author_url`, `game_picture_url`, `instructions`,

 

but i don't know if its including the whole query, which is

mysql_query(INSERT INTO `games`.`game` (`title`, `type`, `author`, `author_url`, `game_picture_url`, `instructions`, 
  `game_file_name`, `counter`, `flash`) VALUES ('$title', '$type', '$author', '$author_url', '$game_picture_url', '$instructions', 
  '$game_file_name', '$counter', '$flash'));

[p2grace]

Try this:

 

mysql_query("INSERT INTO `games`.`game` (`title`, `type`, `author`, `author_url`, `game_picture_url`, `instructions`, 
  `game_file_name`, `counter`, `flash`) VALUES ('$title', '$type', '$author', '$author_url', '$game_picture_url', '$instructions', 
  '$game_file_name', '$counter', '$flash')");

 

I believe you need the quotes

[revraz]

<?php
if ($_POST['submit']) {
  $title= $_POST["title"];
  $type = $_POST["type"];
  $author = $_POST["author"];
  $author_url = $_POST["author_url"];
  $game_picture_url = $_POST["game_picture_url"];
  $instructions = $_POST["instructions"];
  $game_file_name = $_POST["game_file_name"];
  $counter = $_POST["counter"];
  $flash = $_POST["flash"];

  mysql_connect("localhost", "----", "-----") or die(mysql_error());
  mysql_select_db("games") or die(mysql_error());

$sql="INSERT INTO `game` (`title`, `type`, `author`, `author_url`, `game_picture_url`, `instructions`, 
  `game_file_name`, `counter`, `flash`) VALUES ('$title', '$type', '$author', '$author_url', '$game_picture_url', '$instructions', 
  '$game_file_name', '$counter', '$flash')";
$result=mysql_query($sql) or die ("Error in query: $result. " . mysql_error());
}
else {
?>


<form method="post">
Title of game:  <input type="text" size="80" maxlength="300" name="title"/><br>

Type:  <input type="text" size="80" maxlength="300" name="type"/><br>

author:  <input type="text" size="80" maxlength="300" name="author"/><br>

author url:  <input type="text" size="80" maxlength="300" name="author_url"/><br>

game picture name:<input type="text" size="80" maxlength="300" name="game_picture_url"/><br>

instructions:<input type="text" size="80" maxlength="300" name="instructions"/><br>

Game file name(add .swf):<input type="text" size="80" maxlength="300" name="game_file_name"/><br>

Counter start number:<input type="text" size="80" maxlength="300" name="counter"/><br>


Flash markup of game: (add the file src with gamefile):
<textarea rows="30" cols="80" name="flash"></textarea> <br>


<input type="submit" name="submit" value="submit"/>
</form>

<?php
}
?>

 

And post any errors

[ohdang888]

iit works!