0

hi ,
i got an error.pls help me to correct.
my code is

<form action="return.php" method="post">
                    <table width="200" border="0">
                      <tr>
                        <td><h3 align="center">RETURN</h3></td>
                      </tr>
                    </table>
                    <p align="center">&nbsp;</p>
                 <table width="41%" height="254" border="0">
                   <tbody>
                       <tr>
                         <td width="34%">Author:</td>
                         <td width="66%"><p>
                           <input type="text" name="author1" />
                         </p></td>
                       </tr>
                       <tr>
                         <td>Title:</td>
                         <td><p>
                           <input type="text" name="title1" />
                         </p></td>
                       </tr>
                       <tr>
                         <td>Accession No:</td>
                         <td><p>
                           <input type="text" name="accessno1" />
                         </p></td>
                       </tr>
                       <tr>
                         <td>Name:</td>
                         <td><p>
                           <input type="text" name="name1" />
                         </p></td>
                       </tr>
                       <tr>
                         <td>Register No:</td>
                         <td><p>
                           <input type="text" name="regno1" />
                         </p></td>
                       </tr>
                       <tr>
                         <td>Issue Date:</td>
                         
                         <td><p>
                           <label for="select"></label>
                           <select name="sdate1" id="select">
                             <option>date</option>
                             <option>1</option>
                             <option>2</option>
                             <option>3</option>
                             <option>4</option>
                             <option>5</option>
                             <option>6</option>
                             <option>7</option>
                             <option>8</option>
                             <option>9</option>
                             <option>10</option>
                             <option>11</option>
                             <option>12</option>
                             <option>13</option>
                             <option>14</option>
                             <option>15</option>
                             <option>16</option>
                             <option>17</option>
                             <option>18</option>
                             <option>19</option>
                             <option>20</option>
                             <option>21</option>
                             <option>22</option>
                             <option>23</option>
                             <option>24</option>
                             <option>25</option>
                             <option>26</option>
                             <option>27</option>
                             <option>28</option>
                             <option>29</option>
                             <option>30</option>
                             <option>31</option>
                           </select>
                           <label for="select2"></label>
                           <select name="sdate1" id="select2">
                             <option>month</option>
                             <option>1</option>
                             <option>2</option>
                             <option>3</option>
                             <option>4</option>
                             <option>5</option>
                             <option>6</option>
                             <option>7</option>
                             <option>8</option>
                             <option>9</option>
                             <option>10</option>
                             <option>11</option>
                             <option>12</option>
                           </select>
                           <label for="select3"></label>
                           <select name="sdate1" id="select3">
                             <option>year</option>
                             <option>2007</option>
                             <option>2008</option>
                             <option>2009</option>
                             <option>2010</option>
                             <option>2011</option>
                             <option>2012</option>
                             <option>2013</option>
                             <option>2014</option>
                             <option>2015</option>
                             <option>2016</option>
                           </select>
                         </p></td>
                       </tr>
                       <tr>
                         <td height="34">Due Date:</td>
                         <td><p>
                           <select name="ddate1" id="select4">
                           <option>date</option>
                            <option>1</option>
                          <option>2</option>
                          <option>3</option>
                          <option>4</option>
                          <option>5</option>
                          <option>6</option>
                          <option>7</option>
                          <option>8</option>
                          <option>9</option>
                          <option>10</option>
                          <option>11</option>
                          <option>12</option>
                          <option>13</option>
                          <option>14</option>
                          <option>15</option>
                          <option>16</option>
                          <option>17</option>
                          <option>18</option>
                          <option>19</option>
                          <option>20</option>
                          <option>21</option>
                          <option>22</option>
                          <option>23</option>
                          <option>24</option>
                          <option>25</option>
                          <option>26</option>
                          <option>27</option>
                          <option>28</option>
                          <option>29</option>
                          <option>30</option>
                          <option>31</option>
                           </select>
                           <label for="select5"></label>
                           <select name="ddate1" id="select5">
                           <option>month</option>
                            <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                        <option>10</option>
                        <option>11</option>
                        <option>12</option>
                           </select>
                           <label for="select6"></label>
                           <select name="ddate1" id="select6">
                              <option>year</option>
                        <option>2007</option>
                        <option>2008</option>
                        <option>2009</option>
                        <option>2010</option>
                        <option>2011</option>
                        <option>2012</option>
                        <option>2013</option>
                        <option>2014</option>
                        <option>2015</option>
                        <option>2016</option>
                           </select>
                         </p></td>
                       </tr>
                     </tbody>
                   </table>
                
                 <p>&nbsp;</p>
