auto generate student id, php function

pls i want php function that will generate student id like dms/15/01 serially, when entering new records, i want it to show in student reg_number column in registration form so that in can be inserted into database with the rest of information entered manually by the student.
thank you

Jan 5 '16 #1

Subscribe Post Reply

5727

zmbd

5,501

Expert Mod 4TB

ahmad233, what have you tried so far?

People are more willing to help when you've shown that you've already made the attempt at solving the task at hand.

Also, you provide absolutely no information for the basis of the "student id"

Jan 5 '16 #2

ahmad233

i just want to make student registration form, i want student id field to generate student id like dm"department"/16"year"/001"serial number"
here is the code

Expand|Select|Wrap|Line Numbers

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Essence Schools SIS</title>

<style type="text/css">

.topborder {

    background-color: #FFFFFF;

    height: 4cm;

    width: 22.251cm;

    border-top-style: solid;

    border-right-style: solid;

    border-bottom-style: solid;

    border-left-style: solid;

    border-top-color: #FF0;

    border-right-color: #FF0;

    border-bottom-color: #FF0;

    border-left-color: #FF0;

    font-size: 50px;

    font-family: "Comic Sans MS", cursive;

    color: #FFCC00;

    position: absolute;

    background-image: none;

    background-position: 12cm 12cm;

}

.topborder {

    text-align: center;

    position: absolute;

    vertical-align: baseline;

    font-family: "Lucida Sans Unicode", "Lucida Grande", sans-serif;

    left: 216px;

    top: 11px;

    border-top-style: solid;

    border-right-style: solid;

    border-bottom-style: solid;

    border-left-style: solid;

    border-top-color: #FF0;

    border-right-color: #FF0;

    border-bottom-color: #FF0;

    border-left-color: #FF0;

}

.centerborder {

    height: auto;

    width: 843px;

    border-top-style: solid;

    border-right-style: solid;

    border-bottom-style: solid;

    border-left-style: solid;

    border-top-color: #FF0;

    border-right-color: #FF0;

    border-bottom-color: #FF0;

    border-left-color: #FF0;

    position: absolute;

    left: 216px;

    top: 176px;

}

body {

    background-color: #FFF;

}

#apDiv1 {

    position:absolute;

    width:815px;

    height:138px;

    z-index:1;

    left: 6px;

    top: 9px;

}

#apDiv2 {

    position:absolute;

    width:434px;

    height:219px;

    z-index:1;

    left: 209px;

    top: 96px;

    color: #003;

    background-color: #CCC;

    font-weight: bold;

}

.centerborder #apDiv2 #form1 label {

    color: #003;

}

.form1 {

    background-color: #FFF;

    border-top-color: #D6D6D6;

    border-right-color: #D6D6D6;

    border-bottom-color: #D6D6D6;

    border-left-color: #D6D6D6;

}

#apDiv3 {

    position:absolute;

    width:428px;

    height:71px;

    z-index:2;

    left: 215px;

    top: 29px;

}

middleapdev {

    font-size: 36px;

}

.centerborder #apDiv3 p {

    color: #003;

    font-size: 24px;

    font-weight: bold;

}

#apDiv4 {

    position:absolute;

    width:478px;

    height:53px;

    z-index:1;

    left: 385px;

    top: 186px;

}

#apDiv5 {

    position:absolute;

    width:284px;

    height:254px;

    z-index:2;

    left: 273px;

    top: 77px;

}

#apDiv6 {

    position:absolute;

    width:691px;

    height:115px;

    z-index:1;

}

.centerborder #apDiv6 #form1 {

    font-weight: bold;

}

.contententpersonalinfor {

    margin-top: 15px;

    margin-left: 15px;

}

.centerborder #form1 fieldset table tr td {

    text-align: right;

}

.centerborder #form1 fieldset table tr td {

    text-align: center;

}

.centerborder #form1 fieldset table tr td {

    text-align: right;

}

.centerborder #form1 fieldset table tr td {

    text-align: justify;

}

.centerborder #form1 fieldset table tr td {

    text-align: right;

}

.centerborder #form1 fieldset table tr td {

    font-size: 16px;

}

.centerborder #form1 fieldset table tr td {

    font-size: 13px;

}

</style>

</head>
 
<body>

