All Questions
Tagged with sql-server laravel-8
17
questions
0
votes
1
answer
37
views
Laravel migrations create table column with dot in colum name
I have a table in SQL Server database where a column has a dot in its name. When I first created manually the table I had no problems doing it, but now that I'm changing the db server I decided to ...
0
votes
0
answers
60
views
How can i solve this Error "No connection could be made because the target machine actively refused it"
I have built a web application in Laravel 8+, locally this application has no issue. After deploying on the Plesk Server (Shared Hosting, Windows Server) having a database connection error.
What I ...
0
votes
0
answers
215
views
unable to connect to MSSQL using PHP and Laravel in XAMPP. Windows OS
I am working on php version 8.2 using laravel 10. I am working on windows using XAMPP.
I am facing an issue connecting PHP to MSSQL server. I have downloaded drivers from microsoft and copied below ...
1
vote
1
answer
84
views
How to use "SELECT * INTO ..." using laravel
I'm new to laravel and I cant seem to run this query in laravel.
SELECT * INTO tmp.dbo.dataset_15112022_124949 FROM tmp.dbo.dataset;
I have tried the following without any success
$archive_db = "...
0
votes
0
answers
174
views
Not able to login using SQL Server and Laravel 8
I am using SQL Server with Laravel 8. My users table name is Users (letter u in caps) and I have following columns: LoginID(nvarchar(50), not null its my Primary key, Password and Email (letter p,e in ...
0
votes
2
answers
1k
views
SQL Server connection to Laravel
I'm trying to establish a connection to SQL Server with my Laravel app locally .
What I've done is checking pdo files are installed correctly
and phpinfo shows sqlsrv.
ENV Connection String
...
1
vote
1
answer
718
views
Laravel 8.74 - CloudLinux9 - MSSQL11 - ODBC Driver18 - Connection TrustCertificate=1 issue
I am having trouble to add options for laravael config/database.php;
TrustServerCertificate
Encryption
I am getting below error when trying to connect to MSSQL database;
SQLSTATE[08001]: [Microsoft]...
0
votes
3
answers
969
views
Laravel timestamp columns saving with wrong date format
I recently updated an old laravel 5.7 project to 8.0 and the created_at and updated_at model timestamps get created with the wrong format. Back in the day i used this code in all models that are from ...
2
votes
1
answer
677
views
Slow queries with binding parameters on Laravel using SQL Server
In my application, I need to count rows in my view. So I'm using the Laravel Query Builder. It works as expected, but it takes a lot of time to count rows. After some debugging, I figure out what ...
0
votes
1
answer
131
views
Laravel8 : get column name from table SQL Server
I've tried this code:
//controller
$model = new Mymodel;
$table = $model->getTable();
$columns = Schema::getColumnListing($table);
//view.blade.php
{{print_r($columns)}}
but the result only give ...
1
vote
1
answer
642
views
PHP Laravel PDO MSSQL Data Source Name Not Found on Mac OS
I'am currently trying to connect on MSSQL server using the sqlsrv driver of the laravel 8 and its default connection is using PDO MSSQL, I already manage to connect using sqlsrv only and the driver is ...
-1
votes
1
answer
1k
views
How to build query for multiple condition for same column in laravel query builder?
I want to get count from 'user' table with 'plan_validity' is null or more than today's date. both condition need to check for same column with user_id and status = 1.
$currentUser = User::where('...
0
votes
1
answer
231
views
Laravel 8 - MS SQL - Query Builder - using DB Raw. Trying to get the code right to make it work like the working MSSQL code
How do I write this in Laravel to get the query below to work?
Working Query:
select
fname,
lname,
title,
case when picture IS NULL then 'https://www.aaa.com/images/interior/bench2.jpg' else
'https:/...
0
votes
1
answer
1k
views
Laravel 8.54.0 + Livewire : Error SQLSTATE[IMSSP] Tried to bind parameter number 2101. SQL Server supports a maximum of 2100 parameters
I use Laravel Framework 8.54.0 and livewire.
I want to call data for my dropdown form. But I get sqlstate error. Could anyone help me find a way to solve this issue?
Model:
class Item extends Model
{
...
0
votes
1
answer
478
views
Error in Laravel Eloquent relationships ::with uids as primary key
I'm trying to use relationships with '::with' in my project, but I get a strange error.
The entities are:
Binary -> PK: BinaryUid
Template -> PK: TemplateUid
TemplateBinary -> PK: ...