POST query from user input on button click

Question

This is what I'm trying to do. I let the user to input DATEFROM and DATETO. Then when the user click the button, it will execute a query to SELECT * from my table WHERE DATEFROM BETWEEN DATETO. I don't know what's wrong. Please help.

<html>
    <head></head>
    <body>
        <?php
        <form method="POST" action="">
        DATE FROM: <input type="date" name="datefrom"> TO: <input type="date" name="dateto"> <input type="submit" value="Extract excel file" name="extract"></input>
        </form>

        $datefrom = "datefrom";
        $dateto = "dateto";

        if(isset($_POST['extract'])){
            mysql_connect("localhost", "root");
            mysql_select_db("sample");

            $myquery = "SELECT * FROM biometrics WHERE date_created BETWEEN '" . $datefrom . "' AND '" . $dateto . "ORDER BY id_biometrics";


            $result = mysql_query($myquery);

            echo "<table border='1'>
            <tr>
                <th>ID</th>
                <th>Employee Number</th>
                <th>Date Created</th>
                <th>Time Created</th>
                <th>Status</th>
            </tr>";

            while($data = mysql_fetch_row($result))
            {
                echo("<tr>
                <td>$data[0]</td>
                <td>$data[1]</td>
                <td>$data[2]</td>
                <td>$data[3]</td>
                <td>$data[4]</td>
                </tr>");
            }

            echo "</table>";

        }

        ?>
    </body>
</html>

Kannan Rajendran · Accepted Answer · 2013-12-11 10:40:05Z

1

Why there is no password in this line.

mysql_connect("localhost", "root");

Hope the date_created column is in Date or Datetime format. It must not be a int or a varchar or any other thing.

And also add the quotes before ORDER BY.

   $myquery = "SELECT * FROM biometrics WHERE date_created BETWEEN '" . $datefrom . "' AND '" . $dateto . "' ORDER BY id_biometrics";

answered Dec 11, 2013 at 10:40

Kannan Rajendran

2201 silver badge17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nicole101 Over a year ago

because I don't have password in myphpadmin. about the date or datetime, I'll go check it out. thanks. :D

Kannan Rajendran Over a year ago

If you dont have a passowrd, just have it as null value. It must be mysql_connect("localhost", "root", "");

Ashok Maharjan · Accepted Answer · 2013-12-11 10:37:03Z

0

you have missed a quote(') in query ,try like this

if(isset($_POST['extract'])){
        mysql_connect("localhost", "root");
        mysql_select_db("sample");

          $datefrom = $_POST['datefrom'];
          $dateto = $_POST['dateto'];

        $myquery = "SELECT * FROM biometrics WHERE date_created BETWEEN '" . $datefrom . "' AND '" . $dateto . "' ORDER BY id_biometrics";


        $result = mysql_query($myquery);

hope this works for you

answered Dec 11, 2013 at 10:37

Ashok Maharjan

1631 silver badge7 bronze badges

1 Comment

nicole101 Over a year ago

IT WORKED!! THANK YOU SO MUCH. Now I have to extract it in csv file. thanks so much again. :D

iLaYa ツ · Accepted Answer · 2013-12-11 10:33:06Z

0

You missed ', it should be

"SELECT * 
       FROM biometrics 
       WHERE date_created 
       BETWEEN '" . $datefrom . "' AND '" . $dateto . "' ORDER BY id_biometrics";
                                                       ^
                                                       ^

answered Dec 11, 2013 at 10:33

iLaYa ツ

4,0173 gold badges34 silver badges51 bronze badges

Comments

Krish R · Accepted Answer · 2013-12-11 11:28:41Z

0

Can you try this, You need add space BEFORE ORDER BY

mysql_connect("localhost", "root", "");

$myquery = "SELECT * FROM biometrics WHERE date_created BETWEEN ('" . $datefrom . "' AND '" . $dateto . "') ORDER BY id_biometrics";

edited Dec 11, 2013 at 11:28

answered Dec 11, 2013 at 10:36

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Collectives™ on Stack Overflow

POST query from user input on button click

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related