I am using PHP 8.1 and MySQL 8.0. All databases, tables and individual fields are all set to a collation of utf8mb4_0900_ai_ci - except for databases: information_schema and performance_schema, which are utf8mb3_general_ci (system default?). Here are the global variables MySQL…
I maintain a website, written in PHP a while back. Most of its functions rely on returning an error, instead of catching exceptions. Something like this: (Note: something that was a perfectly accepted behavior in prior versions of PHP.) $tbl_nm…
HTML: <form action="submit.php" method="POST" > <div class="file-input"> <input type="file" class="attestat" id="attestat" name="attestat" accept="application/pdf, application/msword, application/vnd.openxmlformats-officedocument.wordprocessingml.document, image/*" multiple="multiple"> <span class="file-name">Выберите файл</span> </div> </form> and PHP: <?php $servername = "localhost"; $username = "root"; $password = "Youshit21"; $dbname = "medacc"; $conn = new…
I'm trying to deploy a web app to a shared hosting provider (Strato), but I have problems establishing a SSL-connection to the Amazon-RDS instance that I'm using. While testing the web app locally (using XAMPP) it works fine, but on…
This is what I'm doing at the moment in my index I made this button <a class="btn btn-warning" href="map.php?id=<?php echo $fila['id']?> "> <i class="bi bi-geo-alt-fill"></i> </a> Then I made this in another file I got this php code <?php $conn…
I have a database with two tables, ships and officers. A ship has multiple officers. To search for a ship with a specific officer, I have a query like this: SELECT a.id FROM ships AS a LEFT JOIN bridge_officers AS…
I hope everyone is okay. Let's go: I'm trying to enable some php extensions and I can't at all. I use ubuntu with the following version: Distributor ID: Ubuntu Description: Ubuntu 22.04.2 LTS Release: 22.04 Codename: jammy Apache: Server version:…
SQL Table tbl_meals +-----+---------+---------+---------+---------+----------+ | id | receiver| bfast | lunch | dinner | date | +-----+---------+---------+---------+---------+----------+ | 1 | smith | served | | served | 04-18-23 | +-----+---------+---------+---------+---------+----------+ | 2 | philip | | served | served |…
In this snippet below which is used only as a SELECT statement for multiple rows of data, it gives a error on $stmt->bind_param($types, ...$values);: mysqli_stmt::bind_param() does not accept unknown named parameters I understand the error in general, but $Query is…
I am trying to connect multiple database in my project. Since i am using single database and it's working properly, now I would like to connect multiple 2 or 3 databse in my exisiting project, which will helpful for me.…