73 questions
0
votes
0
answers
35
views
Trigger Datatables search after reload
I have a datatables table setup
Mainpage.php
new DataTable('.dataTable',{
"pageLength" : 100,
scrollCollapse: true,
scrollY: '500px',
"bPaginate": false,
...
- 2,518
0
votes
1
answer
42
views
Middleware to have one user using its own database
I'm starting a SaaS and to avoid having a too big database, and to help for debugging, I would like each user to use its own database, without duplicating the laravel app.
I have been suggesting using ...
- 1,277
2
votes
0
answers
38
views
Including Current Date in Header of Exported DataTable in Laravel DataTables
I am using Laravel with the Laravel DataTables package. I have added the export button to the DataTable, but I need to include the current date at the top of the page
var dtconfig = {
dom:
...
- 17
2
votes
1
answer
120
views
Server does not return JSON
In development, the server returns JSON. But in production it does not return JSON. I found that in production, browser does not send X-Requested-With header.
In development - Note the X-Requested-...
- 53
1
vote
1
answer
114
views
Laravel datatables pass two instance in one view
I am attempting to send two instances of DataTables to my view. The scenario involves having a tab menu with each tab containing a corresponding table. Here is the approach I have taken.
My controller
...
- 1,219
0
votes
1
answer
91
views
Yajara DataTable Filtration
Hey There Developers ,
I Am using Yajara Data Table Package for handling My Data .Now I am trying to add a filter that should give me the data based on the date Selected (I don't want the date Range ...
- 33
0
votes
1
answer
60
views
Export data into excel laravel
<table>
<thead>
<tr style="font-size: 16px;">
<th>approval_no</th>
<th>pnr</th>
<th>airline</th>
...
- 107
0
votes
0
answers
32
views
table.ajax.json().input not showing in server
I am using Yajra Datatable (https://yajrabox.com/docs/laravel-datatables/10.0)
In my local If I use console.log(table.ajax.json()) I can get table.ajax.json().input and base on this data I perform ...
- 737
0
votes
0
answers
734
views
Yajra datatable Search is not working when "serverSide: true"
When "serverSide: true" then the search option works not perfectly.
My table has 5000+ records, I'm using "serverSide: true" for fast data load, but the search not working. Again ...
1
vote
0
answers
284
views
Incomplete json response in a large eloquent-collection's ajax request
I'm having an error in my Laravel 8 app which uses yajra/laravel-datatables-oracle with server-side rendering, and I can't figure it out so far. What makes it frustating is the fact that this have ...
- 321
0
votes
1
answer
140
views
Mimic the ( Show All ) link in datatables.net
I have a situation where I want to get the full (data) from the backend as a CSV file. I have already prepared the backend for that, but normally the front-end state => (filters) is not in contact ...
- 2,779
-2
votes
1
answer
771
views
How can i define a delete method inside the delete button, It is returning the id of what i am trying to delete which means it is using get
So here are the index and destroy function but the delete button is not working properly and just giving me a blank page with the ID
Controller
//this is the index
public function index()
{
if(...
0
votes
1
answer
177
views
Laravel Data table : Getting SQLSTATE[42S22]: Column not found: 1054 Unknown column error
Here is my data table query funciton.
/**
* @param ProjectTimeLog $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(ProjectDailyStandup $model)
...
1
vote
2
answers
1k
views
Unable to understand why I cannot install laravel-datatables
I'm mantaining an old project, started with laravel 5.4, and now lifted up to laravel 8.
It's all working.
Now I'm in need to install laravel-datatables.
Looking at doc, I discarded v10 because it ...
- 25.8k
0
votes
2
answers
1k
views
Ajax Reload on Vue.js DataTables
ajax.reload() and/or ajax.url().load() is just not working for Vue3 DataTable integration. It works if you include the CDN and follow the jQuery approach to it.
If you follow the instructions on the ...
- 138
1
vote
0
answers
828
views
Livewire Datatables - update columns dynamically without page refresh
I have a custom reporting feature I'm trying to build. To keep it short, the user is presented with options to choose from, those options are used to build an Eloquent query that returns data from the ...
- 29
0
votes
0
answers
343
views
Yarja Datatable Laravel - Null Date Value
I am having issue with handling a null values within a datatable.
In short I have a table with outstanding fees, which has a default null value in the table and is updated the Date paid when the ...
- 109
1
vote
1
answer
930
views
How to connect laravel to firebase?
I am using laravel framework and firebase-database , i made connection between those two it's working fine ,i want to use eloquent models for manipulating the data for that i am using this package
...
- 167
0
votes
1
answer
2k
views
My laravel Yajra datatable does not render. It says invalid json response. However I can not read the error since the response is empty
Hello I have the following controller method to return data to my datatable in Laravel,
Controller Method
public function get(Request $request) {
return Datatables::of(AppUser::all())
->...
- 151
1
vote
1
answer
2k
views
Livewire Datatables - Transform column and filter
I'm trying to substitute column data through callback, that has to return a username, mapped to user unique identifier. The list of usernames is outside of of the model' data and that's where I'm ...
- 7,316
0
votes
0
answers
38
views
Laravel 5.7: Is it possible to add direct a value in the table?
I was wondering, if it possible to add directly a value in the table.
Because I would like that all with the value "1" are registered
Schema::table('games', function (Blueprint $table) {
...
- 286
0
votes
2
answers
288
views
How to get number of the users registered in this month in laravel
Pls help me🙏
I wnat to get number of the Users registered in this week
and number of the Users registered in this month
- 21
0
votes
2
answers
2k
views
Format date column in datatables
i need format date in my datatable column, i´m reading documentation, but i don´t know how i can to do it.
i have this code for create my datatable:
var callTable = $('#calls').DataTable({
dom:...
- 558
2
votes
3
answers
84
views
Make MySQL query more performant
I have two tables, users and points. Currently users has 84,263 rows, while points has 1,636,119 rows. Each user can have 0 or multiple points and I need to extract which point was created last.
show ...
- 914
3
votes
2
answers
6k
views
Laravel Datatables: How to sort column with the second data
How do I sort according to the second data? The sorting works only on the ID. But in my table, I added a badge count and that's what I want to sort by.
Here is my controller
return DataTables::of($...
- 1,219
-1
votes
2
answers
3k
views
How to hash password with md5 instead of bcrypt in laravel 8?
I want to hash password with md5 instead of bcrypt in laravel 8.
In my login controller LoginController.php :
protected function credentials(Request $request)
{
return ['user_name' ...
- 35
-1
votes
1
answer
47
views
Error creating page to change data from table in my blade [duplicate]
I created a page to implement the function of changing the data from the table, and after I did everything on the video tutorial I somehow do not work this page, here is the text of the error:
...
- 51
1
vote
2
answers
91
views
Difficulties with creating a function to delete data from the database
I created a button in the table to implement the function of deleting data on the site, I did everything according to the video tutorial and after I did everything refreshing the page I got an error:
...
- 51
0
votes
1
answer
792
views
local server displays yajra laravel datatables correctly, remote server gives error 500
I am able to see my datatables on my local server, so I pushed the files to git, pulled them to my local server, and published the assets using php artisan vendor:publish --tag=datatables.
I have also ...
- 769
0
votes
1
answer
44
views
The page on the site stopped working after I added the output of the table from the database to the page of the site
I made a display of the plate on the page of the site and then the following error appeared (error screenshot below) error text:
Undefined variable: users (View: /home/vagrant/code/bacon/resources/...
- 51
-2
votes
2
answers
65
views
How to solve the problem of writing data to the database?
I created a page where you can add records to a database, and when I add a record I get an error:
SQLSTATE[HY000]: General error: 1364 Field 'website' doesn't have a default value (SQL: insert into ...
- 51
-1
votes
1
answer
61
views
LRAVEL 8 paginate does not exist, i need select data by region_id and paginate it
I found the paginate() method in the Laravel documentation. However, it doesn't work when I implement it. I get an error that paginate does not exist. I know paginate is maybe only for all(), but I ...
- 15
1
vote
1
answer
1k
views
Laravel datatable service using with relationship different name
I tried using 2 words method relationship. How i can implement the relationship in datatable service using ->with?
In the query method looks like this :
public function query(Pihak $model)
{
...
- 1,111
0
votes
1
answer
1k
views
How to use Nested functions substr(), cast() and Max() in query builder in laravel 8?
I posted this question yesterday but I think it's unclear so I deleted it and posted it again with more details.
In my oracle database I have a USERS table with id_user defined as varchar and this ...
- 107
-1
votes
1
answer
2k
views
How can I make a beautiful table view on a website page ? Laravel
Need help with the design of the text on the site page,I display the data of the table and they do not look good (attached a screenshot) help
my view file:
@extends('layouts.layout')
@section('title')...
- 51
1
vote
0
answers
3k
views
yajra datatables keep index column on search
I have a data collection and I have added a column with index:
BACKEND:
Route::get('user-data', function() {
$model = App\User::query();
return DataTables::eloquent($model)
-&...
- 75
0
votes
1
answer
620
views
Error 419 Page Expired. Laravel Yajra datatables
I'm trying to add a form button to delete a record, but for some reason the csrf token doesn't insert it. I've tried many ways but I can't get it to work. Any suggestions?
<div class="row"...
- 173
1
vote
1
answer
829
views
I failed to refresh data in yajra/laravel-datatables-oracle with draw method
In laravel 6 app I use "yajra/laravel-datatables-oracle": "^9.4" and I need selecting 1 row and running ajax request on server to delete this row
I try to refresh table with draw() ...
- 3,331
0
votes
1
answer
250
views
Update table DB in Laravel with findOrNew
How I can update table in DB, with use function findOrNew
I want first check column in table. If I have same title not add, if I dont have - push
I campare @title@ in table DB.
public function update(...
- 9
1
vote
2
answers
579
views
Return Action Button Shaped Text Datatable Laravel
I want to add action button to my datatable here the code
html table and datatables
<table id="users-table" class="table table-bordered">
<thead>
<tr>
&...
0
votes
1
answer
2k
views
ColReorder is not working in Responsive DataTables?
I have DataTables and implemented the colReorder by dragging the checkbox element using .sortable() jquery-ui and everything is fine. But when I enable responsive:true the column is not ordering any ...
- 55
-2
votes
1
answer
228
views
Neither it show an error nor save the Data into my database PHP Laravel?
I am trying to insert data into the database neither it shows an error nor saves the data into my database below are the codes. here is the create blade php page .
@extends('layouts.app')
@section('...
- 51
0
votes
1
answer
88
views
how to do Role Base Access in Laravel?
I am new in Laravel How to do in laravel role with the following table
$table->id();
$table->string('name');
$table->string('email');
$table->...
- 51
0
votes
2
answers
3k
views
Laravel Yajra Datatables Hide Null Column
Wha is the best way to hide empty or null comumns from Yajra Datatables:
var table = $('.data-table').DataTable({
processing: true,
serverSide: true,
ajax: "{{ route('any.route') ...
- 21
0
votes
2
answers
6k
views
how can i search all data in datatables yajra
i try to use yajra datatables laravel
i have problem in searching
when i search data already exits in datatables it no working
me already try example in documentation but it not working for me
can ...
0
votes
1
answer
2k
views
Laravel datatables raw columns
i have a code like this to display an action button for datatables
->addColumn('action', function () {
return '<form id="delete" action="{{ route(' . 'admin.posts.destroy' . ', $...
0
votes
0
answers
169
views
I don't know how to implement "Belongs To". Laravel
please help me my problem is this:
I'm having relationships in laravel with eloquent. I tried to use Datatables but I don't know how to do "BelongTo Relations". Also, look for an idea in ...
0
votes
2
answers
3k
views
Formatting number in Eloquent query or Yarja Datatables
I am writing a searchable table which includes the area and population. Here is the basic query:
public function getCountryData()
{
$co = DB::table('countries')->leftJoin('country_detail','...
- 622
1
vote
1
answer
2k
views
Laravel datatables - only return the requested columns, removing the additional model fields
I'm using Laravel datatables on a website.
Data is loaded through AJAX. On my frontend code I select which columns the table needs:
var dataTable = $('#products-table').DataTable({
...
- 10.4k
0
votes
1
answer
717
views
Laravel View Composer, cant seem to get it to work
so i have followed many tutorials and videos and checked here and cant seem to get this to work, really need help. im going to provide my code and explain what im trying to so and hopefully someone ...
