Thursday 18 April 2013
Edit funtion in PHP
<?php
error_reporting(0);
include("db.php");
$editId;
if($_REQUEST['id'] != ""){
$id = $_REQUEST['id'] ;
$GLOBALS[$editId] = $id;
}
?>
<!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=utf-8" />
<title>Edit Document</title>
<script type="text/javascript">
function editDone(){
<?php
$id = $_REQUEST['name'];
$email = $_REQUEST['email'];
$password = $_REQUEST['password'];
echo "id = $id + email = $email + pass = $password";
?>
}
</script>
</head>
<body>
<table>
<tr>
<td>Name</td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" /></td>
</tr>
<tr>
<td>
<input type="submit" value="Edit Record" onclick="editDone();" />
</td>
</tr>
</table>
</body>
</html>
error_reporting(0);
include("db.php");
$editId;
if($_REQUEST['id'] != ""){
$id = $_REQUEST['id'] ;
$GLOBALS[$editId] = $id;
}
?>
<!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=utf-8" />
<title>Edit Document</title>
<script type="text/javascript">
function editDone(){
<?php
$id = $_REQUEST['name'];
$email = $_REQUEST['email'];
$password = $_REQUEST['password'];
echo "id = $id + email = $email + pass = $password";
?>
}
</script>
</head>
<body>
<table>
<tr>
<td>Name</td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" /></td>
</tr>
<tr>
<td>
<input type="submit" value="Edit Record" onclick="editDone();" />
</td>
</tr>
</table>
</body>
</html>
Code for Database Connection confirmation PHP+HTML
<html>
<head>
<title> web page 2</title>
</head>
<body>
<?php
error_reporting(0);
$con=mysql_connect("localhost","root","");
if($con){
mysql_select_db('one',$con);
echo "connection successfully";
}
else{
echo "connection fail";
}
$id=$_REQUEST['id'];
$name=$_REQUEST['name'];
$email=$_REQUEST['email'];
$password=$_REQUEST['password'];
$query="INSERT INTO `db1`.`one` (`id`, `name`, `email`, `password`) VALUES (NULL, '$name', '$email', '$password'); ";
$r = mysql_query($query);
if($r)
{echo "inserted";}
else
{echo "error";}
?>
</body>
</html>
<head>
<title> web page 2</title>
</head>
<body>
<?php
error_reporting(0);
$con=mysql_connect("localhost","root","");
if($con){
mysql_select_db('one',$con);
echo "connection successfully";
}
else{
echo "connection fail";
}
$id=$_REQUEST['id'];
$name=$_REQUEST['name'];
$email=$_REQUEST['email'];
$password=$_REQUEST['password'];
$query="INSERT INTO `db1`.`one` (`id`, `name`, `email`, `password`) VALUES (NULL, '$name', '$email', '$password'); ";
$r = mysql_query($query);
if($r)
{echo "inserted";}
else
{echo "error";}
?>
</body>
</html>
Database connect with php
<?php
error_reporting(0);
include("db.php");
if($_REQUEST['id'] != ""){
$id = $_REQUEST['id'] ;
$del = "delete from one where id = $id";
$dd = mysql_query($del);
}
$q = "select * from one;";
$res = mysql_query($q);
?>
<html>
<head>
<title>3rd page</title>
</head>
<body>
<table border="2" cellpadding="2" cellspacing="2">
<tr>
<td>ID</td>
<td>Name</td>
<td>Email</td>
<td>Password</td>
<td>Delete</td>
<td>Edit</td>
</tr>
<?php
while($row = mysql_fetch_array($res)){
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['password']; ?></td>
<td><button onClick="return confirm('Are you shure to delete Record No :<?php echo $row['id']; ?>')" href="DatabaseConnect.php?id=<?php echo $row['id']; ?>">Delete</button></td>
<td><a href="Edit.php?id=<?php echo $row['id']; ?>">Edit</a></td>
</tr>
<?php } ?>
</table>
</body>
</html>
error_reporting(0);
include("db.php");
if($_REQUEST['id'] != ""){
$id = $_REQUEST['id'] ;
$del = "delete from one where id = $id";
$dd = mysql_query($del);
}
$q = "select * from one;";
$res = mysql_query($q);
?>
<html>
<head>
<title>3rd page</title>
</head>
<body>
<table border="2" cellpadding="2" cellspacing="2">
<tr>
<td>ID</td>
<td>Name</td>
<td>Email</td>
<td>Password</td>
<td>Delete</td>
<td>Edit</td>
</tr>
<?php
while($row = mysql_fetch_array($res)){
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['password']; ?></td>
<td><button onClick="return confirm('Are you shure to delete Record No :<?php echo $row['id']; ?>')" href="DatabaseConnect.php?id=<?php echo $row['id']; ?>">Delete</button></td>
<td><a href="Edit.php?id=<?php echo $row['id']; ?>">Edit</a></td>
</tr>
<?php } ?>
</table>
</body>
</html>
MOnte Carlito tool simulation
Tool for monte carlo provided by sir umer (ITPM)
MonteCarlito 1.10 --- Free Excel Tool for Monte Carlo Simulation
Subscribe to:
Posts (Atom)