Adding info to database trouble....

**Arielladog** · Jul 21, 2000 18:17

I've been readint he tutorial y'all have on this site...it's great.

Anyway, to "learn" this stuff, I try tinkering with scripts, but it won't work for some reason. It displays the jokes, but for some reason, when I tell it to add a joke, it won't. Here's the code I've been trying to use. (Can someone also explain to me how 'if("ADD" == $submitjoke){' is supposed to work...I don't understand how that is triggered when the user clicks on the button and submits the form .... maybe I M just to used to JavaScript, but I want to UNDERSTAND the language, so please help. (since it displays the info fromt he database, I know that it is connecting.)

<html>
<head>
<title>Today's Date</title>
</head>
<body>
<?php

$dbcnx = @mysql_connect("localhost","root","");

mysql_select_db("jokes");

?>
<h1>Add a Joke:</h1><br>
<form method="post" action="<?php echo($PHP_SELF);?>">
<textarea name="JokeText">Type your joke here:</textarea><br>
<input type="submit" name="submitjoke" value="ADD">
</form><br><Br>
<?php

if("ADD" == $submitjoke){
$sql="INSERT INTO Jokes SET".
"JokeText='JokeText', ".
"JokeDate=CURDATE()";
}

mysql_query($sql)

?>
<h1>Jokes thus far:</h1>
<?php
$jokes = mysql_query("SELECT JokeText FROM Jokes");

while ($row=mysql_fetch_array($jokes)){
echo("<P>" . $row["JokeText"]."</p>");
}

?>
</body>
</html>

**ChrRmr** · Jul 22, 2000 11:46

if("ADD" == $submitjoke) means "if the variable submitjoke is equal to ADD then..." in other words, this like checks if the user has pressed the submit button or if s/he has simply entered the url. I like to do it the following way (which I think makes more sense):

echo "
<from action='". $PHP_SELF ."' method='post'>
<input type='hidden' name='submit' value='1'>
...
...
...
</form>";

if($submit) {

// do stuiff

}

----

The variable named $submit will only contain the value 1 if the form has been submitted. In php, 1 = Boolean true, so the if statement will only execute if the form has been submitted.

Hope this helps.

Christian

**Arielladog** · Jul 22, 2000 13:46

I see, now that makes more sense...thanx!

ALso, anyone know how come the textarea isn't adding any stuff to the database, like it should?

**Arielladog** · Jul 22, 2000 15:15

I dunno, but I was reading tutorial at sitepoint in conjuction with this one, and tried this code:

if($submitjoke){
$sql="INSERT INTO Jokes (JokeText,JokeDate) VALUES ('$JokeText',CURDATE())";
}

and it worked .. dunno why other one didn't

**ChrRmr** · Jul 22, 2000 16:38

SQL used to UPDATE a record:

UDPATE joke_db SET joke='Knock, Knock', author="Me" where joke_id='007'

SQL used to INSERT a NEW record:

INSERT INTO joke_db (joke_id, joke, author) VALUES ('', 'Knock, Knock', 'Me')

Christian

**Kevin Yank** · Jul 23, 2000 12:16

Sounds like Arielladog is using a version of MySQL prior to 3.22.10, which doesn't support the newer INSERT INTO table SET ... syntax.

------------------
-Kevin Yank.
http://www.SitePoint.com/
Helping Small Business Grow Online!

elm · Aug 6, 2000 23:37

>Sounds like Arielladog is using a version
>of MySQL prior to 3.22.10, which doesn't
>support the newer INSERT INTO table
>SET ... syntax.

Yeah... that one kept me going circles for an hour. Thanks!

I'm going to fire off an e-mail to my host and see if they are going to update the software.

elm

User Tag List

Thread: Adding info to database trouble....

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions