I'm connecting to a MariaDB database using PHP PDO library. When running the code on PhpStorm, everything works fine, but when running on LAMPP I get the following exception: 127.0.0.1:45536 [500]: POST /register - Uncaught PDOException: SQLSTATE[HY000] [2002] No such…
im trying to make function that take every row from column inv by user id multiply it by 0,015 and then insert this value to zhod with same user id. i have this but im lost already. if someone can…
I seem to have some problem with encoding, but I can't pinpoint it. PHPMyAdmin says: Server type: MariaDB Server version: 10.3.39-MariaDB-log - MariaDB Server Server charset: ISO 8859-2 Central European (latin2) Server connection collation: utf8mb4_unicode_ci I can't change the SQL…
I do a lot of data transfers from sites to sites mainly DB data.. Latest was a simple pdo DB query, fetchall, then Jason encode the data, send to remote site and populate database with data, same database structure. I…
using ubuntu 22, php8.2, odbc driver 18, OpenSSL 3.0.2, when I try to connect with a sqlsrv database using pdo_sqlsrv, it return me this error: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate] the code…
So I'm pulling one column from my database by PDO and i want to echo it directly without assign a variable. <?php echo ($db->query("SELECT name FROM categories WHERE code = '{$_GET['code']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC); This throws array to string error, when…
Question: I had encountered deadlock errors in my application's database transactions. To address this issue, I added retry logic, which successfully resolved the deadlock problem. However, now I'm facing a new issue, and I'm hoping to get some guidance on…
I have a problem. i need to research through query all text containing a substring given by a post method on php. for example, if i input an "a" or a number like "1" (char not int) i need to…
I have a working website running on Unix that connects via VPN to a SQL Server database using dblib. The connection has been created in years past like this: $pdo = new PDO('dblib:host=192.168.2.4:1433;dbname=Andover;charset=utf8', 'UserName', 'Password'); $Query= "Select * From tablename";…
Hi I'am trying to return a the value of output parameter of oracle stored procedure using PDO. I have a class called Sql and in the constructor I am doing the connection to the database then I am using those…