forum.lissyara.su

Код: Выделить всё

      ...
      my $lip = "10.0.0.1";
      my $query = "SELECT id FROM localips WHERE ip = INET_ATON('".$lip."')";
      print $query."\n";
      my $sqlsi = $dbh->prepare($query);
      $sqlsi->execute() or warn "Can't find record for '$lip'\n";
      ...

Код: Выделить всё

       SELECT id FROM localips WHERE ip = INET_ATON('10.0.0.1')
       DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1))' at line 1 at ./test.pl line 52.

Код: Выделить всё

my $sqlsi = $dbh->prepare('SELECT id FROM localips WHERE ip = INET_ATON(?)');
$sqlsi->execute($lip);

Код: Выделить всё

  my $query = 'SELECT id FROM localips WHERE ip = '.$lip;
      my $sqlsi = $dbh->selectrow_array($query);
print $sqlsi;

Код: Выделить всё

INET_ATON('".$lip."')";