I have a query inside my PHP program like SELECT table_a.firstname, table_a.lastname, table_b.english_score, table_b.maths_score FROM table_a INNER JOIN table_b ON table_b.student_id = table_a.id …
Tag: sql
Get a product from specific product attribute term name in WooCommerce
I’m trying to create a WooCommerce shortcode to display one product with some information. Every day there is a new product with attribute DAGAANBIEDING and value JA or NEE. I only want to show that …
Create a table for each user with their ID
I have a problem with a website that I am currently creating that I need a table for each user but it does not work. I have tried to create a table during registration or the first login, which also …
PHP SQL get values with complex checkbox filter
I have 3 tables product product_feature feature In the first one I have my products, the second one I have the id to the product and the id to the feature and the 3rd one I have the features that can be different colors, sizes, material… I built a filter menu with Color blue, red, white, black… Size XL L
Update database with a live choice made by client
How to update a specific cell in phpmyadmin with jQuery after appending a specific div to a group, code is below the problem is when the item getting updated in database, it became always Group 2 which is the second update. So how to update the database with the selected group on a side question is it better to use
Laravel: problem with password not updated with hash password in database
When I register a new user sign up, it save the password to database with hashed password. But when I go edit the user from the admin dashboard, the edit function work perfectly, but the password did not store or save as a hashed password, it save as plain text. This is link to image show in database modification This
fetchAll only fetches one row from two joined tables
I have a join of two tables. Actually the code and the fetching worked fine before I inserted : and But now it only fetches the first row even though there are two: I used fetchAll and a foreach loop so I just don’t see why it is only fetching the first row. Maybe someone can help, thank you! Answer
Bind_param warning number of variables and parameters don’t match [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 1 year ago. Improve this question When I go to edit anything other than the image and link I get this error “”, although it still updates the
insert into tables from another tables
Well, I trying insert into tables to another but I get this error; WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version …
Foreign key returning empty result set
I’ve created a foreign key to link two tables: The addresses of my users (foreign key) User login details (primary key). However, when I create the foreign key no details that the user enters are …