Stack Overflow
Stack Overflow

Questions tagged [bindparam]

In PHP, binds a variable to a corresponding named or question mark parameter in the SQL statement that was used to prepare the statement.

Binds a PHP variable to a corresponding named or question mark parameter in the SQL statement that was used to prepare the statement. Unlike PDOStatement::bindValue(), the variable is bound as a reference and will only be evaluated at the time that PDOStatement::execute() is called. 

public bool PDOStatement::bindParam ( mixed $parameter , mixed &$variable [, int $data_type = PDO::PARAM_STR [, int $length [, mixed $driver_options ]]] )

Reference

PHP Documentation

267 questions
-1
votes
1 answer

Returning a field from mysql using rowCount is not working

I want the following code to return the userID from mysql tblUser of the user if the email and password matched. Currently it is not returning anything
LESETJA
  • 15
  • 3
-1
votes
1 answer

'SQLSTATE[HY093]: Invalid parameter number: parameter was not defined'

I keep getting the above error. Here's my set up where it is happening: $InsertSQL = "insert into reports.NonVarassetInvoices(State, CLLI, Type, Vendor, DateReceived, InvoiceNumber, InvoiceDate, TotalInvoiceAmount, ProjectWONumber, CAF,…
Mike
  • 1,853
  • 3
  • 45
  • 75
-1
votes
1 answer

Passing array through bind_param

I'm passing an array of values through a bind_param function, the way I do this is like this: _mysqli…
MrLine
  • 638
  • 7
  • 25
-1
votes
2 answers

PHP - PDO Prepared statment, "Warning: PDOStatement::bindParam() expects at least 2 parameters"

i am trying to use a prepared statement to set a placeholder value using a class object property that is passed as an argument to the __construct function. However i seam to be getting an error specifying the need for 2 parameters when i only have…
Frederick M. Rogers
  • 841
  • 4
  • 14
  • 37
-1
votes
1 answer

Zero is inserted instead of the values [Insert Query Using Prepare statement]

How to insert varchar types to mysqli database using prepare and bind. Here is my code for prepare $ins_filter = $con->prepare("INSERT INTO http_filter ( filter_id , filter_name , created_by , src_ip_address_from , src_ip_address_to ,…
Asha N
  • 11
  • 6
-1
votes
2 answers

Bind Param Error

I'm having a MySQL/MySQLi/PHP Error with my link shortener the error is: Fatal error: Call to a member function bind_param() on a non-object in /home/exabit/public_html/9ui/index.php on line 50 here is the problematic…
Z Davies
  • 17
  • 5
-1
votes
1 answer

Insert into phpmyadmin with bind param

I want to insert values into my database. I have phpMyAdmin database on a free webserver. Here is the code: $con = mysqli_connect("hostname", "user", "password", "databasename"); $name = $_POST["name"]; $username = $_POST["username"]; …
Caroline Koosy
  • 61
  • 7
-1
votes
1 answer

PDO foreach loop over bindParam with a reference return wrong result

I think I've read many topics on that question but still get a wrong result. I have a query parameters array that I want to loop with foreach() to bind parameters. foreach($aQueryParams as $key => &$value){ $stmt->bindParam($key,…
Samy-DT
  • 13
  • 5
-1
votes
1 answer

If I use $_POST value directly in bindParam (mysqli) will there be a security issue?

I have been reading about using $_POST values being used directly in isert statements and understand that this is an invitation for trouble. What is not clear in any of the posts I read was - Say my form is sending 7 items to my mysqli insertion…
vinaya
  • 262
  • 2
  • 15
-2
votes
1 answer

PHP bindParam function does not work

By commenting out I found out that the last line in this code that isn't commented out $query->bindParam(':password', $password); is the line where the code stops working and all I get is a This page isn’t working .... is currently unable to…
griesgram
  • 71
  • 6
-2
votes
1 answer

error when using bind_param() in php

I keep getting the follow error when using bind_param() and have tried everything to fix it but nothing seems to work. Warning: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables here is…
Rebekah
  • 21
  • 4
-2
votes
1 answer

No result when using prepared statements

I want to create a simple select with prepared statements but as result I just get NULL :( When I do it without prepared statements everything is working fine.
ultimate2106
  • 21
  • 5
-2
votes
4 answers

Query to Validate if Email Already Exists in Database; Row count returns 1 instead of 0

I am trying to validate if $email exists in my database. I am 100% sure $email has not been registered before, yet count($results) is returning 1 and $results['email'] is returning an empty string. I have looked at other examples on how to code a…
Andrew Redican
  • 39
  • 5
-2
votes
2 answers

PHP Fatal error: Call to a member function bind_param() on a non-object in

I am getting a error while running below code any one here pls help me out public function storeUser($name, $email, $password, $phone,$stream) { $response = array(); $uuid = uniqid('', true); $hash = $this->hashSSHA($password); …
Kunal Agrawal
  • 11
  • 6
-2
votes
1 answer

Not Getting Any Results with Query

I am having getting my query to display results, I have ran the exact same query locally in mySQL and I get the desired result but when it is executed through the following code nothing happens. $JobID = '3214.GF.010.J45.TEA'; $ProjectID = '3214'; …
Lewis M Hackfath
  • 131
  • 5
  • 17
1 2 3
…
17
18