I simply need to check from database if Day is Blocked show in a select box as disabled and if NOT show the next 2 months all the days in the same select box. I get the Closed(Blocked) days with…
I am trying to connect from this docker container: version: '3.8' services: vidslide-api: image: php:8.1.17-apache ports: - "80:80" volumes: - ./htdocs:/var/www/html command: > sh -c " docker-php-ext-install mysqli && docker-php-ext-enable mysqli && apache2-foreground " to this docker container: version: '3.8'…
I know this is a bit unusual question, but I am looking for a way to execute code like this: $conn = mysqli_connect('localhost', 'root', null, 'mydb'); And instead of going to UNIX socket connection I would like it to use…
I have a question about the correct use of $mysqli->set_charset(). I haven't used this feature on my site for years. Now I'm rewriting my connection script, and want to apply $mysqli->set_charset() properly. At the moment the site is still based…
Hi I'm trying to achieve something with my loop from my database and I don't have the solution. I think I'm close to the solution but really need help. I believe I need to make a loop in a loop…
Suppose I'm a PHP application and I start an innodb transaction with mysqli_begin_transaction and it returns true. Then I do a series of inserts. As far as I am aware --- as a PHP application ---, all inserts went in…
I was trying to make a simple database to write and read from and on pretty much one of the first steps I encountered a problem: it would not connect. I got the error message: "No connection could be made…
If I have a user input form, but the data from this is used purely to make comparisons in PHP, can it be subject to a SQL injection risk? I assume not, and that it is only where I want…
First I get my SQL query result that I put in an array like this : $stmt= $conn->prepare("SELECT p.*, f.* FROM fruit f left JOIN person p ON f.fk_p_id = p.p_id "); $stmt->execute(); $result= $stmt->get_result(); while ($data= $result->fetch_assoc()) { $arr…
Here is the code <?php $servername = "localhost"; $usrname = "root"; $pwd = ""; $db = "test_db"; // connect to the database $conn= mysqli_connect($servername, $usrname, $pwd,$db); if (!$conn){ die('connection failed' . mysqli_connect_error()); } // Create database $sql = "CREATE DATABASE…