My aim is to get a total count of ‘pending’ and ‘approved’ comments for all posts for a specific user. The comments table has a status column for ‘pending’ or ‘approved’. For the record, the page_id in the comments table maps to the id in the posts table. I star…
Tag: mysql
Amateur trying to fix dropdown menu from SQL
I’m trying to help a friend with a website. I usually don’t work with PHP, jquery. The dropdown has 4 levels. The first level has 4 points. The 4 points have their own sub-levels, different for each other. I’m trying to find them and then make them display in a dropdown, directly from the da…
PHP & MySQL DateTime – Timezone Handling
I want to store a DateTime value in my database (MySQL 5.7). I am trying to figure out the best way to handle time zones. From a glance it seems that MySQL only takes DateTime in the format of Y-m-d H:…
Dynamic multi level Menu with sorting – how to find out the menu level – PHP, MySQL
I have a multilevel menu, a submenu with sorting. I need to find out the menu level so I can assign some characters as bullets. I want to list it using select and add in lvl2 – <option>str_repeat (“ ”, 2) Item Lorem ipsum lvl3 – <option>str_repeat (“ …
How to insert data using a checkbox inside a while loop php
I want to add the value of a checkbox to the specific row in the database. It adds the value to the wrong rows each time. I tried adding a hidden input with a different value. Answer perhaps this might help you understand what I was implying by creating and binding the prepared statements outside the loop. Wi…
MySQL find Array Values in DB Array field
i have an array, that can contain different values for example: Array ( [0] => Allgemeine Pharmazie [1] => Geriatrische Pharmazie ) The WordPress DB contains in the meta_value the following array: a:4:{i:0;s:20:”Allgemeine Pharmazie”;i:1;s:22:”Geriatrische Pharmazie”;i:2;s:16:…
is there a more efficient way of comparing two variables obtained from a db?
This works but is there a shorter(more efficient) way of doing this? code compares 2 numbers. One is from the most recent record, the other is from 7 records down. $sql5=”SELECT market_cap_rank …
Search query by size in PHP
I want my site to search for any product that belonged to particular size when clicked any size option in the select input menu on mobile version like shop by size menu in www.brastop.com on mobile version. My problem is on how to extract size variable from option tag and put it in the select query in sizeres…
Adjusting values in MySQL based on current value
My database is for keeping track of user’s balances, and there are certain actions that will add or remove balance from the users. Currently I am doing this to get the balance and update it $conn->…
Adding HTML codes inside PHP
I’m trying to add a view button to my table but I’m getting a syntax error, unexpected href. Seems like I’m wrong with the formatting. Still trying to learn PHP but is it possible to add href to the …