|
|
|
 |
Some queried recently on how to have new data sent to them in an email.
here is an example
| $date = date("Y-m-d");
$sql = "select * from table where date_format(date,'%Y-%m-%d') = '$today'";
$result = mysql_query($sql);
$message = ''; //default and initilize variable
if (($result)&&(mysql_num_rows($result)>0))
{
while ($rows = mysql_fetch_array($result))
{
$message .= mysql_field_name($result,0).':'.$rows[0].'\n' ; \\add whatever fields you want
}
}else{
$message = "No results today";
}
$to = "me@mydomain.com";
$subject = "New data entered";
//build the headers
$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\n";
$headers .= "X-Priority: 1\n";
$headers .= "X-MSMail-Priority: High\n";
$headers .= "X-Mailer: PHP\n";
$headers .= "From: \"Site Admin <no-reply@sitename.com>\n";
mail($email, $subject, $message, $headers);
?> | |
|
|
| Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | Broadcast HTML Email
Categories : PHP, Email, MySQL, Databases | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | for each record, do this to the first record, and do that to any subsequent record
Categories : PHP, Databases, MySQL, Beginner Guides | | | Convert a File database into MySQL
Categories : PHP, Filesystem, Databases, MySQL, Beginner Guides | | | Newbie Notes #4 - Trapping dumb MySQL query errors
Categories : PHP, Databases, MySQL, Debugging, Beginner Guides | | | mySQL/PHP/search with multientry
form and table output with colored rows
Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases | | | Email a user with out exposing email address
Categories : PHP, Databases, MySQL, Email | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | How to Insert a Date Format Into MySQL from PHP
Categories : PHP, Databases, MySQL, Date Time, Beginner Guides | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | Making a simple Hit-Log using PHP and MySql
Categories : PHP, Log Files, Beginner Guides, Databases, MySQL | | | Newbie Notes #10 - Generating drop downs
Categories : PHP, MySQL, HTML, Beginner Guides, Databases | | | Add, Edit /Update & Delete all in one Contact Management Form
Categories : PHP, MySQL, Databases, Beginner Guides | | | Solution to those 'tell-a-friend' type email issues
Categories : PHP, Email, Databases, MySQL | |
| |
| |
|
