Questions tagged [mysqli]
Referred to as the MySQLi extension or MySQL improved extension. Allows access to additional features provided in MySQL 4.1.3 and newer. It is included with PHP version 5 and later.
59 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
39
views
MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received
I am trying to do mysql replication. But I want to while the backup is being uploaded to the slave server, the changes in the master are not received.
For example:
I have a user table on my X db. And ...
user avatar
İbrahim Gunes
-3
votes
1
answer
25
views
In what format do I need Insert 3 table sql? [closed]
In what format do I need Insert 3 table sql?
animals(`AnimalsID`, `Animals`, `IUCN_Red_List`, `TypesID`, `BloodedID`)
types(TypesID,Types)
blooded(BloodedID,Blooded)
0
votes
1
answer
414
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 ...
0
votes
1
answer
436
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
143
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 ...
1
vote
0
answers
488
views
MariaDB using 1000+ parameters with EXPLAIN
Can you confirm if this is a bug... I cannot work out if it's MariaDB (10.3.34 or 10.7.3), PHP (mysqlnd), or a mistake I've made:
<?php
$db = new mysqli('host', 'user', 'pass', 'database');
//...
0
votes
1
answer
117
views
Is a connection from my SSL-secured server to an RDS instance automatically encrypted when using mysqli_connect?
I'm trying to determine if I need to use mysqli_ssl_set to encrypt my db layer. I have a standard Amazon RDS instance that I'm connecting to with MySQL user and pass, but I'm unsure if that connection ...
1
vote
1
answer
632
views
UPDATE SET N + 1 equal to a row (with iteration)
Question: How would you iterate over the previous result (referenced below) over for each of the values in column b3?
MariaDB Fiddle (this includes prior fiddle information to solve the previous ...
1
vote
2
answers
25
views
Is it possible to join these both tables?
SELECT u.*,h.*,d.*
FROM User u
LEFT JOIN HealthDec h ON u.ID = h.EmpId
LEFT JOIN Document d On u.ID = d.UserID;
and:
SELECT count(id) FROM OHS
WHERE Category = 'POLICIES'
AND ID NOT IN
(
...
0
votes
3
answers
52
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['...
1
vote
2
answers
190
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 | ...
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 ...
0
votes
1
answer
154
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 ...
1
vote
0
answers
51
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, ...
0
votes
1
answer
39
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 ...