Need help to code for email submit

[edwinteguh]

Hello, I have one voting photos website, but when some one upload photos, the script just has name model and uploaded photos feature. I want to add email link feature, so I can store their email and contact their again if they win prizes/quiz. And their email will stored at admin area.

Would you help me how I can make this feature?
below is my upload.php code.

<?

ob_start();

require_once('../mysqlvalues.inc.php');
require_once('../mysqlfunc.inc.php');
require_once('authentication.php');

if(!$authorized) {echo"Invalid Login"; exit();}

open_conn();

if(isset($_GET['edit'])) {

if(isset($_POST['savechanges'])) {

$Name=my_addslashes($_POST['modelname']);
$LinkText=my_addslashes($_POST['modeltext']);

$id=$_POST['modelid'];
$extension=explode('.', $_FILES['upfile']['name']);
$imagename=str_replace(' ', '', "$id" . ".$extension[1]");

if (move_uploaded_file($_FILES['upfile']['tmp_name'], "../images/uploads/$imagename")) {

chmod("../images/uploads/$imagename", 0777);

mysql_query("UPDATE Models SET Thumbnail='$imagename' WHERE ID='$id'");

}

mysql_query("UPDATE Models SET Name='$Name', Wins='$_POST[modelwins]', Loses='$_POST[modelloses]', Draws='$_POST[modeldraws]', LinkText='$LinkText', LinkUrl='$_POST[modelurl]', Status='$_POST[modelstatus]' WHERE ID='$id'");

header("Location: index.php?order=$_GET[order]&sort=$_GET[sort]");

}

$Model=mysql_query("SELECT ID, Name, Wins, Loses, Draws, Thumbnail, LinkText, LinkUrl, Status, (Wins) / (Wins+Loses) AS WinPercent, (Loses) / (Wins+Loses) AS LosePercent, (Wins+Loses+Draws) AS Matches, DATE_FORMAT(DateTime, '%d %M %Y') AS Date FROM Models WHERE ID='$_GET[edit]' LIMIT 1");
$Model=mysql_fetch_assoc($Model);

if($Model['Status'] == 0) {$status0='selected';}else{$status1='selected';}

echo"<table align=\"center\" border=\"1\">
<form action=\"index.php?order=$_GET[order]&sort=$_GET[sort]&edit=$_GET[id]\" method=\"post\" enctype=\"multipart/form-data\">
<tr>
<td align=\"center\" valign=\"top\" rowspan=\"8\"><a href=\"../stats.php?id=$Model[ID]\"><img src=\"../images/uploads/$Model[Thumbnail]\" title=\"$Model[Name]\" alt=\"$Model[Name]\" height=\"125\" width=\"125\" border=\"0\" /></a></td>
<td align=\"right\" valign=\"center\">Name:</td>
<td align=\"left\" valign=\"center\"><input type=\"text\" name=\"modelname\" value=\"$Model[Name]\"></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">Approved:</td>
<td align=\"left\" valign=\"center\"><select name=\"modelstatus\"><option value=\"0\" $status0>No</option><option value=\"1\" $status1>Yes</option></select></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">Wins:</td>
<td align=\"left\" valign=\"center\"><input type=\"text\" name=\"modelwins\" value=\"$Model[Wins]\"></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">Loses:</td>
<td align=\"left\" valign=\"center\"><input type=\"text\" name=\"modelloses\" value=\"$Model[Loses]\"></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">Draws:</td>
<td align=\"left\" valign=\"center\"><input type=\"text\" name=\"modeldraws\" value=\"$Model[Draws]\"></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">Text:</td>
<td align=\"left\" valign=\"center\"><input type=\"text\" name=\"modeltext\" value=\"$Model[LinkText]\"></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">Url:</td>
<td align=\"left\" valign=\"center\"><input type=\"text\" name=\"modelurl\" value=\"$Model[LinkUrl]\"></td>
</tr>
<tr>
<td align=\"right\" valign=\"center\">File:</td>
<td align=\"left\" valign=\"center\"><input type=\"file\" name=\"upfile\"/></td>
</tr>
<tr>
<td align=\"left\" colspan=\"3\"><input type=\"button\" value=\"Go Back\" onClick=\"javascript:history.go(-1);\"> <input type=\"submit\" name=\"savechanges\" value=\"Save Changes\"></td>
</tr>
<input type=\"hidden\" name=\"modelid\" value=\"$_GET[edit]\">
</form>
</table>";

exit();

}

if(isset($_GET['delete'])) {

$Thumbnail=mysql_result(mysql_query("SELECT Thumbnail FROM Models WHERE ID='$_GET[delete]' LIMIT 1"),0);
@unlink("../images/uploads/$Thumbnail");
mysql_query("DELETE FROM Models WHERE ID='$_GET[delete]' LIMIT 1");

}

