fork download 
  1. <?php
  2.  
  3. $age = 30;
  4. $dateFrom = '2016-01-01';
  5. $dateTo = '2016-08-31';
  6.  
  7. $query = sprintf("SELECT name, timestamp FROM people WHERE age = %d AND timestamp >= '%s' AND timestamp < '%s';", $age, $dateFrom, $dateTo);
  8.  
  9. echo $query;
Success #stdin #stdout 0.01s 52488KB
comments (?)
stdin 
Standard input is empty
stdout 
SELECT name, timestamp FROM people WHERE age = 30 AND timestamp >= '2016-01-01' AND timestamp < '2016-08-31';
https://ideone.com/8uWe6R
language:
PHP (php 7.3.5)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!