hippo_ajax_form_exec.php

use form to access different mysql database

<?php
  header("Cache-Control", "no-cache");
  header("Pragma", "no-cache");
  header("Expires", "-1");
  
  /*session*/
  session_start();
  if(session_is_registered("david_session"))
  {
    $_SESSION['david_session']++;
  }
  else
  {
    session_register("david_session");
    $_SESSION['david_session'] = 0;
  }
  
  /*require*/
  require('hippo_ajax_form_func.php');
  require('classes/hippo_sql_query.php');
  require('DBVar.php');
  
  /* Submit Data*/
  if(isset($_POST['aryFormData']))
  {
    $aryFormData = $_POST['aryFormData'];
    /*
    echo 'debug='.$aryFormData['text1'][0].'<br>';
    */
    if($aryFormData['server'][0]=='' || $aryFormData['loginID'][0]=='' || $aryFormData['loginPWD'][0]=='' || $aryFormData['dbName'][0]=='' || $aryFormData['dbTable'][0]=='')
    {
      echo 'Error: plz fill all data...';
      exit();
    }
    else
    {
      if($connection_method=="mysql")
      {
        $my_sql1 = new hippo_sql_query($connection_method,$aryFormData['server'][0],$aryFormData['dbName'][0],$aryFormData['loginID'][0],$aryFormData['loginPWD'][0],$dbPort);
        $sql_stmt1 = "SELECT * FROM ".$aryFormData['dbTable'][0];
        if($res_1 = $my_sql1->query_exec($sql_stmt1, "4"))
        {
          foreach ($res_1 as $key => $value )
          {
            foreach ($value as $key2 => $value2 )
            {
              echo $key.'=>'.$value2.'<br>';
            }
          }
        }
        else
        {
          echo 'Error: can NOT access Database.';
        }
        
      }
    } 
  }
  else /*Else: if(isset($_POST['aryFormData']))*/
  {
  } /*End: if(isset($_POST['aryFormData']))*/
  
  
?>