Category : codeigniter

database table_img for better understanding Pardon me for weak English writing my sql query that i am getting value,low_value,high_value and limit_exceded_. issue is in limit_exceded to not get correct values, it shows all 0. SELECT `myvalues`.`value`, `sub_types`.`low_value`, `sub_types`.`high_value`, (case when myvalues.value > sub_types.low_value and myvalues.value < sub_types.high_value then 1 else 0 end) as limit_exceded FROM ..

Read more

I have to display those table columns(racipe:table) which is linked to parent table(product). this is my code below. this function is in product model function get_product_by_url($url_slug_product) { $this->db->select(‘recipe_title,recipe_image,category_name,product_name, url_slug_product, product_image, url_slug, product_subname’); $this->db->join(‘category’,’product_category_id = category_id’,’left’); $this->db->join(‘recipe’,’product_id = recipe_product_id’,’left’); $query = $this->db->get_where(‘product’, array(‘url_slug_product’ => $url_slug_product), 1); return $query; } function get_recipes(){ $this->db->select(‘recipe_id,recipe_title,recipe_image,product_id,product_name’); $this->db->from(‘recipe’); $this->db->join(‘category’,’recipe_category_id = category_id’,’left’); ..

Read more

I am building a docker collection that will eventually have the following containers (and more) web (nginx) proxy (reverse proxy nginx) php-fpm the web will have the allowance for several frameworks to be added via folders and subfolders ./folder1/folder2/codeigniter ./folder3/folder4/laravel the folders for codeigniter and laravel are symlinks to a public folder the index.php page ..

Read more

alert(getDistanceFromLatLonInKm($(‘[name="showp"]’).val(),$(‘[name="showp"]’).val()).toFixed(1)); should pass value something like this alert(getDistanceFromLatLonInKm(31.5952599,74.3526989,59.3293371,13.4877472).toFixed(1)); i have 2 input fields 1 input field is use to get user current location(latlong) and 2nd input is stored in db(lat long) <input type="text" placeholder="Enter Cordinates Only" name="location_url_ot"> <input type="text" value="{{ $customer->customer->location_url }}" name="showp" > using this code i am geting user curent location function getLocation() ..

Read more

i am storing some values in db according to some conditions code $getDistanceValue = ($this->getDistance($order) * 1.37); $prev_orders = Order::where(‘id’ , ‘<‘ , $order->id)->where(‘customer_id’ , $order->customer_id)->orderBy(‘id’ , ‘desc’)->get(); $prev_order = $prev_orders[0]; if($getDistanceValue * 1000 > 500){ if($prev_order->chk_ord_vst == 0) { $order->chk_ord_vst = 1; } elseif($prev_order->chk_ord_vst != 0){ $set_ord_check = $prev_order->chk_ord_vst + 1; } } elseif($getDistanceValue ..

Read more