Mailing List from Database Results

busby

I have been given a task to create some SQL reports.

One of the reports is to display all the customers who have purchased a certain product based on user selection and then have those results able to be extracted to a mailing list.

So ive got the report done. Some drop down boxes allow a user to select a product and once submitted the results are then displayed.

But i dont even know where to begin with extracting those results to a mailing list. Could someone help me please? What method should I use? and where do i begin? Any code would be helpful but i think its more the method of doing this that im after mostly. BTW im a rookie with PHP/Mysql ive just got my first job since leaving university and this is a task ive been given at work so any quick and helpful replies are greatly appreciated 🙂

Thanks in advance.

awbrowni30

you could create an export button that will pass arguments to a page or ajax/jquery that will create a csv file of your results.

<?php
function export_excel_csv()
{
    $conn = mysql_connect("localhost","root","");
    $db = mysql_select_db("database",$conn);

$sql = "SELECT * FROM table";
$rec = mysql_query($sql) or die (mysql_error());

$num_fields = mysql_num_fields($rec);

for($i = 0; $i < $num_fields; $i++ )
{
    $header .= mysql_field_name($rec,$i)."\\t";
}

while($row = mysql_fetch_row($rec))
{
    $line = '';
    foreach($row as $value)
    {                                           
        if((!isset($value)) || ($value == ""))
        {
            $value = "\\t";
        }
        else
        {
            $value = str_replace( '"' , '""' , $value );
            $value = '"' . $value . '"' . "\\t";
        }
        $line .= $value;
    }
    $data .= trim( $line ) . "\\n";
}

$data = str_replace("\\r" , "" , $data);

if ($data == "")
{
    $data = "\\n No Record Found!\n";                       
}

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=reports.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\\n$data";
}
?>

alternate121

Hi Busby,

Not too sure what you are after, but maybe this script can help, if you need me to explain it, just ask 🙂

<?php
session_start();

$id=$_SESSION['user_id'];

$connect=mysql_connect("localhost","some_user","some_password");

$select=mysql_select_db("database",$connect);

$query_users=mysql_query("SELECT * FROM users WHERE id=''$id" );

while($row=mysql_fetch_array($query_users)){
$user=$row['username'];
$has_bought=$row['bought'];
}

$emailSubject = 'testemail';
$webMaster = 'someuser@somedomain.com';

$firstname = "Website";
$lastname = "Admin";
$email = "php@script.com";
$description = "Test email!";

$body = "<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'
'http://www.w3.org/TR/html4/loose.dtd'><html><head>
<style>

</style>
</head>
<body>
<div id='mess'>
Hello $user,<br /><br />if ($has_bought==true){You are a paid member!}else{click <a href=\"member_buy.html\">Here!</a> to become a member.}</div>
</div>
</body>
</html>
";

$headers = "From: php@script.co.uk\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";

$success = mail($webMaster, $emailSubject, $body, $headers); //<<

$theResults = <<<EOD
(Message sent successful, worked!)
EOD;
echo "$theResults";
?>

I quickly typed the script up so if there is any errors please ask and i will correct them.

alternate121

awbrowni30's script is much better, but i am not too sure if it is too complicated, so if you need i can still explain the script, i posted the script half an hour after so i didnt know awbrowni30 had replied. After looking at awbrowni30's script i realise what you want to do and you will need foreach loops that awbrowni30 provides.

busby

thanks guys...aw's script helped me a lot and thanks to you too alternate 🙂 got it sorted now