Comments (3)
@KarelWintersky
Just add second argument overrideDefault to select()
->select("a.id, a.title, a.cdate", true)
from fluentpdo.
... and no any info at readme... :-(
from fluentpdo.
If you don't want everything from the table, use ->select(null)
, this was documented in the past.
$query = new \Envms\FluentPDO\Query($this->pdo);
$query = $query
->from('articles AS a')
->select(null)
->select("a.id, a.title, a.cdate")
->where("a.s_hidden = 0")
->where("a.s_draft = 0")
->leftJoin("articles_keys AS ak ON ak.aid = a.id")
->orderBy("a.cdate DESC")
->groupBy("a.id");
var_dumo( $query->getQuery() );
from fluentpdo.
Related Issues (20)
- Tables aliases broken ? HOT 3
- how i can use left join in foreach?
- PHP 8.0 support HOT 3
- Add params to SELECT method HOT 2
- Website not working HOT 1
- The select examples don't work HOT 1
- The ->fetchAll() can be used to put the result in a variable? HOT 1
- The fluent PDO passes parameters by "prepare" and "bindValue" to avoid sql injection? HOT 2
- Insert: lastval is not yet defined HOT 1
- Feature request: INSERT SELECT support
- PHP 8.1 Return type compatibility deprecation notices
- BETWEEN Method? HOT 2
- Undefined class constant 'PDO::FETCH_DEFAULT' HOT 1
- Use an object instead of an array for the update and insertInto function
- Error with %d format symbol inside select clause HOT 3
- Any news on 3.0? HOT 6
- Memory leak on multiple inserts/selects with big content HOT 1
- JSON data type support
- Cannot delete from tables with multiple primary keys HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from fluentpdo.