I’ve started WordPress 1 month ago and i’ve just done my first hook into the website (just to add/remove an estimated delivery date). Once i’ve had this I was thinking that I’ve broke the website (LMAO) but it was just a postmeta problem. The postmeta value just need to be added on on …
Tag: php
Find 5 greatest totals after summing (quantity x value) for each qualifying user
I currently have a table which displays the inventory values of users. It works, but it displays all users and their inventory values in a random order. I’m wanting to limit the table to the top 5 descending inventory values only. This data cuts across three tables: DB Fiddle Users Inventories (contains…
How do i link different rows of database into buttons and display the appropriate informations?
Below is the php page and code i created to display information from two rows of the database. This is the picture of my database. And this is the code and page where the user will be redirected to after clicking the ‘More Information’ button. What I am actually trying to do is to make the booking…
MySQL error: Cannot add foreign key constraint (PrestaShop module)
I’m trying to write MySQL queries for my custom PrestaShop module. I encountered an issue while adding foreign keys and have no idea what might be wrong. I double checked column types and their existance. Here’s the error: Cannot add foreign key constraint And here is all the code I’m trying…
How to get the last 7 weeks, 7 months date range from current date PHP?
How can I get the date range of last seven weeks /months from the current date, i have already done with last seven days fetch last seven days, weeks and month sales total grouped by 7 particular days, 7 particular weeks and 7 particular months ex: Last seven weeks Last seven Months The below query I have don…
How to find out if variable value in database json column Codeigniter?
Im using Codeigniter. Im trying to get some value in database like; the problem is ‘json_value’ column is like = [{“name”:”test1″,”value”:”test1″},{“name”:”test2″,”value”:”test2″}] how can I get ‘…
How do I use ROW_NUMBER in MySQL to check number of rows per day per employee?
I’m storing punch-in and punch-out data in a table that looks like so: id empid punchtime 74 4 2021-08-04 17:11:54 171 4 2021-08-06 13:47:45 202 4 2021-08-09 10:14:01 271 4 2021-08-09 18:20:01 308 4 2021-08-10 11:14:54 343 4 2021-08-10 14:46:21 349 4 2021-08-10 15:22:10 380 4 2021-08-10 18:10:58 406 4 2…
NULL changes to 0 when added to the db
Ok I have tried everything I can think of, I couldn’t make it. I am creating some inputs like this: And then when I get the $_POST I am checking if the input is 0 or “” and setting it to NULL. And I am adding to the DB with this But when the query runs, qty6 (for example) that
Order results by “Best Match” SQL
I’m working on a project which requires the user to search for certain categories of products. The products have tags such as: T-shirt, Jumper, hat and I am currently displaying the results ordered by the amount of likes. Here’s my SQL statement: But the issue is that if let’s say someone se…
Laravel 8 Livewire search filter not working with first where clause
I want to have a table which shows all the data per company that has a filter search input, the problem is when I put the first argument where(‘company_id’, Auth::user()->company_id) it bugs out and doesn’t make the filter search work. This is my query for the table. Answer I suppose you …