<? session_start();
$sendAfter = (10)*(60); // in seconds
$sendEmail = false;
$now = date('Y-m-d H:i:s');
if(!isset($_SESSION['sent_time'])) // if you are first time send email
{
$sendMail = true;
$_SESSION['sent_time'] = $now;
}
else
{
$diff = strtotime($now) - strtotime($_SESSION['sent_time']);
if($diff >= $sendAfter)// if difference is more than 10 min then only send mail
{
$sendMail = true;
$_SESSION['sent_time'] = $now;
}
}
if($sendMail)
echo "mail sending code here";
else
echo "nothing to do";
?>
Generally if form post some data on any page, better you do all db related operations or other php coding at top of page and then redirect user to some page using header.
header('Location:index.php');
without header you may face problem. e.g. if user POST data and you have insert query in database and if you won't have header then each time user press refresh there will be record inserted in database every time.
Hope ID is auto increamented and primary field. When you insert new record then its id is greater than prev. thus if you search all results with one date and see MAX(ID), it returns last inserted row for that date.
Ohhh... you have same code 6 times..Is this code by you? for debugging echo sql query and run it directly in database and check if you are getting desired result.
echo $sql="SELECT * from generators WHERE convert(datetime,convert(char(10),TIMESTOMPX,101))= '$search'";
exit;
Oh.. i forget you already posted html code on first post.. Can you try below one.. Use any static date which is there in database and post output..
<?php
require_once('../config/lang/eng.php');
require_once('../tcpdf.php');
// extend TCPF with custom functions
class MYPDF extends TCPDF {
public function myconnection(){
$this->con = mysql_connect("localhost","root","");
mysql_select_db("bank", $this->con);
$date = '2011-08-11'; // use any date which is there in database
$this->result = mysql_query("SELECT * FROM transaction WHERE transaction_date = '".$date."' ORDER BY tran_id") or die( '<strong>Error: </strong>'. mysql_errno().':'.mysql_error());
<script language = "Javascript">
function isValidNumber(str)
{
var tomatch= /^[0-9]{10}$/
if(tomatch.test(str))
return true;
else
return false;
}
function Validate()
{
function validateEmail(f){
if(isEmail(f.email.value)==false)
{
alert('Please enter a valid email address');
f.email.select();
return false;
}
return true;
}
function isEmail(string){
if(string.search(/^\w+((-\w+)|(\.\w+))*\@[A-Za-z-0-9]+((\.|-)[A-Za-z-0-9]+)*\.[A-Za-z-0-9]+$/)!=-1)
return true;
else
return false;
}
if (document.form1.first_name.value == '')
{
alert('Please fill in your first name!');
return false;
}
if(!document.form1.first_name.value.match(/^[a-zA-Z]+$/)){
alert('Please enter only string values!');
return false;
}
if (document.form1.last_name.value == '')
{
alert('Please fill in your last name!');
return false;
}
if(!document.form1.last_name.value.match(/^[a-zA-Z]+$/)){
alert('Please enter only string values!');
return false;
}
if (isEmail(document.form1.email.value) == '')
{
alert('Please enter a valid email address!');
return false;
}
if (document.form1.phone_number.value == '')
{
alert('Please fill in phone number!');
return false;
}
else
{
if(!isValidNumber(document.form1.phone_number.value))
{
alert('Please enter only numbers');
return false;
}
}
if (document.form1.user_type.value == '')
{
alert('Please fill in your user type!');
return false;
}
if (document.form1.username.value == '')
{
alert('Please fill in your desired username!');
return false;
}
if (document.form1.password.value == '')
{
alert('Please fill in your desired password!');
return false;
}
if (document.form1.confirm_password.value == '')
{
alert('Please fill in your password again for confirmation!');
return false;
}
if (document.form1.password.value !=
document.form1.confirm_password.value)
{
alert("The two passwords are not identical! "+
"Please enter the same password again for confirmation");
return false;
}
return true;
}
</script>
I have made this code in past. Hope this will help you.Add it in your code and echo query you will understand it. You can change upto your requirement.
<?
function searchString($str,$matchAr)
{
$out = '';
$str = preg_replace('/\s\s+/', ' ', $str);
$temp = explode(' ',$str);
foreach($matchAr as $match)
{
$out.="(";
foreach($temp as $value)
{
$out.="$match LIKE '%$value%' AND ";
}
$out = substr($out,0,-4);
$out.=") OR ";
}
return substr($out,0,-4);
}
$where.=" AND (".searchString($key,array('title','name')).")";
// if user type aaa , it will match with title field and name field
// if user type aaa bbb , it will check search must contain aaa bbb both. Either in title or name.
echo $sql = "select * FROM tbl_name WHERE $where ";
?>
Ajax is used for the case: - Once php page is loaded. - Then we want any php stuff like database insert,update,delete,select query or any php coding without again refreshing page. - so here we use ajax, so end user wont realize that some thing happen on server side. - The code i have given is using jquery. Jquery is JS library, using which we can do all stuff of javascript more easily and min line of coding. Jquery have thousands of function e.h. you have used innerHTML, jquery have http://api.jquery.com/html/.
That is called ajax. and case 2 in my above post. Hope you have some idea what AJAX is.
<script language="javascript" src="http://code.jquery.com/jquery-1.6.1.min.js"></script>
<script language="javascript">
function change()
{
$.ajax({ // this function will send php request in back so no need to refresh page
type: "POST",
url: "ajax.php", // in ajax.php check requested flexi variable passed from below line and write update query.
data: "flexi=flexi1",
success: function(msg){
// change html portion
}
});
}
// same for flexi2
</script>
<?
if(isset($_POST['alloc1']))
{
$query = 'UPDATE flexi SET allocation = "allocated", user = "'.$_SESSION["username"].'" WHERE flexi="flexi1"';
$result = mysql_query($query);
$result = $_SESSION['allocate'];
header("location:page.php");// page.php is the page where you want to redirect after success update
exit;
}
if(isset($_POST['alloc2']))
{
$query = 'UPDATE flexi SET allocation = "allocated", user = "'.$_SESSION["username"].'" WHERE flexi="flexi2"';
$result = mysql_query($query);
$result = $_SESSION['allocate'];
header("location:page.php");// page.php is the page where you want to redirect after success update
exit;
}
?>
// this should be in form
<input type='button' style='float:right' name="alloc1" value='Allocate'>
<input type='button' style='float:right' name="alloc2" value='Allocate'>
$query1 = 'UPDATE flexi SET allocation = "allocated", user = "'.$_SESSION["username"].'" WHERE flexi="flexi1"';
$result1 = mysql_query($query1);
$result1 = $_SESSION['allocate'];
$query2 = 'UPDATE flexi SET allocation = "allocated", user = "'.$_SESSION["username"].'" WHERE flexi="flexi2"';
$result2 = mysql_query($query2);
$result2 = $_SESSION['alloc'];
That means each time page is refreshed sql query will update record.
You can do it by 2 way. 1) server side Use submit button. When user click on submit button page will be posted and top php code will update record. Top php code will be in if condition. e.g.
