All Questions
13,355
questions
0
votes
0
answers
36
views
PDO MySQL 5.6 Query Execution Timeout [duplicate]
Going through threads from 2009-2022 it doesn't look like there has been a real answer on getting a query to timeout in PHP from MySQL (5.6). The PDO timeout attribute is for the connecting, not the ...
0
votes
0
answers
35
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)...
0
votes
0
answers
18
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
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 = "...
0
votes
0
answers
53
views
PHP Desktop with mysql
I downloaded php desktop from the following github repository: https://github.com/cztomczak/phpdesktop.
However, from what I checked, it doesn't even come with the pdo_mysql extension in PHP Version 7....
0
votes
0
answers
32
views
Reload page with no querystring if original querystring yielded no results from a database query
I've the following code for filename usa.php
$query = "SELECT * FROM usa WHERE deleted='0' AND filename<>''";
$stmt = $conn->prepare($query);
$stmt->execute(array());
$...
0
votes
0
answers
84
views
Random MySql client error "got an error writing communication packets"
I have several different Linux servers running MySQL 8.0.x instances (ranging from 8.0.23 to 8.0.33).
I occasionally get "error writing communication packets" from clients when connecting to ...
0
votes
0
answers
33
views
php Getting the COUNT [duplicate]
I’m looping through a user table to check if they exist in another table. It sounds simple enough, but I’m not able to the results I need.
Running this query tells me if the user exists:
SELECT COUNT(*...
-1
votes
1
answer
37
views
Return row ID # to be used in next execute() statement? [duplicate]
I have three tables, one master table for plant readings, whose id is the foreign key that associates multiple readings from the compressor table and the ice temperatures table. I want to get the id ...
1
vote
0
answers
68
views
Cloud SQL issue after PHP update to 8.2
I am using PDO connection for Cloud SQL from website. I have updated PHP to 8.2 recently and connection has stopped working and giving error
[MY-010914] [Server] Bad handshake
even though there is ...
0
votes
0
answers
22
views
Showing one instance of a join [duplicate]
Currently i get all users with there respective roles if they have multiple
but i do get more then one instance of the same user but with a difrent role Like:
User1=>role1
User1=>role2
but i ...
0
votes
0
answers
29
views
I can't manage to make PDO works in PHP [duplicate]
i've used PDO without problems (we did installed it with our teacher, as i remember we just had to uncomment the extensions line) and two days ago i tried to reinstall the whole lamp stack (cause i ...
0
votes
0
answers
16
views
bindParam (PDO)- SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens [duplicate]
I am learning php and getting the error:
"SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens" when executing below php pdo code. mysql table ...
-2
votes
1
answer
93
views
PHP connection to server failed in Visual Studio Code [duplicate]
I'm having trouble with connecting my PHP to a server so I can use a database.
First I've tried this code. But this gives me the message: "could not find driver".
<?php
$hostname ...