I have a Laravel project set up on my MacBook and I'm encountering an issue with connecting to the database when using PHP artisan serve. Here's the problem: When I access the project via localhost/project_name/public, everything works fine, and database…
For about two weeks now I have the surreal problem that almost every order has the correct items but wrong meta datas and the ordered number of items are changed like 3-20 instead of just one. I had a bloated…
I'm encountering a database connection issue in my newly hosted Laravel 11 application on Hostinger. I've carefully configured the files and database in phpMyAdmin, but I'm getting this error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'127.0.0.1' (using password: NO) this…
I tried to create a 1-to-1 relationship in PostgreSQL but when i check the ERD it looks like a 1-to-many relationship. this is my SQL script: CREATE TABLE capital ( id SERIAL PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE country…
I have a Spring boot app with custom queries. I need to find all database rows according to condition - if :myFlag is true, field in database must be in a list (:values here), or null. Can I use something…
I need a result of an array that is flattenened like this: $result = ["1", "2", "3", "4", "5", "6", "7"]; I have a DB result of this query: $articles = DB::table('articles') ->where('is_published', 'true') ->get() ->pluck('category'); When I do this…
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'eshop.sessions' doesn't exist SELECT * FROM sessions WHERE id = N7H5CpGFStKcjjHhlq9aOo05OE0eU2I9muBXC4Tc limit 1 enter image description here When i check my database i have no table named sessions (never had by…
setup: aws rds mysql aurora Our DB has a writer and a reader instances. If we use the reader instance(which has a separate CPU) will large read requests have any affect on the Database that the Writer instance is connecting…
I have millions of rows of data in MySQL DB. Can you suggest me any services or platforms that support JOINS and fast data retrieval. I have looked on elastic search and manticore search, but these don't support JOINS. So,…
i want to get the order id maximum by the relative user id $order_id = "select * from products_orders where order_user_id = $user_id AND MAX(order_id) "; $ord_del = mysqli_query($con,$order_id) ; $ord_row = mysqli_fetch_assoc($ord_del); i try this method but this wont…