📁 File Manager

Dosya Düzenle: reciptGenCode1.php

<?php
include 'connect.php';

echo $id = $_GET['id']; //formNo
 $FormStyle = $_GET['form'];
  $pz = $_GET['price'];

$s = "select * from challan  where challan='$id' ";
$q = mysqli_query($con,$s);
 while ($row=mysqli_fetch_array($q)){
   $name=$row['name'];
   $sno=$row['sno'];
   $Phone= $row['phone'];
   $course= $row['course'];
   $price= $row['price'];
   $fNo = $row['formNo'];
 }
 
 $st1 = "select * from bank where course='$course' and amount='$price'"; $qst1 = mysqli_query($con,$st1);if($str1 = mysqli_fetch_array($qst1)){$text	= $str1['text'];}

if($course=='BCA')
 {
 $a = "SELECT * FROM recipt WHERE course = 'BCA'";
 if ($result = mysqli_query($con,$a))
  {
 echo $rowcount = mysqli_num_rows($result)+1;  
       if ($rowcount < 10000) {
        $formattedRowcount = str_pad($rowcount, 2, '0', STR_PAD_LEFT);
          } else {    $formattedRowcount = $rowcount;    }
             echo  "this is the number ".$formattedRowcount;   $twoDigitNumber = "26";    $rollno = $twoDigitNumber . $formattedRowcount;  echo "The concatenated value is: " . $rollno;
            }
 }
 
 
 
 
  else{
      if($course=='BBA')
 {
 $a = "SELECT * FROM recipt WHERE course = 'BBA'";
 if ($result = mysqli_query($con,$a))
  {
 echo $rowcount = mysqli_num_rows($result)+1;  
       if ($rowcount < 10000) {
        $formattedRowcount = str_pad($rowcount, 2, '0', STR_PAD_LEFT);
          } else {    $formattedRowcount = $rowcount;    }
             echo  "this is the number ".$formattedRowcount;   $twoDigitNumber = "266";    $rollno = $twoDigitNumber . $formattedRowcount;  echo "The concatenated value is: " . $rollno;
            }
 }
 
 
 
 
 
 
 
 else{
      if($course=='MLMDT')
 {
 $a = "SELECT * FROM recipt WHERE course = 'MLMDT'";
 if ($result = mysqli_query($con,$a))
  {
 echo $rowcount = mysqli_num_rows($result)+1;  
       if ($rowcount < 10000) {
        $formattedRowcount = str_pad($rowcount, 2, '0', STR_PAD_LEFT);
          } else {    $formattedRowcount = $rowcount;    }
             echo  "this is the number ".$formattedRowcount;   $twoDigitNumber = "264";    $rollno = $twoDigitNumber . $formattedRowcount;  echo "The concatenated value is: " . $rollno;
            }
 }
   
   
   
   
   
   else
   {
       
        if($course=='FPT')
 {
 $a = "SELECT * FROM recipt WHERE course = 'FPT'";
 if ($result = mysqli_query($con,$a))
  {
 echo $rowcount = mysqli_num_rows($result)+1;  
       if ($rowcount < 10000) {
        $formattedRowcount = str_pad($rowcount, 2, '0', STR_PAD_LEFT);
          } else {    $formattedRowcount = $rowcount;    }
             echo  "this is the number ".$formattedRowcount;   $twoDigitNumber = "261";    $rollno = $twoDigitNumber . $formattedRowcount;  echo "The concatenated value is: " . $rollno;
            }
 }
   
    else
    {
    if($course=='BA')

{
 $a = "SELECT * FROM recipt WHERE course = 'BA'";
 if ($result = mysqli_query($con,$a))
  {
 echo $rowcount = mysqli_num_rows($result)+1;  
       if ($rowcount <10000) 
       {
        $formattedRowcount = str_pad($rowcount, 3, '0', STR_PAD_LEFT);
        
         $formattedRowcount= $formattedRowcount+1000;
         if($formattedRowcount>999)
         {
           $twoDigitNumber = "26";
         }
         else{
             $twoDigitNumber = "260";
         }
          
         
                
                } 
            else {    $formattedRowcount = $rowcount;   
                  }
                        $rollno = $twoDigitNumber . $formattedRowcount;  echo "The concatenated value is: " . $rollno;
                 }
          }   
          
          
          
          
          
          
   
    else {
         if($course=='BSC')
 {
 $a = "SELECT * FROM recipt WHERE course = 'BSC'";
 if ($result = mysqli_query($con,$a))
  {
 echo $rowcount = mysqli_num_rows($result)+1;  
       if ($rowcount < 10000) {
        $formattedRowcount = str_pad($rowcount, 3, '0', STR_PAD_LEFT);
          } else {    $formattedRowcount = $rowcount;    }
               $twoDigitNumber = "260";    $rollno = $twoDigitNumber . $formattedRowcount;  echo "The concatenated value is: " . $rollno;
            }
 }
    }
    
       
    }   
       
   }
     }
  }
 
 
 
$randomNumber = rand(10000, 99999);
 //$rollno = rand(10, 99);
$currentDate = date('Y-m-d');
 $sql1 = "INSERT INTO recipt VALUES('$randomNumber','$rollno','$id','$name','$course','$Phone','$price','$text','$currentDate','$fNo')";
if(mysqli_query($con,$sql1)){

$sql12="UPDATE challan SET `status` = 'Paid' WHERE challan.sno = '$sno'";
if(mysqli_query($con,$sql12)){
    echo "doneee";
    
    //roll
    
    $sql15="UPDATE StudentForms SET `rollno` = '$rollno' WHERE StudentForms.FormNo = '$fNo'";
if(mysqli_query($con,$sql15)){
    echo "doneee";
    
    
}
    
   
   $sql151="UPDATE subjects SET `clgroll`= '$rollno'  WHERE subjects.formNo = '$fNo'";
               if(mysqli_query($con,$sql151)){
                                        echo "Rollno added to Subjct table";
                                             }
   
    
    
    
}
 
 
 
  $s12 = "select * from bank where course = '$FormStyle' and amount= '$pz' ";
                        $q12 = mysqli_query($con,$s12);
                        if ($formSt = mysqli_fetch_array($q12))
                        {
                              echo $type= $formSt['remarks'];
                               header("location:bcaRecipt.php?id=$id");
                        }
    
    
    
    
   
//header("location:reciptGenCode.php?id=$randomNumber");
	}
	else{
		echo "Data already submited ";
}

İptal