the INSERT INTO query

Hitoshi

This is my code :

<?php

require_once ('forum_db.php');

$query = "INSERT INTO threads (topic, author, post, replies, last_reply, category) VALUES ('$topic', '$author', '$post', '$replies', '$author', '$category')"

?>

<form action="posttopic.php" method=post>
Topic : <input type=text name="topic" size=20><br>
<input type=hidden name="category" value="general">
Message : <input type=text name="post" size=20><br>
<input type=hidden name="author" value="guest"><br>
<input type=hidden name="replies" value="0"><br>
<input type=submit name="submit" value="::Submit/:.">
</form>

I want it to send the data to the database using the form. However, once I've entered everything and hit submit, it doesnt send to the database. What's wrong with this script. Anyone?

pseudonym

Which BB software is this for? 🙂

Also.. is this supposed to process the form and then query the db afterwards (Im assuming so).

If it is, Il rewrite for you to fix it.. as it's arse-backwards (as we say here in the UK)

Hitoshi

Yeah thats what it's supposed to do (proccess then query).

It's not for a BB forum. The script is for a forum package i'm working on at the moment.

I dunno what the rules are for this forum and posting websites etc but here is the address of my forum under construction and I intend to distribute the package for free when it's complete.

PHPx Board

www.unrealised.com

pseudonym


<?php 

require_once ('forum_db.php'); 

if (isset($_POST['submit'] {
   $topic = $_POST['topic'];
   $author = $_POST['author'];
   $post = $_POST['post'];
   $replies = $_POST['replies'];
   $author = $_POST['author'];
   $category = $_POST['category'];
   $query = "INSERT INTO threads (topic, author, post, replies,  last_reply, category) VALUES ('$topic', '$author', '$post', '$replies', '$author', '$category')";
$result = mysql_query($query);
  } else {  

?> 
<form action="<?=$_SERVER['PHP_SELF']?>" method=post> 
Topic : <input type=text name="topic" size=20><br> 
<input type=hidden name="category" value="general"> 
Message : <input type=text name="post" size=20><br> 
<input type=hidden name="author" value="guest"><br> 
<input type=hidden name="replies" value="0"><br> 
<input type=submit name="submit" value="::Submit/:."> 
</form> 
<?
}
?>

Ok.. that is pretty rough (needs error checking and so.. but hopefully should give you a clue 🙂

Edited twice.. because Im tired :rolleyes:

Hitoshi

thanks lol. Sorry, I did this before but it was for a chat room. It was a little more complicated with this INSERT ^_

pseudonym

Like all things, it's a learning curve. Im still a newbie.. but Im learning 😃

Hell, today I managed to successfully write a form handler with 83 seperate unique variables ..along with an epoch time explode and combine function 😃

Ps.. did that form above work for you 😃😃

Hitoshi

for some reason im still having problems :S


<?php  

require_once ('forum_db.php');  

if (isset($_POST['submit'] { 

   $topic = $_POST['topic']; 
   $author = $_POST['author'];
   $post = $_POST['post']; 
   $replies = $_POST['replies']; 
   $category = $_POST['category']; 
   $query = "INSERT INTO threads (topic, author, post, replies,  last_reply, category) VALUES ('$topic', '$author', '$post', '$replies', '$author', '$category')"; 
$result = mysql_query($query); 

  } else {   

echo 'fail';

?>  

<form action="<?=$_SERVER['PHP_SELF']?>" method=post> 
Topic : <input type=text name="topic" size=20><br> 
<input type=hidden name="category" value="general"> 
Message : <input type=text name="post" size=20><br> 
<input type=hidden name="author" value="guest"><br> 
<input type=hidden name="replies" value="0"><br> 
<input type=submit name="submit" value="::Submit/:."> 
</form>

Parse error: parse error in /home/hitoshi/public_html/posttopic.php on line 7

I couldn't work it out.

pseudonym


<?php   

require_once ('forum_db.php');   

if (isset($_POST['submit'])) {  

   $topic = $_POST['topic'];  

   $author = $_POST['author']; 
   $post = $_POST['post'];  

   $replies = $_POST['replies'];  

   $category = $_POST['category'];  

   $query = "INSERT INTO threads (topic, author, post, replies,  last_reply, category) VALUES ('$topic', '$author', '$post', '$replies', '$author', '$category')";  

$result = mysql_query($query); 


} else {    

echo 'fail'; 
?>   

<form action="<?=$_SERVER['PHP_SELF']?>" method=post> 
Topic : <input type='text' name="topic" size=20><br> 
<input type='hidden' name="category" value="general"> 
Message : <input type='text' name="post" size=20><br> 
<input type='hidden' name="author" value="guest"><br> 
<input type='hidden' name="replies" value="0"><br> 
<input type='submit' name="submit" value="::Submit/:."> 
<?
}
?>
</form>

My bad. Missed the "))" off the end of the isset. :rolleyes: Im too tired to answer properly. But I just tested this and it does work.

Hitoshi

thanks ^_ I've not used an insset before so I wouldn't have known. You just saved me hours of guessing!

pseudonym

You will find there are many different ways to achieve the same thing with PHP. This is a way I do it 🙂 and it works for me.

As I said in the earlier post, there is no error checking or HTML stripping.. so you really want to look at securing your form.. but for the moment.. just get used to using multipurpose pages 😃

You will " if (isset(" is a very powerful tool when combined with $_SERVER['PHP_SELF']. You also need to search around here for forms queries.. and check up about GET & POST methods 🙂 Will save lots of time in the future.. and prevent frustration 😉

Good luck 😃

//Edit.. that popup close.. err. not sure. never had to do it. Javascript could probably do it, but Im clueless. Google it 😃

Hitoshi

PS :

Just a quick one.. My topic post script is actually in a pop up window. How would I get the window to close and the parent window refresh, on submit? Sorry this isn't PHP related but you should probably be able to answer it