contact form

[j05hr]

I need php code for my website to process a form, i want it to be sent to a database and to an email address. I know this is something really simple but when i google it, it just comes up with forms processing it to an email address. Would anyone be able to point me in the right direction? Cheers

[Maq]

This is simple but takes some time.  Do you have anything done yet?  If yes, please post it so we don't waste our time rewriting existing code.

[j05hr]

i don't have any code for it, i have the database setup for it but that's it.  A guy was helping me on here about a month ago but he got ill and i kind of need it now.  The form can be seen at http://www.jasongold.org/contact1.html

[kenrbnsn]

If you want someone to write the code for you please post in the Freelancing area.

 

Ken

[j05hr]

i don't want someone to write the code for me, i asked if anyone could point me in the right direction of a tutorial or something and Maq asked if I've got any code already?

[Maq]

I think this is a bigger task than what you think.  If you need help with specific parts I'll be glad to help.  Some pointers:

 

1) Submit to itself for error checking.

2) If it validates use the send mail function to send the values of the fields.

3) What kind of DB is it?  MySQL I assume, there are plenty of tutorials and threads on how to store this info.

[j05hr]

Yeah it's a MySQL DB.  Would you be able to point me in the direction of the right sort of tutorials?

[Maq]

I already did.  If you want a source for tutorials I would go to either tizag.com or w3schools.com.  They are both excellent for finding basic scripts/tutorials with correct standards.

[j05hr]

I've tried to look around for some codes on it as i'm not going to be able to teach myself how to do it that quickly using w3schools or the like.

 

I found this and instead of trying to make it work for my form i've just copied the one they have and i can't get it to work, can you see a problem with the code as no matter how much i try, i can't get it to work and it says. The requested URL /â€sendform.php†was not found on this server.  and i don't understand why this is as senform.php is in my server?

 

dbconnect.php

<?php

$host= “localhost”;
$dbuser =”your database username here”;
$dbpass = “your database password here”;
$dbname = “your database name here”;

$connection = mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
?>

 

sendform.php

<?php

include ‘dbconnect.php’;

$name = $_POST['name'];

$email = $_POST['email'];

$comments = $_POST['article'];

$company = $_POST['company'];

$mailmsg.= ‘Name: ‘ . $name . “\n”;
$mailmsg.= ‘Email: ‘ . $email . “\n”;
$mailmsg.= ‘Article: ‘ . $article . “\n”;
$mailmsg.= ‘Company: ‘ . $company . “\n”;

$query = mysql_query(”INSERT INTO emails (name, company, email, article) VALUES (’$name’,'$email’,'$company’, ‘$article’)”) or die(mysql_error());

?>

 

 

[kenrbnsn]

Get rid of the weird quotes:

 

‘ and ’ should be replaced with '

“ and ” should be replaced with "

 

 

Ken

[Maq]

Well if it's on your server and it's not recognizing it, it's probably because you're not in the right directory or you're not calling the correct page.  Match the directory with the URL you're using.

[j05hr]

I'm in the right directory as i've used php before and i changed the quoted but still nothing.

[kenrbnsn]

You're doing the query, but not sending any email.

 

Ken

[j05hr]

But then it shouldn't come up saying the page doesn't exsist when it does?