Hi friend,
from morning onwards I am facing the problem with following php
script.
This script functionality as follows:
Getting the date from user and validating it.
I couldn't trace where the error is. Can anybody help me?
Any help greatly appreciable.
Devicetag.php
-------------
<?php
//checking whether user had logged in or not.
require("./secure_connection.php");
$flag=session_authentication();
if(!$flag)
{
header("Location:wrongusage.html");
exit;
}
// Connect to MySQL
$connection = mysql_connect( 'localhost', 'balaji', 'pingpong' )
or die ( 'Unable to connect to server.' );
// Select database on MySQL server
mysql_select_db( 'amerm' ) or die ( 'Unable to select database.'
);
$emp_id=$HTTP_SESSION_VARS["user"];
$query1="select emp_name from employee where emp_id='$emp_id'";
$result=mysql_query($query1) or die("unable to execute query");
// Get the employee name who logged in
$line=mysql_fetch_array($result);
$emp_name=$line["emp_name"];
// Get current time and date
$today = date("Y:m:d H:i:s");
?>
<!DOCTYPE html public "-//w3c//dtd html 4.0 transitional//en">
<HTML>
<head>
<script type="JavaScript">
function changepage()
{
if(document.makereq.dev_name.selectedIndex!="0")
{
document.makereq.method="POST";
document.makereq.action="./makerequest.php";
document.makereq.submit();
return true;
}
return false;
}
function save()
{
if (document.makereq.dev_name.options[0].selected)
{
alert('Please choose the device name');
document.makereq.dev_name.focus();
return false;
}
else if(document.makereq.dev_type.options[0].selected)
{
alert("Please choose the device type");
document.makereq.dev_type.focus();
return false;
}
else if(document.makereq.dev_tag.options[0].selected)
{
alert("Please choose the device tag");
document.makereq.dev_tag.focus();
return false;
}
else
{
var flag;
alert("Debug point #1");
flag=checkDate();
if(flag==0)
{
return false;
}
else
{
flag=window.confirm('Are you sure details are
correct?');
if(flag)
{
document.makereq.method = "POST";
document.makereq.action="save_request.php";
document.makereq.submit();
return true;
}
else
return false;
}
}
}
function checkDate()
{
var myDayStr1 = document.makereq.date1.value;
var myMonthStr1 = document.makereq.month1.value;
var myYearStr1= document.makereq.year1.value;
var myDateStr1 = myDayStr + ' ' + myMonthStr + ' ' + myYearStr;
/* Using form values, create a new date object
which looks like "Wed Jan 1 00:00:00 EST 1975". */
var myDate1 = new Date( myDateStr1 );
// Convert the date to a string so we can parse it.
var myDate_string1 = myDate1.toGMTString();
/* Split the string at every space and put the values into an
array so,
using the previous example, the first element in the array is
"Wed", the
second element is "Jan", the third element is "1", etc. */
var myDate_array1 = myDate_string1.split( ' ' );
/* If we entered "Feb 31, 1975" in the form, the "new Date()"
function
converts the value to "Mar 3, 1975". Therefore, we compare the
month
in the array with the month we entered into the form. If they
match,
then the date is valid, otherwise, the date is NOT valid. */
if ( myDate_array1[2] != myMonthStr1 )
{
alert( 'I\'m sorry, but "' + myDateStr1 + '" is NOT a
valid date.' );
return 0;
}
myDayStr2 = document.makereq.date2.value;
myMonthStr2 = document.makereq.month2.value;
myYearStr2 = document.makereq.year2.value;
myDateStr2 = myDayStr2 + ' ' + myMonthStr2 + ' ' + myYearStr2;
var myDate2 = new Date( myDateStr2 );
var myDate_string2 = myDate2.toGMTString();
var myDate_array2= myDate_string2.split( ' ' );
if ( myDate_array2[2] != myMonthStr2 )
{
alert( 'I\'m sorry, but "' + myDateStr2 + '" is NOT a
valid date.' );
return 0;
}
return 1;
}
function check()
{
document.makereq.method = "POST";
document.makereq.action="createrequest_f.php";
document.makereq.submit();
return true;
}
</script>
</head>
<BODY background="imacbg1.gif"
ONLOAD="document.makereq.dev_tag.focus()">
<form name="makereq">
<div align="center">
<center>
<h2>CREATE REQUEST</h2>
<table border="0" width="100%">
<tr>
<td width="50%" align="right">
<p align="right"><b><font size="2"
face="Arial">Device Name</font></b>
</td>
<td width="5%"></td>
<td width="50%" align="left">
<select name="dev_name" STYLE="width : 127px"
onChange="changepage();">
<option value="0">SELECT</option>
<option value="<?php echo $dev_name; ?>"
SELECTED><?php echo $dev_name; ?></option>
</select>
</td>
</tr>
<tr>
<td width="50%" align="right">
<p align="right"><b><font size="2"
face="Arial">Device Type </font></b>
</td>
<td width="5%"></td>
<td width="50%">
<select name="dev_type" STYLE="width : 127px">
<option value="0">SELECT</option>
<option value="<?php echo $dev_type; ?>"
SELECTED><?php echo $dev_type ?></option>
</select>
</td>
</tr>
<tr>
<td width="50%" align="right">
<p align="right"><b><font size="2"
face="Arial">Device Tag </font></b>
</td>
<td width="5%"></td>
<td width="50%">
<select name="dev_tag" STYLE="width : 127px"
onchange="document.makereq.button1.focus()">
<script language="php">
$query = "SELECT dev_tag FROM tinventory
where dev_status='AVAILABLE' and dev_name='$dev_name' and
dev_type='$dev_type' order by dev_tag";
$result = mysql_query($query);
if(mysql_num_rows($result))
{
// we have at least one
device, so show all devices as options in select form
print("<option
value=\"\">SELECT</option>");
while($row =
mysql_fetch_row($result))
{
print("<option
value=\"$row[0]\">$row[0]</option>");
}
}
else
{
print("<option
value=\"\">No devices available</option>");
}
//closing the mysql connection
mysql_close($connection);
</script>
</select>
</td>
</tr>
<tr>
<td width="50%" align="right">
<p align="right"><b><font size="2"
face="Arial">From Date </font></b>
</td>
<td width="5%"></td>
<td width="28%">
<select name="date1" >
<option value="1" >1</option>
<option value="2" >2</option>
<option value="3" >3</option>
<option value="4" >4</option>
<option value="5" >5</option>
<option value="6" >6</option>
<option value="7" >7</option>
<option value="8" >8</option>
<option value="9" >9</option>
<option value="10" >10</option>
<option value="11" >11</option>
<option value="12" >12</option>
<option value="13" >13</option>
<option value="14" >14</option>
<option value="15" selected>15</option>
<option value="16" >16</option>
<option value="17" >17</option>
<option value="18" >18</option>
<option value="19" >19</option>
<option value="20" >20</option>
<option value="21" >21</option>
<option value="22" >22</option>
<option value="23" >23</option>
<option value="24" >24</option>
<option value="25" >25</option>
<option value="26" >26</option>
<option value="27" >27</option>
<option value="28" >28</option>
<option value="29" >29</option>
<option value="30" >30</option>
<option value="31" >31</option>
</select>
<select name="month1">
<option value="1" >Jan</option>
<option value="2" selected>Feb</option>
<option value="3" >Mar</option>
<option value="4" >Apr</option>
<option value="5" >May</option>
<option value="6" >Jun</option>
<option value="7" >Jul</option>
<option value="8" >Aug</option>
<option value="9" >Sep</option>
<option value="10" >Oct</option>
<option value="11" >Nov</option>
<option value="12" >Dec</option>
</select>
<select name="year1">
<option value="2002"
selected>2002</option>
<option value="2003">2003</option>
</select>
<select name="time1">
<option value="1" >1</option>
<option value="2" >2</option>
<option value="3" >3</option>
<option value="4" >4</option>
<option value="5" >5</option>
<option value="6" >6</option>
<option value="7" >7</option>
<option value="8"selected >8</option>
<option value="9" >9</option>
<option value="10" >10</option>
<option value="11" >11</option>
<option value="12" >12</option>
</select>
<select name="time11" >
<option value="00" >00</option>
<option value="01" >01</option>
<option value="02" >02</option>
<option value="03" >03</option>
<option value="04" >04</option>
<option value="05" >05</option>
<option value="06" >06</option>
<option value="07" >07</option>
<option value="08" >08</option>
<option value="09" >09</option>
<option value="10" >10</option>
<option value="11" >11</option>
<option value="12" >12</option>
<option value="13" >13</option>
<option value="14" >14</option>
<option value="15" >15</option>
<option value="16" >16</option>
<option value="17" >17</option>
<option value="18" >18</option>
<option value="19" >19</option>
<option value="20" >20</option>
<option value="21" >21</option>
<option value="22" >22</option>
<option value="23" >23</option>
<option value="24" >24</option>
<option value="25" >25</option>
<option value="26" >26</option>
<option value="27" >27</option>
<option value="28" >28</option>
<option value="29" >29</option>
<option value="30"selected >30</option>
<option value="31" >31</option>
<option value="32" >32</option>
<option value="33" >33</option>
<option value="34" >34</option>
<option value="35" >35</option>
<option value="36" >36</option>
<option value="37" >37</option>
<option value="38" >38</option>
<option value="39" >39</option>
<option value="40" >40</option>
<option value="41" >41</option>
<option value="42" >42</option>
<option value="43" >43</option>
<option value="44" >44</option>
<option value="45" >45</option>
<option value="46" >46</option>
<option value="47" >47</option>
<option value="48" >48</option>
<option value="49" >49</option>
<option value="50" >50</option>
<option value="51" >51</option>
<option value="52" >52</option>
<option value="53" >53</option>
<option value="54" >54</option>
<option value="55" >55</option>
<option value="56" >56</option>
<option value="57" >57</option>
<option value="58" >58</option>
<option value="59" >59</option>
</select>
<select name="time111">
<option value="AM" selected>AM</option>
<option value="PM">PM</option>
</select>
</td>
</tr>
<tr>
<td width="50%" align="right">
<p align="right"><b><font size="2"
face="Arial">To
Date </font></b>
</td>
<td width="5%"></td>
<td width="32%">
<select name="date2" >
<option value="1" >1</option>
<option value="2" >2</option>
<option value="3" >3</option>
<option value="4" >4</option>
<option value="5" >5</option>
<option value="6" >6</option>
<option value="7" selected>7</option>
<option value="8" >8</option>
<option value="9" >9</option>
<option value="10" >10</option>
<option value="11" >11</option>
<option value="12" >12</option>
<option value="13" >13</option>
<option value="14" >14</option>
<option value="15" >15</option>
<option value="16" >16</option>
<option value="17" >17</option>
<option value="18" >18</option>
<option value="19" >19</option>
<option value="20" >20</option>
<option value="21" >21</option>
<option value="22" >22</option>
<option value="23" >23</option>
<option value="24" >24</option>
<option value="25" >25</option>
<option value="26" >26</option>
<option value="27" >27</option>
<option value="28" >28</option>
<option value="29" >29</option>
<option value="30" >30</option>
<option value="31" >31</option>
</select>
<select name="month2">
<option value="1" >Jan</option>
<option value="2" >Feb</option>
<option value="3" selected>Mar</option>
<option value="4" >Apr</option>
<option value="5" >May</option>
<option value="6" >Jun</option>
<option value="7" >Jul</option>
<option value="8" >Aug</option>
<option value="9" >Sep</option>
<option value="10" >Oct</option>
<option value="11" >Nov</option>
<option value="12" >Dec</option>
</select>
<select name="year2">
<option value="2002"
selected>2002</option>
<option value="2003" >2003</option>
</select>
<select name="time2">
<option value="1" >1</option>
<option value="2" >2</option>
<option value="3" >3</option>
<option value="4" >4</option>
<option value="5"selected>5</option>
<option value="6" >6</option>
<option value="7" >7</option>
<option value="8" >8</option>
<option value="9" >9</option>
<option value="10" >10</option>
<option value="11" >11</option>
<option value="12" >12</option>
</select>
<select name="time22" >
<option value="00" >00</option>
<option value="01" >01</option>
<option value="02" >02</option>
<option value="03" >03</option>
<option value="04" >04</option>
<option value="05" >05</option>
<option value="06" >06</option>
<option value="07" >07</option>
<option value="08" >08</option>
<option value="09" >09</option>
<option value="10" >10</option>
<option value="11" >11</option>
<option value="12" >12</option>
<option value="13" >13</option>
<option value="14" >14</option>
<option value="15" >15</option>
<option value="16" >16</option>
<option value="17" >17</option>
<option value="18" >18</option>
<option value="19" >19</option>
<option value="20" >20</option>
<option value="21" >21</option>
<option value="22" >22</option>
<option value="23" >23</option>
<option value="24" >24</option>
<option value="25" >25</option>
<option value="26" >26</option>
<option value="27" >27</option>
<option value="28" >28</option>
<option value="29" >29</option>
<option value="30" >30</option>
<option value="31" >31</option>
<option value="32" >32</option>
<option value="33" >33</option>
<option value="34" >34</option>
<option value="35" >35</option>
<option value="36" >36</option>
<option value="37" >37</option>
<option value="38" >38</option>
<option value="39" >39</option>
<option value="40" >40</option>
<option value="41" >41</option>
<option value="42" >42</option>
<option value="43" >43</option>
<option value="44" >44</option>
<option value="45" selected>45</option>
<option value="46" >46</option>
<option value="47" >47</option>
<option value="48" >48</option>
<option value="49" >49</option>
<option value="50" >50</option>
<option value="51" >51</option>
<option value="52" >52</option>
<option value="53" >53</option>
<option value="54" >54</option>
<option value="55" >55</option>
<option value="56" >56</option>
<option value="57" >57</option>
<option value="58" >58</option>
<option value="59" >59</option>
</select>
<select name="time222">
<option value="AM" >AM</option>
<option value="PM" selected>PM</option>
</select>
</td>
</tr>
<tr>
<td width="30%" align="right">
<b><font size="2"
face="Arial">Comments </font></b>
</td>
<td width="5%"></td>
<td width="50%" align="right">
<textarea rows="5" name="comments" cols="50" nowrap
></textarea>
</td>
</tr>
</table>
<table>
<tr>
<td width="50%" align="right">
<p align="left">
</td>
<td width="5%">
<p align="left"> <input type="button" name="button1"
Value=" SAVE " OnClick="save();">
</td>
<td width="50%">
<p align="left">
<input type="button" name="button2" Value="SUBMIT"
OnClick="check();">
</td>
</tr>
</table>
</center>
</div>
<input type="hidden" name="from_date" value="">
<input type="hidden" name="to_date" value="">
</form>
</BODY>
</HTML>
Thanks and regards
Balaji
**************************Disclaimer************************************
Information contained in this E-MAIL being proprietary to Wipro Limited
is 'privileged' and 'confidential' and intended for use only by the
individual or entity to which it is addressed. You are notified that any
use, copying or dissemination of the information contained in the E-MAIL
in any manner whatsoever is strictly prohibited.
********************************************************************
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
