Jump to content

PHP Javascript

vinoindiamca

By vinoindiamca
in PHP Coding Help

Recommended Posts

vinoindiamca Member

vinoindiamca

Posted
Posted

Hi,

  I have coded PHP with javascript. As i am a ASP Developer i am new to PHP ,so  please give the suggestion like my code method of using is correct.

 

Table Design

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

Table Name = emp

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

Coloumn Name        identifier        auto increment  Datatype

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

empid (pk)              on                  yes                integer

empno                                                              varchar(30)

empname                                                          varchar(50)

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

 

 

Connection Part

<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='xxxx';
$con=mysql_connect($dbhost,$dbuser,$dbpass) or die("Error connecting MYSQL");
$dbname='emp';
mysql_select_db($dbname);
?>

Index.php File ie Login form

<html>
<head>
<title>Loginform</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style3 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
.style5 {font-family: Arial, Helvetica, sans-serif; font-size: 18px; }
-->
.tableright
{
border-bottom:1px #AAB0F9 solid;
border-top:1px #AAB0F9 solid;
border-left:1px #AAB0F9 solid;
border-right:1px #AAB0F9 solid;
}

</style>
</head>

<body>
<?php
function insert()
{
  include 'connection.php';
  
		  if (($_POST["uname"]=="") || ($_POST["pass"]==""))
		  {
				echo "<script language='javascript'>";
				echo "alert('Invalid User name & Password');";
				echo "window.location='index.php';";
				echo "</script>";

			    
				exit;
		  }
  $username=$_POST["uname"];
  $password=$_POST["pass"];
  
  $query="select uname,pass from user_mgmt where uname='$username' and pass='$password'";
		$result = mysql_query($query) or die(mysql_error());

				echo "<script language='javascript'>";
				echo "Invalid User name & Password";
				echo "window.location='index.php'";
				echo "</script>";
		  
		  if(mysql_num_rows($result)==1)
		 {
		setcookie("Allow_Users","1",0,"/","",0);
		header("location:http://localhost/PHPNEW/emp/select.php");
		}
		else
		{
		setcookie("Denie_Users","2",0,"/","",0);
		header("location: index.php");
		}

}
function form()
{
?>
<form name="form1" method="post">
<table width="98%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="8%"> </td>
    <td width="8%"> </td>
    <td width="51%"> </td>
    <td width="10%"> </td>
    <td width="23%"> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td colspan="2"><table width="98%" height="205"  border="0" cellpadding="0" cellspacing="0" class="tableright">
      <tr>
        <td><table width="95%"  border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F1F2FE">
          <tr>
            <td colspan="3"><span class="style5">Login</span></td>
            </tr>
          <tr>
            <td width="42%"> </td>
            <td width="3%"> </td>
            <td width="55%"> </td>
          </tr>
          <tr>
            <td><div align="right"><span class="style3">User Name </span></div></td>
            <td> </td>
            <td><input name="uname" type="text" id="uname"></td>
          </tr>
          <tr>
            <td><div align="right"><span class="style3">Password</span></div></td>
            <td> </td>
            <td><input name="pass" type="text" id="pass"></td>
          </tr>
          <tr>
            <td> </td>
            <td> </td>
            <td> </td>
          </tr>
          <tr>
            <td> </td>
            <td> </td>
            <td><input type="submit" name="add" id="add" value="Login"></td>
          </tr>
          <tr>
            <td> </td>
            <td> </td>
            <td> </td>
          </tr>
          <tr>
            <td> </td>
            <td> </td>
            <td> </td>
          </tr>
          <tr>
            <td> </td>
            <td> </td>
            <td> </td>
            </tr>
        </table></td>
        </tr>
    </table></td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>
</body>
</form>
<?php
}
if (isset($_POST['add']))
{
insert();
}
else
{
form();
}
?>
</html>

Create Folder called emp and create following files

Insert.php file
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style6 {font-size: 12}
.style8 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
.style9 {font-size: 12px}
-->
</style>
</head>

<body>
<?php
function insert()
{
include 'connection.php';
$empno1=$_POST["empno"];
$empname1=$_POST["empname"];

$query="Insert into emp (empno,empname) values ('$empno1','$empname1')";

if(!mysql_query($query))
{
				echo "<script language='javascript'>";
				echo "alert('Employee Id Already Exists');";
				echo "window.location='insert.php';";
				echo "</script>";
}
header("location: select.php");
}
function form()
{
?>
<form name="form1" method="post">
<table width="98%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="17%"> </td>
    <td width="2%"> </td>
    <td width="61%"> </td>
    <td width="10%"> </td>
    <td width="10%"> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><div align="right"><span class="style8">Empno</span></div></td>
    <td><div align="right"></div></td>
    <td>
      <div align="left">
        <input name="empno" type="text" id="empno">
      </div></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><div align="right"><span class="style8">Empname</span></div></td>
    <td><div align="right"></div></td>
    <td>
      <div align="left">
        <input name="empname" type="text" id="empname">
      </div></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><div align="right"></div></td>
    <td><div align="right"></div></td>
    <td><div align="right"></div></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><span class="style6"></span></td>
    <td><span class="style6"></span></td>
    <td><input name="add" type="submit" id="add" value="Add"></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><span class="style6"></span></td>
    <td><span class="style6"></span></td>
    <td><span class="style6"></span></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>
</form>
<?php
}
if (isset($_POST['add']))
{
insert();
}
else
{
form();
}
?>
</body>
</html>


