Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

2662039Apr 28 2014 — edited Apr 29 2014

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?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 27 2014
Added on Apr 28 2014
#oracle, #php, #sql
1 comment
1,907 views