I have successfully installed php 7.4 with Remi packages in my CentOS 8 VPS (Used this guide https://www.digitalocean.com/community/tutorials/how-to-run-multiple-php-versions-on-one-server-using-apache-and-php-fpm-on-centos-8) I have a VirtualHost in my Apache server, that points to my domain and load the req…
Tag: pdo
How to set conditions for search in prepared statements?
I am trying to create a site search in prepared statements, Here is my code : Conditions for search This is how I add it to query : Here is my question. How can I use conditions safe way in prepared statements ? Answer You can build up an array of any bind parameters dynamically and then pass this to
PDO query not returning correctly [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 1 y…
Subquery in INSERT executed differently in PDO than SQL
I want to insert a new dataset into a MySQL table tab with external data, but also with data from another table otherTab using the others’ table primary key and another condition. However, it could be …
How to make Oracle keep the case of identifiers as they appear in the query?
I want to use a php library that uses PDO. And I want to use an Oracle database with it. The problem is that authors of that library use unquoted identifiers in their queries, e.g.: In this case, Oracle converts the case of identifiers to UPPER, but authors assume the case is lower, therefore an undefined ind…
Connect PHP 7.4 to Firebird database: could not find driver
I’m following the docs to connect php to firebird database. I activated the extension in php.ini I restarted apache on xampp, and I copy pasted the code of the docs for testing. when I run the code I get could not find driver what am I missing here? environment: XAMPP with PHP 7.4 Windows 10 Answer The …
Search MySQL query in PHP [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 1 y…
How can I convert this mysqli to PDO?
prepare(“SELECT * FROM userinfo order by id DESC”); $query->execute(); mysqli_stmt_bind_result($…
PHP Group PDO or JSON results by 3 fields and output
I’m trying to group my results in an array by the 3 fields delivery_date, van_no and drop_no, this is what i have so far: // Gets all orders and sorts by delivery date, van and drop number $…
How to INSERT simultaneously two different arrays in PDO MySQL?
I’m having trouble with a PDO insert. I’d like to insert a multidimensional array into a db, which i managed to. However, i also would like to insert a completely different array, disconnected from the first one into the same db line (which means same INSERT query). 1st multidimensional array = $_…