campaign form

[saltedm8]

would someone please tell me the best way to create a campaign form,

i need to take names, addresses, telephone numbers, email addresses, age, and comments.

but i need them to automatically imprint onto a html page, so it is easily printed out,

just a straight layout with seperating tables

name ! address! telephone! email !age! comments!

also if possible, i needed a 'counter' that i can put onto my main website to say how many people have signed ( maybe even an image )

thank you

[moojoo]

PHP/MySQL would work that way every one would be stored in the database. As for printing you can use CSS to display the data in a nice way and a print style sheet to ensure it prints out correctly.

[saltedm8]

what if i was to make a 'email form',, then have it 'sent' to another file, then download that file when he time is rignt ? would that work, because the php and mysql is above me

[moojoo]

You would need to use some language to write out a new file too. Would be easier imo to just inject the info to a database and have it display from the database as needed. Less files, less work. You could do it very quickly with DW's built in server behaviors. Although we will also help you along as needed as you know.

[saltedm8]

sounds good,

i dont have a clue where to start,

i can create a seperate database for it,

but i have no idea about the steps to create the php codes,

would you be able to talk my through it ?

cheers

[moojoo]

This should help get you started
http://www.php-mysql-tutorial.com/co...-using-php.php

[saltedm8]

thanks mate

is it just this i need ??

Code: Select all

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'petstore';
mysql_select_db($dbname);
?>

and what do i need to save it as ? - config.php ?

sounds easy enougth if that is all it is, - also, how do i point scripts to it ?

cheers

[moojoo]

Just name it whatever you need to and include it at the top of the files that need the db connection like so.

<?php include("connection.php"); ?>

[saltedm8]

ok, i have not done the database yet, but how do i create the form, so it works with the database

cheers

[saltedm8]

how would i make the form and make to connect with the database ?

[Ryan Fait]

Everything you need is in the link that moojoo gave you. I looked it over and it's quite a nice tutorial.