PHP - Php Auto Email Response

Hi

I need to auto send an email to notify user about their next appointment date.
Anyone know how to do the auto send email coding or it requires any external php class to do so?

I'm using php and xampp.

Thanks
Ben CHew

I'm new to PHP, can anyone can help me with auto sending email?
I have a database which store my customer data which includes their next appointment date etc and I would like to auto send an email reminder to them.

I have some problem with the script and I'm not sure it's work.
My email script "To", I'm not sure how should I state the recipient email as there might be a few customers which have the same appointment date.

Please do advise on my code.

Code: [Select]
<?php

include 'cogfig.php'; #here store all my connection

$sql = "select email from user where appointment_date <= CURRENT_DATE and appointment_date >= ( CURRENT_DATE - INTERVAL 1 day )";

while (mysql_fetch_array($results)) {

    if ($query) {
        $to = 
        $subject = "Appointment Reminder";
        $message = "Dear Customer \n\n" .
                "We would like to inform you that your appointment is tomorrow. \n" .
                "Your Sincerely\n" .
                "Admin";
        $from = "abc@def.com";
        $headers = "From: $from";
        $sentMail = mail($to, $subject, $message, $headers);

        if ($sentMail) {
            $statusMessage = "Appointment Reminder Successfully Sent. \n";
        } else {
            $statusMessage = "Appointment Reminder Unsuccessfully Sent";
        }
    }
}
?>

I'm trying to get my php form to send a simple auto responder to the persons email that submitted the form. Something like "Thanks we received your info". I don't know how to integrate that into my existing script. Below are the configurable parts of the php. The form works perfectly ... just want to add the auto respond function. Thanks!
_________________________________________________ _________________________________________________ _____


<?php

$d = date("m-d-y H:i:s");



/*  *************  Begin Configuration  *************  */
$relocate = "http://www.xxxxx.com/";   // insert your relocation url here
$home = "http://www.xxxxx.com/";
$MOVE_TO_PATH = '/home/content/xxxxx/html/FileUpload/';
$PATH_TO_DIR = 'http://www.xxxxx.com/FileUpload/';



$sender_name = "Order";
$sender_email = "me@xxxxx.com";
$mailheaders = "Content-Type: text/plain; charset=us-ascii\nFrom: $sender_name <$sender_email>\nReply-To: <$sender_email>\nReturn-Path: <$sender_email>\nX-Mailer: PHP";




//$to = "me@xxxxx.com";
$to = "me@xxxxx.com";
$subject = "Order";


$success_block = "<p>Thank you for submitting your information. We will review your information and get back to you within a day or two.</p><br><br>";

/*  *************  End Configuration  *************  */


// mail
if ($send != "false") {
  mail($to, $subject, $msg, $mailheaders);   // mail sent to admin
  header("Location: $relocate");
}
?>

Code: [Select]
        $IP = $_SERVER['REMOTE_ADDR'];
        $DATE = date("Y-m-d");
        $TIME = date("H:i:s");
$NameOfSender = "BLABLABLABALLA";


$email = $fieldnm_3; // use their addy instead of yours
$subject = 'ikwerkthuis.be inloggegevens introductie film'; // change subject
$text = 'Beste  $NameOfSender,

Welkom bij ikwerkthuis.be.
Hieronder vind U de logingevens voor het bekijken van de introductiefilm:

Adres:            http://ikwerkthuis.be/index.php/introductie
Gebruikersnaam:   introductie
Paswoord:         film2012

%DataOfForm%

Wij nemen spoedig contact met u op.

Met vriendelijke groeten,
Het ikwerkthuis.be team

IP: $IP
Date: $Date
Time: $Time'; // change text

mail($email, $subject, $text, 'From: '.$emailadd.''); // send another one out


header("Location:$success_page_name");

}
?>

I have an auto responder in a php order form with the phrase "Our web sites uses a secure order form for customers to purchase products, and services..."  When the message is sent, the word 'services'  comes out like this: "...products, and 1s."  Each instance of the word 'services' is changed to '1s'. Any ideas?

i wanting users to be able to update there email address and check to see if the new email already exists. if the email is the same as current email ignore the check.
i have no errors showing up but if I enter a email already in the db it still accepts the new email instead of bringing the back the error message.
Code: [Select]
// email enterd from form //
$email=$_POST['email'];


$queryuser=mysql_query("SELECT * FROM members WHERE inv='$ivn' ") or die (mysql_error());
 while($info = mysql_fetch_array( $queryuser )) {
  $check=$info['email'];
 // gets current email //
}


