if (!Cache::store(‘file’)->has(‘channel’)) { $products = Channel::select(‘*’); Cache::store(‘redis’)->put(‘channel’, $products, 86400); } $products = Cache::store(‘redis’)->get(‘channel’, []); return DataTables::eloquent($products) ->addIndexColumn() ->make(true); This throws me "Serialization of ‘PDO’ is not allowed", if i am trying if (!Cache::store(‘file’)->has(‘channel’)) { $products = Channel::select(‘*’)->get(); Cache::store(‘redis’)->put(‘channel’, $products, 86400); } $products = Cache::store(‘redis’)->get(‘channel’, []); return DataTables::eloquent($products) ->addIndexColumn() ->make(true); then datatables throws error of Method ..
Category : mysql
i’m developing a Laravel 8 application I need to take values from a table, count how many occurrences I find of anagrafica_soggetto.codiceFiscale by adding the values of the field withDB :: raw (‘sum (importoResiduo) as residuo’). My problem is that I need to group these results into six bands with where clauses. The where clauses ..
can some one help me to do in laravel join for 3 tables ( payments, invoice_payments & attendances) every table has (id, user_id, amount & date) i want to join 3 tables throw user_id and date by month as the date format dd-mm-yyyy to get the sum amount for every table and groupby month, user_id ..
For example I have online store with keyboards and mouses tables. And on the product(keyboard or mouse) page I want to show Recommended to buy with… section where other product (keyboard or mouse) will appear. So on Keyboard#1 page may be recommended Keyboard#2 and Mouse#1, that means on Keyboard#2 and Mouse#1 pages will be recommended ..
I am making an application with Laravel 8 and Livewire. In my reportResidui.blade.php view I have integrated a livewire component called report-residui-header-filter and which I use to filter (this component works fine). The problem occurs when I perform the query, I need to filter from a table going to group the data for the field ..
This is the raw query "SELECT * FROM re_customer WHERE LOWER(email) = ‘" . $input[’email’] . "’ AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1(‘" . $input[‘password’] . "’))))) OR password = ‘" . md5( $input[‘password’] ) . "’) AND status = ‘1’"; I tried $customer = DB::connection( ‘oc’ ) ->table( Customer::$customerTable ) ->where( DB::raw( ‘LOWER(email)’ ), ..
Well, I wanna ask for the using group by in the eager loading from laravel, I have been stuck and I don’t have more idea for this, I hope someone can help me to guide me solve this problem, I explain first. First of all I already make a query from mysql, and for my ..
I am creating an application to be hosted on a server, and I used .htaccess however the first page that load which is usually the login screen(whose path is in my resources folder)has change to the public folder and I click anywhere else as everything is linking to the public folder, which is not right ..
Is there an equivalent query for this in eloquent? SELECT DISTINCT agent_code,ord_amount FROM orders Sourc..
I’m currently working with a LAMP stack that uses Laravel framework and we use a sessions table within MySQL to manage user sessions. If a user’s session expires then their record is removed from that table (120 minutes of no activity / logging out), and when a user newly logs in to the app a ..
Good day everyone, I’ve the following problem, I’m working on the back of a CRUD, currently I’ve to validate that the information entered by the user cannot be greater or less than what I’ve registered in each field of the database i.e it has to be equal to the database value, to verify this I ..
Hi I have a problem with the controller setting for uploading the image to the database, can you please help me what is the problem and how can I solve it code error Sourc..
I have a query that gets a list of students and Iam using a foreach loop to iterate and get the student_id of each student. Inside the foreach loop I have another query that calculates the student marks. When calculating the student marks, i need the student_id which is from the first query Logic $students ..
I have 2 tables, one is items which contains title, quantity and price, it connects with another table call orders, so it’s one to many relationship. If i query order entries with items load as well how could i get the subtotal of each item, "qty x price = subtotal" and get the grand total ..
Hi I have table threads and questions with relation one-to-many. every message has foreign key thread_id. I want to check is last message in the thread is from user and if yes then count it, so it will count all unanswered threads by admin. +—-+————-+———+———-+——+ | id | thread_id | user_id | admin_id | text ..
Trying to create Fake Posts by using tinker but met with the error code bellow IlluminateDatabaseQueryException with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (posty.posts, CONSTRAINT posts_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE) (SQL: insert into posts (body, user_id, updated_at, created_at) ..
I have a date field on a form that I would like to insert a value into the database. I created some error messages for the form. I am using form requests for validation logic. When I submit the form I have an error message about an empty date value. How can I solve this ..
I am out of option . going through many solutions nothing worked . It has been asked by many people but nothing earlier solutions worked for me . .env DB_CONNECTION=mysql DB_HOST=db DB_PORT=3306 DB_DATABASE=laravel DB_USERNAME=root DB_PASSWORD=root config/database.php ‘mysql’ => [ ‘driver’ => ‘mysql’, ‘url’ => env(‘DATABASE_URL’), ‘host’ => env(‘DB_HOST’, ‘db’), ‘port’ => env(‘DB_PORT’, ‘3306’), ‘database’ => ..
So I currently have a database for Recipe Management with 3 tables: Recipe table holding everything but ingredients, ingredients table with the ingredients name and category and then a composite table joining the two to avoid the many to many relationship the composite table has quantity and measurement aswell as the two primary keys. I ..
So, I want in my laravel project to press the upload button, but to upload the image to a photo host, it doesn’t matter which, and then this link to go to my database. How can I do this? Sourc..
I have a query join 3 tables for sales with about 15000 rows. The query takes about 22 seconds to respond, this is too big for me. Someone, please help me optimize this query. I use Laravel and use the filter from the form. Here is my query : $data = DB::table(‘crm_donhang as dh’) ->select(‘dh.id ..
i wanted to dockerize my laravel app. i launched two containers of mysql and php like this sudo docker pull mysql/mysql-server:latest sudo docker run –name=mysql -e MYSQL_ROOT_PASSWORD=mypass -d mysql/mysql-server:latest sudo docker pull phpmyadmin/phpmyadmin:latest sudo docker run –name phpmyadmin -d –link mysql:db -p 8081:80 phpmyadmin/phpmyadmin so i configured my user and imported my db manually in ..
i have a website on Laravel 8 with MySQL and i want to use firebase for Realtime chatting only can anyone tell me how to use this with Laravel 8..? can anyone tell how laravel combine with firestore just for chatting only ..? Sourc..
I am using Laravel 8 and trying to get an application form to post to two tables in my database From my 2 database migration files: public function up() { Schema::create(‘applicants’, function (Blueprint $table) { $table->id(); $table->string(‘apptitle’); $table->string(‘firstname’); $table->string(‘middlename’)->nullable(); … $table->timestamps(); }); } public function up() { Schema::create(‘applications’, function (Blueprint $table) { $table->id(); $table->integer(‘applicant_id’); $table->integer(‘user_id’); ..
I have developed project in laravel for accounting related activity which has many relational tables with foreign keys in mysql. Everything works fine but the problem is my client has an excel file which has more than 10000 (ten thousand) records like vendor name,invoice number,date,amount etc.. So how can i import all of this data ..
Web Development Company
Free Hosting Company
