Error in SQL like

Question

I’m trying to make a select where I want all the data of a person who has the same ip and date equal to today’s date. The reason is that I need to restrict as many times as a person sends contact to my system.

below my code.

        $ip = $_SERVER['REMOTE_ADDR'];
        $data = date('Y-m-d');
$row = mysql_query("SELECT * FROM tbl_CONTATOS where TXT_ENDIP_CONTT = '.$ip.'  and DAT_INCLU_CONTT like '%".$data."%' ");
        $count = mysql_num_rows($row);

         echo $count; die;

Answer 1

The error is not in the like, but in the concatenation of the variable $ip

Since the variable is already inside a string with double quotes vc was trying to concatenate with single quotes.

Below is an example of how it should look:

    $ip = $_SERVER['REMOTE_ADDR'];
    $data = date('Y-m-d');
    $row = mysql_query("SELECT * FROM tbl_CONTATOS where TXT_ENDIP_CONTT = '$ip'  and DAT_INCLU_CONTT like '%".$data."%' ");
    $count = mysql_num_rows($row);

     echo $count; die;

Answer 2

Concatenating your string is wrong. Maybe this is your error.

Substitute:

$row = mysql_query("SELECT * FROM tbl_CONTATOS where TXT_ENDIP_CONTT = '.$ip.'  and DAT_INCLU_CONTT like '%".$data."%' ");

For:

$row = mysql_query("SELECT * FROM tbl_CONTATOS where TXT_ENDIP_CONTT = '{$ip}' and DAT_INCLU_CONTT like '%{$data}%'");

I take the opportunity and recommend reading and learning about PDO.

Answer 3

You don’t need the LIKE. You want something like

$db = new PDO('mysql:host=localhost dbname=teste', 'usuario', 'senha');
$query = "SELECT * FROM tbl_CONTATOS where TXT_ENDIP_CONTT = ? and DAT_INCLU_CONTT = ?";
$stmt = $db->prepare($query);
$stmt->bindValue(1, $_SERVER['REMOTE_ADDR']);
$stmt->bindValue(2, date('Y-m-d'));
$result = $stmt->execute();
$count = $result->rowCount();

echo $count; die;

Answer 4

But your date field in the database is type STRING or DATE?

I have worked with banks that did not accept to compare DATE using LIKE.