Hey

I'm not sure which board this would go under, but i have a coding problem.

I want to add a "add your own tips" to my site.

I have a code, but i don't know really what to do with it, what databases to make, fields, etc.

HELP PLEASE

You've given us very little information, and I don't think anyone here can read your mind. Why don't you start by linking us to the script you have, and maybe the website you want it to appear on.

haha, sorry.

The script a friend wrote for me;

PHP Code:

<?php
mysql_connect("host", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
function silence($string) 
{
        $string = htmlspecialchars( $string, ENT_QUOTES );
        if( get_magic_quotes_gpc(   ) ) {
 
            $string = stripslashes( $string );
 
        }                
        $string = mysql_real_escape_string( $string );
 
    return $string;  
} 
 
if(!$_POST["Submit"]) {
    echo "<form action=\"\" method=\"post\">
    <input type=\"text\" name="tipsAuthor" />
    <input type=\"text\" name=\"tips\" />
    <input type=\"submit\" name=\"Submit\" />
    </form>";
 
}
else {
 
    $clean["author"] = silence($_POST["tipsAuthor"]);
    $clean["tip"] = silence($_POST["tips"]);
 
    mysql_query("INSERT INTO tips (author, tip) VALUES('$clean["author"]', '$clean["tip"]' ) ") or die(mysql_error());  
}
?>

1) Would this script just go on the webpage?

He told me to make a database and 2 fields; author and tips, which i did, i got this;

This is what it looks like on the actual webpage;

This is what the database and fields look like;


The site page that it will go on is; http://www.get-rid-of-blackheads.com...Submitted.html

I hope that is enough information and thanks for any help!

PHP Code:

...
if(!$_POST["Submit"]) {
    echo "<form action=\"\" method=\"post\">
    <input type=\"text\" name="tipsAuthor" />
    <input type=\"text\" name=\"tips\" />
    <input type=\"submit\" name=\"Submit\" />
    </form>";
 
}
else {
 
    $author = silence($_POST["tipsAuthor"]);
    $tip = silence($_POST["tips"]);
 
    mysql_query("INSERT INTO tips (author, tip) VALUES('$author', '$tip' ) ") or die(mysql_error());  
}
?> 


That should do it.

Nope, still not working.

www.get-rid-of-blackheads.com/user-submitted.html

Help?

What error are you getting?

... if(!$_POST["Submit"]) { echo " "; } else { $author = silence($_POST["tipsAuthor"]); $tip = silence($_POST["tips"]); mysql_query("INSERT INTO tips (author, tip) VALUES('$author', '$tip' ) ") or die(mysql_error()); } ?>

PHP Code:

...
if(!$_POST["Submit"]) {
    echo "<form method=\"post\">
    <input type=\"text\" name=\"tipsAuthor\" />
    <input type=\"text\" name=\"tips\" />
    <input type=\"submit\" name=\"Submit\" />
    </form>";
 
}
else {
 
    $author = silence($_POST["tipsAuthor"]);
    $tip = silence($_POST["tips"]);
 
    mysql_query("INSERT INTO tips (author, tip) VALUES('$author', '$tip' ) ") or die(mysql_error());  
}
?> 


Try that.

Are you sure your page is in .php extension ?
I think that the mesage that appears near the text boxes is because php is disabled.

THATS PROBABLY IT! Any ideas on how to enable it?