title: Auto generate id, stud_id for table
body: <p>I have a database table with id, stud_id, stud_info I know how to auto increment id but i also want stud_id to be auto incremented with something like <code>STU000001</code> Is it possible to do using only php and then insert it in database?
  Stud_id should be equals id with STU and 6 digit including id.</p>