Tag: pdo

Installing pdo_sqlsrv driver in PHP 7.4 using CentOS 8

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 required php version for that environment. How do you enable the pdo_sqlsrv extension to a php 7.4 installation using Remi? I’ve followed this guide: https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#installing-the-drivers-on-red-hat-7-and-8 but

How to set conditions for search in prepared statements?

mysql pdo php

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]

ajax pdo php

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 year ago. Improve this question

Subquery in INSERT executed differently in PDO than SQL

mysql pdo php

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?

case-sensitive oracle pdo php

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 index php error occurs.

Connect PHP 7.4 to Firebird database: could not find driver

firebird pdo php

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 problem is that

Search MySQL query in PHP [closed]

pdo php

How can I convert this mysqli to PDO?

mysql mysqli pdo php

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

arrays json pdo php

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?

arrays multidimensional-array pdo php

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 = $_POST[‘training’] 2nd array = $training_diploma Kinda difficult to explain.