Forms +database+maps

gul123

yes i do have those categories setup is working but the category section in your module for locations is not working, when i add a category by clicking add button it pop up a form for categories and add successfully but not showing in drop down....

gul123

$config['module_overwrites']['categories']['hidden'] = FALSE; // change to FALSE if you want to use the generic categories module
$config['module_overwrites']['tags']['hidden'] = FALSE; // change to FALSE if you want to use the generic tags module

/*********************** /OVERWRITES ************************************/

$config['modules']['categories'] = array();

gul123

+HOW I CAN MAKE DROPDOWN IN THE FORM WHICH WILL HAVE THE NAME OF CITIES,,,,,ETC

admin

For the dropdowns to show up, they need the context value of "locations" (note the where condition in the locations_model.php file for the $foriegn_key parameter).

gul123

sorry i could not understand it

gul123

function find_location($where)
{
$this->db->select('locations.*, '.$this->_tables['fuel_categories'].'.slug as category, '.$this->_tables['fuel_categories'].'.slug as category_slug');
$data = $this->locations_model->find_all_array($where);
$i = 1;
foreach($data as $k => $v)
{
$data[$k]['markerText'] = "{$i}";
$i++;
}

gul123

yes i got it ....now showing successfully......and now i want to add some fields e.g dropdown i know about textfield but how dropdown......

gul123

and now when i select the dropdown for categories near search field it says .............
A Database Error Occurred

Error Number: 1054

Unknown column 'locations.category' in 'where clause'

admin

That DB error looks to be a bug that I will need to look into.

gul123

okz.....

gul123

please guide me how to create dropdown in location creation form e.g like i want to show all cities of a specific country in dropdown and i want to populate dropdown from database...plus how can i change the orders of the fields in the form

admin

For modifying the locations form, you'll need to modify the locations_model::form_fields method. In your case, you'll want to change the "cities" field to a dropdown. To do that, I'd do something like this:
function form_fields($values = array(), $related = array()) { $fields = parent::form_fields($values, $related); $fields['latitude']['comment'] = 'This value will automatically be generated by Google\'s geolocation service if the address is legit'; $fields['longitude']['comment'] = 'This value will automatically be generated by Google\'s geolocation service if the address is legit'; $my_array_of_cities = array('city1' => 'city1', 'city2' => 'city3'); $fields['city'] = array('type' => 'select', 'options' => $my_array_of_cities); // if you want to pull the options from a model //$fields['city'] = array('type' => 'select', 'model' => 'my_city_model'); return $fields; }

gul123

Yes i got it ......and done it Thanks a lot......One thing more is it true if i want to change the fields order in form i have to change the order in table in mysql if not then how i can do this
and second thing i am using categories in location form as a province and its working nicely but i want to change the Category label to Province in filter records area.....
and plus i am successful in showing map ....but i want to highlight

admin

First, the fix for the category dropdown in the list view is to replace line 10 in the locations_fuel_module.php file with the following (note the key is changed from "category" to "fuel_categories:id"):
'filters' => array('fuel_categories:id' => array('type' => 'select', 'label' => 'Category', 'model' => 'fuel_categories', 'model_params' => array('id', 'name', array('context' => 'locations')), 'first_option' => 'Select a category...'))

To change the label, you add the "label" => "Province" to the locations_model::form_fields method like so:
... $field['category']['label'] = 'province'; ... return $fields;

gul123

Thanks a lot yes its done now....
now i want to use same this type of form to be use on front end so user can add locations from front end that form will have captcha as well to avoid spam....how i can do that please guide me
Bundle of Thanks for your guidelines....

gul123

i have read your this tutorial but there is no clear where to create controller and where to create view and how to call form in view ...my bad luck not getting it

onegun

you can create controller at fuel/application/controllers folder, using normal class will do

e.g.

Class Categories extends CI_Controller{
function Categories(){
parent::__construct();
$this->load->database();//for you talk to database
}
function view(){
$vars=array();
$this->fuel->pages->render('categories',$vars);
}
}

you can create views at fuel/application/views
as render above mentioned file name to be "categories", you create another categories.php as view file

that is it. you may need to set routing for it, though.

gul123

how i can do things in view ,how to call or show something ...@onegun

onegun

u see my example above, inside function view() there is a $vars array, put your varaible name inside , e.g. $vars['category']=array('fruit','meat');

then inside your views, you can access the variables by doing

foreach($category as $c) echo $c;

gul123

okz let me try

gul123

Parse error: syntax error, unexpected T_STRING\fuel\application\controllers\categories.php on line 2

when i put as u directed
in view that is categories.php i have
<?php

foreach($category as $c) {
echo $c;
}


?>

gul123

solved the above issue and now giving ....

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: category

Filename: core/Loader.php(332) : eval()'d code

Line Number: 3
....@onegun

onegun

did you put i$vars['category'] in your controller?

also you need to do $this->fuel->pages->render('categories',$vars); in your view function. If still cant get the result try in your view

foreach($vars['category'] as $c)

gul123

still same
Message: Undefined index: category

onegun

post all your codes+filename, so we can take a look

gul123

okz
This is controller in application/controllers/categories
?php
Class Categories extends CI_Controller{
function Categories(){
parent::__construct();
$this->load->database();//for you talk to database
}
function view(){
$vars['category']=array('fruit','meat');
//$this->fuel->pages->render('categories',$vars);
$this->fuel->pages->render('categories',$vars);
}
}
and this is view....in application/views/categories
<?php

foreach($vars['category'] as $c){
echo $c;

}


?>

onegun

i think the problem may because you did not set the route, you can set routing at routes.php
meanwhile, to solve this problem in this particular case without the need of setting route.

change function view(){} in controller to

function index(){
$vars['category']=array('fruit','meat');
//$this->fuel->pages->render('categories',$vars);
$this->fuel->pages->render('categories',$vars);
}

gul123

thanks for your help.....
Well i did ask some queries from admin. waiting for his kind reply

gul123

i want to create same form like i have locations form in admin to add locations for frond end how i can do this please guide me

archienorman11

@admin, could I please get a copy of this module to test? Thanks,