PHP - Create Free Email System In Mysql

I have database table EMAIL[e_id,receiver_email,sender_email,email_Subject,date_time,Text_body]

i have displayed sender_email,Email_subject,Date_time in html table
by using
 select sender_email,Email_subject,Date_time from email where receiver_email=$current _user
i need to open email_body by clicking the sender_email
problem is that how can i get value of first cell of table in the same row by clicking any other column
or if you have alternative
as yahoo displayes all emails received in inbox
by clicking any sender it opens that specific email

For some reason my email system isnt working, but no errors are showing up and i cant seem to find a syntax error. I need some fresh eyes to help to solve this...

Code: [Select]
<?php
if(isset($_POST['PersonName'])) {
 
// EDIT THE 2 LINES BELOW AS REQUIRED
$email_to = "j.hopley@2008.ljmu.ac.uk";
$email_subject = "An email from your blog.";
 
 
function died($error) {
// your error code can go here
echo "We are very sorry, but there were error(s) found with the form you submitted. ";
echo "These errors appear below.<br /><br />";
echo $error."<br /><br />";
echo "Please go back and fix these errors.<br /><br />";
die();
}
 
// validation expected data exists
if(!isset($_POST['PersonName']) ||
!isset($_POST['PersomComment']) ||
!isset($_POST['PersonEmail']) ||
!isset($_POST['PersonNumber'])) {
died('We are sorry, but there appears to be a problem with the form you submitted. One or more fields were empty or contained invailid charicters.');      
}
 
$person_name = $_POST['PersonName']; // required
$person_comment = $_POST['PersomComment']; // required
$person_email = $_POST['PersonEmail']; // required
$person_number = $_POST['PersonNumber']; // not required

 
$error_message = "";
$email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
  if(!preg_match($email_exp,$person_email)) {
$error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
$string_exp = "/^[A-Za-z .'-]+$/";
  if(!preg_match($string_exp,$person_name)) {
$error_message .= 'The Name you entered does not appear to be valid.<br />';
  }
  if(strlen($person_comment) < 2) {
$error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
  if(strlen($error_message) > 0) {
died($error_message);
  }
$email_message = "Form details below.\n\n";
 
function clean_string($string) {
  $bad = array("content-type","bcc:","to:","cc:","href");
  return str_replace($bad,"",$string);
}
 
$email_message .= "First Name: ".clean_string($person_name)."\n";
$email_message .= "Email: ".clean_string($person_email)."\n";
$email_message .= "Telephone: ".clean_string($person_number)."\n";
$email_message .= "Comments: ".clean_string($person_comment)."\n";
 
 
// create email headers
$headers = 'From: '.$person_email."\r\n".
'Reply-To: '.$person_email."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers); 
}
?>

For my A level ICT i need to create a PHP newsletter email system for which people can sign up from one page and then a admin can log in and send out the email to the people that have signed up. My problem is i also need to attach a PDF to these emails, however i cant work out how to add this into the scripts i have for the newsletter system. Even my teacher cant help me  , please can someone help me    .
The code i have is below.
admin.php
<?php
  //load configuration
  require("config.php");
  
  //connect to database
  @mysql_connect($db_server,$db_user,$db_password) or die("Database server connection failed. Check variables \$db_server, \$db_user and \$db_password in config.php");
  @mysql_select_db($db_name) or die("Selecting database failed. Check variable \$db_name in config.php");
  
  //print header
  echo $header;
?>
<h1><?php echo $title; ?> - Administration</h1>
<hr>
<?php 
  $pwd = $_GET["pwd"];

  //simple login
  if(isset($pwd) && ($pwd == $password)){
    $submit = $_POST["submit"];
    $submit_newsletter = $_POST["submit_newsletter"];
    $del = $_GET["del"];
          
    //insert new address
    if(isset($submit)){
      $name = $_POST["name"];
      $email = $_POST["email"];
      
      @mysql_query("INSERT INTO $db_table (email,name) VALUES ('$email','$name');");
      
      //error occurred
      if(@mysql_error()){
        ?><p>Inserting entry failed: <?php echo @mysql_error(); ?></p>
        <p><a href="javascript&#38;#058;history.back();">Click here to go back.</a></p><?php
      //successful
      }else{
        ?><p>Entry has been inserted successfully. <a href="admin.php?pwd=<?php echo $pwd; ?>">Click here to continue.</a></p><?php
      }
    //delete an entry
    }else if(isset($del)){
      @mysql_query("DELETE FROM $db_table WHERE id=$del;");
      
      //error occurred
      if(@mysql_error()){
        ?><p>Deleting entry failed: <?php echo @mysql_error(); ?></p>
        <p><a href="javascript&#38;#058;history.back();">Click here to go back.</a></p><?php
      //successful
      }else{
        ?><p>Entry has been deleted successfully. <a href="admin.php?pwd=<?php echo $pwd; ?>">Click here to continue.</a></p><?php
      }
    //send newsletter
    }else if(isset($submit_newsletter)){
      $sent = 0;
      $result = @mysql_query("SELECT name,email FROM $db_table ORDER BY email ASC;");
      $subject = $_POST["subject"];
      $message = $_POST["message"];
      
      ?><p>Sending emails to ...</p>
      <ul><?php
      
      //send emails one by one
      while($row=@mysql_fetch_array($result)){
        $name = $row["name"];
        $email = $row["email"];
        
        ?><li><?php echo $name; ?> (<?php echo $email; ?>) ... <?php

        if(@mail($email,$subject,$message,"From: $admin <$admin>\n")){
          ?>sent<?php
          $sent++;
        }else{
          ?>failed<?php
        }
        
        ?></li><?php
      }
      
      ?></ul>
      <p><strong><?php echo $sent; ?> emails sent.</strong> <a href="admin.php?pwd=<?php echo $pwd; ?>">Click here to continue.</a></p><?php
    //print forms
    }else{
       ?><h2>Send newsletter</h2>
       <form method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>">
         <table>
           <tr>
             <td>Subject:</td>
             <td><input type="text" name="subject" class="fixedwidth"></td>
           </tr>
           <tr>
             <td valign="top">Message:</td>
             <td><textarea name="message" cols="60" rows="20" class="fixedwidth"><?php echo $signature; ?></textarea></td>
           </tr>
           <tr>
             <td>&nbsp;</td>
             <td><input type="submit" name="submit_newsletter" value="Send"></td>
           </tr>
         </table>
       </form>

       <h2>Add an email address</h2>
       <form action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>" method="post">
         <table>
           <tr>
             <td>Name:</td>
             <td><input type="text" name="name" value="" maxlength="255"></td>
           </tr>
           <tr>
             <td>Email address:</td>
             <td><input type="text" name="email" value="" maxlength="255"></td>
           </tr>
           <tr>
             <td>&nbsp;</td>
             <td><input type="submit" name="submit" value="Submit"></td>
           </tr>
         </table>
       </form>

       <h2>Email addresses</h2>
       <table cellpadding="5" cellspacing="2">
         <tr class="header">
           <td><strong>Name</strong></td>
           <td><strong>Email address</strong></td>
           <td>&nbsp;</td>
         </tr>
         <?php
           $result = @mysql_query("SELECT * FROM $db_table ORDER BY email ASC;");
           $colored = false;

           while($row=@mysql_fetch_array($result)){
             $colored = !$colored;
             ?><tr<?php if($colored){ ?> class="colored"<?php } ?>>
               <td width="200"><?php echo $row["name"]; ?></td>
               <td width="200"><?php echo $row["email"]; ?></td>
               <td><a href="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>&del=<?php echo $row["id"]; ?>">remove</a></td>
             </tr><?php
           }
         ?>
       </table>
       <?php
    }
  }else{
    //print login form
    echo $login;
  }
  
  //print link to news
  ?><p align="right"><a href="index.php">Newsletter</a></p><?php
  
  //print footer
  echo $footer;

  //close database connection
  @mysql_close();
?>
config.php
<?php
/* ######################## DATABASE ######################## */

  // Database server
  $db_server = "localhost";
  
  // Database name
  $db_name = "zpwebsi1_news";
  
  // Database username
  $db_user = "zpwebsi1_zac";

  // Database password
  $db_password = "powell";
  
  // Database table to store news
  // (will be created automatically)
  $db_table = "easy_newsletter";

/* ##################### CONFIGURATION ###################### */

  // Complete URL of the script
  // (begins with http://, ends with slash)
  $url = "http://www.charsfieldthreehorseshoes.co.uk/alemail.html";
  
  // Password for the administration
  $password = "admin";
  
  // Administrator email address (will be used as sender of
  // the newsletter emails)
  $admin = "zac@zpwebsite.com";

  // Title (will be displayed in the browser's header
  $title  = "Ale Mail";

  // Signature (will be inserted when creating a fresh
  // newsletter but can be changed before submitting)
  $signature  = "\n\n\n\n\n---------------------\nYou receive this email because you have registered with our newsletter $title. Click the following link to unsubscribe: $url";

/* ######################### LAYOUT ######################### */

  // Header to be used on each page
  $header = <<<EOT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <link href="style.css" rel="stylesheet" type="text/css">
    <title>$title</title>
  </head>
  <body>
EOT;

  // Footer to be used on each page
  $footer = <<<EOT
  </body>
</html>
EOT;

  // Login form
  $login = <<<EOT
    <form action="admin.php" method="get">
      Password: <input name="pwd" type="password"> <input type="submit" value="Login">
    </form>
EOT;
?>

And index.php
<?php
  //load configuration
  require("config.php");
  
  //print header
  echo $header;
?>
<h1><?php echo $title; ?></h1>
<hr>
<?php  
  //form submitted
  if(isset($_POST["submit"])){
    //connect to database
    @mysql_connect($db_server,$db_user,$db_password) or die("Database server connection failed. Check variables \$db_server, \$db_user and \$db_password in config.php");
    @mysql_select_db($db_name) or die("Selecting database failed. Check variable \$db_name in config.php");

    $name = $_POST["name"];
    $email = $_POST["email"];
    
    //subscribe
    if($_POST["action"]=="subscribe"){
      //check if name is long enough
      if(strlen($name)<3){
        ?><p>Name must consist of at least 3 characters.</p><?php
      //check if email is valid
      }else if(!eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$",$email)){
        ?><p>Email address is not valid.</p><?php
      //check if email already exists
      }else if(@mysql_num_rows(@mysql_query("SELECT id FROM $db_table WHERE email='$email';"))){
        ?><p>Email address exists already.</p><?php
      //insert values
      }else{
        @mysql_query("INSERT INTO $db_table (email,name) VALUES ('$email','$name');");

        //error occurred
        if(@mysql_error()){
          ?><p>An unknown error occurred. Please try again later.</p><?php
        //successful
        }else{
          ?><p>Subscription was successful. Thank you!</p><?php
        }
      }
    //unsubscribe
    }else{
      @mysql_query("DELETE FROM $db_table WHERE email='$email';");

      //error occurred
      if(@mysql_error()){
        ?><p>An unknown error occurred. Please try again later.</p><?php
      //email not found
      }else if(@mysql_affected_rows()==0){
        ?><p>Email address not found.</p><?php
      //successful
      }else{
        ?><p>You have unsubscribed successfully!</p><?php
      }
    }
  }
?>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
  <table>
    <tr>
      <td>Your name:</td>
      <td><input type="text" name="name" value="" maxlength="255"></td>
    </tr>
    <tr>
      <td>Your email address:</td>
      <td><input type="text" name="email" value="" maxlength="255"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="radio" name="action" value="subscribe" id="action_subscribe" checked> <label for="action_subscribe">subscribe</label>&nbsp;<input type="radio" name="action" value="unsubscribe" id="action_unsubscribe"> <label for="action_unsubscribe">unsubscribe</label></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="submit" value="Submit"></td>
    </tr>
  </table>
</form>
<p align="right"><a href="admin.php">Administration</a></p>
<?php
  //print footer
  echo $footer;

  //close database connection
  @mysql_close();
?>

Hi guys,

I understand that there are websites which do teach about creating Email Confirmation, are there any sites which you can recommend? Thanks

Wilson

I have a form on my website that currently uses the mail() function to send the information it collects and all works fine. I want to switch it over to open the email in Thunderbird on the user's machine so they can view it prior to sending. This should be much less complicated but I can't find answers anywhere, all I want to do is just open the email in the user's email client with the proper information/attachments included. Anyone? Thanks!

Hi All,

I don't really need help with the code, I just need to know the process...

This will take place in a simple form.  The user enters the payment information and checks off 'Send Receipt' option.  From there, the payment data is stored in the DB.  Then, I need to have a PDF generated of the receipt and finally email the tenant with confirmation and the PDF that was created.

Once the data is inserted, I can use fPDF to merge the data to the PDF document I created.  That part I don't understand is how to automatically save that file and attach it to an email.

Ideas / suggestions?

How to create a pdf dynamically and that pdf should sent as a email attachment.

I am using a login system in php and mySQL but only one page is potected.

pages i am using:
1. login.php // inputing details (user name, password)
2. checkloginDetails.php // connect to db and check login details
3. logged_in.php // successfully login

...i need more than the one page protected for example; once the user has logged in there will be the main logged in page with other links, remove topics, add, user, remove user all these pages i want protecting but with out the user inputing his details again.

Has anyone got an idear onhow i ould achive this?
 

i have already made the register page where their info goes into the database, and im not sure about the code that selects values from the database.
mysql_connect('', '', '');
mysql_select_db('');

$user = $_POST['user'];
$pass = $_POST['pass'];

echo "<font color='white'>You Need To Login</font>";
if($user == Username && $pass == Password) echo "Welcome $user";

mysql_query("SELECT ('Username', 'Password') FROM login");

?>

I'm trying to after submission   1. create a csv 2. insert record into db 3. send email that's created in form submission - $msg. 4. send email with attachment to only the email I specify (if possible) if not attach it to the email that's created at submission.    I've search and search and found different methods but doesn't work with my code. I kept 3 lines at the top but can't get them to work ... either I don't get an email after submission or don't get an attachement.    Can some one help?

<?php 

$random_hash = md5(date('r', time()));

$csvString = "..."; // your entire csv as a string
$attachment = chunk_split(base64_encode($csvString));

$to = "email@email.com";


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

// VALIDATION

  if(empty($_POST['firstName'])) 
  { 
   
   "First Name Required";
  } 
  
     
 if(empty($_POST['lastName'])) 
  { 
   
   "Last Name Required"; 
  
  }
  
  if(empty($error))  
  { 
   
	$to = "$to";
	$subject = 'The Form';
        $headers = "MIME-Version: 1.0 \r\n";
	$headers .= "Content-Type: text/html; \r\n" ;
	
   $msg .="<html>
	<head></head>
    <body>
    <table width='100%' cellspacing='0' border='0' cellpadding='0'>
    <tr><td>
    	<table width='100%' cellspacing='0' border='0' cellpadding='0'>
           <tr><td>This is the email sent.</td></tr>
        </table>
      </body>
    </html>";

  include('con.php');
	
	 $con = mysqli_connect($host,$user,$pass,$dbName);
	 if (!$con)
	  {
	  die('Could not connect: ' . mysqli_error($con));
	  }

      mysqli_select_db($con,"thetable");
	  
	 $firstName = mysqli_real_escape_string($con, $_POST['firstName']);
	$lastName = mysqli_real_escape_string($con, $_POST['lastName']);
						
	$sql = "SELECT * FROM thetable WHERE `firstName` = '{$firstName}' OR `lastName` = '{$lastName}'";
		
       $result = mysqli_query($con,$sql);
		 
	if(($result->num_rows)>= 1)
	{
	$theerror = "You exist"; 
	}
		
	else
	{
		  
	  $sql="INSERT INTO thetable(firstName, lastName) VALUES ('$_POST[firstName]','$_POST[lastName]'";
		   
		   $success = "Sent ... Insert it!!!"; 
		   
		   
	      if (!mysqli_query($con,$sql))
		  {
		  die('Error: ' . mysqli_error($con));
		  }
		   
		   $result = @mail($to, $subject, $msg, $headers); 
		}
		 
	   mysqli_close($con);

     
      { 
       
      } 
    } 
  } 
 
?> 

Edited by barkly, 27 October 2014 - 02:59 PM.

Hi,

I have a fully pledged membership system and want to integrate my own user referral system but want some tips, advice really on the logic of it. Basically already registered users on my site will have the option to refer people, only registered users. I will try to explain my logic and what i have done so far.

My current registered users table is something like

Quote

    users (table)
    - id (user id)
    - email (user email)
    - password (hash of users password)
    - reg_date (date user registered)


I have some other fields but not relevant to what I want to do and to keep things as simple as possible I left them out.

I am thinking of creating a new table called referrals and for example when a registered user on my site from the users table goes to a member only page called referral.php it will display a form so they can enter an email address of someone they want to refer and it also displays the people they referred.

My referral table is like this so far and not sure if it's best way to go about the database logics and php logic.

my table so far looks like this:

Quote

    referrals (table)
    - id (auto incremented every time a new referral (row) is added to referrals table)
    - referrer_uid (id of referrer, this would be the unique id of a registered user from the users table)
    - referred_email (email address of person who has been referred)
    - status (when someone is first referred default will be `referred`, if they signup to site via referral link this will update to `completed`)
    - created_on (date the referral was made, unix timestamp)
    - updated_on (date the referred person actually clicks the referral link and completes signup)


Currently i added the database table above to my site on local. added some sample data for testing and created a referral.php page where there's a form so a registered member can enter a persons email and refer them to my site to signup. On referral.php there is also  the total people they referred and a table showing all the people they referred as follows:

Referred Email | Referred Date | Status | Completed On

Now so far everything is seems fine. I have my sample (pretend referrals i made) data showing in my test account. The part i am now not sure about is this:

Obviously to stop abuse i do my usual validation checks like: check to ensure the email being entered on referrals page does not exist in users table (registered member), check to ensure the email has not already been referred previously (for spam reasons) only allowed to refer an email address once and not allowed to refer someone who has previously been referred by someone else to (again for spam reasons)

Now onto the tracking the referral and link building.

I was first thinking this:

on sign up form have a hidden field. The sign up form would do a simple check to see if isset $_GET['ref'] like signup.php?ref=something_here

if it is prefill the hidden field, when user then signs up if the ref=something_here matches what's in the database then update referral to complete so the referrer knows that their friend for example signed up via their referral, unix timestamp of when referred person completed signup.

Now i was going to use the email address of referred person or username of person who made the referral signup.php?ref=username or signup.php?ref=referred_email . Now what i am thinking is what would be better and i guess stop random abuse is create another column and call it referred_id; this would be a random md5 hash that is unique to that referral and it will be appended to the url like signup.php?ref=md5_hash_here.



So my questions a

1) Is there anything you think i should change, improve on, alter etc ?

