How to get date from html form through php to show table from oracle sql

2662039

I have a form method post.Also an input date like input date (html 5,the one that picks the date from a window below)

I want to take the date the user inputs and use it in a php which contains a contains a select statement that is like that $stid = DBExecute($conn, "select customer_name,product_name,order_date,quantity and ends like this.. and order_date>='".$_POST['date']."'");

Then i have echo "<table....

And while ($row = oci_fetch_array($stid, OCI_ASSOC)) {......

But I have a problem on that. No results shown. Why?

Does anybody know to help me?

What value the date input gives in HTML5 and in which format? How can i fix that?

Christopher Jones-Oracle

There's not enough info posted to help.  Do some googling.  Do some debugging - add some 'var_dump' calls in PHP to check everything

e.g. var_dump($_POST);

And never, ever, ever do concatenation like you do with $_POST to build up a query string.  This is a major "SQL Injection" security risk.

instead, use an OCI8 bind variable.  See PHP: OCI8 - Manual