DaniWeb Forum Index > Web Development > PHP

Newbie question: PHP form not writing to MySQL database

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2007

Posts: 1,357

Reputation: evstevemd has a spectacular aura about

Solved Threads: 127

evstevemd

Offline

Nearly a Posting Virtuoso

#11

18 Days Ago

Ahghh!
<sorry>
I don't meant you but the poster of thread!
It is great for beginners. I quoted a wrong person,
</Sorry>

Atheist: God is man made imagination, he doesn't exist!
Theist: It's okay, can you imagine anything else that doesn't exist?
Junior MD --- Python, C++ and PHP

•

Join Date: Oct 2009

Posts: 147

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 14

venkat0904 venkat0904 is offline

Offline

Junior Poster

#12

18 Days Ago

aahhh its fine... i was starting to get worried that after spending 2 months coding, some1 s suggesting me to read that absolute beginners stuff..

•

Originally Posted by evstevemd

Ahghh!
<sorry>
I don't meant you but the poster of thread!
It is great for beginners. I quoted a wrong person,
</Sorry>

Last edited by venkat0904; 18 Days Ago at 6:30 am.

Gimme reputation points if u find my post helpful.
use [code] tags wherever applicable
dont start a new thread unless u cant find the topic already on forum.
mark a thread "solved" as soon as u get a solution

•

Join Date: Aug 2008

Posts: 4

Reputation: Sucesso is an unknown quantity at this point

Solved Threads: 0

Sucesso

Offline

Newbie Poster

#13

18 Days Ago

Still not working for me. I don't know the code, so I'm not sure what to look for, but I made sure that all the variable names and everything were correct.

Here's the code that I'm using:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD="post">
<P>Type your word here:<BR>
<TEXTAREA NAME="word" ROWS="2" COLS="40" WRAP="HARD"></TEXTAREA><BR>
<INPUT TYPE="SUBMIT" NAME="submitWord" VALUE="SUBMIT">
</FORM>
 
<?php
$word = $_POST['submitWord'];
if ("SUBMIT" == $submitWord) {
  $sql = "INSERT INTO Dictionary SET " .
         "Word='$word', " .
         "AddDate=CURDATE()";
  if (mysql_query($sql)) {
    echo("<P>Your word has been added.</P>");
  } else {
    echo("<P>Error adding submitted word: " .
         mysql_error() . "</P>");
  }
}
?>
<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD="post">
<P>Type your word here:<BR>
<TEXTAREA NAME="word" ROWS="2" COLS="40" WRAP="HARD"></TEXTAREA><BR>
<INPUT TYPE="SUBMIT" NAME="submitWord" VALUE="SUBMIT">
</FORM>

<?php
$word = $_POST['submitWord'];
if ("SUBMIT" == $submitWord) {
  $sql = "INSERT INTO Dictionary SET " .
         "Word='$word', " .
         "AddDate=CURDATE()";
  if (mysql_query($sql)) {
    echo("<P>Your word has been added.</P>");
  } else {
    echo("<P>Error adding submitted word: " .
         mysql_error() . "</P>");
  }
}
?>

If this helps, when I use PuTTY to check the contents of the database, I see this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
mysql> select * from Dictionary;
+----+----------+------+----------------------------------------------+------------+
| ID | Word     | PoS  | Definition                                   | AddDate    |
+----+----------+------+----------------------------------------------+------------+
|  2 | abstract | adj  | NULL                                         | 0000-00-00 |
|  3 | abstract | adj  | NULL                                         | 0000-00-00 |
|  4 | abstract | adj  | not concrete; hard to understand; intangible | 2009-11-08 |
+----+----------+------+----------------------------------------------+------------+
3 rows in set (0.01 sec)
mysql> select * from Dictionary;
+----+----------+------+----------------------------------------------+------------+
| ID | Word     | PoS  | Definition                                   | AddDate    |
+----+----------+------+----------------------------------------------+------------+
|  2 | abstract | adj  | NULL                                         | 0000-00-00 |
|  3 | abstract | adj  | NULL                                         | 0000-00-00 |
|  4 | abstract | adj  | not concrete; hard to understand; intangible | 2009-11-08 |
+----+----------+------+----------------------------------------------+------------+
3 rows in set (0.01 sec)

•

Originally Posted by evstevemd

Are you sure you don need this dose?

Thanks! I'll look at that now.

•

Join Date: Oct 2009

Posts: 147

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 14

venkat0904 venkat0904 is offline

Offline

Junior Poster

#14

17 Days Ago

why dont u use the code suggested above... ur sql query syntax itself is wrong.. how do you expect to get a database entry with that...
general syntax for insert statement is-
INSERT INTO [tablename] (col1,col2 ...) VALUES (val1, val2...);

Also ur table structure shows other fields also besides word and date... are u sure when u are inserting a new row, these values are allowed to be null?

•

Originally Posted by Sucesso

Still not working for me. I don't know the code, so I'm not sure what to look for, but I made sure that all the variable names and everything were correct.

Here's the code that I'm using:
Help with Code Tags

PHP Syntax (Toggle Plain Text)
<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD="post">
<P>Type your word here:<BR>
<TEXTAREA NAME="word" ROWS="2" COLS="40" WRAP="HARD"></TEXTAREA><BR>
<INPUT TYPE="SUBMIT" NAME="submitWord" VALUE="SUBMIT">
</FORM>
 
<?php
$word = $_POST['submitWord'];
if ("SUBMIT" == $submitWord) {
  $sql = "INSERT INTO Dictionary SET " .
         "Word='$word', " .
         "AddDate=CURDATE()";
  if (mysql_query($sql)) {
    echo("<P>Your word has been added.</P>");
  } else {
    echo("<P>Error adding submitted word: " .
         mysql_error() . "</P>");
  }
}
?>
<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD="post"> <P>Type your word here:<BR> <TEXTAREA NAME="word" ROWS="2" COLS="40" WRAP="HARD"></TEXTAREA><BR> <INPUT TYPE="SUBMIT" NAME="submitWord" VALUE="SUBMIT"> </FORM> <?php $word = $_POST['submitWord']; if ("SUBMIT" == $submitWord) { $sql = "INSERT INTO Dictionary SET " . "Word='$word', " . "AddDate=CURDATE()"; if (mysql_query($sql)) { echo("<P>Your word has been added.</P>"); } else { echo("<P>Error adding submitted word: " . mysql_error() . "</P>"); } } ?>
If this helps, when I use PuTTY to check the contents of the database, I see this:
Help with Code Tags

PHP Syntax (Toggle Plain Text)
mysql> select * from Dictionary;
+----+----------+------+----------------------------------------------+------------+
| ID | Word     | PoS  | Definition                                   | AddDate    |
+----+----------+------+----------------------------------------------+------------+
|  2 | abstract | adj  | NULL                                         | 0000-00-00 |
|  3 | abstract | adj  | NULL                                         | 0000-00-00 |
|  4 | abstract | adj  | not concrete; hard to understand; intangible | 2009-11-08 |
+----+----------+------+----------------------------------------------+------------+
3 rows in set (0.01 sec)
mysql> select * from Dictionary; +----+----------+------+----------------------------------------------+------------+ | ID | Word | PoS | Definition | AddDate | +----+----------+------+----------------------------------------------+------------+ | 2 | abstract | adj | NULL | 0000-00-00 | | 3 | abstract | adj | NULL | 0000-00-00 | | 4 | abstract | adj | not concrete; hard to understand; intangible | 2009-11-08 | +----+----------+------+----------------------------------------------+------------+ 3 rows in set (0.01 sec)
Thanks! I'll look at that now.

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes