vinoindiamca's Content - Page 2

[SOLVED] Date Format Problem

vinoindiamca posted a topic in PHP Coding Help

Hi I need help yaar regarding date format in mysql $ardt=$_POST["txtardt"]; $drdt=$_POST["txtdrdt"]; $query="insert into booking values('$ardt','$drdt')"; mysql> select * from booking; +--------+-------+-------------+-------------+-------------+---------------+---- --------+----------+---------+---------+--------+---------+ ArrivalDate | DepartureDate --------+----------+---------+---------+--------+---------+ | 0000-00-00 | 0000-00-00 | | 0000-00-00 | 0000-00-00 | -------------+---------------+---- How to insert with date format

PHP Javascript

vinoindiamca posted a topic in PHP Coding Help

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">  .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">  </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">  </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

Working correctly

vinoindiamca posted a topic in PHP Coding Help

Yesterday I got some errors in this codes now i corrected the problem is while using checkbox we should use this function $delid=mysql_real_escape_string($v); to work correctly New PHP Users can use this file for reference <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'xxxx'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); //echo "Connected to MySQL<br />"; $dbname = 'emp'; mysql_select_db($dbname); ?> <html> <head> <title>PHP</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css">  </style> </head> <script language="javascript"> function goto() { document.form1.action="index.php"; document.form1.submit(); } </script> <script language="javascript"> </script> <body> <?php function insert() { include 'connectmysql.php'; if(($_POST["uname"] == "") || ($_POST["pass"] == "")) { header("Location :index.php"); echo "<script language='javascript' type='text/javascript'>"; echo " alert('Invalid User Name & Password');"; echo "window.location='index.php'"; echo "</script>"; echo"<form name='form1' method='post'>"; echo "<table border='0'>"; echo "<input type='button' name='Submit' value='Back To Login' onClick='goto()'>"; echo "</table>"; echo "</form>"; 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' type='text/javascript'>"; echo " alert('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/PHP/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="33%"> </td> <td width="30%"> </td> <td width="37%"> </td> </tr> <tr> <td colspan="3"><table width="96%" height="31" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="8%"> </td> <td width="1%" bgcolor="#D3D7F8"> </td> <td width="91%" bgcolor="#D3D7F8"><span class="style9"> PHP </span><span class="style9"></span></td> </tr> </table></td> </tr> <tr> <td colspan="3"> </td> </tr> <tr> <td colspan="2"> </td> <td><table width="87%" border="0" cellpadding="0" cellspacing="0" class="tableright"> <tr> <td height="204"> <table width="98%" height="198" border="0" align="center" cellpadding="0" cellspacing="0"> <tr bgcolor="#EDEEFC"> <td height="19" colspan="4"><div align="center"><span class="style1"> </span></div></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19" colspan="4"><div align="center"><span class="style1">Login</span></div></td> </tr> <tr bgcolor="#EDEEFC"> <td width="28%" height="19" class="style6"><div align="right">Username</div></td> <td width="2%" height="19"><div align="left">:</div></td> <td height="19" colspan="2"><input name="uname" type="text" size="25" maxlength="30"></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19" class="style6"><div align="right">Password</div></td> <td height="19"><div align="left">:</div></td> <td height="19" colspan="2"><input name="pass" type="text" size="25" maxlength="30"></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19"> </td> <td height="19"> </td> <td height="19" colspan="2"> </td> </tr> <tr bgcolor="#EDEEFC"> <td height="19" bgcolor="#EDEEFC"> </td> <td height="19"> </td> <td width="11%" height="19"> </td> <td width="59%" height="19"><input type="submit" name="add" value="Login" id="add" ></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19"> </td> <td height="19"> </td> <td height="19" colspan="2"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <input type="hidden" name="login"> </form> <?php } if (isset($_POST['add'])){ insert(); }else{ form(); } ?> </body> </html> SELECT and DELETE PAGE save it as insert.php <!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">  </style> </head> <script language="javascript"> function goto() { document.form1.action="select.php"; document.form1.submit(); } function edit(val) { // alert(val) // win=window.open("","mywin","scrollbars,resizable,static,depedent") document.form1.target="_self"; document.form1.action="update.php"; document.form1.cid.value=val; document.form1.submit(); } </script> <body > <?php include 'connectmysql.php'; //mysql_query($query); //} $rowsPerPage = 10; $pageNum = 1; if(isset($_GET['page'])) { $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT * FROM emp LIMIT $offset, $rowsPerPage"; //$result = mysql_query("SELECT * FROM emp"); $result = mysql_query($query) or die('Error, query failed'); $count=mysql_num_rows($result); ?> <form name="form1" method="post" > <input type="hidden" name="cid" value="<?php echo $row['empid'] ; ?>"> <table width="98%" border="0"> <tr> <td width="11%"> </td> <td width="81%"> </td> <td width="8%"> </td> </tr> <tr> <td colspan="3"> <table width="98%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4" class="style9"><div align="left"><strong>Employee Details </strong></div></td> </tr> <tr class="tableheaderA"> <td width="10%" class="style8">S.No</td> <td width="8%" class="style8"><input name="delete" type="submit" id="delete" value="Delete"></td> <td width="47%" class="style8"> Employee Number </td> <td width="35%" class="style8"> Employee Name </td> </tr> <?php while($row = mysql_fetch_array($result)) { ?> <tr> <td class="style12"> <?php echo $row['empid'] ?> </td> <td class="style12"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['empid']; ?>"></td> <td class="style13"> <a href="javascript:edit('<?php echo $row['empid'] ; ?>')" class="style2"> <?php echo $row['empno'] ; ?> </a> </td> <td class="style14"> <?php echo $row['empname'] ; ?> </td> </tr> <?php } ?> </table> <span class="style8"> </span></td> </tr> <tr> <td colspan="3"><span class="style8"> <?php $query = "SELECT COUNT(*) AS numrows FROM emp"; $result = mysql_query($query) or die('Error, query failed'); $row = mysql_fetch_array($result, MYSQL_ASSOC); $numrows = $row['numrows']; $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; $nav = ''; for($page = 1; $page <= $maxPage; $page++) { if ($page == $pageNum) { $nav .= " $page "; // no need to create a link to current page } else { $nav .= " <a href=\"$self?page=$page\">$page</a> "; } } if ($pageNum > 1) { $page = $pageNum - 1; $prev = " <a href=\"$self?page=$page\">[Prev]</a> "; $first = " <a href=\"$self?page=1\">[First Page]</a> "; } else { $prev = ' [Prev] '; // we're on page one, don't enable 'previous' link $first = ' [First Page] '; // nor 'first page' link } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " <a href=\"$self?page=$page\">[Next]</a> "; $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> "; } else { $next = ' [Next] '; // we're on the last page, don't enable 'next' link $last = ' [Last Page] '; // nor 'last page' link } //echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last; echo $first . $prev . $nav . $next . $last; ?> </span></td> <?php // Check if delete button active, start this if(isset($_POST['delete'])){ if (!empty($_POST['checkbox'])) { foreach($_POST['checkbox'] as $v) { $del_id = mysql_real_escape_string($v); $sql = "DELETE FROM emp WHERE empid ='$del_id'"; mysql_query($sql); echo "<script language='javascript' type='text/javascript'>"; echo "window.location='insert.php'"; echo "</script>"; } } } // if successful redirect to delete_multiple.php mysql_close(); ?> </tr> <tr> <td> </td> <td><input type="button" name="Submit" value="Back to Insert" onClick="goto()"></td> <td> </td> </tr> </table> </form> </body> </html> INSERT PAGE save it as select.php <!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">  </style> </head> <script language="javascript"> function save() { alert(document.form1.savehid.value); document.form1.target="_self"; document.form1.action="insert.php"; document.form1.savehid.value; document.form1.submit(); } function goto() { document.form1.action="select.php"; document.form1.submit(); } </script> <body> <?php function insert() { include 'connectmysql.php'; $id = $_POST['empid']; $empno1 = $_POST['empno']; $empname1 = $_POST['empname']; //if(empty($id)) error_message("You need to enter some text in news box!"); //if($id=$ss['empid']) //{ $query = "INSERT INTO emp (empno,empname) VALUES ('$empno1','$empname1')"; if (!mysql_query($query)) { echo"<form name='form1' method='post'>"; echo "<table border='0'>"; echo "<input type='button' name='Submit' value='Back to Insert' onClick='goto()'>"; echo "</table>"; echo "</form>"; die('Error, Empid Already Exists Please insert Correctly'); } header("Location:insert.php"); //header("Location:http://localhost/insert.php"); } function form(){ ?> <form method="post" name="form1"> <table width="98%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="3"> </td> </tr> <tr> <td colspan="2"> </td> <td width="29%"><a href="../index.php" class="style8 style10">Log Off</a> </td> </tr> <tr> <td width="12%"><span class="style8">Empno</span></td> <td colspan="2"><input name="empno" type="text" id="empno"></td> </tr> <tr> <td><span class="style8">Empname</span></td> <td colspan="2"><input name="empname" type="text" id="empname"></td> </tr> <tr> <td colspan="3"><span class="style9"></span><span class="style9"></span></td> </tr> <tr> <td><span class="style9"></span></td> <td colspan="2"><input name="add" type="submit" value="add" id="add" ></td> </tr> </table> <input type="hidden" name="savehid" value="add"> </form> <?php } if (isset($_POST['add'])){ insert(); }else{ form(); } ?> </body> </html> UPDATE PAGE save it as update.php <!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">  </style> </head> <script language="javascript"> function save() { alert(document.form1.savehid.value); document.form1.target="_self"; document.form1.action="insert.php"; document.form1.savehid.value; document.form1.submit(); } function goto() { document.form1.action="insert.php"; document.form1.submit(); } </script> <body> <?php function insert() { include 'connectmysql.php'; $cid=$_POST['cid']; $empno1 = $_POST['empno']; $empname1 = $_POST['empname']; //if(empty($id)) error_message("You need to enter some text in news box!"); //if($id=$ss['empid']) //{ $query = "UPDATE emp set empno='$empno1',empname='$empname1' where empid=$cid"; echo $query; if (!mysql_query($query)) { echo"<form name='form1' method='post'>"; echo "<table border='0'>"; echo "<input type='button' name='Submit' value='Back to Insert' onClick='goto()'>"; echo "</table>"; echo "</form>"; die('Error, Empid Already Exists Please insert Correctly'); } header("Location:insert.php"); //header("Location:http://localhost/insert.php"); } function form(){ include 'connectmysql.php'; $cid=$_POST['cid']; $sql = "SELECT * FROM emp where empid='$cid'"; //$result = mysql_query("SELECT * FROM emp"); $result1 = mysql_query($sql) or die('Error, query failed'); $row = mysql_fetch_array($result1); ?> <form method="post" name="form1"> <input type="hidden" name="cid" value="<?php echo $cid ?>"> <table width="98%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="3"> </td> </tr> <tr> <td width="12%"> </td> <td width="59%"> </td> <td width="29%"><a href="../index.php" class="style8 style10">Log Off</a> </td> </tr> <tr> <td><span class="style8">Empno</span></td> <td colspan="2"><input name="empno" type="text" id="empno" value="<?php echo $row['empno'] ; ?> "></td> </tr> <tr> <td><span class="style8">Empname</span></td> <td colspan="2"><input name="empname" type="text" id="empname" value="<?php echo $row['empname'] ; ?> "></td> </tr> <tr> <td colspan="3"><span class="style9"></span><span class="style9"></span></td> </tr> <tr> <td><span class="style9"></span></td> <td colspan="2"><input name="add" type="submit" value="add" id="add" ></td> </tr> </table> <input type="hidden" name="savehid" value="add"> </form> <?php } if (isset($_POST['add'])){ insert(); }else{ form(); } ?> </body> </html> :-\

Files not working

vinoindiamca posted a topic in PHP Coding Help

When i Try to Update the records Unidentified Offset Error is arised please help me over this.... Create a db called emp Create a table called emp fields are empid int, empno varchar,empname varchar Thanks in advance <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'xxxx'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); //echo "Connected to MySQL<br />"; $dbname = 'emp'; mysql_select_db($dbname); ?> Login Page Save it as index.php <html> <head> <title>PHP</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css">  </style> </head> <script language="javascript"> function goto() { document.form1.action="index.php"; document.form1.submit(); } </script> <script language="javascript"> </script> <body> <?php function insert() { include 'connectmysql.php'; if(($_POST["uname"] == "") || ($_POST["pass"] == "")) { header("Location :index.php"); echo "<script language='javascript' type='text/javascript'>"; echo " alert('Invalid User Name & Password');"; echo "window.location='index.php'"; echo "</script>"; echo"<form name='form1' method='post'>"; echo "<table border='0'>"; echo "<input type='button' name='Submit' value='Back To Login' onClick='goto()'>"; echo "</table>"; echo "</form>"; 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' type='text/javascript'>"; echo " alert('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/PHP/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="33%"> </td> <td width="30%"> </td> <td width="37%"> </td> </tr> <tr> <td colspan="3"><table width="96%" height="31" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="8%"> </td> <td width="1%" bgcolor="#D3D7F8"> </td> <td width="91%" bgcolor="#D3D7F8"><span class="style9"> PHP </span><span class="style9"></span></td> </tr> </table></td> </tr> <tr> <td colspan="3"> </td> </tr> <tr> <td colspan="2"> </td> <td><table width="87%" border="0" cellpadding="0" cellspacing="0" class="tableright"> <tr> <td height="204"> <table width="98%" height="198" border="0" align="center" cellpadding="0" cellspacing="0"> <tr bgcolor="#EDEEFC"> <td height="19" colspan="4"><div align="center"><span class="style1"> </span></div></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19" colspan="4"><div align="center"><span class="style1">Login</span></div></td> </tr> <tr bgcolor="#EDEEFC"> <td width="28%" height="19" class="style6"><div align="right">Username</div></td> <td width="2%" height="19"><div align="left">:</div></td> <td height="19" colspan="2"><input name="uname" type="text" size="25" maxlength="30"></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19" class="style6"><div align="right">Password</div></td> <td height="19"><div align="left">:</div></td> <td height="19" colspan="2"><input name="pass" type="text" size="25" maxlength="30"></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19"> </td> <td height="19"> </td> <td height="19" colspan="2"> </td> </tr> <tr bgcolor="#EDEEFC"> <td height="19" bgcolor="#EDEEFC"> </td> <td height="19"> </td> <td width="11%" height="19"> </td> <td width="59%" height="19"><input type="submit" name="add" value="Login" id="add" ></td> </tr> <tr bgcolor="#EDEEFC"> <td height="19"> </td> <td height="19"> </td> <td height="19" colspan="2"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <input type="hidden" name="login"> </form> <?php } if (isset($_POST['add'])){ insert(); }else{ form(); } ?> </body> </html> SELECT and DELETE PAGE save it as insert.php <!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">  </style> </head> <script language="javascript"> function goto() { document.form1.action="select.php"; document.form1.submit(); } function edit(val) { // alert(val) // win=window.open("","mywin","scrollbars,resizable,static,depedent") document.form1.target="_self"; document.form1.action="update.php"; document.form1.cid.value=val; document.form1.submit(); } </script> <body > <?php include 'connectmysql.php'; //mysql_query($query); //} $rowsPerPage = 10; $pageNum = 1; if(isset($_GET['page'])) { $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT * FROM emp LIMIT $offset, $rowsPerPage"; //$result = mysql_query("SELECT * FROM emp"); $result = mysql_query($query) or die('Error, query failed'); $count=mysql_num_rows($result); ?> <form name="form1" method="post" > <input type="hidden" name="cid" value="<?php echo $row['empid'] ; ?>"> <table width="98%" border="0"> <tr> <td width="11%"> </td> <td width="81%"> </td> <td width="8%"> </td> </tr> <tr> <td colspan="3"> <table width="98%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4" class="style9"><div align="left"><strong>Employee Details </strong></div></td> </tr> <tr class="tableheaderA"> <td width="10%" class="style8">S.No</td> <td width="8%" class="style8"><input name="delete" type="submit" id="delete" value="Delete"></td> <td width="47%" class="style8"> Employee Number </td> <td width="35%" class="style8"> Employee Name </td> </tr> <?php while($row = mysql_fetch_array($result)) { ?> <tr> <td class="style12"> <?php echo $row['empid'] ?> </td> <td class="style12"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['empid']; ?>"></td> <td class="style13"> <a href="javascript:edit('<?php echo $row['empid'] ; ?>')" class="style2"> <?php echo $row['empno'] ; ?> </a> </td> <td class="style14"> <?php echo $row['empname'] ; ?> </td> </tr> <?php } ?> </table> <span class="style8"> </span></td> </tr> <tr> <td colspan="3"><span class="style8"> <?php $query = "SELECT COUNT(*) AS numrows FROM emp"; $result = mysql_query($query) or die('Error, query failed'); $row = mysql_fetch_array($result, MYSQL_ASSOC); $numrows = $row['numrows']; $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; $nav = ''; for($page = 1; $page <= $maxPage; $page++) { if ($page == $pageNum) { $nav .= " $page "; // no need to create a link to current page } else { $nav .= " <a href=\"$self?page=$page\">$page</a> "; } } if ($pageNum > 1) { $page = $pageNum - 1; $prev = " <a href=\"$self?page=$page\">[Prev]</a> "; $first = " <a href=\"$self?page=1\">[First Page]</a> "; } else { $prev = ' [Prev] '; // we're on page one, don't enable 'previous' link $first = ' [First Page] '; // nor 'first page' link } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " <a href=\"$self?page=$page\">[Next]</a> "; $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> "; } else { $next = ' [Next] '; // we're on the last page, don't enable 'next' link $last = ' [Last Page] '; // nor 'last page' link } //echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last; echo $first . $prev . $nav . $next . $last; ?> </span></td> <?php // Check if delete button active, start this if(isset($_POST['delete'])){ if (!empty($_POST['checkbox'])) { foreach($_POST['checkbox'] as $v) { $del_id = mysql_real_escape_string($v); $sql = "DELETE FROM emp WHERE empid ='$del_id'"; mysql_query($sql); echo "<script language='javascript' type='text/javascript'>"; echo "window.location='insert.php'"; echo "</script>"; } } } // if successful redirect to delete_multiple.php mysql_close(); ?> </tr> <tr> <td> </td> <td><input type="button" name="Submit" value="Back to Insert" onClick="goto()"></td> <td> </td> </tr> </table> </form> </body> </html> INSERT PAGE save it as select.php <!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">  </style> </head> <script language="javascript"> function save() { alert(document.form1.savehid.value); document.form1.target="_self"; document.form1.action="insert.php"; document.form1.savehid.value; document.form1.submit(); } function goto() { document.form1.action="select.php"; document.form1.submit(); } </script> <body> <?php function insert() { include 'connectmysql.php'; $id = $_POST['empid']; $empno1 = $_POST['empno']; $empname1 = $_POST['empname']; //if(empty($id)) error_message("You need to enter some text in news box!"); //if($id=$ss['empid']) //{ $query = "INSERT INTO emp (empno,empname) VALUES ('$empno1','$empname1')"; if (!mysql_query($query)) { echo"<form name='form1' method='post'>"; echo "<table border='0'>"; echo "<input type='button' name='Submit' value='Back to Insert' onClick='goto()'>"; echo "</table>"; echo "</form>"; die('Error, Empid Already Exists Please insert Correctly'); } header("Location:insert.php"); //header("Location:http://localhost/insert.php"); } function form(){ ?> <form method="post" name="form1"> <table width="98%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="3"> </td> </tr> <tr> <td colspan="2"> </td> <td width="29%"><a href="../index.php" class="style8 style10">Log Off</a> </td> </tr> <tr> <td width="12%"><span class="style8">Empno</span></td> <td colspan="2"><input name="empno" type="text" id="empno"></td> </tr> <tr> <td><span class="style8">Empname</span></td> <td colspan="2"><input name="empname" type="text" id="empname"></td> </tr> <tr> <td colspan="3"><span class="style9"></span><span class="style9"></span></td> </tr> <tr> <td><span class="style9"></span></td> <td colspan="2"><input name="add" type="submit" value="add" id="add" ></td> </tr> </table> <input type="hidden" name="savehid" value="add"> </form> <?php } if (isset($_POST['add'])){ insert(); }else{ form(); } ?> </body> </html> UPDATE PAGE save it as update.php <!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">  </style> </head> <script language="javascript"> function save() { alert(document.form1.savehid.value); document.form1.target="_self"; document.form1.action="insert.php"; document.form1.savehid.value; document.form1.submit(); } function goto() { document.form1.action="insert.php"; document.form1.submit(); } </script> <body> <?php function insert() { include 'connectmysql.php'; $cid=$_POST['cid']; $empno1 = $_POST['empno']; $empname1 = $_POST['empname']; //if(empty($id)) error_message("You need to enter some text in news box!"); //if($id=$ss['empid']) //{ $query = "UPDATE emp set empno='$empno1',empname='$empname1' where empid=$cid"; echo $query; if (!mysql_query($query)) { echo"<form name='form1' method='post'>"; echo "<table border='0'>"; echo "<input type='button' name='Submit' value='Back to Insert' onClick='goto()'>"; echo "</table>"; echo "</form>"; die('Error, Empid Already Exists Please insert Correctly'); } header("Location:insert.php"); //header("Location:http://localhost/insert.php"); } function form(){ include 'connectmysql.php'; $cid=$_POST['cid']; $sql = "SELECT * FROM emp where empid='$cid'"; //$result = mysql_query("SELECT * FROM emp"); $result1 = mysql_query($sql) or die('Error, query failed'); $row = mysql_fetch_array($result1); ?> <form method="post" name="form1"> <input type="hidden" name="cid" value="<?php echo $cid ?>"> <table width="98%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="3"> </td> </tr> <tr> <td width="12%"> </td> <td width="59%"> </td> <td width="29%"><a href="../index.php" class="style8 style10">Log Off</a> </td> </tr> <tr> <td><span class="style8">Empno</span></td> <td colspan="2"><input name="empno" type="text" id="empno" value="<?php echo $row['empno'] ; ?> "></td> </tr> <tr> <td><span class="style8">Empname</span></td> <td colspan="2"><input name="empname" type="text" id="empname" value="<?php echo $row['empname'] ; ?> "></td> </tr> <tr> <td colspan="3"><span class="style9"></span><span class="style9"></span></td> </tr> <tr> <td><span class="style9"></span></td> <td colspan="2"><input name="add" type="submit" value="add" id="add" ></td> </tr> </table> <input type="hidden" name="savehid" value="add"> </form> <?php } if (isset($_POST['add'])){ insert(); }else{ form(); } ?> </body> </html> (edited by kenrbnsn to add for readability)

Sign In

vinoindiamca

Posts

Joined

Last visited

Content Type

Profiles

Forums

Everything posted by vinoindiamca

[SOLVED] Date Format Problem

PHP Javascript

Working correctly

Files not working

Browse

Activity

Important Information