Tag: pdo

PHP/ADO Registration Submission [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 4 months ago. Improve this question ( ! ) Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect in…

Update MySQL Database With Data From Multiple Input Elements Inside A While Loop, And A Single Submit Button Outside of The While Loop

forms loops mysql pdo php

I have a page that fetches images from a database after an initial upload, that allows the user to add titles and tags to the images. I have set the while loop to output the individual images inside one form. Each image has two related input fields. What I would like to do is have it so when the form

PDOStatement::execute Values doesn’t work with WHERE Condition & HAVING Condition

having mysql pdo php

i have a erreur PDOStatement::execute Values with WHERE Condition & HAVING Condition in same requette how i can make execute preparing value in both of theme WHERE, HAVING Erreur : Invalid parameter number: number of bound variables does not match number of tokens Answer you first have a problem in your m…

How to connet to my database with pdo in php

pdo php

I want to get all data from my database table ‘user_info’ with PDO in PHP. My username is ‘root’ and the database is name ‘meta’. How to connect to it with PDO with PHP. Answer Try this:

Query return speed is fine but fetch is very slow

pdo php postgresql

PostgreSQL 14 PHP 7.4 I have a PHP call that returns a handle to a scrollable cursor (PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL) with about 760,000 records. The handle is being returned in a reasonable amount of time. However, once I have the handle back, doing nothing but fetching each record in a loop is ta…

PHP SQL Query to get the most common value in the table

count pdo php sql

I’m trying to have my query count the rows and have it return the most common name in that list, then from that it counts how many times that name appears and outputs the name and the amount of times its there This is the code I’m using: However, it just displays the first username in the table an…

How can I update json column with a correct data type with PDO?

mysql mysql-json pdo php

I have MySQL 5.7 and a query with PDO: But after it I’m having: id data 1 {“old_field”: 2, “new_field”: “1”} Why does my new value have a string type? Expected table: id data 1 {“old_field”: 2, “new_field”: 1} I have success without using PDO(J…

PHP script does not execute the MYSQL command

mysql pdo php

I want to update price on invoice with this PHP code (the config file is included, more SQL statements are executed above this): full code (html form): Whole script and things around are working, but the MYSQL exec. isnt working for some reasons (no errors at all) Answer This: should be: Don’t put param…

Assign value PHP variable as column name during fetching

pdo php

I am trying to fetch the values from columns in a MySQL table using PHP. The variable $batch_id is dynamic, i.e. it changes column name depending on the request. Say, it can adopt value like ‘Batch1’ or ‘Batch10’. I was able to extract the column name into the $batch_id variable, but w…

Insert NULL to mySQL-DB instead of 0000-00-00 using PHP Class/function

mysql pdo php

I have a little problem with my PHP-class/function which adds data to my mySQL DB. There is a form in html/php which calls a function on submit to insert data into the DB. Inside the form there is a date-field which is optional to fill out. When I now pass the form data to my function to insert to the