time validation for text box.

valid time in 24 hours format with no seconds

my textboxes have same name and id with array

i am alerting the text box value onblur.It shows only the first text box value

I want to alert for every text box if value is not a number

Expand|Select|Wrap|Line Numbers

     <?php

    session_start();

    if (!$_SESSION['uname']) header("Location:login.php"); ?>

    <html><head><title>Attendance sheet</title>

    <link rel="stylesheet" href="att_style.css" type="text/css" >

    <script type="text/javascript">
 
    function IsNumber(strAlert)

    {
 
    //alert(strAlert);

    var txtb = document.getElementById('in_time[]').value;

    //for (var i = 0; i < txtb.length; i++) {

    //var txtv = txtb[i].value;

    alert(txtb);

    //}

    }
 
    </script>

    </head>

    <body>

    <?php

    $cnn = mysql_connect("localhost","root","");

    mysql_select_db("time_sheet",$cnn);
 
    $dbdate = mysql_query("SELECT start_mon,end_mon FROM admin");

    $dd = mysql_fetch_array($dbdate);
 
    $curmon = getdate();

    $nextmonth = $curmon['mon'] + 1;

    $start = "2012" . "-" . $curmon['mon'] ."-". $dd['start_mon'];

    $end =  "2012" . "-". $nextmonth ."-". $dd['end_mon'];

    $_SESSION['fromdate'] = $start;

    $_SESSION['todate'] = $end;
 
    $dateMonthYearArr = array();

    $fromDateTS = strtotime($start);

    $toDateTS = strtotime($end);
 
    for ($currentDateTS = $fromDateTS; $currentDateTS <= $toDateTS; $currentDateTS += (60 * 60 * 24)) {

    $currentDateStr = date("M d",$currentDateTS);

    $notmysql[] = $currentDateStr;
 
    $currmysql = date("Y-m-d",$currentDateTS);

    $mysqlfor[] = $currmysql;        

    }

    echo "    No of days: " . count($mysqlfor);

    //Table for view
 
    if (isset($_REQUEST['sub'])) {

    $inti = $_POST['in_time'];

    $outi = $_POST['out_time'];
 
    $intime = serialize($inti);

    $outtime = serialize($outi);
 
    $inser = unserialize($intime);

    $outser = unserialize($outtime);

    $dbdate = mysql_query("SELECT start_mon,end_mon FROM admin");

    $dd = mysql_fetch_array($dbdate);

    $curmon = getdate();

    $nextmonth = $curmon['mon'] + 1;
 
    $dateMonthYearArr = array();

    $fromDateTS = strtotime($start);

    $toDateTS = strtotime($end);
 
    for($b = 0; $b < count($mysqlfor); $b++) {

    $qry = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$b]."' ");

    $ds = mysql_fetch_array($qry);
 
    if(!$qry) die(mysql_error());

    $check = mysql_num_rows($qry);

    //                print_r($inser);

    if($check == 0) {

    if($inser[$b] == "") $inser[$b] = '00:00';
 
    if($outser[$b] == "") $outser[$b] = '00:00';
 
    $ins = mysql_query("INSERT INTO timetable VALUES ('', '".$_SESSION['uname']."', 

    '".$mysqlfor[$b]."', '".$inser[$b]."', '".$outser[$b]."', '') ");

    }

    else {

    //print_r($mysqlfor[$b]);

    $upd = mysql_query("UPDATE `timetable` SET `in` = '".$inser[$b]."',

     `out` = '".$outser[$b]."' WHERE `date` = '".$mysqlfor[$b]."' ");

    if(!$upd) die(mysql_error());                    

    }

    }

    }

    ?>

    <form name="myForm" method="post" action="">

    <table border="1" cellspacing="0" cellpadding="2">

    <tr><th scope="row">DATE</th>

    <?php

    for ($s = 0; $s < 10; $s++) {

    ?>

    <td align="center"><?php print_r($notmysql[$s]); } ?></td></tr>
 
    <tr><th scope="row">IN</th> <?php 

    for ($ss = 0; $ss < 10; $ss++) { ///////////////getting from DB

    $sele = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$ss]."' ");

    $emp = mysql_num_rows($sele);

    ?>

    <td align="center"> <?php

    $numrows = mysql_num_rows($sele);

    if($numrows == 0) { 

    ?>

    <input name="in_time[]" id="in_time[]" type="text" onBlur="IsNumber();" size="5">

    </td>

    <?php

    }

    else {

    while($row1 = mysql_fetch_array($sele))  {        

    ?>

    <input name="in_time[]" id="in_time[]" type="text" onBlur="IsNumber();" 

    value="<?php echo $row1['in']; ?>" size="5"></td>

    <?php } 

    }

    }?>

    </tr>
 
    <tr><th scope="row">OUT</th> <?php 

    for ($v = 0; $v < 10; $v++) {

    ?>

    <td align="center"> <?php

    $sel2 = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$v]."'");

    $numrows = mysql_num_rows($sel2);

    if($numrows == 0) { ?>

    <input name="out_time[]" id="out_time[]" type="text" size="5"></td> 

    <?php 

    }

    else {

    while($row2 = mysql_fetch_array($sel2)) { ?>

    <input name="out_time[]" id="out_time[]" type="text" onBlur="IsNumber();" 

    value="<?php echo $row2['out']; ?>" size="5"></td>

    <?php

    }

    }

    }?>

    </tr>
 
    <tr><th scope="row">Late</th><?php for ($s = 0; $s < 10; $s++) { 

    ?>

    <td align="center"><input name="late_time[]" id="late_time[]" onBlur="IsNumber();" 

    type="text" size="5"></td> 

    <?php  

    }?>

    </tr>

    </table>

    <br><br>

    <!-- second tab-->

    <?php if(count($notmysql) >= 11) { ?>

    <table border="1" cellspacing="0" cellpadding="2"><tr><th scope="row">DATE</th>

    <?php

    for ($st = 10; $st < 20; $st++) { ?>        

    <td align="center"><?php print_r($notmysql[$st]); ?></td>

    <?php    

    }

    ?></tr>
 
    <tr><th scope="row">IN</th> 

    <?php for ($g = 10; $g < 20; $g++) { 

    $selec = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$g]."'");

    $numrows = mysql_num_rows($selec);

    ?> <td align="center"> <?php

    if($numrows == 0) { ?>    

    <input name="in_time[]" id="in_time[]" type="text" onBlur="IsNumber();" size="5"></td>

    <?php

    }

    else {

    while($secinrow = mysql_fetch_array($selec)) { ?>

    <input name="in_time[]" id="in_time[]" value="<?php echo $secinrow['in']; ?>" onBlur="IsNumber();"

    type="text" size="5"></td>

    <?php  

    }

    }

    }?></tr>
 
    <tr><th scope="row">OUT</th>

    <?php for ($h = 10; $h < 20; $h++) { 

    $select = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$h]."'");

    ?>

    <td align="center"> <?php

    $numrows = mysql_num_rows($select); 

    if($numrows == 0) {?>

    <input name="out_time[]" id="out_time[]" type="text" onBlur="IsNumber();" size="5"></td>

    <?php 

    }

    else { 

    while($secoutrow = mysql_fetch_array($select)) {

    ?> 

    <input name="out_time[]" id="out_time[]" type="text" onBlur="IsNumber();" 

    value="<?php echo $secoutrow['out']; ?>" size="5"></td>

    <?php } 

    }

    }?></tr>
 
    <tr><th scope="row">Late</th>

    <?php for ($m = 10; $m < 20; $m++) { ?>

    <td align="center"><input name="late_time[]" id="out_time[]" onBlur="IsNumber();"

    type="text" size="5"></td> <?php 

    } 

    ?>

    </tr>

    </table>

    <?php } ?> 

    <br/><br/>
 
    <!-- Third table-->

    <?php if(count($notmysql) >= 21) { ?>

    <table border="1" cellspacing="0" cellpadding="2">

    <tr>

    <th scope="row">DATE</th>

    <?php

    for ($tt = 20; $tt < count($notmysql); $tt++) {     

    ?>

    <td align="center"><?php print_r($notmysql[$tt]); ?></td><?php } 

    ?>

    </tr>
 
    <tr><th scope="row">IN</th>

    <?php for ($j = 20; $j < count($notmysql); $j++) {

    $selected = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$j]."' ");

    ?> <td align="center"> <?php

    $numrows = mysql_num_rows($selected);

    if($numrows == 0) {?>

    <input name="in_time[]" id="in_time[]" type="text" onBlur="IsNumber();" size="5"></td>

    <?php }

    else {

    while($treinrow = mysql_fetch_array($selected)) {

    ?>

    <input name="in_time[]" id="in_time[]" type="text" onBlur="IsNumber();"

    value="<?php echo $treinrow['in']; ?>" size="5"></td> 

    <?php

    }

    }

    }

    ?>

    </tr>
 
    <tr><th scope="row">OUT</th> <?php for ($k = 20; $k < count($notmysql); $k++) { 

    $selectedr = mysql_query("SELECT * FROM timetable where date = '".$mysqlfor[$k]."'");

    $numrows = mysql_num_rows($selectedr);

    ?>

    <td align="center"> <?php    

    if($numrows == 0) { ?>    

    <input name="out_time[]" id="out_time[]" type="text" onBlur="IsNumber();" size="5"></td> 

    <?php }

    else {

    while($treoutrow = mysql_fetch_array($selectedr)) {

    ?>    

    <input name="out_time[]" id="out_time[]" onBlur="IsNumber();" 

    value="<?php echo $treoutrow['out']; ?>" type="text" size="5"></td> 

    <?php 

    }

    }

    } ?>

    </tr>
 
    <tr><th scope="row">Late</th>

    <?php for ($s = 20; $s < count($notmysql); $s++) { ?>

    <td align="center">

    <input name="late_times[]" id="late_times[]" type="text" value="<?php ?>" size="5"></td> <?php 

    } ?>

    </tr>

    </table>

    <?php } ?>

    <!--Table End -->

    <a style="float:right" href="logout.php">Logout</a>

    <p align="center"><input name="sub" type="submit" value="Save"></p>

    </form>

    </body>

    </html>