<div class="topborder"><img src="img/ess header.jpg" width="829" height="150" alt="ESSENCE SCHOOL" />

  <p>&nbsp;</p>

</div>

<p>&nbsp;</p>

<p>&nbsp;  </p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<div id="apDiv4"><a href="menu.php" target="_self"><img src="img/home.PNG" alt="" name="HOME" width="100" height="50" id="HOME" /></a><a href="student regis.php" target="_self"><img src="img/enter rec.PNG" alt="" name="rec" width="120" height="50" id="rec" /></a><a href="view records.php" target="_self"><img src="img/view rec.PNG" alt="" name="view" width="120" height="50" id="view" /></a><a href="#" target="_self"><img src="img/schl fees.PNG" alt="" name="sch" width="120" height="50" id="sch" /></a></div>

<p>&nbsp;</p>

<div class="centerborder">

  <p>&nbsp;</p>

  <p>&nbsp;</p>

  <form name="reg" action="code_exec.php" onsubmit="return validateForm()" method="post" enctype="multipart/form-data">

<table width="274" border="0" align="center" cellpadding="2" cellspacing="0">

  <tr>

    <td colspan="2">

        <div align="left">
 
         <script type="text/javascript">

function validateForm()

{

var a=document.forms["reg"]["regno"].value;

var b=document.forms["reg"]["surname"].value;

var c=document.forms["reg"]["firstname"].value;

var d=document.forms["reg"]["other"].value;

var e=document.forms["reg"]["datepicker"].value;

var f=document.forms["reg"]["stateoforigin"].value;

var g=document.forms["reg"]["lga"].value;

var h=document.forms["reg"]["gender"].value;

var i=document.forms["reg"]["disability"].value;

var j=document.forms["reg"]["datepicker2"].value;

var k=document.forms["reg"]["class"].value;

var l=document.forms["reg"]["photo"].value;

var m=document.forms["reg"]["pname"].value;

var n=document.forms["reg"]["occupation"].value;

var o=document.forms["reg"]["contact"].value;

var p=document.forms["reg"]["address"].value;

if ((a==null || a=="") && (b==null || b=="") && (c==null || c=="") && (d==null || d=="") && (e==null || e=="") && (f==null || f=="") && (g==null || g=="") && (h==null || h=="") && (i==null || i=="") && (j==null || j=="") && (k==null || k=="")&& (l==null || l=="") && (m==null || m=="") && (n==null || n=="") && (o==null || o=="") && (p==null || p==""))

  {

  alert("All Field must be filled out");

  return false;

  }

if (a==null || a=="")

  {

  alert("regno must be filled out");

  return false;

  }

if (b==null || b=="")

  {

  alert("surname must be filled out");

  return false;

  }

if (c==null || c=="")

  {

  alert("first name must be filled out");

  return false;

  }

if (d==null || d=="")

  {

  alert("other must be filled out");

  return false;

  }

if (e==null || e=="")

  {

  alert("date of birth must be filled out");

  return false;

  }

if (f==null || f=="")

  {

  alert("state of origin must be filled out");

  return false;

  }

if (g==null || g=="")

  {

  alert("lga must be filled out");

  return false;

  }

if (h==null || h=="")

  {

  alert("gender must be filled out");

  return false;

  }

  if (i==null || i=="")

  {

  alert("disability must be filled out");

  return false;

   }

  if (j==null || j=="")

  {

  alert("date of addmission must be filled out");

  return false;

  }

  if (k==null || k=="")

  {

  alert("class must be filled out");

  return false;

  }

  if (l==null || l=="")

  {

  alert("passport must be inserted");

  return false;

   }

  if (m==null || m=="")

  {

  alert("parent name must be filled out");

  return false;

   }

  if (n==null || n=="")

  {

  alert("parent occupation must be filled out");

  return false;

   }

  if (o==null || o=="")

  {

  alert("parent phone number must be filled out");

  return false;

   }

  if (p==null || p=="")

  {

  alert("address be filled out");

  return false;

  }

}
 
