我是 QueryBuilder 的新手，我正在嘗試執(zhí)行 POST 請(qǐng)求（使用 JSON）來(lái)檢索數(shù)據(jù)庫(kù)中的一些信息。我使用數(shù)組是因?yàn)槊總€(gè)屬性可以有多個(gè)值。這是我當(dāng)前發(fā)送的 JSON：{ "name":["Martin"], "state":["Ohio", "Texas"], "job":["Photographer", "Reporter"]}這是我的數(shù)據(jù)庫(kù)：ID | NAME | FIRST_NAME | STATE | JOB | SPEAK_FRENCH1 | Martin | John | Ohio | Photographer | 12 | Martin | Max | Ohio | Reporter | 13 | Martin | Sophie | Texas | Model | 14 | Alexander | David | Kansas | Author | 05 | Archie | Kira | Maine | Photographer | 16 | Lushen | Albert | Nevada | Pilot, Model | 17 | Wilkins | Minnie | Utah | Tailor | 08 | Martin | Thomas | Texas | Reporter | 19 | Patino | Stephen | Virginia | Pilot, Reporter | 110 | Ting | Maria | Nevada | Dentist | 011 | Brown | Barbara | Virginia | Reporter | 112 | Martin | William | Texas | Photographer | 113 | Zachary | Thomas | Virginia | Telephonist | 1我想要的請(qǐng)求：SELECT * FROM 'application'WHERE SPEAK_FRENCH = 1AND NAME = "Martin"AND STATE = "Ohio"AND JOB LIKE "%Photographer%"OR SPEAK_FRENCH = 1AND NAME = "Martin"AND STATE = "Ohio"AND JOB LIKE "%Reporter%"OR SPEAK_FRENCH = 1AND NAME = "Martin"AND STATE = "Texas"AND JOB LIKE "%Photographer%"OR SPEAK_FRENCH = 1AND NAME = "Martin"AND STATE = "Texas"AND JOB LIKE "%Reporter%"
2 回答
浮云間
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超4個(gè)贊
使用 Doctrine 你可以這樣做：
? ? $queryBuilder = $this->createQueryBuilder('request');
? ? $queryBuilder
? ? ? ? ->andWhere($queryBuilder->expr()->andX(
? ? ? ? ? ? $queryBuilder->expr()->eq('user.speakFrench', ':speakFrench'),
? ? ? ? ? ? $queryBuilder->expr()->like('request.name', ':name'),
? ? ? ? ? ? $queryBuilder->expr()->in('request.state', ':states'),
? ? ? ? ? ? $queryBuilder->expr()->in('request.job', ':jobs'),
? ? ? ? ))
? ? ? ? ->setParameter('speakFrench', true)
? ? ? ? ->setParameter('name', 'Martin')
? ? ? ? ->setParameter('states', ['Ohio', 'Texas'])
? ? ? ? ->setParameter('jobs', ['Photographer', 'Reporter'])
? ? ? ? ->getQuery()
? ? ? ? ->getResult();
這應(yīng)該是一個(gè)好的開(kāi)始。
婷婷同學(xué)_
TA貢獻(xiàn)1844條經(jīng)驗(yàn) 獲得超8個(gè)贊
以下似乎是符合您要求的有效查詢：
SELECT *
FROM application
WHERE SPEAK_FRENCH = 1
AND NAME = "Martin"
AND STATE = IN("Ohio","Texas")
AND (JOB LIKE "%Photographer%" OR JOB LIKE "%Reporter%");
- 2 回答
- 0 關(guān)注
- 153 瀏覽
添加回答
舉報(bào)
0/150
提交
取消