Tag: mysql

Generate a last 7 days weekly report in Mysql

I want to get a report of my eco_orders table that how much order i get in a day for last 7days. I got the result with below sql and it’s absolutely fine. but the problem is I want to include the non order day count with zero Answer You can try this option –

How to insert 3 image to 3 field in DB Laravel

css html laravel mysql php

I want to insert 3 images to 3 fields in DB, but I can’t move this to folder public. My code in function store in Controller Someone help me. Thank you. Answer Try this:

PHP mysqli and SSL

mysql mysqli openssl php ssl

I am trying to configure Galera Cluster over a WAN (VPN is not an option). For obvious reasons I am setting up the connections to require SSL keys, and am having difficulties getting the application …

adding values in an array from SQL result

mysql php sum

I’m trying to put the user_value in an array if the affiliate_id=50. Then add up the array with the sum function. The issue is the array only has one of the user values inside it. My question is how …

PHP MYSQL Results into a table

for-loop html mysql php

I have a PHP/MySQL query that returns the following: The months return in an ordered fashion (E.g. January records are always before February records). However, not every user will have a result every month (see above). And I want my data to present such as this, in an html table: Here is my (non working) att…

query gives the same result multiple times

mysql php sql-update

I am doing a CRUD and I’m doing the edit part, I have multiple tables that are related to each other by foreign key, like for example the table ’empleados’ has the foreign key ‘rela_usuarios’ which …

Laravel whereNull and where clause returns empty object

eloquent laravel mysql php

I’m new to laravel. I tried to fetch some records from my database which are “parent” column is “null”. But it returns always empty object. Then I got the query using toSql() …

I can’t figure out why my delete system is not working, can anyone help me out?

function mysql php

I am working on this system where people can upload posts but for some reason whenever I try using my delete function it doesn’t work can anyone help me out? This is my button <?php while($row = …

How to get two minimum values from a price column (database). [Laravel]

laravel mysql php

I’m doing an online store and I have a “sale” section. In this section I want to place two products with the minimum price. I can get one product using the min () function, but I do not understand how to get two minimum values from the database.Thank you in advance. Answer you can use it l…

Notice: Trying to access array offset on value of type null in C:xampphtdocsresindex.php on line 97 name:

mysql php

I’ve created student result portal. It must display the student’s name and marks if the roll number and date of birth matches the data on database. Successfully, it displays the student’s mark details. But it shows error when displaying the student’s name. Below is the error. what I&#8…