</script>
 
  <form name="reg" action="code_exec.php" onsubmit="return validateForm()" method="post" enctype="multipart/form-data">

    <fieldset>

      <legend>PERSONAL INFORMATION</legend>

      <table width="781" height="174" border="0">

      <tr> <td width="136">REG. NO:</td>

          <td> <label for="regno"></label>

            <input type="text" name="regno" id="regno" /><?php echo $regno; ?></td>

          </tr>

        <tr>

          <td width="135">SURNAME:</td>

          <td> <label for="surname"></label>

            <input type="text" name="surname" id="surname" /></td>

          <td width="113"> FIRST NAME:</td>

          <td width="150"><label for="firstname"></label>

          <input type="text" name="firstname" id="firstname" /></td>

          <td width="58">OTHER:</td>

          <td width="149"><label for="other"></label>

          <input type="text" name="other" id="other" /></td>

        </tr>

        <tr>

          <td>DATE OF BIRTH:</td>

             <td><link href="jquery-ui_themes_smoothness.css" rel="stylesheet" type="text/css" />

<script src="http://code.jquery.com/jquery-1.9.1.js"></script>

<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>

<link rel="stylesheet" href="/resources/demos/style.css" />
 
<script type="text/javascript">

$(document).ready(function() {

$( "#datepicker" ).datepicker({ minDate: -90000, maxDate: "90Y+1M+7D",

changeMonth: true, changeYear: true,

numberOfMonths:1,

dayNamesMin: ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'],

dateFormat:"yy/mm/dd",

showAnim:"drop" });//fold, slide, blind, bounce, slideDown, show, fadeIn, clip.

});

</script><label for="datepicker"></label>

          <input type="text" name="datepicker" id="datepicker" /></td>

          <td>STATE OF ORIG:</td>

          <td><label for="stateoforigin"></label>

          <input type="text" name="stateoforigin" id="stateoforigin" /></td>

          <td>L.G.A:</td>

          <td><label for="lga"></label>

          <input type="text" name="lga" id="lga" /></td>

        </tr>

        <tr>

          <td>GENDER:</td>

          <td><label for="gender"></label>

          <input type="text" name="gender" id="gender" /></td>

          <td>DISABILITY:</td>

          <td><label for="disability2"></label>

          <input type="text" name="disability" id="disability2" /></td>

        </tr>

        <tr>

          <td>DATE OF ADMISS:</td>

          <td><link href="jquery-ui_themes_smoothness2.css" rel="stylesheet" type="text/css" />

<script src="http://code.jquery.com/jquery-1.9.1.js"></script>

<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>

<link rel="stylesheet" href="/resources/demos/style.css" />
 
<script type="text/javascript">

$(document).ready(function() {

$( "#datepicker2" ).datepicker({ minDate: -90000, maxDate: "90Y+1M+7D",

changeMonth: true, changeYear: true,

numberOfMonths:1,

dayNamesMin: ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'],

dateFormat:"yy/mm/dd",

showAnim:"drop" });//fold, slide, blind, bounce, slideDown, show, fadeIn, clip.

});

</script><label for="datepicker2"></label>

          <input type="text" name="datepicker2" id="datepicker2" /></td>

          <td>CLASS ADMITT:</td>

          <td><label for="class"></label>

          <input type="text" name="class" id="class" /></td>

          </tr>               

      </table> 

              <table width="444" border="0">

        <tr>

          <td <label> Upload Passport</label>

           <input type="hidden" name="size" value="350000">

           <input type="file" name="photo"> 

        </tr>

      </table>
 
        <table width="510" border="0">

          <tr>

            <td>NAME OF PARENT/GUARDIAN :</td>

            <td><label for="pname"></label>

            <input type="text" name="pname" id="pname" /></td>

          </tr>
 
          <p>&nbsp;</p>

          <tr>

            <td>PARENT/GUARDIAN OCCUPATION:</td>

            <td><label for="occupation"></label>

            <input type="text" name="occupation" id="occupation" /></td>

          </tr>

          <tr>

            <td> PARENT/GUARDIAN PHONE NO:</td>

            <td><label for="contact"></label>

              <input type="text" name="contact" id="contact" /></td>

          </tr>

          <tr>

            <td> PARENT/GUARDIAN ADDRESS:</td>

            <td>    <label for="address"></label>

              <input type="text" name="address" id="address" /></td>

          </tr>

        </table>
 
      <p>&nbsp;</p>

    </fieldset>

    <p>

        <tr>

                <td><div align="center"></div></td>

                <td><input name="submit" type="submit" value="Submit" /></td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

              </tr>

     </p>