<table width="200" border="0">
            <tr>
              <td>
                <div align="center">
                    <input type="submit" name="button2" id="button2" value="Return" />
                  <input type="reset" name="Reset" id="button" value="Clear" />
                  <input name="bk" value="Back" onClick="javascript:window.history.go(-1)" type="button"> 
                </div>
                         
                <div align="center"></div>
          </td>
            </tr>
            </table>
            </td>

           
          </form>

my php code is

<?php
			
$author1 = $_POST['author1'];
$title1 = $_POST['title1'];
$accessno1=$_POST['accessno1'];
$name1=$_POST['name1'];
$regno1=$_POST['regno1'];
$sdate1=$_POST['sdate1'];
$ddate1=$_POST['ddate1'];
$con = mysql_connect("localhost");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  } 
mysql_select_db("test", $con);
$rs=mysql_query("select * from issue where title='$title1'");
$count=mysql_num_rows($rs);
if($count>0)
{ 
$sql="INSERT INTO return (author1,title1,accessno1,name1,regno1,sdate1,ddate1) VALUES('$author1','$title1','$accessno1','$name1','$regno1','$sdate1','$ddate1')";
mysql_query($sql) or die(mysql_error());
echo "<script ='javascript'type='text/javascript'>
alert('book returned')
</script>";
}

mysql_close($con)
?>

also i have a problem in date in the database..it is displayin like 00-00-0000..how can i recover from this problem

3
Contributors
10
Replies
12
Views
6 Years
Discussion Span
Last Post by karthik_ppts
Featured Replies
  • 1
    cereal 1,524   6 Years Ago

    And also your table name, [b]return[/b], is a reserved word, check this: [url]http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html[/url] Use backticks if you want to use it: [code]"insert into `return` ..."[/code] bye :) Read More

  • change your select box name as day, select2 name as month, and select3 name as year and replace your line 8 of php code as [CODE]$sdate1=$_POST['year']."-".;$_POST['month']."-".[$_POST['day'][/CODE]. Do the same for other date too. Read More

0

replace your line 20 oh php as

echo $sql="INSERT INTO return (author1,title1,accessno1,name1,regno1,sdate1,ddate1) VALUES('$author1','$title1','$accessno1','$name1','$regno1','$sdate1','$ddate1')";

copy the printed query and execute it in the sql section of your phpmyadmin ans see what happens.

Edited by karthik_ppts: n/a

0

thankuu...i got the correct answer...also i hav 1 doubt.in database date is displayin like 00-00-0000.

1

change your select box name as day, select2 name as month, and select3 name as year and replace your line 8 of php code as

$sdate1=$_POST['year']."-".;$_POST['month']."-".[$_POST['day']

.

Do the same for other date too.

Edited by karthik_ppts: n/a

0

after entering the data ,some errors are found.
like

Notice: Undefined index: year in C:\xampp\htdocs\project\return.php on line 16

Notice: Undefined index: month in C:\xampp\htdocs\project\return.php on line 16

Notice: Undefined index: day in C:\xampp\htdocs\project\return.php on line 16

Notice: Undefined index: year in C:\xampp\htdocs\project\return.php on line 17

Notice: Undefined index: month in C:\xampp\htdocs\project\return.php on line 17

Notice: Undefined index: day in C:\xampp\htdocs\project\return.php on line 17
can u clear this problem as soon as possible

0
11 $author1 = $_POST['author1'];
12 $title1 = $_POST['title1'];
13 $accessno1=$_POST['accessno1'];
14 $name1=$_POST['name1'];
15 $regno1=$_POST['regno1'];
16 $sdate1=$_POST['year']."-".$_POST['month']."-".$_POST['day'];
17 $ddate1=$_POST['year']."-".$_POST['month']."-".$_POST['day'];

Edited by sibymary: n/a

0

Read what Karthik suggested to you. This happens because you're sending the same name field for day, month and year. An example, change names of select fields with these:

sdate1day
sdate1month
sdate1year
ddate1day
ddate1month
ddate1year

Change also the lines n.16 and 17, so they will be:

$sdate1=$_POST['sdate1year']."-".$_POST['sdate1month']."-".$_POST['sdate1day'];
$ddate1=$_POST['ddate1year']."-".$_POST['ddate1month']."-".$_POST['ddate1day'];

Edited by cereal: n/a

0

I have done what u told. But in db, again date is like 0000-00-00......I want to change it to what I’m inserting from form into the database like 2005-3-12

0

datetime column? Use strtotime():

<?php
$year = '2011';
$month = '9';
$day = '21';
echo date('Y-m-d',strtotime($year.'-'.$month.'-'.$day));
?>

In your case will be:

$sdate1 = date('Y-m-d',strtotime($_POST['sdate1year']."-".$_POST['sdate1month']."-".$_POST['sdate1day']));

bye :)

Edited by cereal: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.