</option>
<?php
}
}
?>
</select>
</div>
<?php
}
?>
<div class="col">
<?php
$aql = "blog_category {\n\t\t\t\t\t\tname\n\t\t\t\t\t\torder by name asc\n\t\t\t\t\t}\n\t\t\t\t\tblog_website on blog_category.blog_id = blog_website.blog_id {\n\t\t\t\t\t\twhere website_id = {$website_id}\n\t\t\t\t\t}";
$dropdown = array('select_name' => 'cat_ide', 'value_field' => 'blog_category_ide', 'option_field' => 'name', 'selected_value' => $_GET['cat_ide'], 'null_option' => 'All Categories', 'onchange' => 'this.form.submit();');
aql::dd($aql, $dropdown);
?>
</div>
<div class="clear"></div>
</div>
</form>
<?php
snippet::tabs($tabs);
?>
<div id="gridcontent">
<?php
aql::grid($aql_blog_title, $col, $param);
<hr>
<div>host: <pre>skyphp.org</pre></div>
<div>db name: <pre>dev_db</pre></div>
</div>
<div id = "sql" class = 'col'>
<h3>SQL:</h3>
<textarea cols="100" rows="20" id="sql_statement"></textarea>
</div>
<?php
$code_aql = "sky_codebase {\n\t\t\t\t\tname as codebase\n\t\t\t\t}";
$code_p = array('select_name' => 'codebase', 'value_field' => 'codebase', 'option_field' => 'codebase', 'null_option' => '- codebase -', 'selected_value' => '');
?>
<div id = "options" class = 'col'>
<div>Codebase:</div>
<div><?php
aql::dd($code_aql, $code_p);
?>
</div>
<div><input name = "execute" type = "button" onclick = "execute()" value = "Execute" id = "execute" /></div>
<div id = "output"></div>
</div>
</div>
<div id = "previous-runs">
<?php
#require_once('/pages/dev/db-version-control/ajax/previous-runs.php');
?>
</div>
<div class = "clear"></div>
</div>
<?php
<?php
if (!$blog_article) {
$blog_article['blog_ide'] = $_POST['blog_ide'];
}
$aql = "blog_category{\n\t\t\t\tname,\n\t\t\t\tslug\n\t\t\t\twhere blog_ide = {$blog_article['blog_ide']}\n\t\t\t\torder by name asc\n\t\t\t}";
aql::dd($aql, array('onchange' => 'if($(\'option:selected\',this).val())insert_tag($(\'option:selected\',this).text(),true)', 'select_name' => 'blog_category_ide', 'selected_value' => $blog_article['blog_category_ide'], 'value_field' => 'blog_category_ide', 'option_field' => 'name', 'null_option' => 'Select Blog Category'));
<?php
$i = $_POST['i'];
$j = $_POST['j'];
$market_aql = "market{\n name as market_name\n where market.primary=1\n order by name asc\n }";
$market_dropdown = array('select_name' => "assignment_{$i}_market_ide_{$j}", 'value_field' => 'market_ide', 'option_field' => 'market_name', 'null_option' => '- Market -');
aql::dd($market_aql, $market_dropdown);
<div>
<?php
$i = $_POST['i'] + 1;
$j = -1;
$blog_aql = "blog{\n name as blog_name\n where active=1\n order by name asc\n }";
$blog_dropdown = array('select_name' => "assignment_{$i}_blog_ide", 'value_field' => 'blog_ide', 'option_field' => 'blog_name', 'null_option' => '- Blog -');
aql::dd($blog_aql, $blog_dropdown);
?>
<script type='text/javascript'> var bas_i_<?php
echo $i;
?>
_j = 0; </script><input id='blog_author_assignment_add_market_<?php
echo $i;
?>
' type='button' value='Add New Market' onclick='add_new_market(<?php
echo $i;
?>
,bas_i_<?php
echo $i;
?>
_j++,this.id);' /><?php
?>
</div>
