Fatal error: Uncaught ArgumentCountError: The number of elements in the type definition string must match the number of bind variables
This shows the number of values in your query does not match the amount of bind variables, you should post your query as well, so we can look at it.
Also, instead of mailing excerpts, it is probably easier to use something like pastebin to share your entire code.
I have also noticed that "DateTime::createFromFormat('d./m/Y', $d);" returns false... Why?
The value of $d seemingly does not match the format, perhaps due to the extra '.' (dot) after the d in the format (or is that intentional?)
Op di 12 jan. 2021 om 00:53 schreef Talin Sharma <talinsharma.in@xxxxxxxxx>:
Without the quotes I get:
Fatal error: Uncaught ArgumentCountError: The number of elements in the type definition string must match the number of bind variables in C:\Users\talin\Documents\Code\Web\Projects\Transactions\excel\excelUpload.php:64 Stack trace: #0 C:\Users\talin\Documents\Code\Web\Projects\Transactions\excel\excelUpload.php(64): mysqli_stmt->bind_param('1', false, 1, 1, 1, 1) #1 {main} thrown in C:\Users\talin\Documents\Code\Web\Projects\Transactions\excel\excelUpload.php on line 64What now?I have also noticed that "DateTime::createFromFormat('d./m/Y', $d);" returns false... Why?Thanks:Talin SharmaOn Mon, Jan 11, 2021 at 4:59 PM Serge Fonville <serge.fonville@xxxxxxxxx> wrote:When I try : $stmp->bind_param('$des', '$d1', '$a', '$m', '$t', '$s');
I get: Fatal error: Uncaught Error: mysqli_stmt::bind_param(): Argument #2 cannot be passed by referenceWhat does that mean?You are converting all values to strings, the whole idea is to maintain the data type, so you should remove the quotes.On top of that, you are using single quotes, so the values are not expanded inside the string.Op ma 11 jan. 2021 om 22:44 schreef Talin Sharma <talinsharma.in@xxxxxxxxx>:When I try : $stmp->bind_param('$des', '$d1', '$a', '$m', '$t', '$s');I get: Fatal error: Uncaught Error: mysqli_stmt::bind_param(): Argument #2 cannot be passed by referenceWhat does that mean?Thanks:Talin SharmaOn Mon, Jan 11, 2021 at 12:44 PM Serge Fonville <serge.fonville@xxxxxxxxx> wrote:What would I put where you have to tell what type of date(string, number?)One of the benefits of prepared statements is that you do not need to convert or specify data types. Since the mysqli library handles that for you. It finds the datatype from the datatype of the variable and passes its value to the database service.Op ma 11 jan. 2021 om 13:42 schreef Talin Sharma <talinsharma.in@xxxxxxxxx>:I can try this but if I use prepared statements, I have multiple fields to insert. What would I put where you have to tell what type of date(string, number?)Thanks:Talin SharmaOn Mon, Jan 11, 2021 at 2:42 AM Serge Fonville <serge.fonville@xxxxxxxxx> wrote:I tried and minimize your question to the following code:<?php
$date_from_sheet = "1/1/2021";
// As you know the format of the date, it is easier to convert based on that
$timestamp = DateTime::createFromFormat('d./m/Y', $date_from_sheet);
// Instead of inserting the values inside the string, use bind variables instead.
$query = "INSERT INTO some_table(date_field) values (?)";
// I'm assuming $mysqli is already instantiated elsewhere
$stmt = $mysqli->prepare($query);
// The only field in the query is the date field,
// so it is clear that the only parameter is the corresponding value
$stmt->bind_param($timestamp);
// The only remaining thing to do is execute it.
$stmt->execute();
?>Does this enable you to solve your issue?I used the following sources:Op ma 11 jan. 2021 om 02:18 schreef Talin Sharma <talinsharma.in@xxxxxxxxx>:I have also tried: $d1 = date("Y-m-d H:i:s", strtotime($d)); But that returns random dates when I insert into the database... What is wrong?Thanks:Talin SharmaOn Sun, Jan 10, 2021 at 7:10 PM Talin Sharma <talinsharma.in@xxxxxxxxx> wrote:Also here is the excel sheet I am using for testing.Thanks:Talin SharmaOn Sun, Jan 10, 2021 at 7:05 PM Talin Sharma <talinsharma.in@xxxxxxxxx> wrote:I am attaching all of my code. How do I enter the timestamp to the database then?Thanks:Talin SharmaOn Sun, Jan 10, 2021 at 7:01 PM Serge Fonville <serge.fonville@xxxxxxxxx> wrote:It doesn't seem to work. What I did: $d1 = 'strtotime('1/1/2021'); echo $d1;' Echos: '980053200' That in human form is: 'November 30, -0001' Not what I want... any idea why?You are converting the timestamp to a string again using echo, this outputs a unix epoch. You should instead treat $d1 asPerhaps if you share a bigger part of your code, it would be easier to be of help.
Op ma 11 jan. 2021 om 00:51 schreef Talin Sharma <talinsharma.in@xxxxxxxxx>:It doesn't seem to work. What I did: $d1 = 'strtotime('1/1/2021'); echo $d1;' Echos: '980053200' That in human form is: 'November 30, -0001' Not what I want... any idea why?Thanks:Talin SharmaOn Sun, Jan 10, 2021 at 6:30 PM Serge Fonville <serge.fonville@xxxxxxxxx> wrote:Hi Talin,Would https://www.php.net/manual/en/function.strtotime.php solve your conversion problem?Op ma 11 jan. 2021 om 00:18 schreef Talin Sharma <talinsharma.in@xxxxxxxxx>:Hi All,I have a string: '1/1/2021'. I want to turn this into a timestamp for entering into MySql. I have tried everything I could find. Please let me know how to proceed.Also, let me know if you need more information.Thanks:Talin Sharma
