PDA

View Full Version : How to create Database for a website.


cqruwan1200
12-16-2008, 03:25 PM
Hi Friends. I want to place data entry form for my web site. And I want to get data to a database. Can Some one help me for this. Thanks.....

gayannr
12-16-2008, 03:27 PM
What is the language u r using :)

hasiwarna
12-16-2008, 03:31 PM
If ASp nam podi help ekak karannam

ran123456
12-16-2008, 03:31 PM
vistara nam hodtama madi ... :P

cqruwan1200
12-16-2008, 03:42 PM
I don't know computer language well. I need like a sample script.

cqruwan1200
12-16-2008, 03:44 PM
vistara nam hodtama madi ... :P

Oya web site wala contact us kiyala giyama thiyenne ape details dala submit karanda a wage akak daganda ona. Thanks

gayan kalhara
12-16-2008, 03:48 PM
If youdon't have proper progremming knowladge,, Its better to use this...

www.emailmeform.com

its better if you have a primary client configured mail account rather than web based one,,

you can try Gmail

cqruwan1200
12-16-2008, 04:00 PM
Thanks

seth7
12-16-2008, 05:39 PM
menna php code.

contact.php

<form method="post" action="sendeail.php">

<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>
<input type="hidden" name="ip" value="<?php echo $ipi ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" />
Your Name: <br />
<input type="text" name="visitor" size="35" />
<br />
Your Email:<br />
<input type="text" name="visitormail" size="35" />
<br />
<br />
<br />
Attention:<br />
<select name="attn" size="1">
<option value=" Contact ">Contact </option>
</select>
<br />
<br />
Mail Message: <br />
<textarea name="notes" rows="4" cols="40"></textarea>
<br />
<input name="submit" type="submit" value="Send Mail" />
<br />
</form>


sendeail.php


<form method="post" action="sendeail.php">
<?php

$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$visitor = $_POST['visitor'];
$visitormail = $_POST['visitormail'];
$notes = $_POST['notes'];
$attn = $_POST['attn'];


if (eregi('http:', $notes)) {
die ("Do NOT try that! ! ");
}
if(!$visitormail == "" && (!strstr($visitormail,"@") || !strstr($visitormail,".")))
{
echo "<h2>Use Back - Enter valid e-mail</h2>\n";
$badinput = "<h2>Feedback was NOT submitted</h2>\n";
echo $badinput;
die ("Go back! ! ");
}

if(empty($visitor) || empty($visitormail) || empty($notes )) {
echo "<h2>Use Back - fill in all fields</h2>\n";
die ("Use back! ! ");
}

$todayis = date("l, F j, Y, g:i a") ;

$attn = $attn ;
$subject = $attn;

$notes = stripcslashes($notes);

$message = " $todayis [EST] \n
Attention: $attn \n
Message: $notes \n
From: $visitor ($visitormail)\n
Additional Info : IP = $ip \n
Browser Info: $httpagent \n
Referral : $httpref \n
";

$from = "From: $visitormail\r\n";


mail("YOUR EMAIL ADDRESS", $subject, $message, $from);

?>
<p align="center"> Date: <?php echo $todayis ?> <br />
Thank You : <?php echo $visitor ?> ( <?php echo $visitormail ?> ) <br />
Attention: <?php echo $attn ?> <br />
Message:<br />
<?php $notesout = str_replace("\r", "<br/>", $notes);
echo $notesout; ?>
<br />
<?php echo $ip ?> <br />
<br />
<a href="index.html"> Next Page </a></p>
</form>


:)

cqruwan1200
12-17-2008, 07:01 AM
menna php code.

contact.php

<form method="post" action="sendeail.php">

<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>
<input type="hidden" name="ip" value="<?php echo $ipi ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" />
Your Name: <br />
<input type="text" name="visitor" size="35" />
<br />
Your Email:<br />
<input type="text" name="visitormail" size="35" />
<br />
<br />
<br />
Attention:<br />
<select name="attn" size="1">
<option value=" Contact ">Contact </option>
</select>
<br />
<br />
Mail Message: <br />
<textarea name="notes" rows="4" cols="40"></textarea>
<br />
<input name="submit" type="submit" value="Send Mail" />
<br />
</form>


sendeail.php


<form method="post" action="sendeail.php">
<?php

$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$visitor = $_POST['visitor'];
$visitormail = $_POST['visitormail'];
$notes = $_POST['notes'];
$attn = $_POST['attn'];


if (eregi('http:', $notes)) {
die ("Do NOT try that! ! ");
}
if(!$visitormail == "" && (!strstr($visitormail,"@") || !strstr($visitormail,".")))
{
echo "<h2>Use Back - Enter valid e-mail</h2>\n";
$badinput = "<h2>Feedback was NOT submitted</h2>\n";
echo $badinput;
die ("Go back! ! ");
}

if(empty($visitor) || empty($visitormail) || empty($notes )) {
echo "<h2>Use Back - fill in all fields</h2>\n";
die ("Use back! ! ");
}

$todayis = date("l, F j, Y, g:i a") ;

$attn = $attn ;
$subject = $attn;

$notes = stripcslashes($notes);

$message = " $todayis [EST] \n
Attention: $attn \n
Message: $notes \n
From: $visitor ($visitormail)\n
Additional Info : IP = $ip \n
Browser Info: $httpagent \n
Referral : $httpref \n
";

$from = "From: $visitormail\r\n";


mail("YOUR EMAIL ADDRESS", $subject, $message, $from);

?>
<p align="center"> Date: <?php echo $todayis ?> <br />
Thank You : <?php echo $visitor ?> ( <?php echo $visitormail ?> ) <br />
Attention: <?php echo $attn ?> <br />
Message:<br />
<?php $notesout = str_replace("\r", "<br/>", $notes);
echo $notesout; ?>
<br />
<?php echo $ip ?> <br />
<br />
<a href="index.html"> Next Page </a></p>
</form>


:)

Thanks Lot. Machan