2) Do you think i am going about it the rite way or making a mess of it ?

3) Have i left anything out that i may have not thought of that could cause the system to be abused ?

Any suggestions, feedback, help on the whole logic would be great.

I coded allot of it last night and won't take me long to do the rest but need some help in terms of ensuring i am doing it the best way possible etc, the logic behind it all.

Thanks for any suggestions, help, advice, tips!

PHPFAN

Okay so kinda new to php and been looking around google for hours trying to figure this out, I am trying to get this array from MySql instead of it being hardcoded as my website always has new users... This is for a chat system built into the site.

Table = user_table
$row1 = Username
$row2 = Password

function SimpleLoginSystem() {
$this->aExistedMembers = array(
'User1' => 'qwerty',
'User2' => 'assdf',
'User3' => 'qwe',
'Beatz' => '123'
);
}

I have tried many variations of MySql queries and inserting into the array list, but every time (even when I echo_r($array) and copy and paste the user and pass it still says wrong user/pass... Anyone that can help me with this?

Would be much appreciated

function SimpleLoginSystem() {
$vLink = mysql_connect("localhost", "root", "password");
mysql_select_db("website");

$resultset = mysql_query("SELECT Username, Password FROM user_table");

$this->aExistedMembers = array();
for ($i = 1; $line = mysql_fetch_assoc($resultset); $i++) aExistedMembers[$i] = $line;
echo mysql_error();
print_r($aExistedMembers);
}

Sorry if I haven't explained this too well I am not too good at explaining

I'm a newbie and want to explore on the use of php.I want to create a transcript system but do not know how to go about it.please where should i start from?

I have two sets of codes that work perfectly.  One is for the table and the other is for the rating system.  I can't seem to figure out how to combine the two codes so that the rating system is displayed INSIDE the table instead of after it.  I'm not sure if it's possible, but I've seen it used on sites like Netflix.  If you can tell me how to fix it or give me a different suggestion I would be eternally thankful.

What I am trying to do ultimately is have a table that has a star rating associated with each entry without linking to a full page.



Code: [Select]
<link rel="stylesheet" type="text/css" href="style.css">
<script type="text/javascript" src="/jquery_star.js"></script>
<script type="text/javascript" src="/script.js"></script>
<?php
$con = mysql_connect("localhost","myhowd5_undrdg","indie500");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("myhowd5_jo151", $con);

$result = mysql_query("SELECT * FROM jos_easytables_table_data_1");

echo "<table border='1'>
<tr>
<th>Artist</th>
<th>Genre</th>
<th>Your Rating</th>
<th>Average Rating</th>
<th>Total Votes</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['column0'] . "</td>";
  echo "<td>" . $row['column1'] . "</td>";
    echo "<td>" . $row['rating'] . "</td>";
      echo "<td>" . $row['total_rating'] . "</td>";
        echo "<td>" . $row['total_ratings'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?> 

<?php
mysql_connect("localhost", "myhowd5_undrdg", "indie500") or die(mysql_error());
mysql_select_db("myhowd5_jo151") or die(mysql_error());

$query = mysql_query("SELECT * FROM jos_easytables_table_data_1");

while($row = mysql_fetch_array($query)) {
    $rating = (int)$row[rating];
    ?>
    <div class="floatleft">
        <div id="rating_<?php echo $row[id]; ?>">
            <span class="star_1"><img src="/star_blank.png" alt="" <?php if($rating > 0) { echo"class='hover'"; } ?> /></span>
            <span class="star_2"><img src="/star_blank.png" alt="" <?php if($rating > 1.5) { echo"class='hover'"; } ?> /></span>
            <span class="star_3"><img src="/star_blank.png" alt="" <?php if($rating > 2.5) { echo"class='hover'"; } ?> /></span>
            <span class="star_4"><img src="/star_blank.png" alt="" <?php if($rating > 3.5) { echo"class='hover'"; } ?> /></span>
            <span class="star_5"><img src="/star_blank.png" alt="" <?php if($rating > 4.5) { echo"class='hover'"; } ?> /></span>
        </div>
    </div>
    <div class="star_rating">
        (Rated <strong><?php echo $rating; ?></strong> Stars)
    </div>

    <div class="clearleft">&nbsp;</div>
    <?php    
}

?>