Reminder Php
Ik heb hulp nodig bij dit script, ik zoek een manier om een balkje toe te voegen voor email en dit script dus voor iedereen beschikbaar te maken. Ik ben niet al te goed in php dus hulp zou ongelooflijk goed zijn.
Vraag dan eerst hulp, en post dan het script..
ik herhaal: ben echt een idioot als het aankomt op php, slechts een beginner. En willem-jan: het script is af daarom heet het ook personal reminder. Ik wil er een draai aan geven waardoor dit vrijkomt voor iedereen
<input type="text" name="reminder_email">
invoegen in de database:
// No error let's add the entry
mysql_query( "INSERT INTO reminder_events(reminder_name, reminder_desc, reminder_date, reminder_email) VALUES('".addslashes($_POST['reminder_name'])."', '".addslashes($_POST['reminder_desc'])."', '".addslashes($_POST['reminder_email'])."', '".addslashes($reminder_date)."')" );
er weer uithalen en gebruiken:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?php
include('database.inc.php'); // Our database connectivity file
// Values you need set
$number_of_days_before = 1;
$reminder_details = "";
$todays_date = date( "Ymd" );
$year = substr($todays_date, 0, 4);
$month = substr($todays_date, 4, 2);
$date = substr($todays_date, 6, 2);
$trigger_date = date("Ymd", mktime (0,0,0,$month,$date-$number_of_days_before,$year));
$result = mysql_query( "SELECT * FROM reminder_events WHERE reminder_date <= $trigger_date ORDER BY reminder_date ASC" );
$nr = mysql_num_rows( $result );
while( $row = mysql_fetch_array( $result ) )
{
$year = substr($row["reminder_date"], 0, 4);
$month = substr($row["reminder_date"], 4, 2);
$date = substr($row["reminder_date"], 6, 2);
$reminder_date = date("M j, Y", mktime (0,0,0,$month,$date,$year));
$reminder_details .= "Event: ".$row["reminder_name"]."\n";
$reminder_details .= "Date: ".$reminder_date."\n";
$reminder_details .= $row["reminder_desc"]."\n\n";
$email = $row["reminder_email"];
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send out Reminder mail
$mailheader = "From: Reminder System <$email>\nX-Mailer: Reminder\nContent-Type: text/plain";
mail("$email","Reminder","$reminder_details","$mailheader");
// Delete the sent reminders
mysql_query("DELETE FROM reminder_events WHERE reminder_date <= $trigger_date" );
}
?>
include('database.inc.php'); // Our database connectivity file
// Values you need set
$number_of_days_before = 1;
$reminder_details = "";
$todays_date = date( "Ymd" );
$year = substr($todays_date, 0, 4);
$month = substr($todays_date, 4, 2);
$date = substr($todays_date, 6, 2);
$trigger_date = date("Ymd", mktime (0,0,0,$month,$date-$number_of_days_before,$year));
$result = mysql_query( "SELECT * FROM reminder_events WHERE reminder_date <= $trigger_date ORDER BY reminder_date ASC" );
$nr = mysql_num_rows( $result );
while( $row = mysql_fetch_array( $result ) )
{
$year = substr($row["reminder_date"], 0, 4);
$month = substr($row["reminder_date"], 4, 2);
$date = substr($row["reminder_date"], 6, 2);
$reminder_date = date("M j, Y", mktime (0,0,0,$month,$date,$year));
$reminder_details .= "Event: ".$row["reminder_name"]."\n";
$reminder_details .= "Date: ".$reminder_date."\n";
$reminder_details .= $row["reminder_desc"]."\n\n";
$email = $row["reminder_email"];
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send out Reminder mail
$mailheader = "From: Reminder System <$email>\nX-Mailer: Reminder\nContent-Type: text/plain";
mail("$email","Reminder","$reminder_details","$mailheader");
// Delete the sent reminders
mysql_query("DELETE FROM reminder_events WHERE reminder_date <= $trigger_date" );
}
?>
dit zou moeten werken lijkt me...
Gewijzigd op 12/01/2006 22:48:00 door Niek Berckmans
De database moet je aanmaken in phpmyadmin, je maakt simpelweg een nieuwe tabel aan met daarin de kolommen die nodig zijn (zie script)
reminder_email VARCHAR(255) not null
reminder_id bigint(20) unsigned NOT NULL auto_increment,
reminder_name varchar(255) NOT NULL default '',
reminder_desc text,
reminder_email VARCHAR(255) NOT NULL,
reminder_date varchar(8) NOT NULL default '0',
PRIMARY KEY (reminder_id),
KEY reminder_id (reminder_id)
) TYPE=MyISAM;
dit heb ik toegevoegd in phpmyadmin, hij gaf me geen error dus ik neem aan dat het klopt, ik begrijp nog 1 regel niet en dat is:
// No error let's add the entry
mysql_query( "INSERT INTO reminder_events(reminder_name, reminder_desc, reminder_date, reminder_email) VALUES('".addslashes($_POST['reminder_name'])."', '".addslashes($_POST['reminder_desc'])."', '".addslashes($_POST['reminder_email'])."', '".addslashes($reminder_date)."')" );
wat doe ik hiermee??
