index.php

<?
session_start();
?>
<?
include("config.php");
$query = "SELECT * FROM user" ;
$result = mysql_query($query,$mycon);
///order by----------------------------------------------------------------
if($count_click1 =$_GET['count1'])
{
///order by customer_name
if ($count_click1%2 == 0)
{$query = "select * from user  order by username " ;}
else
{$query = "select * from user  order by username  DESC";}
}
else if($count_click2 =$_GET['count2'])
{///order by customer_street
if ($count_click2%2 == 0)
{$query = "select * from user order by password " ;}
else
{$query = "select * from user order by password  DESC";}
}
else if($count_click3 =$_GET['count3'])
{///order by customer_city
if ($count_click3%2 == 0)
{$query = "select * from user order by gender " ;}
else
{$query = "select * from user order by gender  DESC";}
}
///delete row
if(isset($_POST['submit']))
{
foreach($_POST['chk']as $name)
{$query = "DELETE FROM user WHERE username = '".$name."'";
  mysql_query($query,$mycon);
}
}
///search word customer_name
$name = $_POST['Search'];
if(isset($_POST['Search-bt'])){
$query = "SELECT * FROM user WHERE username like '$name%' ";
$result = mysql_query($query,$mycon);
}
else $result = mysql_query($query,$mycon);
//search customer_city by list
$gender = $_POST['gender_list'];
if(isset($_POST['Search-2']))
{
    if($gender == 'All'){
$gender = $_POST['gender_list'];
$query = "SELECT * FROM user" ;
}else {
$gender = $_POST['gender_list'];
$query = "SELECT * FROM user where gender = '$gender' ";
}
$result = mysql_query($query,$mycon);
}
?>
<form id="form1" name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  <p>
    <input type="text" name="Search" id="Search" />
    <input type="submit" name="Search-bt" id="Search-bt" value="Search_name" title="ค้นหาชื่อลูกค้า" />
  </p>
  <p>
    <label for="gender_list"></label>
    <select name="gender_list" >
     <option value="All">All</option>
      <option value="femal">หญิง</option>
      <option value="male">ชาย</option>
    </select>
    <input type="submit" name="Search-2" id="Search" value="Select_gender">
  </p>
  <table width="458" border="0">
 <tr>
 <td width="22" bgcolor="#FF9900">&nbsp;</td>
 <td width="26" bgcolor="#FF9900"><strong>Edit</strong></td>
 <td width="115" bgcolor="#FF9900" title="username"><strong><a href=index.php?count1=<?=$count_click1+1?>>Username</a></strong></td>
 <td width="111" bgcolor="#FF9900" title="password"><strong><a href=index.php?count2=<?=$count_click2+1?>>Password</a></strong></td>
 <td width="105" bgcolor="#FF9900" title="gender"><strong><a href=index.php?count3=<?=$count_click3+1?>>Gender</a></strong></td>
 </tr>
 <?
 while($row = mysql_fetch_array($result))
 {
 ?>
 <tr bgcolor="#FFCC66">
 <td><input type="checkbox" name="chk[]" id="chk[]" title="คลิกเลือก"value="<?php echo $row['username'];?>" /></td>
 <td><a href ="update.php?name=<?php echo $row['username'];?>">
   <img src="img/b_edit.png" width="16" height="16" alt="Edit" title="แก้ไข" /></a></td>

 <td><?php echo $row['username'];?></td>
 <td><?php echo $row['password'];?></td>
 <td><?php echo $row['gender'];?></td>
 </tr>
 <?
 }
mysql_close($mycon);
 ?>
 </table>
  <p>
    <input type="submit" name="submit" id="submit" value="Delete" title="ลบ"/>
    <input type="reset" name="reset" id="reset" value="Reset" title="ยกเลิก" />
  </p>
 
</form>
<p><a href="insert.php">ลงทะเบียน</a></p>
<form enctype="multipart/form-data"  id="form1" name="form1" method="post" action="upload.php" >
<input type="file" name="imagefile" />
<input type="submit" name="submit" value="submit" />
</form>