All Questions
10,156
questions
-3
votes
0
answers
40
views
data cant be save in database [closed]
i have a registration form and i want to store the information (gender and phone included) but it didnt store in the database even the register is successful but the column for gender and phone_number ...
- 11
0
votes
0
answers
17
views
MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received [migrated]
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 ...
-2
votes
0
answers
24
views
Insert null in INTEGER COLUMN in mysql [duplicate]
In my mysql database we have few nullable integer and date columns.
Earlier we used to enter blank string ('') in these columns when no data was there and it used to insert properly. But not sure ...
0
votes
1
answer
55
views
Mysql/html how to get output like this, or similar
PhpMyAdmin
Looking for output like this:
In Mysql/PHP, how can I get output like this, or similar (photo 2)?
$start = mysqli_query($conn, $sql);
if (mysqli_num_rows($start) > 0) {
$row = ...
- 19
0
votes
0
answers
162
views
mysqli_connect: authentication method unknown to the client [caching_sha2_password]
I have PHP Version 8.3.7 installed and running according to phpinfo. I attempt a connection to a MYSQL 8 database and receive the message:
PHP Fatal error: Uncaught mysqli_sql_exception: The server ...
0
votes
1
answer
99
views
How to edit value from a linked table in a dropdown(<select>) box?
How to output and edit columns of a many-to-many table through <select\>.
I have three tables : filial_work , department_work, contact_work .
In them, I managed to output only the already ...
- 13
0
votes
0
answers
17
views
Mysqli not showing anything on website (hot_info, exceptions) [duplicate]
some who doesn't know what they're doing here. I am trying to connect to a MySQL database with mysqli from a PHP site running on a local Apache server with PHP 8.3.7, but even when I supply the wrong ...
- 1
0
votes
0
answers
36
views
CSV file not uploading to the SQL database and PHP code not defining the values properly [duplicate]
My PHP code is not uploading data that is being inserted to my SQL database. I have had different source have looked for different fixes for this problem, but I cannot seem to find a fix for it. I ...
- 9
0
votes
0
answers
22
views
How do i get a specific data from my database table to display use? [duplicate]
So i have these PHP code that supposed to retrieve specific data from MySQL database and i want to display the user type in my navigation bar. My problem is it doesn't really display the actual user ...
-3
votes
1
answer
64
views
PHP MYSQL display sql results with foreach loop [closed]
I have a list of submitted vehicle checks. The checks are organized and grouped by date. The table shows the date as well as who submitted that check. When I click view, it should show all the checks, ...
- 1
1
vote
1
answer
59
views
How to construct an UPDATE statement using two arrays
I have an array of column headers and an array of corresponding values at the same index
I need to update a row using both those arrays in SQL.
I know this might not be the neatest way of doing this. ...
- 71
0
votes
0
answers
30
views
PHP not reading/writing emojis from MYSQL database [duplicate]
I've recently upgraded a server to ubuntu 22.04 LTS (from 20.4). This meant moving from PHP 7.4 to PHP 8.1. All works fine (following work on replacing from deprecated PHP functions).
However, I can ...
- 69
0
votes
2
answers
912
views
Mysqli querying error: Argument #1 ($mysql) must be of type mysqli, DB given
Struggling to understand how to get the ID of the newly inserted row.
This is my procedural mysqli connection and SQL INSERT statement:
class DB {
var $conn;
function __construct($...
- 23
0
votes
0
answers
28
views
Server sent charset (255) unknown to the client, what to do? [duplicate]
How to solve this? For the record, I do not have access to my.ini file so that option I cannot try. I am looking for other options to solve this.
I use MySQL 8.1 command client, EasyPHP Devserver and ...
0
votes
0
answers
73
views
#2002 - Connection timed out The server is not responding (or the local server's socket is not correctly configured)
I'm trying to make a MySQL & phpMyAdmin on Replit but there is an error when I'm trying to connect to it from Node.JS, phpMyAdmin.co or any another host and the error "#2002 - Connection ...
