notes

access_mysql_sendmail_array_stuff

<code>
, <?php
, //get the db connection credentials from wp-config
, include wp-config.php;
, 
, $servername = DB_HOST;
, $dbname = DB_NAME;
, $username = DB_USER;
, $password = DB_PASSWORD;
, $email_address_file_name = DQemail_addresses.txtDQ;
, $email_addresses_to_send_file_name = DQemail_addresses_to_send.txtDQ;
, 
, // Create connection
, $conn = mysqli_connect($servername, $username, $password, $dbname);
, 
, // Check connection
, if (!$conn) {die(DQConnection failed: DQ . mysqli_connect_error());}
, //query db
, $sql = DQSELECT comment_author_email FROM wp_comments WHERE comment_approved = 1DQ;
, $result = mysqli_query($conn, $sql);
, 
, //mysql results to array
, while($row = mysqli_fetch_row($result)) 
, {
, 		$mysql_array = $row0;
, }
, $mysql_array = array_unique($mysql_array);
, 
, //file contents to array
, $file_array = explode(DQ\nDQ, file_get_contents($email_address_file_name));
, $file_array = array_unique($file_array);
, 
, $unique_array = array_merge(array_diff($mysql_array, $file_array), array_diff($file_array, $mysql_array));
, echo DQmysql_array - DQ;
, print_r($mysql_array);
, echo DQ DQ;
, echo DQ DQ;
, echo DQfile_array - DQ;
, print_r($file_array);
, echo DQ DQ;
, echo DQ DQ;
, echo DQunique_arrayput - DQ;
, print_r($unique_array);
, 
, //create the file for comparison (append)
, $fp_a = fopen($email_address_file_name, a);
, foreach ($unique_array as $value) {
, if ($value!==) fwrite($fp_a, $value.DQ\nDQ); //remove empty lines
, }
, fclose($fp_a);
, $str=DQDQ;
, //create the file to email (write) 
, $fp_w = fopen($email_addresses_to_send_file_name, w);
, foreach ($unique_array as $value) {
, if ($value!==) fwrite($fp_w, $value.DQ\nDQ); //remove empty lines
, if ($value!==) $message .= $value.DQ\nDQ; //remove empty lines
, }
, fclose($fp_w);
, 
, if (filesize($email_addresses_to_send_file_name) > 1)
, {
, 	$email_header = 
, 	DQ
, 	To: pete.olson@outlook.com
, 	Subject: sendmail test two
, 	From: peteolson3150@gmail.com
, 	DQ;
, 	$to = pete.olson@outlook.com;
, 	$subject = Mail Chimp Addresses;
, 	$headers = From: peteolson@gmail.com;
, 
, 	mail($to, $subject, $message, $headers);
, 	echo DQ Somebody got mail!DQ;
, 	
, } 
, else 
, {
, 	echo DQ No mail sentDQ;
, }
, 
, </code>
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
,