if(!isset($_GET['order'])) {$order='Name';}else{$order=$_GET['order'];}
if($_GET['sort'] == 'ASC') {$sort='DESC';}else{$sort='ASC';}

$res=mysql_query("SELECT ID, Name, Wins, Loses, Draws, Thumbnail, LinkText, LinkUrl, Status, (Wins) / (Wins+Loses) AS WinPercent, (Loses) / (Wins+Loses) AS LosePercent, (Wins+Loses+Draws) AS Matches, DATE_FORMAT(DateTime, '%d %M %Y') AS Date FROM Models ORDER BY $order $sort");

while($Model=mysql_fetch_assoc($res)) {

$bg = ($bg == '#EFEFEF' ? '#FFFFFF' : '#EFEFEF');
$color = ($color == '#000000' ? '#000000' : '#000000');

$WinPercent=@round(($Model['Wins'] / ($Model['Wins']+$Model['Loses'])) * 100, 2);
$LosePercent=@round(($Model['Loses'] / ($Model['Wins']+$Model['Loses'])) * 100, 2);

if($Model['LinkText'] == '' && $Model['LinkUrl'] == '') {$Url=' - ';}else{$Url="<a href=\"$Model[LinkUrl]\">$Model[LinkText]</a>";}
if($Model['Status'] == 0) {$Status='No';}else{$Status='Yes';}

$Content .="<tr>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\"><a href=\"../stats.php?id=$Model[ID]\"><img src=\"../images/uploads/$Model[Thumbnail]\" title=\"$Model[Name]\" alt=\"$Model[Name]\" height=\"125\" width=\"125\" border=\"0\" /></a></td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Model[Name]</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Url</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Status</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Model[ID]</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Model[Date]</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Model[Wins]</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$WinPercent%</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Model[Loses]</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$LosePercent%</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\">$Model[Draws]</td>
<td align=\"center\" valign=\"center\" style=\"background-color:$bg;color:$color\"><a href=\"index.php?order=$order&sort=$_GET[sort]&edit=$Model[ID]\"><img src=\"../images/edit.png\" border=\"0px\"></a> <a href=\"index.php?order=$order&sort=$_GET[sort]&delete=$Model[ID]\"><img src=\"../images/delete.png\" border=\"0px\"></a></td>
</tr>";

}

close_conn();

echo"<table align=\"center\" border=\"1\">

<tr>
<td align=\"center\" valign=\"center\"><b>Thumbnail</b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=Name&sort=$sort\">Name</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=LinkText&sort=$sort\">URL</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=Status&sort=$sort\">Approved</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=ID&sort=$sort\">ID</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=DateTime&sort=$sort\">DateTime</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=Wins&sort=$sort\">Wins</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=WinPercent&sort=$sort\">Win Percent</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=Loses&sort=$sort\">Loses</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=LosePercent&sort=$sort\">Lose Percent</a></b></td>
<td align=\"center\" valign=\"center\"><b><a href=\"index.php?order=Draws&sort=$sort\">Draws</a></b></td>
<td align=\"center\" valign=\"center\">&nbsp;</td>
</tr>
$Content
</table>";

?>

Sorry maybe very length, but I'm unsure where I can this file to make short.
Thank you very much
Edwin

[andrewsmd]

To save someone's email address you would need a simple form and then you would have to store the data somewhere i.e. a file or database. Finding example code on how to do that should be fairly straight forward on google.

[edwinteguh]

Please sorry to late reply.
Thank you very much Sir, I try to put simple form, but unsure how to store data.
But know I use form email from emailmeform, but this code use html, my page use php. Would you assist me how to put html code at php file?
I try to use echo, but still get error.

Thank you very much for your advance.
Edwin

[andrewsmd]

I'm not for sure what you want to do. Here is a simple form that mails a message to someone the user specifies.

<html>
<form method="post" name="myForm">
<h2>Send Email</h2><br>
<table cellspacing="10">
<tr><td>To:</td><td><input type="text" name="to" /></td></tr>
<tr><td>From:</td><td><input type="text" name="from" /></td></tr>
<tr><td>Message:</td><td><textarea rows="4" cols="20" name="msg"></textarea></td></tr>
</table>
<br>
<input type="submit" name="submit" value="submit" />
</form>

<?php

//if they click the submit button
if(isset($_POST['submit'])){

$to = $_POST['to'];
$from = $_POST['from'];
$msg = $_POST['msg'];

//to address, subject, message
mail($to, "Mail from system", "Email message from $from\nContent $msg");

}//if isset submit

?>
</html>

[edwinteguh]

sorry to late reply.
I will try this. Thank you so much