<?php

class studentstb {

public function __construct(){


    $conn=mysql_connect("localhost","root","");

mysql_select_db("testdb",$conn); mysql_set_charset("utf8",$conn); }

public function add_record($a,$b,$c,$d){

mysql_query("insert into student(st_id,st_name,img_name,co_no)values($a,'$b','$c',$d)");

}

public function update_record($a,$b,$c){ if($c==("")){ mysql_query("update student set st_name='$b' where st_id=$a"); } else{ mysql_query("update student set st_name='$b', img_name='$c' where st_id=$a");

}

}

public function del_record($a){

mysql_query("delete from student where st_id=$a");

}