Jump to content

problem in PHP-MYSQL


hitesh_here

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]
Link to comment
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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.