if($check!=$email){
// if check not equal to $email check the new email address already exists//
$queryuser=mysql_query("SELECT * FROM members WHERE email='$email' ");
//$result=mysql_query($sql);
$checkuser=mysql_num_rows($queryuser);
if($checkuser != 0)
{
$error= "0";
header('LOCATION:../pages/myprofile.php?id='.$error.'');


}
}

cheers

//php code
<?php
include_once('con.php');
if(!empty($_GET['search'])) {
$search = $connect->prepare('SELECT * FROM posts WHERE title LIKE :search');
$search->bindValue(':search', '%'.$_GET['search'].'%', PDO::PARAM_STR);
$search->execute();
?>
<?php
while($row = $search->fetch()) {?>
<li class="result" onClick="searchValue('<?php echo $row['title'];?>')"><?php echo $row['title'];?></li>    
<?php } ?>
<?php } ?>

//ajax

$('#inputsch').keyup(function(){
	$.ajax({
	type: 'GET',
	url: 'fetch.php',
	data:'search='+$(this).val(),
	success: function(data){
		$('#box').show();
		$('#box').html(data);
	}
	});
}); 
});
function searchValue(val) {
$('#inputsch').val(val);
$('#box').hide();
}


//search box

 <form action="search.php">
 <input id="inputsch" type="text" name="search" placeholder="search..." autocomplete="off" autofocus>
 <button type="submit" value="search" >search</button> 
 </form>
 <div id="box"></div>


//the problem here is when i click the result is only added to input, but i want it to autosubmit

 

So a project I have simply to learn how it is done is to make an auto updating sitemap with a auto submitter. I have been doing a little research on sitemaps but haven't found much in the way of a tutorial or white paper or similar, anyway I was wondering if I am on the right track or not.

What I was thinking for the auto-updating sitemap is since site maps are XML, when an article is published using my custom CMS/Blogging system, I make it rewrite the sitemap appending the new URL that will be generated.

Then for the auto-submit, I can either make it a cron job or just manual press, but it would go though a for list of URLs, replacing the end part with my site map url. I think that is how it would be done.

If you have a better idea, or can point out an article so I can understand a lot more with sitemaps, I will appreciate it, I am trying to learn as much as possible, I have gone to the offical website (sitemaps.org) but it doesn't have what I am looking for.

Thanks,

James

When I submit the login form its not returning anything and it was working until I added in the $remember part so I'm wondering why its still not returning TRUE.

Code: [Select]
/**
* Login user on the site. Return TRUE if login is successful
* (user exists and activated, password is correct), otherwise FALSE.
*
* @param string
* @param string
* @param int
* @return bool
*/
    function login($username, $password, $remember)
    {   
        $this->ci->load->model('kow_auth/users');
        $user_data = $this->ci->users->get_user_by_username($username);
       
        if ($user_data)
        {
            $regenFromPostPW = $this->ci->genfunc->reGenPassHash($password, $user_data->password2);
            if ($regenFromPostPW == $user_data->password)
            {
                $this->ci->session->set_userdata(array(
                                'xtr'       => 'yes',
'user_id' => $user_data->user_id,
'username' => $user_data->username,
'status' => $user_data->users_statuses_id,
                                'role'  => $user_data->users_roles_id
));
                if ($remember == 1)
                {
                    $timeTOexpire = time()+(60*60*24*31*2);
                    $this->input->set_cookie('xtrcook', '1', $timeTOexpire);
                }
                else
                {
                    $cookie = trim(get_cookie('xtrcook'));
                    if ($cookie || is_numeric($cookie))
                    {
                        delete_cookie('xtrcook');
                    }
                }
                $this->clear_login_attempts($user_data->user_id);
                $this->ci->users->insert_session($this->ci->session->userdata('session_id'), $this->ci->session->userdata('user_id'), $this->ci->genfunc->getRealIpAddr(), $this->ci->genfunc->getUserOS());
                return TRUE;
            }
            else
            {
                $this->increase_login_attempt($user_data->user_id);
            }
        }
        else
        {
            return NULL;
        }   
    }

I send off this:


<?php
$data = "<egateway>
<eCardExpiryMonth>01</eCardExpiryMonth>
<eCardExpiryYear>04</eCardExpiryYear>
<eCardHoldersName>Joe Bloke</eCardHoldersName>
<eCardNumber>4444333322221111</eCardNumber>
<eCVN>123</eCVN>
<eTotalAmount>100</eTotalAmount>
</egateway>
";
$ch = curl_init();
curl_setopt($ch, CURLOPT_POSTFIELDS, $edata);
curl_setopt($ch, CURLOPT_URL, "https://www.example.com/gateway_cvn/testpage.asp");
curl_exec($ch);
curl_close($ch);
?>


