Tag: php

Get products with specific attribute term and specific category term in Woocommerce using SQL

php sql taxonomy-terms woocommerce wordpress

I wish to find products with two different criteria. The code I used first to search one criteria is; This returns all those products (Object_ID) with the attribute “pa_1_scale” and ts.term_id = 400. I can also do this to return all products with product_cat and ts.term_id = 397, using a different WHERE statement UNION ALL just combines the two. How

How to stop DB inputs for a certain amount of time from all current users

mysql php sql validation

So I’m making a php website that sometimes requires a big data input from an admin-type user. This would not be frequent and only would happen to update or add certain data to the DB. During this upload time which probably will take a minute or two, I cannot have other Users try to pull the data and and manipulate

How to access multiple variables outside foreach loop in php

jquery php sql variables

I am not a php pro and have already explored different online search forums but could not find any suitable answer and that’s why posting my question here. Function One: Runs a query to database and define variables in foreach loop as follows: Function two: Now I want to get the values of those variables in another function as follows:

Connection failed: SQLSTATE[HY093]: Invalid parameter number

pdo php sql

Hello everyone, I’ve got a problem with my php code. I keep getting this error 0 1 2 3Connection failed: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens. As I understand it means that the number of parameters doesn’t match. I rewrited it many times and I’m pretty sure, that everything in this line

INSERT value by adding URL and file name

mysql php sql sql-insert

I want to to insert value into my single column with website URL and upload path. But I’m really don’t doing that. Here I have 2 columns into my table. And I want to insert the website URL and upload …

MySql Group By Count item count Distinct

laravel mysql php sql

I have a table looks like Here user id 1 exist in level 1 and level 2 Now when we count group by level then in counting we want ignore user_id 1 from level 1 cause it exist another group. we want to consider only one group existing and higher group. I have done only group count but cant understand

Different user login problem because of the syntax error [closed]

mysql php sql

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question In my program, I want different users to have different class_id in order to let them go into different mange page. I distribute them in

can i use md5 hashed values inside $this->db->escape() in codeigniter,

codeigniter php sql

when i tried to use md5 hashed values inside $this->db->escape() i’m getting error like below when i tried to fetch count of results “Call to a member function num_rows() on bool” my code Answer You are making double escape as i see it. Remove the single quotes from $this->db->escape(). Or the better way is to set the variables in the

get users that did not buy a product

mysql php sql

How to run a unique function to calculate and replace a null value in a database?

case javascript php sql sql-update

In the above database, I want to calculate the value for “A2” using the other 3 variables. The premise is that each column has a specific score with respect to each variable and the javascript would sum the answers in a row with a null blank in the A2 slot in this case. Answer You can implement the same logic