All Questions
22,173
questions
0
votes
0
answers
16
views
web aplication using php pdo fulltext search delivers result on ubuntu system but not on windows system; identical DB on both
The setting
Windows 11
Server-Version: 8.4.0 - MySQL Community Server - GPL
Apache/2.4.61 (Win64) PHP/8.3.8
Ubuntu
Server-Version: 10.3.39-MariaDB-0ubuntu0.20.04.2 - Ubuntu 20.04
Apache/2.4.41 (Ubuntu)...
-1
votes
0
answers
27
views
To view the history of errors using PDO in SQL [duplicate]
I have created a system using PDO for SQL but there is a small typo error in the field. This has caused the data not to be saved to SQL. The user has filled out dozens of data entries and I just ...
-6
votes
0
answers
24
views
Select Count doesnt count on PHP [duplicate]
$sql_back_adet = "SELECT COUNT(backlink) AS backlink FROM sites";
$stmt_ba = $db->query($sql_back_adet);
if ($stmt_ba->num_rows > 0) {
while ($row = $stmt_ba->fetch_assoc()) {...
0
votes
0
answers
17
views
PHP PDO Query is not returning any results despite SQL query running correctly in MySQL Workbench [duplicate]
I am working on some PHP code where I take a comma seperated string from a user table, and seperate it into a comma seperated string to be inserted into another SQL query to pull the comma seperated ...
0
votes
0
answers
18
views
Php pdo_sqlite extension installation error
I installed php 8.2 on my raspberry pi 4, the installation was successful, and I then installed the SQLite extensions through apt. I uncommented the correct lines in the php.ini file, and php itself ...
0
votes
1
answer
52
views
Not able to show a pdf / image from binary data in MSSQL using PDO LOB
I go MSSQL database which contains attachments - most of them are PDFs. I want to create simple website, that will display attachment after clicking a button. I got main website prepared (there are ...
-3
votes
1
answer
33
views
PHP XAMPP Config [closed]
I try to connect my php website with a XAMPP Server so I can access my MySQL database. Any Ideas how the config has to look like, because I'm rather stuck with this one.
I tried to make a config but ...
-1
votes
0
answers
31
views
Fatal error: Uncaught PDOException: could not find driver for SQLite [duplicate]
I just created a SQLite database 'data.db'. I want to connect it in this php code:
<?php
$pdo=new PDO('sqlite:./data.db');
$query=$pdo->query('SELECT * FROM posts');
if ($query === false){
...
0
votes
0
answers
31
views
Informix PDO assoc_id error SQLSTATE=HY000, SQLDriverConnect: -25546
It has been about half a year that we have been facing an error on our production server. At the beginning it happened every 2-3 months, but last Friday it happened again and today once again. We have ...
0
votes
0
answers
18
views
SQLSTATE[HY000] [2002] No connection could be made because the target machine was selected [duplicate]
I'm trying to connect my windows machine with xampp, using php with PDO, to a server on the local network (Linux)
<?php
$dbname = "DBNAME";
$user = "USERNAME";
$pass = "...
7
votes
9
answers
780
views
Possible bug with PHP PDO and with PostgreSQL
At the startup of the docker application (with laravel php), for 1 request, connection to database is fine. After the first request I start to get this error.
SQLSTATE[08006] [7] could not send SSL ...
1
vote
1
answer
59
views
PHP is not reading .env file
I am using PHP with PDO to connect to my database.
I want to start using environment variables, so I used the following terminal command:
composer require vlucas/phpdotenv
My .env file now contains ...
0
votes
0
answers
18
views
SQLSTATE[HY093]: Invalid parameter number, fetch data from API [duplicate]
i faced this error when i build API, i want to fetch data that can filter based on 2 category (cpNumber or partNumber).
this is result from postman, status code 500
{"error":"Database ...
0
votes
0
answers
38
views
Why PDO::FETCH_CLASS is working with small results and does not work with large results?
I'm trying to convert my SQL result into a class using PDO::FETCH_CLASS.
The code was working fine, until I encountered a query that generates 83 rows. The query returns two columns, one of type int ...
-2
votes
0
answers
52
views
Why do i get PHP source code and bad chars via SQL output?
Normally i don't have big issues programming PHP and SQL, but i can't really figure out what causes this little bug.
I have a page using PHP and fetching data from a MSSQL server.
I use PDO functions ...