All Questions
26,678 questions
0
votes
0
answers
25
views
mysqli rollback commit is not working with innodb table [duplicate]
I am trying to set up transaction rollbacks but no matter what I do, the insert is not rolled back.
I have confirmed the DB engine is innoDB:
Name Engine Version ...
- 560
0
votes
1
answer
10
views
Can not connect to joomla DB from active template directory?
Using shaper_helix3 template, I'm having hard time to connect to DB from a custom.php I placed at /templates/shaper_helix3/custom.php directory. I'm sending a parameter with some external js code and ...
0
votes
0
answers
35
views
exceeding max_connections_per_hour on bought database
Im using PHP and MySqli for my database connection on a database i bought which has max connections of 500. I dont really know or have been taught how to manage and optimise queries, but when im ...
1
vote
1
answer
56
views
How to set a default value of 1 year from now for expire_at in Laravel migrations? [duplicate]
I am creating fields for a table in Laravel. I want to create a expire_at column using $table->timestamps() but set a default date of 1 year from now.
Currently, I am trying the following:
$table-&...
1
vote
3
answers
48
views
Wordpress pages do not appear after transfer to new host
Somewhat of an amateur here: I moved a wordpress site from one host to another. This involved me backing up the old site, and uploading all of the material from the wp_content folder into the ...
- 43
0
votes
1
answer
65
views
MultiDatabase Relationship Model
My goal is to create a project for multiple vehicle resellers. I need to stay up-to-date with new brands, models, versions, and years that are constantly being released.
However, it’s not practical ...
- 1
0
votes
0
answers
43
views
Efficiently Handling Polymorphic Relationships and Statuses in a Large-Scale Relational Database with Laravel
I'm currently working on a project using Laravel where I need to handle statuses across multiple types of entities (e.g., posts, comments, etc.). I've set up a polymorphic relationship to link ...
0
votes
1
answer
32
views
Property [nama_guru] does not exist on this collection instance
I’m working on a feature to display teacher data grouped by category (guru_category). Below is the code I’m using:
public function showGuru(Request $request)
{
$search = $request->input('search'...
2
votes
1
answer
53
views
How to Generate Unique IDs for Chat Messages in Laravel with GridDB?
I'm building a real-time chat application using Laravel and want to use GridDB as my database due to its high performance with time-series data. Since GridDB doesn't have an official PHP client, I've ...
1
vote
1
answer
33
views
How to Integrate GridDB with Laravel Using a Custom Database Driver?
I'm working on a Laravel project where I want to use GridDB as my database. Since Laravel doesn't have built-in support for GridDB, I'm trying to create a custom database driver to handle the ...
0
votes
0
answers
18
views
How to create a query to view number of guests between dates on Mysql [duplicate]
I have a series of reservation on a booking system and I would like to create a view that would show how many guest are in a given date interval (for example: from 2024-11-01 until 2024-12-31) that ...
- 360
-3
votes
1
answer
85
views
How to get all possible records with highest value in specific column
I have four tables:
Items:
id
name
1
item 1
2
item 2
Item-module:
item_id
module_id
1
1
1
2
1
3
Module:
id
name
type
1
module 1
type_1
2
module 2
type_2
3
module 3
type_2
4
module 4
...
- 35
0
votes
0
answers
64
views
meta value in database
in empror theme we have some custom field what I want to add to my custom fields in DOKAN plugin product editor for seller, I added codes in my function.php of theme what dokan said we can used, see ...
- 11
0
votes
0
answers
23
views
generate empty rows for no transactions dates [duplicate]
I have a sales table with columns:
CREATE TABLE SALES (
SALESID INT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(255) NOT NULL,
QUANTITY INT,
SALESDATE DATE NOT NULL DEFAULT (CURRENT_DATE),
...
- 2,142
0
votes
0
answers
23
views
How can I populate the pricing data associated with date dropper by Felix G?
I am using Date Dropper javascript to show prices on a js calendar.
// Get pricing data (this object simulates the way you should obtain your pricing data object)
// 1. Get pricing data (this object ...
- 11