imanilchaudhari/json-file-search.php

Last active June 10, 2022 10:23

Star (2) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/imanilchaudhari/1fc53815d3c53bfa43858c44d526f71a.js"></script>
Save imanilchaudhari/1fc53815d3c53bfa43858c44d526f71a to your computer and use it in GitHub Desktop.

Download ZIP

Yii2 filter from JSON field example

Raw

json-file-search.php

<?php $item = FileMeta::find()->where("JSON_EXTRACT(data, '$.user_id') = {$user_id} and JSON_EXTRACT(data, '$.type') = 'video'")->andWhere(['key' => 'showcase'])->one(); ?>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment