Register Shutdown Function
// capture the start time
$start_time = microtime(true);
// do some stuff
// ...
// display how long the script took
echo "execution took: ".
(microtime(true) - $start_time).
" seconds.";
// capture the start time$start_time = microtime(true);// do some stuff// ...// display how long the script tookecho "execution took: ". (microtime(true) - $start_time). " seconds.";Ajax retrieve data onchange input:
<script type="text/javascript">
$(document).ready(function () {
// if user chooses an option from the select box...
$("#cid").change(function () {
// get selected value from selectbox with id #department_list
var cusno = $(this).val();
$.ajax({
url: "functions/get_name.php",
data: "q=" + cusno,
dataType: "json",
// if successful
success: function (response, textStatus, jqXHR) {
// no teachers found -> an empty array was returned from the backend
if (response.customer_name.length == 0) {
$('#result').html("nothing found");
}
else {
// backend returned an array of names
var list = $("#list");
// remove items from previous searches from the result list
$('#list').empty();
// append each teachername to the list and wrap in <li>
$.each(response.customer_name, function (i, val) {
//list.append($("<li>" + val + "</li>"));
document.getElementById("cname").value=val;
});
}
}});
});
// if anywhere in our application happens an ajax error,this function will catch it
// and show an error message to the user
$(document).ajaxError(function (e, xhr, settings, exception) {
$("#error").html("<div class='alert alert-warning'> Uups, an error occurred.</div>");
});
});
</script>
Use of PHP group_concat
If you wants to display date wise records in a single row you need group_concat.
Table 1: customer table 2: customer_trasaction
customer_id id
customer_name customer_id
customer_city paid_date
paid_amount
Now we need to get all the customer details transaction in a month datewise in one row per customer
$query=mysql_query("Select customer.customer_id,customer.customer_name, group_concat(customer_transaction.paid_amount) from customer left join customer_transaction on customer.customer_id=customer_trasaction.customer_id group by customer.customer_id where customer_transaction.paid date between '2014-09-01' and '2014-09-30' ");
Mail send
<?php
$name=$_POST['name'];
$email=$_POST['email'];
$pattern = "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/i";
if (preg_match($pattern, trim(strip_tags($_POST['email']))))
{
$cleanedFrom = trim(strip_tags($_POST['email']));
} else
{
return "The email address you entered was invalid. Please try again!";
exit();
}
$contact=$_POST['contact'];
$domain=$_POST['domain'];
$skypeid=$_POST['skypeid'];
$message=$_POST['message'];
$res = $name;
$res .= $contact."\r\n";
$res .= $domain."\r\n";
$res .= $skypeid."\r\n";
$res .= $message."\r\n";
$from = $email."\r\n";
$subject="Enquiry";
$headers = "From: $from \r\n";
$header .= "MIME-Version: 1.0\r\n";
$header .= "Content-type: text/html\r\n";
$to="yourmail@domain.com";
if(mail($to, $subject, $res, $headers))
{
echo "<span id='messageBack'>Message successfully sent</span>";
} else{
echo "<span id='messageBack'>Your message wasn't sent. Please try again later.</span>";
}
?>