Advertisement
faisalmukhtarch

Untitled

Jun 17th, 2015
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.22 KB | None | 0 0
  1. //This part is working
  2. <?php
  3.         $vbCrLf = chr(13).chr(10);
  4.         error_reporting(0);
  5.     // open connection to MySQL server
  6.     $link = mysqli_connect("localhost", "root", "root", "print")
  7.     or die ('Unable to connect!');
  8.                    
  9.                    
  10.     //create and execute query
  11.     $query = "SELECT  bin, iban, bename, benadd, bcoun, bcode, bname, badd FROM datee";
  12.     $result = mysqli_query($link,$query);
  13.                    
  14.     //create selection list
  15.     $DropDownList .= "<select name='Company' id='DropDownListId' onchange='javascript:SelectChanged();'> ".$vbCrLf;
  16.     $DropDownList .= "<option value=''></option> ".$vbCrLf;
  17.                    
  18.     while($row = mysqli_fetch_row($result))
  19.     {
  20.         $heading = $row[0];
  21.         $DropDownList .= "<option value='$heading'>$heading</option> ".$vbCrLf;
  22.        
  23.  
  24.         $IbnArrayPhp .= 'IbnArray["'.$heading.'"]="'.$row[1].'";'.$vbCrLf;
  25.         $BenameArrayPhp .= 'BenameArray["'.$heading.'"]="'.$row[2].'";'.$vbCrLf;
  26.         $BenaddArrayPhp .= 'BenaddArray["'.$heading.'"]="'.$row[3].'";'.$vbCrLf;
  27.         $BcounArrayPhp .= 'BcounArray["'.$heading.'"]="'.$row[4].'";'.$vbCrLf;
  28.         $BcodeArrayPhp .= 'BcodeArray["'.$heading.'"]="'.$row[5].'";'.$vbCrLf;
  29.         $BnameArrayPhp .= 'BnameArray["'.$heading.'"]="'.$row[6].'";'.$vbCrLf;
  30.         $BaddArrayPhp .= 'BaddArray["'.$heading.'"]="'.$row[7].'";'.$vbCrLf;
  31.     }
  32.     $DropDownList .= "</select> ".$vbCrLf;
  33.       ?>
  34.  
  35.  
  36. <script language="Javascript" type="text/javascript">
  37.     var IbnArray = new Array();
  38.     <?php echo $IbnArrayPhp; ?>
  39.     var BenameArray = new Array();
  40.     <?php echo $BenameArrayPhp; ?>
  41.     var BenaddArray = new Array();
  42.     <?php echo $BenaddArrayPhp; ?>
  43.     var BcounArray = new Array();
  44.     <?php echo $BcounArrayPhp; ?>
  45.     var BcodeArray = new Array();
  46.     <?php echo $BcodeArrayPhp; ?>
  47.     var BnameArray = new Array();
  48.     <?php echo $BnameArrayPhp; ?>
  49.     var BaddArray = new Array();
  50.     <?php echo $BaddArrayPhp; ?>
  51.     function SelectChanged()
  52.     {
  53.         var Company = document.getElementById('DropDownListId').value;
  54.         document.getElementById('iban').value = IbnArray[Company];
  55.         document.getElementById('bename').value = BenameArray[Company];
  56.         document.getElementById('benadd').value = BenaddArray[Company];
  57.         document.getElementById('bcoun').value = BcounArray[Company];
  58.         document.getElementById('bcode').value = BcodeArray[Company];
  59.         document.getElementById('bname').value = BnameArray[Company];
  60.         document.getElementById('badd').value = BaddArray[Company];
  61.  
  62.     }
  63. </script>
  64.         <?php echo $DropDownList; ?>
  65. </label>
  66. </legend>
  67.  
  68. //This part is not working
  69. <?php
  70.         $vbCrLf1 = chr(13).chr(10);
  71.         error_reporting(0);
  72.     // open connection to MySQL server
  73.     $link1 = mysqli_connect("localhost", "root", "root", "print")
  74.     or die ('Unable to connect!');
  75.                    
  76.                    
  77.     //create and execute query
  78.     $query1 = "SELECT  aini, acname, acnum, num2, num3 FROM datee";
  79.     $result1 = mysqli_query($link1,$query1);
  80.                    
  81.     //create selection list
  82.     $DropDownList1 .= "<select name='Company1' id='DropDownList1Id' onchange='javascript:SelectChanged();'> ".$vbCrLf1;
  83.     $DropDownList1 .= "<option value=''></option> ".$vbCrLf1;
  84.                    
  85.     while($row1 = mysqli_fetch_row($result1))
  86.     {
  87.         $heading1 = $row1[0];
  88.         $DropDownList1 .= "<option value='$heading1'>$heading1</option> ".$vbCrLf1;
  89.        
  90.  
  91.         $AcnameArrayPhp .= 'AcnameArray["'.$heading1.'"]="'.$row1[1].'";'.$vbCrLf1;
  92.         $AcnumArrayPhp .= 'AcnumArray["'.$heading1.'"]="'.$row1[2].'";'.$vbCrLf1;
  93.         $Num2ArrayPhp .= 'Num2Array["'.$heading1.'"]="'.$row1[3].'";'.$vbCrLf1;
  94.         $Num3ArrayPhp .= 'Num3Array["'.$heading1.'"]="'.$row1[4].'";'.$vbCrLf1;
  95.  
  96.     }
  97.     $DropDownList1 .= "</select> ".$vbCrLf1;
  98.       ?>
  99.  
  100.  
  101. <script language="Javascript" type="text/javascript">
  102.     var AcnameArray = new Array();
  103.     <?php echo $AcnameArrayPhp; ?>
  104.     var AcnumArray = new Array();
  105.     <?php echo $AcnumArrayPhp; ?>
  106.     var Num2Array = new Array();
  107.     <?php echo $Num2ArrayPhp; ?>
  108.     var Num3Array = new Array();
  109.     <?php echo $Num3ArrayPhp; ?>
  110.  
  111.  
  112.     function SelectChanged()
  113.     {
  114.         var Company1 = document.getElementById('DropDownList1Id').value;
  115.         document.getElementById('acname').value = AcnameArray[Company1];
  116.         document.getElementById('acnum').value = AcnumArray[Company1];
  117.         document.getElementById('num2').value = Num2Array[Company1];
  118.         document.getElementById('num3').value = Num3Array[Company1];
  119.  
  120.  
  121.  
  122.     }
  123. </script>
  124.         <?php echo $DropDownList1; ?>
  125. </label>
  126. </legend>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement