All Questions
49,370
questions
-1
votes
0
answers
45
views
Session variable into a prepared statement [closed]
When I submit a form, I would like the Session variable user_id to carry through to my prepared statements so it can be inserted into my table.
Code of dev.inc.php (following comments...)
<?php
if(...
- 154
-2
votes
0
answers
45
views
Problem connecting to SQL with PHP - This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server [duplicate]
I'm on a shared hosting platform with Krystal running Ubuntu, trying to connect to an SQL database in house with PHP but I'm getting the error:
Caught PDO exception:
SQLSTATE[IMSSP]: This extension ...
- 545
0
votes
1
answer
37
views
How to query revisions of learndash courses, lessons and chapters in SQL
I have a database backup from where I would like to get all revision for a course, then for its lessons and for each lessons the chapters.
The revision of a course was easy enough: SELECT * FROM ...
- 853
2
votes
1
answer
50
views
Query WooCommerce orders count and total amount for specific status via SQL (HPOS compatible)
I'm developing a custom WordPress plugin to display WooCommerce order statistics in the admin panel using SQL queries. However, the plugin does not show the correct data.
Issue:
The plugin is supposed ...
- 21
-1
votes
1
answer
67
views
column not found but column exists in laravel query
Below is my query in laravel project.In this query purchase_return_products.purchase amount actually exists but this show error
'[2024-07-14 16:28:02] local.ERROR: Errors: SQLSTATE[42S22]: Column
not ...
0
votes
3
answers
68
views
how to make cells in <td> tag
I have a table like this :
No
Name Product
Type
Num of Units
1
ADA
B112
3 Pcs
2
ADA
B253
1 Pcs
3
ADA
K23
6 Pcs
4
DUZK
l1
10 Pcs
5
DUZK
l5
10 Pcs
6
Naro
NX
1 Pcs
I have this SQL :
$query = &...
0
votes
0
answers
18
views
PHP PDO Query is not returning any results despite SQL query running correctly in MySQL Workbench [duplicate]
I am working on some PHP code where I take a comma seperated string from a user table, and seperate it into a comma seperated string to be inserted into another SQL query to pull the comma seperated ...
- 1
-2
votes
0
answers
33
views
Why update not working here . Is thery any problem with the code? [duplicate]
When I run this page, it says You couldn't execute the query. I think there is a syntax problem, but I cannot see the problem.
The variables look fine when I echo them. I added the column names as a ...
-3
votes
1
answer
38
views
PHP XAMPP Config [closed]
I try to connect my php website with a XAMPP Server so I can access my MySQL database. Any Ideas how the config has to look like, because I'm rather stuck with this one.
I tried to make a config but ...
- 1
0
votes
0
answers
12
views
iterate over rows in a form [duplicate]
basically i want to write a code that iterates through each row in this form and echoes it, but currently when i hit "save" it only echoes the bottom row there.screenshot
$id=$_POST['id'];
$...
1
vote
0
answers
26
views
I am using Zen Cart and this functions PHP page code needs an adjustment for my use
I would like to have the following statement allow prices to display on the product listing page whether it is a display/read only attribute or not. I currently have the display/read only items ...
- 11
0
votes
0
answers
71
views
query optimization for perfex crm accounting module when dealing with large number of data
Could someone assist me in optimizing the following two functions responsible for loading data into dashboard charts? They currently take approximately five minutes to execute due to a growing dataset ...
- 19
-2
votes
0
answers
62
views
Can't create database sql php cpanel enabled two factor authentication
If I remove two-factor I can create normally. I can't create the db. How can I fix it? Thanks.
I need to enable two factor. My code was attacked by hackers.
Exam code
<?php
$database_name = "...
- 1
0
votes
1
answer
46
views
PHP/Sql : Problem storing a custom date in the database
I want to manually add a updated/modified date for my WordPress posts. So, when I set a date manually and upload the post, the update date is displayed correctly (and the "_cstm_update_post" ...
- 721
0
votes
1
answer
43
views
Sort wordpress post based on highest views
Here's is my post which shows only those posts who has views. Views are counted using wp-view-counter plugin and show those posts as well who are categorized as trending term either they have views or ...
- 11