logo
down
shadow

convert select DB::table to array on laravel


convert select DB::table to array on laravel

Content Index :

convert select DB::table to array on laravel
Tag : laravel , By : Helpful Dude
Date : November 29 2020, 09:01 AM

hope this fix your issue You can get array using lists method
$d = DB::table('sps')
                ->select(array('sps.namasp'))
                ->where('namasp','like',$term)
                ->lists("<< value >>","<< key >>");

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Need array instead of object in laravel using raw Query like DB::select("SELECT * FROM table");


Tag : laravel , By : doctorbigtime
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , In laravel when i use DB::select("SELECT * FROM table"); It return a object,but i need a array. So how can i get a array instead of object? , Please Try this one.
\Illuminate\Support\Facades\DB::setFetchMode(PDO::FETCH_ASSOC);
$values=\Illuminate\Support\Facades\DB::select("select * from  your_table");
\Illuminate\Support\Facades\DB::setFetchMode(PDO::FETCH_CLASS);
var_dump($values);

Using array values to select database table in laravel


Tag : arrays , By : Lathentar
Date : March 29 2020, 07:55 AM
it fixes the issue Yes, You should use whereIn for array. In fact, whereIn takes second parameter as array of values for specified column.
Product::whereIn('product_id', $value);

Laravel [QUERY] how to select contents from table 1 where condition must meet in table 2 and table 3


Tag : php , By : lietkynes
Date : March 29 2020, 07:55 AM
I wish did fix the issue. I am stuck in building a query where I need to select items from table 1 if the condition is met on table 2 and table 3. , This isn't tested, but it will be something like the following:
$query = Company::query()
  ->select(['company.name','company.location'])
  ->leftJoin('services', 'services.company_id', '=', 'company.company_id')
  ->leftJoin('date', 'date.service_id', '=', 'services.service_id')
  ->where('services.service_name', $servicename)
  ->where('date.service_date', $servicedate);

convert a nested array to a specific select box in laravel


Tag : php , By : Pancilobak
Date : March 29 2020, 07:55 AM
Any of those help Here is a way to implement this using pure PHP with a recursive function...
First we define the array of categories:
$categories = [
  ['id' => 1, 'name' => 'TV & Home Theather'],
  ['id' => 2, 'name' => 'Tablets & E-Readers'],
  ['id' => 3, 'name' => 'Computers', 'children' => [
    ['id' => 4, 'name' => 'Laptops', 'children' => [
      ['id' => 5, 'name' => 'PC Laptops'],
      ['id' => 6, 'name' => 'Macbooks (Air/Pro)']
    ]],
    ['id' => 7, 'name' => 'Desktops'],
    ['id' => 8, 'name' => 'Monitors']
  ]],
  ['id' => 9, 'name' => 'Cell Phones']
];
function printCats($categories, $parent = NULL) {
    while ($category = array_shift($categories)) {
        $catName = ($parent ? $parent.' &gt;&gt; ' : '').$category['name'];
        print("<option value='{$category['id']}'>{$catName}</option>\n");
        if (isset($category['children']))
            printCats($category['children'], $catName);
    }
}
printCats($categories);
<option value='1'>TV & Home Theather</option>
<option value='2'>Tablets & E-Readers</option>
<option value='3'>Computers</option>
<option value='4'>Computers &gt;&gt; Laptops</option>
<option value='5'>Computers &gt;&gt; Laptops &gt;&gt; PC Laptops</option>
<option value='6'>Computers &gt;&gt; Laptops &gt;&gt; Macbooks (Air/Pro)</option>
<option value='7'>Computers &gt;&gt; Desktops</option>
<option value='8'>Computers &gt;&gt; Monitors</option>
<option value='9'>Cell Phones</option>

Convert table with select fields to js array


Tag : javascript , By : JoeCh
Date : March 29 2020, 07:55 AM
will help you Instead of getting all the table you could get only the selectors using document.getElementsByClassName o document.getElementsByTagName
Then you can iterate (but its NOT an iterable you cannot use map or reduce) and get the selected value of every select.
function extractTable() {
    var tableItems = document.getElementsByClassName("field_select");
    var tableRows = [];       

    for(var i = 0; i<tableItems.length; i++){
      var e = tableItems[i]
      var option = e.options[e.selectedIndex].value;
      console.log(option)
      tableRows.push(option);
    }

    // Create a JSON
    let jsonTable = JSON.stringify(tableRows, null, 2);
    console.log(jsonTable);
};
Related Posts Related QUESTIONS :
  • Laravel 5.8 .env.testing file is not working
  • The following code of laravel in not working in sublime
  • Laravel Passport middleware protected routes "Unauthenticated" problem
  • How can I generate array (for each row) using faker?
  • Windows Laravel update: composer failed to open stream, permission denied
  • How to fix PHP Parse error: syntax error, unexpected '?' in vendor\laravel\framework\src\Illuminate\Foundation\helpers.p
  • Where is the correct place to locate custom functions in Laravel?
  • How to alter all Request in laravel
  • MethodNotAllowedHttpException in RouteCollection
  • one-time payment with Laravel Cashier without subscription
  • Class 'Pusher\Pusher' not found - Laravel 5.8
  • ErrorException (E_NOTICE) Trying to get property 'name' of non-object
  • Laravel if condition is match disable otherwise don't disable
  • How to add fields which are not available in database?
  • How to Optimize Import Process for very large data for Laravel?
  • Laravel 5.8: A facade root has not been set after homestead restart
  • How to display new line on blade when generating PDF using DomPDF?
  • How to return custom response when validation has fails using laravel form requests
  • Password_resets table missing, even after doing php artisan migrate
  • how do i fix error laravel Route not defined
  • How to run schedule tasks every minute in Laravel?
  • Custom storage path per model
  • Laravel blank projects.. so many files! Can it be reduced somehow?
  • GET multiselect selected values
  • Experiencing slow booting times in Laravel
  • How to delete the first row
  • Speed up Eloquent query
  • Date and timestamp format and unique rule
  • How to make a 503 return?
  • "Missing required parameters for [Route: property.edit]" error when editing product
  • Only display selected fields to the view using Laravel Query Builder
  • Custom method not work on HasMany relation
  • How to display data without showing html tags
  • Emitting unnamed compat plugin
  • Composer instalation failed php version conflict
  • Pluck or Something else?
  • How can I catch NotFoundHttpException in laravel to send a custom response?
  • Moodle autologin plugin - how to direct user to a specific course?
  • Laravel does not display uploaded image
  • I get the Object not found error while trying to output all users details from database
  • Vuejs Axios POST request gets HTTP422 error from Laravel backend
  • Problems with Laravel 5.6 Vue.js e o app.js (404)
  • How to call API from controller Laravel without using curl and guzzle as its not working
  • How do I declare a composite primary key in the Lumen Model?
  • "Class 'App\Controllers\controller' not found"
  • How to find only last row from second table, along with its first table row
  • Why did Not working Laravel middleware CORS with Vue.js
  • Vue SPA and Laravel Socialite
  • Vue.js with Laravel Permission
  • "Class 'App\Http\Controllers\Flight' not found"
  • How to expose a image without saving to the public folder of Laravel
  • "Uncaught RangeError: Maximum call stack size exceeded" on very simple Laravel + Vue app
  • Laravel - views folder getting deleted repeatedly
  • How can I make index form resource route out of the middleware?
  • Laravel whereHas not getting any results?
  • How to make Laravel resources when multiple models in output
  • Get field data when user Spout to read Excel file
  • Convert complex SQL query with many joins to Eloquent
  • Return variable from within Laravel Excel Import
  • Redirect "method is not supported for this route"
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com