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
https://forums.phpfreaks.com/topic/6165-problem-in-php-mysql/
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
https://forums.phpfreaks.com/topic/6165-problem-in-php-mysql/#findComment-22274
Share on other sites

Archived

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

×
×
  • 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.