All Questions
235,624
questions
0
votes
1
answer
6
views
PHP varible from mysql query in form, when null
I have an html form used to edit a record in a mysql table.
In the case of editing, I prefill the form with the current values for the record as returned by the query, as below:
<INPUT TYPE="...
- 155
0
votes
0
answers
12
views
How to allow customers to update their sales channel in admin interface in a Shopware 6 plugin?
I'm working on an e-commerce platform where customers are assigned to sales channels. Currently, this information is stored in the database, but can only be updated through direct database queries. I ...
- 125
-1
votes
1
answer
25
views
laravel model pages not communicating properly
Working on a client project, hit a setback.
Laravel is reading
"Call to undefined relationship [service_item] on model [App\Models\Service]".
It's simply trying to read data from two ...
-2
votes
0
answers
19
views
Laravel 10 migration data type ( Exg : text, string, longtext ... Etc.) size list in charector and size(kb pr mb)
Laravel 10 migration data type (Exg: text string longtext etc.)
Data type
size KB (char)
String
xx kb (cab)
Text
xy kb (acb)
Can anyone share this list.
A list of data type and it's sizes ( ...
- 1
0
votes
1
answer
38
views
Detecting OR operator sequences and wrapping their content in a parenthesis when building a query with PHP
I made the following PHP code to build a query based on user input, where they can choose the condition and the operator and the resulting query would be printed on their screen every time they added ...
-2
votes
0
answers
24
views
MacBook remote database access works with Sequel Ace and MySQL Workbench but not php (not a duplicate) [duplicate]
My remote database access works with Sequel Ace and MySQL
Workbench but not php
My connection script contains the exact same data.
I've searched everywhere for a solution.
Any idea why?
Thanks.
Robert
...
- 1
0
votes
1
answer
33
views
Eloquent ORM performance with subqueries for relational models
Laravel eloquent uses subqueries for relationship model instead of joins as joins offer more optimal performance .How does eloquent orm ensures performance for relational models ?
- 3,805
-3
votes
0
answers
18
views
MySQL data to OneDrive [closed]
We are using windows server and scheduled phpscript to extract MYSQL data and load into csv file, then upload it to Onedrive. However this process in the recent days seems to be troublesome.
We are ...
- 1
-3
votes
0
answers
40
views
data cant be save in database [closed]
i have a registration form and i want to store the information (gender and phone included) but it didnt store in the database even the register is successful but the column for gender and phone_number ...
- 11
-2
votes
0
answers
27
views
Laravel 11 Eloquent subquery statement failed [duplicate]
Please help with this subquery to transpile to Eloquent sentence:
SELECT * FROM notifications WHERE id NOT IN (SELECT notification_id FROM notification_seen WHERE user_id = 1)
Sql sentence works ...
-2
votes
0
answers
36
views
Storing data from API requests in PHP and mySQL [closed]
I'm developing a API a website for a tourism agency.
All the data (regions, hotels, room types) are populating the database using various APIs from different providers that my client has a B2B ...
- 1
0
votes
0
answers
38
views
i dont know how to display the discussion according the id [closed]
as the title said, I already changed a lot of code but I also cannot display the discussion that users who post by themselves according to user_id in my discussion database. I can display all the ...
- 1
0
votes
2
answers
78
views
My Search function isn't working when I search by name
so I've tried creating a Wordpress plugin that searches data in a different MySQL database and it works when I search by license number but when I search for any kind of name I get sent to a "...
- 17
-4
votes
0
answers
36
views
'ion' instead 'selection' in MySQL [closed]
I am using PHP & Symfony with MySQL.
Whenever I try to type 'selection', it always saves to 'ion'.
If I try to fix it from the web, it says it's saved but shows actually 'ion'. Then I have to fix ...
-2
votes
0
answers
33
views
SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data at line 1 column 16 of the JSON data [duplicate]
So, I'm new to PHP and SQL. I wanted to select the highscore of the user on the database and overwrite the highscore variable with it, so it doesn't start by 0 everytime I reload. I already managed to ...
- 1