All Questions
27 questions
0
votes
1
answer
401
views
Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2
Not sure to post on the right StackExchange forum. If not, let me know!
Working environment:
OpenSUSE Leap 15.4
MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB
PHP 8.0.25 (cli) (built: Oct 31 2022 ...
- 317
0
votes
1
answer
422
views
mysqli_fetch_array exceeds memory
I a running a relatively simple query:
SELECT gb2_designs.indx,
gb2_designs.response_required,
gb2_designs.user_design_name,
...
0
votes
1
answer
137
views
How to get mysqli to read a mysql cnf file
From the command line, one can get mysql and mysqldump to read a config file using --defaults-extra-file. This can contain username and password for connection.
Is there a way to get mysqli from php ...
- 2,116
0
votes
3
answers
49
views
Deleting rows from multiples tables at once [closed]
I have a question about this piece of code I just wrote. I have a problem with the syntax, the first query executes its purpose, the problem is in the second query which does not.
if(isset($_POST['...
- 11
1
vote
2
answers
184
views
MYSQL Calculate ranking of row that is not yet inserted
I've got a table similar to this data:
| id | username | value |
|-----------|----------|-------|
| 1 | bob | 46 |
| 483 | alice | 90 |
| 176 | sue | ...
- 113
0
votes
2
answers
4k
views
Generate invoice number from 0 to so on for ordered products in orders table in php mysqli
I am trying to generate invoice number in orders table, like if user select 1 or multiple products and add it to cart then place order then invoice number should be same in our orders table for that 1 ...
- 103
0
votes
1
answer
150
views
How to perform strictly SQL query that uses multiple values and searches all fields
I'm trying to create what I would call an "inclusive" search and by that, I'm not referring to "between". I have a snippet of code and it does what I need it to do but it's hacky ...
- 101
1
vote
0
answers
50
views
How to prevent a record from being affected by the ORDER BY RAND() function?
I am building an online exam site using php and mysql. It's just for MCQ type questions.
Here is my database structure:
1) QUESTIONS ( Exam_ID, Questions_ID, Questions_Des)
2) OPTIONS ( Question_ID, ...
- 49
0
votes
1
answer
31
views
How to prevent a record from being affected by the ORDER BY RAND statement in MYSQL
I have a series of problems all which I can't put in the title but I will try to explain them as best as I can. I am building an online exam platform with PHP and MySQL.
Problem 1: Prevent a record ...
- 49
0
votes
0
answers
629
views
How to prevent inserting same value in two columns in one Table?
I'm trying to solve problem which will compare BEFORE INSERTING columns values partnerCode and partnerCodeOwner1 with username in the table below, If partnerCode and partnerCodeOwner1 values same with ...
- 101
0
votes
1
answer
241
views
Why is this blob saving when used as a concatenated string but not as a prepared statement
I have a PHP mysqli prepared statement that looks like this:
$editSQL = "UPDATE tblClientReminders
SET Header = ?, Notes = ?, DepartmentID = ?,
TierID = ?, RemindType =...
- 147
2
votes
1
answer
2k
views
How to select multiple item from database
Please help me. How to select student result from databese using multiple select. But not work.......
My Student Database like - std_profile
id StudentId stdName stdRoll stdClass
1 ...
- 21
-1
votes
1
answer
92
views
join 2 table and the value in a specific manner
I have 2 table one is master and another one is the child, now I want to write a query in such a way that all the value from the master should display and the count of that particular parent id row ...
0
votes
1
answer
4k
views
SUM of column by GROUP BY which is WHithin a GROUP BY [closed]
i want to display the rows GROUP BY main Reference Id and then show the amount GROUP BY type.
this my query
SELECT gl.`drcr`,gl.`amount`,gl.`name`,gl.`type`,
gl.`narration`,gl.`main_reference`,...
- 3
2
votes
2
answers
3k
views
mysqli large amount of connections
I run a php site with mysqli. I got 3551496 Connections, but there were only 30 processes
How can It be
What should I do about it?
The server is up for 6 month, The problem is that I keep getting too ...
- 153