Coding webpage
Posted: Sun Oct 14, 2007 9:02 am
Code: Select all
<?php
require_once('db.php');
$act=$_GET['act'];
$id=$_GET['id'];
if($act=='insert')
{
$username=$_POST['username'];
if(empty($username))
$error='Please enter username';
if(!empty($error))
{
$act='form';
}
else
{
if(empty($id) && empty($error))
$query=mysql_query("UPDATE userlist SET username='$username' WHERE id=$id");
else
$query=mysql_query("Insert INTO userlist SET username='$username'");
if(!empty($query) && !empty($id)) $message='Updated';
elseif(!empty($query) && empty($id)) $message='Inserted';
}
}
if($act=='delete')
{
$query=mysql_query("DELETE FROM username WHERE id=$id");
if($query) $message='Deleted';
}
if($act=='form')
{
if(!empty($id))
{
$query=mysql_query("SELECT username FROM userdetails WHERE id=$id");
$fetch_details=mysql_fetch_array($query);
$username=$fetch_details['username'];
}
$form="<form method='post' action='userdet.php?act=insert&id=$id'>
<input type='text' name='username' value='$username'>
<input type='submit' name='submit' value='submit'>
</form>";
}
if($act=='page')
{
// paging
}
echo "<table><tr><td>$message $error</td></tr><tr><td>$form</td></tr></table>";
?>