<?php
$sql="SELECT tbreeding . * , sire.callname AS sire_callname, dam.callname AS dam_callname, sire.regname AS sire_regname, dam.regname AS dam_regname
FROM `tblbreeding` tbreeding
LEFT JOIN `tbldogs` sire ON sire.dog_id = tbreeding.sireFK
LEFT JOIN `tbldogs` dam ON dam.dog_id = tbreeding.damFK
LIMIT 0 , 1000";
$rs=$modx->db->query($sql);
$resultArray = $modx->db->makeArray($rs);
//var_dump($resultArray);//for debugging
if (count($resultArray)>0){
$output = '';
foreach($resultArray as $item){
$params['Sire_callname']=$item['sire_callname'];
$params['Dam_callname']=$item['dam_callname'];
$params['id']=$item['id'];
if($item['show']){
$params['show'] = "checked";
} else {
$params['show'] = "";
}
$output.=$modx->parseChunk('Litters', $params, '[+', '+]');
}
}
return($output);
?><?php
function breeding( &$fields ){
global $modx;
$dbTable=array();
$table = $modx->getFullTableName( 'tblbreeding');
$dbTable['id']=$fields['id'];
$dbTable['show']=$fields['show'];
$dbQuery = $modx->db->insert($dbTable, $table );
return true;
}
?>
I’m not sure what your question is. I didn’t see a question mark... what exactly is the problem you’re having?
How do I call the function ’breeding’ passing it the required fields.
global $modx;
$dbTable=array();
$table = $modx->getFullTableName( 'tblbreeding');
$dbTable['id']=$_POST['id'];
$dbTable['show']=$_POST['show'];
$dbQuery = $modx->db->insert($dbTable, $table );
return true;
Fatal error: Call to undefined function adding faq() in E:\wamp\www\Chrys-haefen\assets\snippets\eform\eform.inc.php on line 378

<form action="http://somesite.com/form_handler_page" method="post"> Id: <input type="text" name="id" /> <br /> Show: <input type="text" name="show" /> </form>
global $modx;
$dbTable=array();
$table = $modx->getFullTableName( 'tblbreeding');
$dbTable['id']=$_POST['id'];
$dbTable['show']=$_POST['show'];
$dbQuery = $modx->db->insert($dbTable, $table );
return true;