</form>

  <p>&nbsp;</p>

</div>

<p>&nbsp;</p>

</body>

</html>
 
here is the php processing file
 
  <?php 

  if (isset($_POST['mop']))

  {

     $regno=$_POST['regno']; 

     $cclass=$_POST['cclass'];

     $term=$_POST['term'];

     $datepicker3=$_POST['datepicker3']; 

      $mop=$_POST['mop'];

      $details=$_POST['details'];

       $amount=$_POST['amount'];

        $outstanding=$_POST['outstanding'];
 
     $link=mysql_connect("localhost","root","rurumtown2012") or die("Cannot Connect to the database!");
 
     mysql_select_db("essence_sis", $link) or die ("Cannot select the database!");

     $query=("INSERT INTO fee (regno, cclass, term, date, mop, details, amount, outstanding) values

     ('".$regno."', '".$cclass."', '".$term."', '".$datepicker3."', '".$mop."', '".$details."', '".$amount."', '".$outstanding."')");

     }
 
          if(!mysql_query($query,$link))

          {die ("An unexpected error occured while saving the record, Please try again!");}

          else

         {

          echo "New record saved successfully!";

          }

          header("location: enterfees.php?remarks=success");
 
mysql_close($con);
 
?>

Jan 5 '16 #3

zmbd

5,501

Expert Mod 4TB

and what is it that your code is doing or not doing - we appreciate that you have the script; however, parsing thru 445 lines of scripting is a bit much to ask...
+ Where in the script is the "student id" being generated?
>> At some point you are going to have to connect to the MySQL server and pull the last serial number.
>> Where are you getting the department information?
>>> What criteria are you using the shorten the department name to its initials, will you need to connect to the database to pull that information too?

+ What is the script actually generating (or not :) )?

Jan 5 '16 #4

Similar topics

auto generate second primary key

by: Sebastien | last post by:

Hi, I am building a products database, linking sales and production. Each part has a unique sales Stock Code and Production Number. The sales stock code is a combination of letters and numbers...

Microsoft Access / VBA

auto generate claim no

by: SalimShahzad | last post by:

Dear Gurus, i had written following codes to auto generate the next claim no Private Const strC = "GCT/02/J/" Private Sub Command1_Click() Dim stra, stre As String Dim intb, intd As Integer...

Microsoft Access / VBA

Auto generate datasets from DB

by: SPG | last post by:

Hi, I am new to C#, and was wondering if there is an easy way to auto generate a Dataset and the relevant classes (IE: Adapter for updating etc) by pointing a wizard at the db? I am sure...

C# / C Sharp

Auto-generate data forms

by: popsovy | last post by:

I am new to the discussion groups and to the .NET world, so this is probably a very basic question.. Is there any quick way in .NET to auto-generate data forms from typed datasets or SQL queries?...

ASP.NET

How to auto generate interface implementations

by: Bill Rust | last post by:

I've created an "Add Item" wizard for VB.NET 2003 that allows a user to add a specialized class that works with my application framework. In the wizard, the user can select the interfaces they...

Visual Basic .NET

Using Auto-Generate Fields with Gridview, how to set column alignment???

by: gwhite1 | last post by:

I am using the auto-generate fields option because my query can be different based on what the user selects. But I would still like to set the column alignment but I can;t seem to access the...

ASP.NET

Auto generate a directory listing?

by: dougawells | last post by:

Hi - I'm hoping for help with the auto-generation of a hyperlinked listing of all files in a directory. The server I use does not auto-generate this. So, when someone comes to this directory and...

Javascript

auto generate password

by: ganesh22 | last post by:

hi... I am doing a project asp.net with C#.my requirement I want to do auto generate password for my application that means when user forget his password when he clicks a link it will auto...

.NET Framework

How to auto generate the name of the user who is logged in?

by: ivyG | last post by:

How do you auto generate the name of the user who is logged in? For example, I had a Detail View to allow the user to insert the data, and i have a column named "Teacher In Charge 1". I wish...

ASP.NET

auto generate number in asp.net which is auto add in sql server table with other data

by: Jagdish Patil | last post by:

I have project in asp.net with sql server backend. i want to auto generate a number for particular column. with the auto generated number i want to insert some other data in the same row same...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General