[Dale]

I have 6 things and the ID and DATE i suppose are NULL as the date is something like CURDATE() and ID is auto increasment but how do i have a form that sends the information to the database as the Spoono.com tutorial dont work.

id
title
msg
author
email
date

[mdhall]

Originally Posted by Dale

I have 6 things and the ID and DATE i suppose are NULL as the date is something like CURDATE() and ID is auto increasment but how do i have a form that sends the information to the database as the Spoono.com tutorial dont work.

Very simple form to db set up. On one page...

<form action="insert.php" method="post">
Title <input type="text" name="title" size="30">
Message <input type="text" name="msg" size="30">
Author <input type="text name="author" size=""30">
Email <input type="text" name="email" size="30">
<input type="submit" name="submit" value="Submit">
</form>

Another page, named insert.php

PHP Code:

$title=$_POST['title'];
$message=$_POST['message'];
$author=$_POST['author'];
$email=$_POST['email'];
                
$location="localhost";
$username="your_db_username";
$password="your_db_password";
$database="database_name";
 $conn = mysql_connect("$location","$username","$password");
 if (!$conn) die ("Could not connect MySQL");
 mysql_select_db($database,$conn) or die ("Could not open database");
 $query = "INSERT INTO table_name(id,title,message,author,email,date0 VALUES('','$title','$msg','author','email',now())";
 
                $result=mysql_query($query);
                mysql_close(); 

Just change the database section and the table name to match your set up.

[Dale]

Its working but its not adding the information into the database.

[Dale]

Its fine!!!!

Just had to change $message to $msg

Thanks mdhall!

[mdhall]

Glad it worked for you.

[johnnytalk]

How would you code it so that it sends you and the form filler a copy of the response to the form?
J.

Originally Posted by mdhall

Glad it worked for you.

[mdhall]

Originally Posted by johnnytalk

How would you code it so that it sends you and the form filler a copy of the response to the form?
J.

Add something like this at the end of the insert.php page, before the "?>" tag. This is very basic, you can do more with headers and multiple emails...


$sendto = "$email";
$subject = "Your Information";
$message = "Thank you for your input. It has been added to out database.";
$website = "my_web_site.com";
if($query){//On Success of the insertion mail
($sendto, $subject, $message, $website);
}

[0o0o0]

when making a database writeable.. for a script like this

What needs to be NULL, and what doesnt?

He has

id
title
msg
author
email
date

? which is null or not? thanks

[0o0o0]

Now I got this all figured out and had to tweek most of it to make it run on my system.

Big question now is.. how does one make mandatory fields?

Since the average joe could sit and just press send send send send blank entries all day long.. and auto fill the db.

Lemme know this question whenever you can thanks!