How to use joomla connection on custom code

Dear all,


I have custom code on submit event. I was created it based on this topic http://www.chronoengine.com/forums/posts/f2/t100399/automatic-numeric-field.html?hilit=generate+number . We know that the code explain connection. Create a new connection even on same database. My question is, how to use joomla connection on this custom code, so I don't have to changes each form if I move to another server or mysql connection.

Thank you.

Hi Yudhizth,

Use the Joomla! database methods. My macro is a bit out of date but still works with Joomla! 3

$db = \JFactory::getDBO();
$query = "
    SELECT ``
        FROM `#__`
        WHERE `` = '' ;
";
$db->setQuery($query);
//$data = $db->loadObjectList();
//$data = $db->loadResult();
$reuslt = $db->execute();
. . .
?>

Bob

Thank you Bob,

I have been try to use your advice. But I still confused with my own code.

This is original code

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "jom";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Koneksi Error: " . mysqli_connect_error());
}

$sql="SELECT max(id) FROM tbl_chronoengine_chronoforms_datatable_generate_number WHERE 1";
$resultado = mysqli_query($conn, $sql);

 if(mysqli_num_rows($resultado) > 0){
  while ($linha = mysqli_fetch_assoc($resultado)) {
   
   $ma = $linha["max(id)"];
   $ma++;
   //
   if(strlen($ma)=='1')
					{
				$ma=(string)$ma;
				$ma='00000'.$ma;
					}
				elseif(strlen($ma)=='2')
					{
				$ma=(string)$ma;
				$ma='0000'.$ma;
					}
				elseif(strlen($ma)=='3')
					{
				$ma=(string)$ma;
				$ma='000'.$ma;
					}
				elseif(strlen($ma)=='4')
					{
				$ma=(string)$ma;
				$ma='00'.$ma;
					}
				elseif(strlen($ma)=='5')
					{
				$ma=(string)$ma;
				$ma='0'.$ma;
					}
   //
  if ($form->data['jns_izin'] = "JAR") {
  $jnsizin=10;
  }else if ($form->data['jns_izin'] = "JAS") {
  $jnsizin=11;
  }else if ($form->data['jns_izin'] = "SUS") {
  $jnsizin=12;
  }else if ($form->data['jns_izin'] = "NOM") {
  $jnsizin=13;
  }
  
  // ---------//
  
  if ($form->data['katizin'] = "NAS") {
  $katizin=100;
  }else if ($form->data['katizin'] = "PRO") {
  $katizin=101;
  }else if ($form->data['katizin'] = "KOT") {
  $katizin=102;
  }else if ($form->data['katizin'] = "IPR") {
  $katizin=103;
  }else if ($form->data['katizin'] = "PIR") {
  $katizin=104;
  }else if ($form->data['katizin'] = "ULO") {
  $katizin=105;
  }
  
  
    
  
 
    $mn = $jnsizin.$katizin.$ma;
   
            $form->data["kode"] = $mn;
    }
 }

 else {
 echo "No result";
}
 mysqli_close($conn);
?>

and this is code with Joomla! JFactory

<?php

$db = JFactory::getDBO();
$query = "SELECT max(id) FROM tbl_chronoengine_chronoforms_datatable_generate_number WHERE 1;";
$db->setQuery($query);

$db->setQuery($query);
$db->query();
$num_rows = $db->getNumRows();
$result = $db->loadRowList();

 if($num_rows > 0){
  while ($linha = $result) {
   //
   $ma = $linha["max(id)"];
   $ma++;
   //
   if(strlen($ma)=='1')
					{
				$ma=(string)$ma;
				$ma='00000'.$ma;
					}
				elseif(strlen($ma)=='2')
					{
				$ma=(string)$ma;
				$ma='0000'.$ma;
					}
				elseif(strlen($ma)=='3')
					{
				$ma=(string)$ma;
				$ma='000'.$ma;
					}
				elseif(strlen($ma)=='4')
					{
				$ma=(string)$ma;
				$ma='00'.$ma;
					}
				elseif(strlen($ma)=='5')
					{
				$ma=(string)$ma;
				$ma='0'.$ma;
					}
   // 
  if ($form->data['jns_izin'] = "JAR") {
  $jnsizin=10;
  }else if ($form->data['jns_izin'] = "JAS") {
  $jnsizin=11;
  }else if ($form->data['jns_izin'] = "SUS") {
  $jnsizin=12;
  }else if ($form->data['jns_izin'] = "NOM") {
  $jnsizin=13;
  }
  
  // ---------//
  
  if ($form->data['katizin'] = "NAS") {
  $katizin=100;
  }else if ($form->data['katizin'] = "PRO") {
  $katizin=101;
  }else if ($form->data['katizin'] = "KOT") {
  $katizin=102;
  }else if ($form->data['katizin'] = "IPR") {
  $katizin=103;
  }else if ($form->data['katizin'] = "PIR") {
  $katizin=104;
  }else if ($form->data['katizin'] = "ULO") {
  $katizin=105;
  }
   
 
    $mn = $jnsizin.$katizin.$ma;
   
            $form->data["code"] = $mn;
    }
 }

 else {
 echo "nenhum resultado";
}
 mysqli_close($conn);
?>

When I click submit, it only loading page and without any result.

Maybe I miss something?

Thank you

Hi Yudhizth,

$db->query(); // this isn't needed (and would be $db->execute(); in Joomla! 3 )
$num_rows = $db->getNumRows();
$result = $db->loadRowList(); // I don't think this is a valid method 

Bob