Use more placeholders in WHERE statement after IN statement with arrays

I need more placeholders to be added to the following query. Is this possible? I have no idea where to begin and I can not find any options on the Internet. The query now: $in2 = str_repeat(‘?,’, …

Check availability of appointment slot

I am creating an area for a user where he can make an appointment. The available appointments are inside a table called: bigo_appuntamento This table has these 5 fields bigo_appto_id –> ID …

Why I can’t connect to a MySQL 5.3.36 shared server using mysqli_connect and PHP 7.4, but it will work using php 7.1?

I have this shared account on Hostgator. Using PHP 7.1 and mysqli_connect, I have no issue connecting to the MySQL 5.3.36 database. The PHP script should be fine. The hosting company sent me an email …

PHP mysqli and SSL

I am trying to configure Galera Cluster over a WAN (VPN is not an option). For obvious reasons I am setting up the connections to require SSL keys, and am having difficulties getting the application …

How can I convert this mysqli to PDO?

prepare(“SELECT * FROM userinfo order by id DESC”); $query->execute(); mysqli_stmt_bind_result($…

How to user fetch_assoc() twice in a single php file?

I have two table. One is an article list and the other one is a category list. In the category table, I have use fetch_assoc() to get the data from my DB and list in the table. But I want to fetch the …

convert mysql to mysqli procedural way for google charts

I am trying to upgrade some google charts i use for my own use from mysql to mysqli procedural way, and i have trouble in re-creating the correct array for the google chart to understand. I think i am …

PHP: mysqli_stmt->close() affecting earlier copy of stmt

I am making a function to more easily use prepared statements in sql queries. But while working on it, I ran into a strange bug. When you run the code below the first var_dump of $response prints the $…

How to email details of all PHP exceptions/errors, including mysqli ones?

How can I get all PHP exceptions, both ones generated by mysqli and normal php ones to be sent to me by email? The problem environment I am using a shared server at my ISP and don’t have access to …

How to get user other data when they login in with thier username?

I’m a newbie in programming. I want to ask is there any way I can get user’s data from MySQL in another page when they login in only with their username and password. What I’m facing is I have a …