Check if date is in database and is greater than

Question

I have date type input on my site. I want to check if selected date is in the database and also is greater than for example 2017-01-01. I have something like this. How to do that?

if(ISSET($_POST['receipt_date'])) {
    $receipt_code=$_POST['receipt_date'];

    $checkdata="SELECT receipt_date FROM receipts WHERE receipt_code='$receipt_code' ";

    $query=mysql_query($checkdata);

    if(mysql_num_rows($query)>0) {
        echo "exist";
    } else {
        echo "ok";
    }
    exit();
}

It would be very helpful if we'd have an idea of the contents of `$_POST['receipt_date']` and the datatype of receipt_date in your database. — Niellles, Nov 23 '17 at 11:09
html input is date type and in database i have datetime field... — MMPL1, Nov 23 '17 at 11:15
Comment 1: *"It's date type.(YYY-MM-DD)"* - Comment 2: *"and in database i have datetime field"* - So, which one is it? — Funk Forty Niner, Nov 23 '17 at 11:25

Weenesta - Mathieu Dormeval · Answer 1 · 2017-11-23T11:44:08.360

0

Check this snippet :

<?php 
$link_to_db = mysqli_connect('localhost', 'my_user', 'my_password', 'my_db');

if(isset($_POST['receipt_date'])) 
{
    $receipt_date = $_POST['receipt_date'];
    $recept_datetime = new Datetime($receipt_date); # use \ before it if you using namespaces

    $check_data = "SELECT receipt_date FROM receipts WHERE receipt_date = '".$recept_datetime->format('Y-m-d H:i:s')."'";

    $query = mysqli_query($link_to_db, $checkdata); # use mysqli instead of mysql functions

    if(mysqli_num_rows($query) == 0) {
        echo "ok";
    }

    $check_datetime = new Datetime('2017-01-01 00:00:00');

    # work only on php > 5.2.2
    if ($receipt_datetime > $check_datetime) {
        echo "check OK";
    }
 }
 ?>

Hope this helps !

edited Nov 23 '17 at 11:44

answered Nov 23 '17 at 11:26

Weenesta - Mathieu Dormeval

927
7
20

double check this, it's incorrect – Funk Forty Niner Nov 23 '17 at 11:27
Checked, my mistake ! – Weenesta - Mathieu Dormeval Nov 23 '17 at 11:29
my previous code working, I have html mistakes but thanks anyway! – MMPL1 Nov 23 '17 at 11:37
1

@MathieuDormeval OP is using mysql_ and you provided a mysqli_ version. The query method requires a db connection. – Funk Forty Niner Nov 23 '17 at 11:38
Answer corrected... – Weenesta - Mathieu Dormeval Nov 23 '17 at 11:44

Check if date is in database and is greater than

1 Answers1