Jump to content

Archived

This topic is now archived and is closed to further replies.

hitesh_here

problem in PHP-MYSQL

Recommended Posts

Hello friends ,

I am develpoing a form to generate a report in a library about the books that are issued and within a particular time period

this is a bit of html code i m using
[code]
           <form action="issued_books.php" method="POST">
           <select name="year" id="year" >
           <option>1998</option>
           <option>1999</option>
           <option>2000</option>
           <option>2001</option>
           <option>2002</option>
           <option>2003</option>
           <option>2004</option>
           <option>2005</option>
           <option>2006</option>
           <option>2007</option>
           </select>
           <input type="text" name="month" size=2 maxlength="2" />
           <input type="text" name="day" size=2 maxlength="2" />
  
           <input type="submit" value="submit" name="submit" />
           </form>
[/code]
in PHP handler there is a code
[code]<?php
      $year = $_POST['year'];
      echo "$year";
      $month = $_POST['month'];
      echo "$month";
      $day = $_POST['day'];
      echo "$day";
?>[/code]

the output for the variable day which i am getting is
230 even when i have input the value 23

I am using EasyPHP in Windows XP

second problem is how to use this date information to compare with the date value in a mysql table.
Thanks for reading my problem and thanks in advance for the solutions.

[b]EDIT BY OBER: PLEASE USE CODE TAGS WHEN POSTING CODE[/b]

Share this post


Link to post
Share on other sites
Well, first of all, your code can be reduced:
[code]<? php
      $year = $_POST['year'];
      echo "$year";
      $month = $_POST['month'];
      echo "$month";
      $day = $_POST['day'];
      echo "$day";
?>[/code]

Can be:
[code]<? php
      extract($_POST);
      echo "$year<br/>";
      echo "$month<br/>";
      echo "$day<br/>";
?>[/code]

Secondly, are you absolutely sure that's what the output is? The way you echoed your variables, they would have ended up right beside each other. With the breaks in there, it should print out each on it's own line. Also, if you're just echoing the variable with no other HTML, you don't need the double quotes around it.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.