Untitled

<!DOCTYPE html>
<html>
<body>

<form action='aa.php' method="post">
  Name:<br>
  <input type="text" name="name"> <br>
  Ic:<br>
 <input type="text" name="ic">   <br>
  Program: <br>
  <input type="radio" name="program" value="Diploma Akaun"> Diploma Akaun<br>
  <input type="radio" name="program" value="Diploma Seni"> Diploma Seni<br>
  <input type="submit" name="submit1" value="Hantar">
</form>

</body>
</html>


<?php
//jika klik submit baru coding ini akan running
if(isset($_POST['submit1']))
{

  $name = '';
  $ic = '';
  $program = '';

$name = $_POST['name'];
$ic = $_POST['ic'];
$program = $_POST['program'];

$mysql_hostname='localhost';
$mysql_user='root';
$mysql_password='';
$mysql_database='a';

$connect_db = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect to database");
mysql_select_db($mysql_database, $connect_db ) or die("could not select database");


$insert = mysql_query("INSERT INTO `biodata` (`ast_id`, `ast_matric`,`ast_name`, `ast_icno`, `ast_program`) VALUES (NULL, '', '$name', '$ic', '$program')");


//ambil 1 row dari table database, eg ambil izzat
$sql = "SELECT *  FROM biodata WHERE ast_icno='$ic' ";
$result=mysql_query($sql);
$data = mysql_fetch_array($result);


//tukar 1 kepada 001
$number = $data['ast_id'];;
$number = sprintf('%03d',$number);


//tukar program kepada program code
$program = $data['ast_program'];

if($program == 'Diploma Akaun')
{
  $program_code = 'C01';
}

else if ($program == 'Diploma Seni')
{
  $program_code = 'C02';
}

else {}


//date eg 16
$date = date("y");

//gabung jd no matric student
$matric_num = 'Z'.$date.$program_code."(".$number.")";


//sql query untuk update matric num dalam database biodata
$result = mysql_query("UPDATE biodata SET ast_matric='$matric_num'  WHERE ast_icno='$ic' ");


//sql query to select all data to be display
$sql2 = "SELECT *  FROM biodata ";
$result2=mysql_query($sql2);

?>
//display table
<table border="1">
  <tr>
    <td> Matric No </td>
    <td> Name </td>
    <td> Ic </td>
    <td> Program</td>
  </tr>
  <?php
  while($data2 = mysql_fetch_array($result2))
  {
  ?>
  <tr>
    <td> <?php echo $data2['ast_matric']; ?> </td>
    <td> <?php echo $data2['ast_name']; ?></td>
    <td><?php echo $data2['ast_icno']; ?> </td>
    <td> <?php echo $data2['ast_program']; ?></td>
  </tr>
  <?php
  }
  ?>
</table>

<?php


}


?>