PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE email_list ( `first_name` varchar(64), `last_name` varchar(64), `email` varchar(64) ); INSERT INTO email_list values ('John', 'Connor', 'john.connor@gmail.com');
Copy Clear
Copy Format Clear
<?php $from = "elmer@makemeelvis.com"; $subject = 'subject'; //$_POST["subject"]; $text = 'text'; //$_POST["text"]; ($dbc = mysqli_connect("data.makemeelvis.com", "elmer", "theking", "elvis_store")) or die("Error connection to MySQL server"); $query = "SELECT * FROM email_list"; ($result = mysqli_query($dbc, $query)) or die("Error querying database."); while ($row = mysqli_fetch_array($result)) { $first_name = $row["first_name"]; $last_name = $row["last_name"]; $msg = "Dear $first_name $last_name, n\ $text"; $to = $row["email"]; //mail($to, $subject, $msg, "From:" . $from); echo "Email sent to: " . $to . "<br/>"; } mysqli_close($dbc); ?>
Show:  
Copy Clear