Re: [PHP] Can anybody help me?

Tyler Longren Thu, 07 Mar 2002 05:22:05 -0800

Did you recieve an error?  If so, what was it?

Tyler


----- Original Message -----
From: "Balaji Ankem" <[EMAIL PROTECTED]>
To: "Php-General" <[EMAIL PROTECTED]>
Sent: Thursday, March 07, 2002 7:23 AM
Subject: [PHP] Can anybody help me?


> 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&nbsp;&nbsp;</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&nbsp;&nbsp;&nbsp;&nbsp;</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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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&nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> <td width="50%">
> <p align="left"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> <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
>
>


----------------------------------------------------------------------------
----


> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Can anybody help me?

Reply via email to