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…
Tag: php
How to stop DB inputs for a certain amount of time from all current users
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…
How to access multiple variables outside foreach loop in php
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 variable…
Connection failed: SQLSTATE[HY093]: Invalid parameter number
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 ti…
INSERT value by adding URL and file name
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
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]
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 int…
can i use md5 hashed values inside $this->db->escape() in codeigniter,
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->es…
get users that did not buy a product
I have three tables users table +————————–+————–+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | …
How to run a unique function to calculate and replace a null value in a database?
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 th…