i've got trouble with a script ... I really don't know what's happening ... this php page receives the url of the page (tell a friend type of script ) ... but then i wanna write the info in a mysql database ... it does but the only thing is that he writes the url on one line of the table ... and when the user fills out the form it writes a second line ... hmmm! i've been trying for hours to get it right ... but i must be missing something !
here's the script :
<?php
$admin_email = ""; // Your valid email (only if you wish to receive alert on new recommendation)
$number_of_email_to_recommend = 5;
$charset = "iso-8859-1"; // Specify the charset for recommending page
$templatefolder = "templates"; // path to Templates Folder
// Language set for Recommend !t
$lang['recommend_window_header'] = "Recommander une page";
$lang['recommend_messages_guide'] = "Commentaires :";
$lang['recommend_messages_warning'] = "DO NOT REMOVE the URL";
$lang['recommend_email_guide'] = "Votre courriel :";
$lang['recommend_email_field_guide'] = "Courriel #";
$lang['recommend_email_subject'] = "Une page suggérée par";
$lang['recommend_submit'] = "Envoyer";
$lang['recommend_reset'] = "Annuler";
$lang['recommend_submit_error1'] = "Votre adresse électronique est invalide";
$lang['recommend_submit_error2'] = "PLEASE ENTER YOUR MESSAGES WITH AT LEAST MY DEFAULT URL !";
$lang['recommend_submit_error3'] = "L'adresse électronique de votre ami(e) est invalide";
$lang['recommend_yourmessages'] = "Bonjour,\nCette page vous est suggérée :\n";
$lang['recommend_thanks'] = "Votre suggestion a bien été transmise avec succès !<br><a href=\"javascript:window.close()\">Quitter</a>";
/###################################################################/
/ DO NOT EDIT THE CODE BELOW IF YOU DON'T KNOW WHAT IT IS ALL ABOUT /
/##################### Recommend !t Functions ######################/
// Get template
function gettemplate($template,$ex="php") {
global $templatefolder;
if(!$templatefolder) $templatefolder = "templates";
return str_replace("\"","\\"",implode("",file($templatefolder."/".$template.".".$ex)));
}
// Display template
function dooutput($template) {
echo $template;
}
// Auto parse URL
function parseURL($input) {
$input = eregi_replace("[a-zA-Z0-9.]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+[[:alnum:]/]","\0", $input);
$input = eregi_replace(" (www.+\..)"," [url]http://\1[/url]", $input);
$input = eregi_replace("[[:alpha:]]+://[<>[:space:]]+[[:alnum:]/]","<a href=\"\0\" target=\"_blank\">\0</a>", $input);
return $input;
}
// Check for valid Email
function checkEmail($input) {
if(!eregi("[a-zA-Z0-9.]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$", $input)) $input = "";
else $input = $input;
return $input;
}
/###################################################################/
if(isset($POST['dowot']) == "send") {
// At first, check for sender's valid email.
// Print out an alert if it's invalid.
if(!checkEmail($POST['senderemail'])) exit($lang['recommend_submit_error1']);
else $senderemail = $POST['senderemail'];
// Recommend email should have at least your URL in the messages as default.
// Print out an alert if it's empty
if($POST['messages']) {
$messages = htmlspecialchars($POST['messages']);
$messages = parseURL(nl2br(stripslashes($messages)));
}
else exit($lang['recommend_submit_error2']);
$tempaddr[] = ""; // use this temporary to sure that there's no repeated emails
// Send the page with messages to sender's friendmail if it's valid
foreach($POST['emails'] as $email){
if(checkEmail($email) && (!in_array($email,$tempaddr))) {
if($sentemails) $sentemails .= " , ";
$sentemails .= $email;
$headers = "Content-Type:text/html; charset=$charset\n";
$headers .= "From: $senderemail<$senderemail>\n";
$headers .= "To: $email\n";
$headers .= "Reply-To: $senderemail\n";
$headers .= "X-Sender: <$senderemail>\n";
$headers .= "X-Mailer: PHP\n";
$headers .= "Return-Path: <$senderemail>";
$messages .= "<br>Page suggérée par : $sendername";
$messages .= "<br> ------------------- <br>Commentaires :<br>$Commentaires";
$messages .= "<br><br><table width='450' border='0' cellspacing='0' cellpadding='2'>
<tr>
<td height='2' bgcolor='#000033'></td>
</tr>
</table>";
@mail($email,"$lang[recommend_email_subject] $senderemail",$messages,$headers);
}
$tempaddr[] = $email;
}
// Print out an alert if there's no valid emails
if(!$sentemails) exit($lang['recommend_submit_error3']);
// Ofcourse we don't forget to show our thankful
else {
$sentemails = parseURL($sentemails);
// Send to your email an alert if you wish
if(checkEmail($admin_email)) {
$messages = "We've just been recommended by $senderemail to email(s): $sentemails";
$headers = "Content-Type:text/html; charset=$charset\n";
$headers .= "From: $admin_email<$admin_email>\n";
$headers .= "To: $admin_email\n";
$headers .= "Reply-To: $admin_email\n";
$headers .= "X-Sender: <$admin_email>\n";
$headers .= "X-Mailer: PHP\n";
$headers .= "Return-Path: <$admin_email>";
@mail($admin_email,"We've just been Recommended",$messages,$headers);
}
eval("dooutput(\"".gettemplate("recommendit_thanks")."\");");
}
}
if($_GET['wot'])
{
$emailfield = '';
$page_to_send = urldecode(getenv("HTTP_REFERER"));
for($i=1;$i<=$number_of_email_to_recommend;$i++)
{
if(isset($emailfield)) $emailfield .= "<br>";
eval ("\$emailfield .= \"".gettemplate("recommendit_emailfield")."\";");
}
eval("dooutput(\"".gettemplate("recommendit")."\");");
}
?>
<?
$date = Date("d-m-Y G:i");
$page = $page_to_send;
$DBhost = "localhost";
$DBuser = "*";
$DBpass = "";
$DBName = "**";
$table = "envoyerpage";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select
database $DBName");
$sqlquery = "INSERT INTO $table VALUES('$id','$date','$page','$sendername','$senderemail','$sentemails','$Commentaires')";
$results = mysql_query($sqlquery);
mysql_close();
?>
Thanks a bunch !
CaptE .... 😕
