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
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.