In return, I get the following XML:

Code: [Select]
<eResponse>
<eTrxnStatus>True</eTrxnStatus>
<eTrxnNumber>20219</eTrxnNumber>
<eAuthCode>123456</eAuthCode>
<eReturnAmount>100</eReturnAmount>
<eTrxnError>00,Transaction Approved(Test CVN Gateway)</eTrxnError>
</eResponse>

Is there a way to make it so this does not show, and instead I can make PHP do something like:

if (eTrxnStatus == True) {// do stuff};

?

Hello,

I'm trying to get webservice response in xml format. I'm getting the response but it's not in xml. It's just text.

Can someone please look at the code ?

<?php

$targeturl="https://api.com";

$DevKey= "xxxxx";

// return xml feed

$ch = curl_init($targeturl);
curl_setopt($ch, CURLOPT_POST, FAlSE);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Authorization: '.$DevKey));
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$response = curl_exec($ch);
$xml = new SimpleXMLElement($response);
curl_close($ch);
echo $response; // will print in browser all country codes in an xml format

/*

ADD YOUR OWN CODE HERE TO DO WHAT YOU WANT WITH THE RESPONSE.  MAYBE SAVE RESULTS TO A FILE OR THE PARSE THE RESULTS INTO A DATABASE?

*/

?> 

Hello All,

Just working with PHP's snap v1 functions I can use snmpget fine but snmpset produces the following error;

Warning: snmpset() [function.snmpset]: No response from 192.....

Code

Code: [Select]
<?PHP

echo 'File started <br />';

$ip = '192.168.1.100';
echo 'Read:<br />';
      $sysdescr = snmpget($ip, 'public', '.1.3.6.1.4.1.17095.3.4.0', 300);

   
   echo $sysdescr;
   echo 'Write Started:<br />';
   snmpset("$ip", 'public', '.1.3.6.1.4.1.17095.4.7.2.0', 's', 'sam@samtwilliams.co.uk', 300);

?>
Like i said the get works fine just the set does not.

Does anyone have any ideas?

Sam

Folks,

I have a mysql tbl called "links".

In it a column named "keywords".

The row 0 has a keyword "search" in the "keywords" column.

I am doing a search for the words "search" in the html form. Clicking the button gives no response! What is wrong ?

I get no mysql connection error. Nor any php error. So it should work and respond!

	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	

 

Full short code ...

	<?php
//include('error_reporting.php');
ini_set('error_reporting','E_ALL');//Same as: error_reporting(E_ALL);
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
?>
	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['search_links']))
    {
        if(ISSET($_POST['keywords']))
        {
            $keywords = $_POST['keywords'];
        }        
        
        mysqli_report(MYSQLI_REPORT_ALL|MYSQLI_REPORT_STRICT);
        mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
        
        $conn = mysqli_connect("localhost","root","","test");
        $db_server = 'localhost';
        $db_user = 'root';
        $db_password = '';
        $db_database = 'test';
        $conn->set_charset('utf8mb4');//Always use Charset.
        
        if (!$conn)
        {
            //Error Message to show user in technical/development mode to see errors.
            die("Database Error : " . mysqli_error($conn));
            
            //Error Message to show User in Layman's mode to see errors.
            die("Database error.");
            exit();
        }
	        $query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE keywords = ?";
	        $stmt = mysqli_stmt_init($conn);
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
	            $result = mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            mysqli_stmt_execute($stmt);
            
            mysqli_stmt_fetch($stmt);
            
            while(mysqli_stmt_fetch($result))
            {
                echo "url"; echo "<br>";
                echo "anchor_text"; echo "<br>";
                echo "description"; echo "<br>";
                echo "keyphrases"; echo "<br>";
                echo "keywords"; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            echo "1. QUERY failed!";
        }
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
            mysqli_stmt_execute($stmt);
            
            $result = mysqli_stmt_get_result($stmt);
            
            while($row = mysqli_fetch_array($result,mysqli_assoc))
            {
                $page_url = $row['page_url']; echo $page_url; echo "<br>";
                $link_anchor_text = $row['link_anchor_text']; echo $link_anchor_text; echo "<br>";
                $page_description = $row['page_description']; echo $page_description; echo "<br>";
                $keyphrases = $row['keyphrases']; echo $keyphrases; echo "<br>";
                $keywords = $row['keywords']; echo $keywords; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("2. QUERY failed!");
        }
    }
}
	
?>
	

How can I receive a response from the server with JSON data, when the function that retrieves the data and returns it to the browser has been completely commented out? 

I am making an AJAX request for JSON formatted data and for some reason it returns a response when it shouldn't as there is no function?