Select.php file 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript">
function edit(val)
{
document.form1.target="_self";
document.form1.action="update.php";
document.form1.cid.value=val;
document.form1.submit();
}
</script>

</head>
<?php
include "connection.php";
$query=("select * from emp");
$result=mysql_query($query) or die(mysql_error());

$query2 = "SELECT COUNT(*) AS numrows FROM emp";
$result2 = mysql_query($query2) or die('Error, query failed');
$row2 = mysql_fetch_array($result2);
$numrows = $row2['numrows'];


?>
<body>
<form name="form1" method="post">
<input type="hidden" name="cid" value="<?php echo $row['empid']; ?>">
<table width="98%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td colspan="5"><table width="98%"  border="1" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="4"> </td>
        <td width="9%">Add New </td>
      </tr>
      <tr>
        <td width="5%">S.No</td>
        <td width="11%"><div align="center">
          <input type="submit" name="delete" id="delete" value="Delete">
        </div></td>
        <td width="15%">Emp number </td>
        <td colspan="2">Emp Name</td>
        </tr>
	<?php
	for ($j = 0; $j<=$numrows; $j++) 
	{
	while($row=mysql_fetch_array($result))
	{
	$j++;
	?>
      <tr>
        <td> <?php echo $j?></td>
        <td><div align="center">
          <input type="checkbox" name="checkbox[]"  id="checkbox[]" value="<?php echo $row['empid'];?>">
        </div></td>
        <td> <a href="javascript:edit('<?php echo $row['empid'];?>')"</a><?php echo $row['empno'];?></td>
        <td colspan="2"> <?php echo $row['empname'];?></td>
        </tr>
	<?php
	}
	}
	?>
    </table></td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>
<?php
if (isset($_POST['delete']))
{
if (!empty($_POST['checkbox']))
{
foreach($_POST['checkbox'] as $v)
{
$delid=mysql_real_escape_string($v);
$sql="delete from emp where empid=$delid";
mysql_query($sql);
  echo "<script language='javascript'>";
   echo "window.location='select.php'";
   echo "</script>";
mysql_close();
}
}
}

?>
</form>
</body>
</html>

Update.php file
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style6 {font-size: 12}
.style8 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
.style9 {font-size: 12px}
-->
</style>
</head>

<body>
<?php
function insert()
{
include "connection.php";
$cid=$_POST['cid'];
$empno1=$_POST['empno'];
$empname1=$_POST['empname'];

$query="update emp set empno='$empno1',empname='$empname1' where empid=$cid";

if(!mysql_query($query))
{
				echo "<script language='javascript'>";
				echo "alert('Employee Id Already Exists');";
				echo "window.location='insert.php';";
				echo "</script>";
}
header("location: select.php");
}
function form()
{
include "connection.php";
$cid=$_POST['cid'];
$sql="select * from emp where empid=$cid";
$result1 = mysql_query($sql) or die('Error, query failed');
$row = mysql_fetch_array($result1);

?>
<form name="form1" method="post">
<input type="hidden" name="cid" value="<?php echo $row['empid'];?>">
<table width="98%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="17%"> </td>
    <td width="2%"> </td>
    <td width="61%"> </td>
    <td width="10%"> </td>
    <td width="10%"> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><div align="right"><span class="style8">Empno</span></div></td>
    <td><div align="right"></div></td>
    <td>
      <div align="left">
        <input name="empno" type="text" id="empno" value="<?php echo $row['empno'];?>">
      </div></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><div align="right"><span class="style8">Empname</span></div></td>
    <td><div align="right"></div></td>
    <td>
      <div align="left">
        <input name="empname" type="text" id="empname" value="<?php echo $row['empname'];?>">
      </div></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><div align="right"></div></td>
    <td><div align="right"></div></td>
    <td><div align="right"></div></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><span class="style6"></span></td>
    <td><span class="style6"></span></td>
    <td><input name="add" type="submit" id="add" value="Add"></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><span class="style6"></span></td>
    <td><span class="style6"></span></td>
    <td><span class="style6"></span></td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>
</form>
<?php
}
if (isset($_POST['add']))
{
insert();
}
else
{
form();
}
?>
</body>
</html>

 

Please give the suggestion

Link to comment
https://forums.phpfreaks.com/topic/137479-php-javascript/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.