dataflow1117@gmail.com
FacebookTwitter

en English
af Afrikaanssq Albanianam Amharicar Arabichy Armenianaz Azerbaijanieu Basquebe Belarusianbn Bengalibs Bosnianbg Bulgarianca Catalanceb Cebuanony Chichewazh-CN Chinese (Simplified)zh-TW Chinese (Traditional)co Corsicanhr Croatiancs Czechda Danishnl Dutchen Englisheo Esperantoet Estoniantl Filipinofi Finnishfr Frenchfy Frisiangl Galicianka Georgiande Germanel Greekgu Gujaratiht Haitian Creoleha Hausahaw Hawaiianiw Hebrewhi Hindihmn Hmonghu Hungarianis Icelandicig Igboid Indonesianga Irishit Italianja Japanesejw Javanesekn Kannadakk Kazakhkm Khmerko Koreanku Kurdish (Kurmanji)ky Kyrgyzlo Laola Latinlv Latvianlt Lithuanianlb Luxembourgishmk Macedonianmg Malagasyms Malayml Malayalammt Maltesemi Maorimr Marathimn Mongolianmy Myanmar (Burmese)ne Nepalino Norwegianps Pashtofa Persianpl Polishpt Portuguesepa Punjabiro Romanianru Russiansm Samoangd Scottish Gaelicsr Serbianst Sesothosn Shonasd Sindhisi Sinhalask Slovaksl Slovenianso Somalies Spanishsu Sudanesesw Swahilisv Swedishtg Tajikta Tamilte Teluguth Thaitr Turkishuk Ukrainianur Urduuz Uzbekvi Vietnamesecy Welshxh Xhosayi Yiddishyo Yorubazu Zulu

DataInFlow
DataInFlow
A Market place of programming
  • Home
  • Tutorial
    • HTML Tutorial
    • PHP TUTORIAL
  • Article
    • Technology
    • Entertainment and News
    • Game
    • Recipes
  • Queries
  • Programming
    • HTML
    • CSS
    • jQuery
    • JavaScript
    • WordPress
    • PHP
    • Codeigniter
    • Laravel
    • Ionic
    • Angular JS
    • Node JS
    • Vue JS
    • Android
    • ASP .NET
  • Sports
    • Cricket
    • Football
    • Football Live Score
  • Web Tools
  • Home
  • Tutorial
    • HTML Tutorial
    • PHP TUTORIAL
  • Programming
  • Queries
  • Sports
    • Cricket
    • Football
    • Football Live Score
  • Article
    • Entertainment and News
    • Technology
    • Recipes
    • Game
  • Web Tools
  • About Us
  • Contact

How to use where condition when get data from database in codeigniter

1612 viewsOctober 18, 2019php
0
Manik Chatterjee0 Posted June 30, 2017

I am using codeigniter and I get the value from database table use where clause and with descending order. I want to select all data with where condition and descending order, I dont know what’s is the code I am using for it. Please give the helping code and solve it.

0 Comments

6 Answers

  • Active
  • Voted
  • Newest
  • Oldest
1 2 Next »
0
Kate Madiltan (anonymous) Posted October 18, 2019

Hi, I can help you with that, you can use conditions and statements when you want to compare or perform any function between two values. Programming is a bit difficult for everyone especially for beginners who don’t know anything about coding but this https://studyclerk.com/help-with-research-paper article also very helpful in this case. Thank you for writing an attractive post.

0 Comments
0
asd (anonymous) Posted October 16, 2019

Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. clash royale kostenlose gems

0 Comments
0
Brooke Bardsley (anonymous) Posted October 16, 2019

Hi, I can help you with that, you can use conditions and statements when you want to compare or perform any function between two values. Programming is a bit difficult for everyone especially for beginners who don’t know anything about coding. Thank you for writing an attractive post.

0 Comments
0
Jimmie (anonymous) Posted August 7, 2019

That’s so useful. Thanks fireboy and watergirl

0 Comments
0
Shyam SJ (anonymous) Posted May 26, 2018

Simple you can use WHERE clause to get resulr from database in Codeigniter. Follow this example.
$this->db->select(‘*’)->from(‘gallery’);
$this->db->where(‘column name’,$value);
$this->db->get();
If you want to get result using WHERE and LIKE in codeigniter then follow below example.
$this->db->select(‘*’)->from(‘gallery’);
$this->db->where(“column name LIKE ‘%$search_name%'”);
$this->db->get();
If you want to select records BETWEEN two dates then you need to follow this example code.
$this->db->select(‘*’)->from(‘Table Name’);
$this->db->where(“DATE_FORMAT(add_date,’%m’) BETWEEN ‘$start_month’ AND ‘$end_month’ “)
$this->db->get()->result();

0 Comments
1 2 Next »
Write your answer.
Register or Login
Question and answer is powered by AnsPress.io
Subscribe to our Newsletter
Search anything
Questions
What is the best editor/IDE for php? 5 Answers | 0 Votes
how to search similar names given by 2 or 3 words ? 11 Answers | 0 Votes
How is the answer coming 1 Answer | 0 Votes
How to set a session variable in laravel 5.2 3 Answers | 0 Votes
How to change input placeholder name using jquery? 2 Answers | 0 Votes
Recent Programming Article
  • Menu hide from sidebar in ionic 3
    June 30, 2017
  • Generate bootstrap modal in angular 6
    June 30, 2017
  • Load more results functionality with jQuery , Ajax and PHP
    June 30, 2017
  • Facebook login with JavaScript SDK
    June 30, 2017
  • Facebook login in Codeigniter and MySQL
    June 30, 2017
Hire us

Hi
Do you want to make web application with php and php framework(CI, Laravel)? Want to make android application with hybrid framework ? Then contact with us. We provide support for developing website and web application at very affordable price.
E-Mail us at: dataflow1117@gmail.com

Recent Technlogy News
  • Astrology Software: Perfect Tool for Astrologers to Earn Money Online
    June 30, 2017
  • Actionable Steps to Secure Workplace for Dummies
    June 30, 2017
  • The Best Spy Glasses in 2019 You Can Buy now
    June 30, 2017
© Copyright 2017-2018 DataInFlow

About Us    Privacy policy    Contact us

Login

Lost your password?

Reset Password

Log in