Mar 3 '12 #1

Subscribe Post Reply

1956

Dormilich

8,658

Expert Mod 8TB

ids must be unique …

Mar 3 '12 #2

by: Megha Vishwanath | last post by:

Hi, We have an application where my clients may be at different timezones. I need to validate time across the timezones with javascript. The date object in JavaScript does not allow me to get...

Javascript

MAJOR headache with Time Validation Script

by: Kenneth | last post by:

Hello, I'm having some serious problems debugging a script that I'm trying to make work. I'm working on a form where a user can type in a time (in the format of HH:MM), and another script...

Javascript

Tough Date/Time validation in JavaScript...

by: simina | last post by:

Hi... I have an "appointments" page where the user should (or not necessarily) choose a date and time for his appointment, from 6 combo boxes:year, month, day, hour, minute and AM or PM, without...

Javascript

Javascript real time validation

by: Al | last post by:

Hi, I'm using an asp:textbox in a form and I want to use the equivalent of the onkeyup event of a "normal" input text. So far, it seems that all validator performs a check up only on...

C# / C Sharp

date-time validation

by: Chris | last post by:

Hi, I have a texbox in a webform that is supposed to hold Dates in a specific format : e.g. 20-12-2004 What is the best way to make sure that the entered data is in the correct format ? ...

C# / C Sharp

2.0: validation text in message box?

by: R.A.M. | last post by:

Hi, Do you know if using asp: validators I can have validation text in browser popup message box? Thank you very much for your help. /RAM/

ASP.NET

date and time validation in vb .net

by: menayah | last post by:

Hi all, Can i use vb validators to validate a date (MM/DD/YY) from a text box ? and also time (HH:MM am/pm)? How to do this validation in a .net webform?

.NET Framework

Time validation

by: narend | last post by:

I want to validation in time in 24:00 Hours format.. i am using in txtbox in html

Javascript

Date/Time Validation Rules

by: DrSporkeh | last post by:

Hai everyone, i need some help :o basically im trying to set some validation rules for an 'employees' table. firstly i've set it to you have to be 16 to work here under 'Date Of Birth' ...

Microsoft Access / VBA

Time validation in a text box

by: dougancil | last post by:

I'm trying to use required validation controls on two text boxes and tried using the following code: <asp:TextBox ID="starttimeInput" runat="server" Width="130px" Height="23px"></asp:TextBox>...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

time validation for text box.

Similar topics