Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add JOIN clause #24

Open
iamludal opened this issue Oct 28, 2021 · 6 comments
Open

Add JOIN clause #24

iamludal opened this issue Oct 28, 2021 · 6 comments
Labels
enhancement New feature or request

Comments

@iamludal
Copy link
Owner

Ideas of usage:

->select('*')
->from('users u')
->join('profile p', ['u.id = p.userId']) 

join($table, $conditions)

@iamludal iamludal added the enhancement New feature or request label Oct 28, 2021
@hugo-leij
Copy link

He @iamludal,

Is this function on your roadmap?

@iamludal
Copy link
Owner Author

iamludal commented Nov 4, 2022

Hi @hugo-leij, I no longer actively maintain this project, but I can implement this function if you need it.

@hugo-leij
Copy link

hugo-leij commented Nov 4, 2022

Hi, @iamludal

Thats the only thing I miss in the query builder. So that will be great!

@iamludal
Copy link
Owner Author

iamludal commented Nov 4, 2022

Alright @hugo-leij, I will work on it then, and keep your informed when it is out. :)

@hugo-leij
Copy link

Quick question: How do I connect to mysli?

$mysqli = new mysqli("localhost","root","pass","db");
$qb = new QueryBuilder($mysqli);

@iamludal
Copy link
Owner Author

iamludal commented Nov 4, 2022

You can't, the library only works with PDO. See https://github.com/iamludal/mysql-querybuilder#getting-started

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants