Forums

Hi Bob & Max !

Recap : Using CCV5 to create a listing of static category info from a specially created DB table called 'undatecnames'. On click CCV5 loads a CFV5 form & passes that form the variable 'gcb'. The CFV5 form uses that variable to call in a row from 'undatecnames' as follows :

CFV5 setup :

CFV5 > Setup > On Load > DB Read > Table Name : dbprefix_updatecnames | ModelID : category | Conditions : < ? php return array('id' => $form->data['gcb']); ? >

CFV5 > Setup > HTML (Render Form) > Submit event : submit | Form method : Post

CFV5 > Code > Custom Code :

< ? php
$catid = $form->data['gcb'];
echo "<h4>'Category ID = $catid</h4>"; 
? >

<table style="width:100%;" >
<tbody>
< ? php
foreach ( $form->data['category'] as $p ) {
  echo "<tr>
  <td colspan='2' width='100%' ><h4>Category Name | {$p['name']}</h4></td>
 </tr>
<tr>
  <td style='padding: 8px;' width='27%' >Com_Con db-ID</td>
  <td style='padding: 8px;' width='73%'>{$p['com_con']}</td>
 </tr>
<tr>
  <td style='padding: 8px;' width='27%' >Published 0=Unpub 1=Pub</td>
  <td style='padding: 8px;' width='73%'>{$p['published']}</td>
 </tr>
</tbody>
</table>";
}
? >

< ? php
$pubstate = $form->data['published'];
if ( $pubstate = "1" ) { echo "Current Category State | Published"; } // OK
? >

< ? php
if ( $pubstate = "1" ) 
{ $p['published'] = "0";
echo "  |  $ p-published  |  " . $p['published'] ; // OK - get 0
echo "<input type='hidden' name='category[published]' /><br>
<input class='button' style='background-color:red;' type='submit' value='Un-Publish This Category' /><br>" ;} 
? >  "

(Above - name='category[published]' - I'm not sure that this the value to pass to 'Submit' ? And is this the right way to use 'On Submit' ? Do I need to incorporate the Action Label in some way ?

CFV5 > Setup > On Submit > Custom Code > Action Label : update_cats_now

CFV5 > Setup > On Submit > Custom Code > Content

< ? php

// Update - com_con categories
$query = "
  UPDATE `dbprefix_categories`
    SET
      `title` = '{$form->data['cat_name']}',
      `published` = $form->data['published']
       WHERE `id` = 'com_con' ;
";
$db->setQuery($query);
$save = $db->execute();

? >

As always - any advice / help appreciated.

Cheers Paulzero

Whole story at www.chronoengine.com/forums/posts/t102871/update-4-different-db-tables-with-2-common-values.html