1. Home
2. php - Complicated condition of getting from database

769 votes

0 answers

php - Complicated condition of getting from database

Get the solution ↓↓↓

I want get line_id from my lines_stations table:

This is timetable search so I have from form station_from_id and station_to_id.

My search function is here:

public function search($station_from_id, $station_to_id) {
    $stations = array($station_from_id, $station_to_id);

    $this->db->from('lines_stations');
    $this->db->where_in('station_id', $stations);
    $q = $this->db->get();
    $lines_stations = $q->result();

    return $q->result();
}
Copy code

This return me all row from lines_stations where station_id is station_from_id or station_to_id but I need get only these where order is correctly - for example:

• station_from_id = 2
• station_to_id = 1

I should get only this:

I haven't idea how to do this.

I'm using CodeIgniter 3.

Undefined asked

2021-12-1

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-1

Link To Source
Link To Answer People are also looking for solutions of the problem: git was not found in your path, skipping source download

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

261 php - Check if a variable has been set with the name of the value of another variable

640 php - Use mysql_fetch_array() with foreach() instead of while()

238 Laravel php artisan shows error of JWT

608 php - Filter content from mysql db with checkboxes using jQuery?

924 php - How to json_decode an json array received from JavaScript?

452 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

318 php - Getting "Call to undefined function: 'define': in phalanger web site

50 php - WooCommerce: Custom function adding free product - Cart page getting broken for orders up to 3000

236 php - Cakephp 2.8.4 ignoring hasMany

999 PHP running out of memory when uploading to s3 bucket - Laravel 5.2

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

CodeIgniter

CodeIgniter is a framework that is known for requiring a minimum amount of customization to get it up and running. This allows those who choose it to work at a good pace. It has been updated many times since its inception in 2006. Now the most recent version is 4.0.3.
https://www.codeigniter.com/