mysql – Laravel Questions

Category : mysql

migration in laravel for PROCEDURE

23rd June 2021 database, laravel, mysql, sql, stored-procedures

I am trying to create procedure migration in laravel but I am getting syntex error every time I tried so but didn’t make it work Below is the code $this->addSql("CREATE PROCEDURE Type_Store_Sync(IN name_it VARCHAR(255), IN guid VARCHAR(32), IN type VARCHAR(10), IN orgid INT(11), IN scheme VARCHAR(6)) LANGUAGE SQL BEGIN CALL mysql.lambda_async( ‘arn:aws:lambda:eu-west-2::function:triggersync’, CONCAT(‘{ "name" : ..

I am trying to insert some data into status table but getting SQL Query Error in Laravel

22nd June 2021 laravel, mysql, php

I am new in Laravel. I have a table, and that table name is {status}. Under the Models Status.php when I removed protected $table=’status’; from status.php then I am getting this error! IlluminateDatabaseQueryException SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘cms.statuses’ doesn’t exist (SQL: insert into statuses (status, user_id, updated_at, created_at) values (dfg, ..

Laravel query builder binding has an empty result

22nd June 2021 laravel, laravel-query-builder, mysql, php, sql

I created a MySQL query and performed it in Laravel. It is my query: DB::query()->selectRaw("* from `social_actions_accounts` where `department_id` in (?) and `id` = ? and `platform` = ?", [1, "1211910722881372160", "twitter"])->get(); My problem is that When id is entered as a string, the empty result is returned. But when it is entered as an ..

How do I get the MIN and MAX dates outside of a given date range with MYSQL?

22nd June 2021 laravel, mysql, php

I have a database of call records. I need to be able to query the records by date but still get the MIN and MAX of the startdatetime as the first and last time they called. The query below gives me the records between the given date range but the MIN and MAX values only ..

Laravel Eloquent – Fetch summaries substring groupedBy and sum total field of group

22nd June 2021 database, eloquent, laravel, mysql

I am trying to fetch a grouped By list of all my Summaries with the according Sum of the total field. To visualise it it would look something like this ID. Code. Total. Created_at. Updated_at 1 61B5A4C5 1437.64 2021-06-22 11:18:09 2021-06-22 11:18:09 2 A9B5311C 711.44 2021-06-22 11:19:10 2021-06-22 11:19:10 3 1426CDC5 711.44 2021-06-22 11:19:27 2021-06-22 ..

Group by returns wrong sum

22nd June 2021 inner-join, laravel, laravel-query-builder, mysql, php

Here’s my 3 tables: Products table: id, product_name Purchase Product table: id, product_id, purchase_price, quantity Sales Product table: id, product_id, sales_price, quantity, purhase_price. I want to find the products which is in purchase list as well as sales list . If it’s not it sales list it should return null sales value as well as ..

How to return a relationship with a model instance in Laravel 8

22nd June 2021 laravel, mysql, oop, php

I need to understand what’s going on with my model instance. I have setup and many-to-many relationship in my User model public function projects(){ return $this->belongsToMany(Project::class, ‘project_users’, ‘user_id’, ‘project_id’)->withPivot(‘role’)->withTimestamps(); } When a user logs in, I return an instance of the user model $user = User::where(’email’, $request->email)->first(); return response([ ‘message’ => ‘User Logged in’, ‘data’ ..

Laravel make 3 data become 1 data and do some counting

22nd June 2021 group-by, laravel, mysql, sql

i have 3 row data in database , i want query to make it become 1 data by its id , what should i do to get 1 row content like : |operator_id|durasi_jam_kerja|durasi_jam_lembur|durasi_jam_standby| 9 2 8 Sourc..

undefined constant laravel-8 counting data from database

22nd June 2021 laravel, laravel-8, laravel-blade, mysql, php

I wanted to call the number of files uploaded by the user through its id but it shows that the fileuploads is not defined. Can aynone help me on this? Here is the function for it public function dashboard() { $dashboardTitle = "Dashboard"; $isCurrent = "dashboard"; $filesUploadCount = Fileupload::where(‘user_id’, Auth::user()->id) ->count(); return view(‘dashboard.index’, [ ‘dashboardTitle’ ..

Laravel migrations won’t apply on MySQL (InnoDB)

21st June 2021 centos, innodb, laravel, mysql, php

Hello everyone, This is my first time posting ! I am running into a problem when applying laravel 8 migrations on my new web server. While trying to deploy my projet I’m unable to apply migrations and I’m not sure why. Below images of the error and my migration, i’m using the php artisan migrate ..

How can i put condition with table JSON attribute

21st June 2021 json, laravel, mysql, php

I want to put conditions on the JSON attribute in the table but no luck. Please give me a solution that how can I put condition with JSON table attribute This is my JSON data in the table "products": { "id": 1, "key": "category" "categories": { "category_A": "John Quil", "category_B": "Ev R. Lasting", "category_C": "923117253207", ..

Hello, I have a simple question, in my controller [closed]

21st June 2021 laravel, mysql, php

I have a simple question, in my controller, i want to check if the amount is greater to zero its should not update and so on according to an if else statement.. but the condition is always spitting out the first condition and not see the last one in else parts. <?php public function update_pourcentage(Request ..

API routes are not working in Laravel VueJS app

21st June 2021 laravel, mysql, php, vue-router, vue.js

I’m building a SPA with Laravel and Vue. However, I need to make an API call with axios but it’s not working. Here’s my web.php: Route::get(‘/{any}’, function () { return view(‘index’); })->where(‘any’, ‘.*’); Here’s my api.php route: Route::get(‘/notification’, ‘[email protected]’); Whenever I make an API call, it shows a blank or broken page. Could you please ..

Getting Numeric value out of range, but I’ve created it BigInt on Laravel 8

21st June 2021 laravel, mysql

I have created a column of datatype BigInt. In the local server, it is working but in Cpanel, it is saying out of range when I am trying to insert the value. If I run a SQL query directly it will work but from the code, it is not working. The value that needs to ..

How to solved Tbale does not exist Mysql?

21st June 2021 laravel, mysql

I am using Laravel migration and each and everything is working fine on my side. I am using a work bench with ubuntu. But when I export data on CPanel it shows an error Error SQL query: — — Dumping data for table `activity_log` — LOCK TABLES `activity_log` WRITE MySQL said: Documentation #1146 – Table ..

How to solved Table does not exist Mysql?

21st June 2021 laravel, mysql

I am using Laravel migration and each and everything is working fine on my side. I am using a work bench with ubuntu. But when I export data on CPanel it shows an error Error SQL query: — — Dumping data for table `activity_log` — LOCK TABLES `activity_log` WRITE MySQL said: Documentation #1146 – Table ..

Payu Integrate with laravel multi sellers

21st June 2021 laravel, mysql, payu, payumoney

I am building a System which will have reseller module, I want to integrate PayU in my system, I found this package for laravel tzsk/payu but the problem the gateway Information is saved in a config file in config/payu.conf I want every reseller to set his account details and save them in database, and then ..

Refactor the JSON object in Laravel

21st June 2021 eloquent, laravel, laravel-5, mysql, php

Here’s my JSON: [ { "ID": 1, "SOURCEID": 1, "TIMESTAMP": "2020-04-05 07:05:29", "VALUE": "30" }, { "ID": 4, "SOURCEID": 2, "TIMESTAMP": "2020-04-05 07:05:17", "VALUE": "40" }, { "ID": 3, "SOURCEID": 1, "TIMESTAMP": "2020-04-06 12:04:59", "VALUE": "35" }, { "ID": 5, "SOURCEID": 1, "TIMESTAMP": "2020-06-17 12:01:32", "VALUE": "1" }, { "ID": 6, "SOURCEID": 2, "TIMESTAMP": "2021-06-17 ..

Laravel image save as .tmp in the db even though the file uploaded in the correct folder

21st June 2021 database, image, laravel, mysql, php

I’m trying to add an user to data base in latavel. following is my User Model. <?php namespace AppModels; use IlluminateContractsAuthMustVerifyEmail; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateFoundationAuthUser as Authenticatable; use IlluminateNotificationsNotifiable; use SpatiePermissionTraitsHasRoles; class User extends Authenticatable implements MustVerifyEmail { use HasFactory, Notifiable, HasRoles; /** * The attributes that are mass assignable. * * @var array */ ..

Laravel DB::raw() failed but work in mysql directly

21st June 2021 laravel, mysql

I am running a sql in Laravel: $last_reading_comprehension_id = DB::select( DB::raw(" INSERT INTO `npee_reading_comprehensions`(npee_id) VALUES ($npee->id),($npee->id),($npee->id),($npee->id); SELECT LAST_INSERT_ID(); ") ); this will fail with errors but when I run the sql directly in mysql, it works Why it that? How can I solve it, thanks a lot for anyone help! Sourc..

Laravel shows wrong date when casting from timestamp to date:Y/n/j

21st June 2021 laravel, mysql, php

I’m using laravel casts inside my model to cast my timestamps to date:Y/n/j. But laravel casts it to wrong date. model: class Diary { protected $casts = [ ‘created_at’ => ‘date:Y/n/j’, ]; app.php: ‘timezone’ => ‘Asia/Tokyo’, php.ini: date.timezone = "Asia/Tokyo" mysql: select * from diaries; +—-+——-+———————+ | id | diary | created_at | +—-+——-+———————+ | ..

How to develop app for existing website with database of mysql

21st June 2021 android, database, ios, laravel, mysql

How Are You? I am new to app development. I have a project to develop an app of already existing website, which is develop in Laravel 8. This website is online food ordering system which contains it’s data of food items and other in mysql database. Plz Guide me about the best way to develop ..

Laravel ajax "invalid or unexpected token" on .append

21st June 2021 ajax, append, controller, laravel, mysql

I am trying to call my table contents using ajax append from a laravel controller function. I am getting this error though Ajax: function fetchcategory() { $.ajax({ type: "GET", url: "/clinical/bbr-category-configuration-data", dataType: "json", success: function (response){ // console.log(response.all_categories); $.each(response.all_categories, function (key, item) { $(‘tbody’).append(‘<tr> <td>’+item.category_name+'</td> <td>’+item.category_name+'</td> <td>’+item.category_name+'</td> <td>’+item.category_name+'</td> </tr>’); }); } }); } Controller: (tabled ..

PHP Fatal error: Uncaught PDOException: SQLSTATE[200]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’ [closed]

20th June 2021 laravel, laravel-5, mysql, php

[20-Jun-2021 14:57:53 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’ in /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:464 Stack trace: #0 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): PDOStatement->execute() #1 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): IlluminateDatabaseConnection->IlluminateDatabase{closure}(‘insert into tr…’, Array) #2 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): IlluminateDatabaseConnection->runQueryCallback(‘insert into tr…’, Array, Object(Closure)) #3 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): IlluminateDatabaseConnection->run(‘insert into tr…’, Array, Object(Closure)) #4 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(417): in /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671 [20-Jun-2021 14:57:53 ..

Filter results by pivot data on laravel / eloquent

20th June 2021 eloquent, laravel, mysql, php

I need to filter my data that match a specified criteria, see the example below DB SCHEME user id name company id name user_company user_id company_id date note DATA user | id | name | | — | —- | | 1 | john | | 2 | jim | company | id | name ..