Learn VBA & Macros in 1 Week!

JavaScript - Setfocus

Full Excel VBA Course - Beginner to Expert

Setfocus	View Content

Good day!

I created a login page and I have the username which is a textbox type, department and i use option and a submit button..

I want that when i open my webpage automaticallt the cursor was on the textbox and when i am done in typing my username and i press the enter key the focus would be on the option which where i can choose my department and when i am done choosing my department and i press the enter key i automatic login and go to the department page.

Here is the code:
PHP Code:
<?php
session_start();
//require_once 'conn.php';
$db_name="dspi";

mysql_connect("localhost", "root", "") or die("Cannot connect to server");
mysql_select_db("$db_name")or die("Cannot select DB");

        $department = mysql_real_escape_string($_POST['department']);
        $username = mysql_real_escape_string($_POST['username']);

        $sql=mysql_query("SELECT `Department`, `Username` FROM `tbllogin` WHERE `Department` = '{$department}' AND Username = '{$username}'") or die(mysql_error());
        $ct = mysql_num_rows($sql);

        if($ct == 1) {
            $row = mysql_fetch_assoc($sql);

            if($row['Department']=='Accounting') {
                header('location: Company.php');
            } elseif($row['Department']=='Engineering') {
                header('location: Company.php');
            } elseif($row['Department']=='Finishing_Goods') {
                header('location: Company.php');
            } elseif($row['Department']=='HRAD') {
                header('location: Company.php');
            } elseif($row['Department']=='MIS') {
                header('location:Company.php');
            } elseif($row['Department']=='Packaging_and_Design') {
                header('location:Company.php');
            } elseif($row['Department']=='Production') {
                header('location:Company.php');
            } elseif($row['Department']=='Purchasing_Logistic') {
                header('location:Company.php');
            } elseif($row['Department']=='QA_and_Technical') {
                header('location:Company.php');
            } elseif($row['Department']=='Supply_Chain') {
                header('location:Company.php');
            }
            else {
                header('location:dspi_login.php');
                echo"Incorrect Username or Department";

                }
    }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Login</title>
<script>
        function searchKeyPress(e)
        {
                // look for window.event in case event isn't passed in
                if (window.event) { e = window.event; }
                if (e.keyCode == 13)
                {
                        document.getElementById('submit').focus();
                }
        }
        </script>
<style type="text/css">

</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
  <div id="Department_Option">
    <select name="department" onkeypress="searchKeyPress(event);">
      <option>Choose your Department. . . . . . </option>
      <option value="Accounting" <?php if($_POST['department'] == 'Accounting') echo "selected='selected'"; ?>>Accounting</option>
      <option value="Engineering" <?php if($_POST['department'] == 'Engineering') echo "selected='selected'"; ?>>Engineering</option>
      <option value="Finishing_Goods" <?php if($_POST['department'] == 'Finishing_Goods') echo "selected='selected'"; ?>>Finishing Goods</option>
      <option value="HRAD" <?php if($_POST['department'] == 'HRAD') echo "selected='selected'"; ?>>HRAD</option>
      <option value="MIS" <?php if($_POST['department'] == 'MIS') echo "selected='selected'"; ?>>MIS</option>
      <option value="Packaging_and_Design" <?php if($_POST['department'] == 'Packaging_and_Design') echo "selected='selected'"; ?>>Packaging and Design</option>
      <option value="Production" <?php if($_POST['department'] == 'Production') echo "selected='selected'"; ?>>Production</option>
      <option value="Purchasing_Logistic" <?php if($_POST['department'] == 'Purchasing_Logistic') echo "selected='selected'"; ?>>Purchasing and Logistics</option>
      <option value="QA_and_Technical" <?php if($_POST['department'] == 'QA_and_Technical') echo "selected='selected'"; ?>>QA and Technical</option>
      <option value="Supply_Chain" <?php if($_POST['department'] == 'Supply_Chain') echo "selected='selected'"; ?>>Supply Chain</option>
    </select>
  </div>
  <div id="Submit_Button">
    <input type="Submit" name="submit" value="Submit" id="submit" onclick="doSomething();"/>
  </div>
  <div id="Dept_Frame"><img src="layout_image/subframev02.png" width="229" height="50" /></div>
  <div id="Submit_Frame"><img src="layout_image/subframev02.png" width="80" height="46" /></div>

<div id="Username_ImageText"><img src="layout_image/userv01.png" width="131" height="62" /></div>
<div id="User_Frame"><img src="layout_image/subframev02.png" width="229" height="50" /></div>
<div id="Username_Textbox">
  <input name="username" type="text" size="30" />
</div>
</form>
</body>

</html>

I hope that somebody help me to solve

Full Excel VBA Course - Beginner to Expert

Setfocus On Dynamically Added Text Box.

Similar Tutorials

View Content

Hello,

I am trying to get something to work and I am not having any luck.

I want to dynamically add a set of fields to a table when when the user onBlur the selection drop-down. I want the cursor to be in the text field of the newly added set.

I have been playing around with onfocus function on the hyperlink to see if when focus is gained, it would throw the user into the text field. I am getting the impress that the field has not been created yet, so the getElementbById function cannot find the object just recently created.

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
<script language="JavaScript">
function addEvent() {
  var ni = document.getElementById('myDiv');
  var numi = document.getElementById('theValue');
  var num = (document.getElementById("theValue").value -1)+ 2;
  numi.value = num;
  var divIdName = "my"+num+"Div";
  var newdiv = document.createElement('div');
  newdiv.setAttribute("id",divIdName);
  newdiv.innerHTML = '<div>'+ num +'</div><div class=name><input class=name id=item-' + num + ' type=text name=item-'+ num + '></div><div><select name=selRow-' + num + ' onBlur="addEvent();"><option value="0">Check</option><option value="1">Cash</option><option value="2">Money Order</option><option value="3">EFT</option></select></div>';
  ni.appendChild(newdiv);
}

function setTxtFocus()
{
  var ni = document.getElementById('myDiv');
  var numi = document.getElementById('theValue');
  var num = (document.getElementById("theValue").value -2)+ 2;
  document.getElementById('item-' + num).focus;
}

</script><style type="text/css">
@import url(style.css);
</style>
</head>

<body onload="addEvent();">
    <div id=image></div>
    <form action=process.php method=post>
    <input type="hidden" value="0" id="theValue" />
    <div id="myDiv"></div>
	<p><a href="javascript:;" onclick="setTxtFocus();">Add Other Suggestion</a></p>
    <p><input type=submit id="submitbutton" value=Submit disabled> <INPUT TYPE="button" VALUE="Back" onClick="history.go(-1);return true;"></p>
    </form>
</body>
</html>

Thanks
jlimited