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
0
votes
0 answers

php bind_param in prepeared statments make the program stops with no error or warnings

I wrote this prepared statment to send data from php to my localhost $stmt = $conn->prepare("INSERT INTO info VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); if ( false===$stmt ) {echo '
ZoZoZo
  • 1
  • 2
0
votes
1 answer

php-use "s" or "i" for long in bind_param()?

in regard to bind_param() function of a prepared statement, it is mentioned in the php documentations that: If you specify type "i" (integer), the maximum value it allows you to have is 2^32-1 or 2147483647. So, if you are using UNSIGNED INTEGER or…
Soheil
  • 587
  • 4
  • 20
0
votes
0 answers

PHP - bind_param with prepared not work with inner join

I don't understand what I'm doing wrong. $email = $_REQUEST['email']; $pass = $_REQUEST['password']; $playername = $_REQUEST['username']; $req_player = "SELECT authme.realname, authme.email, …
Axel Benitez
  • 25
  • 5
0
votes
0 answers

PDO bindParam from array only the last value is inserted

I am doing a small pdo class like this: class Bd { private $conn; private $server; private $port; private $database; private $user; private $pass; function __construct() { $this->server = '127.0.0.1'; …
Jorge Carvalho
  • 59
  • 5
0
votes
0 answers

Safe way to use something like bind_param() to set cellname and detail

I want to make an easy function inside a class that can update each cell in a database. Like I now can use echo $user->cell('email'); to retrieve the email, I want to update it with $user->update('email','new@email.com'); But for as far as I know,…
Bjorn T
  • 33
  • 8
0
votes
0 answers

PDOStatement::bindParam() maximum number of parameters <= 5

Changing from mysqli to PDO, I've started getting errors in my prepared queries regarding the number of parameters given, like so - "PDOStatement::bindParam() expects at most 5 parameters, 7 given" The above was the result of running this…
Carbs
  • 23
  • 5
0
votes
2 answers

bind_param function is not doing anything

I am trying to use the mysqli prepare and bind_param but it is not working. The bind_param function is not doing anything, not returning any error, and pauses execution of the rest of my codes. My codes are as follows: $set =…
Kayode
  • 1
  • 1
0
votes
0 answers

Fatal error: Uncaught Error: Call to a member function bind_param() on bool - couldn´t catch it

may I´m blind after writing over 1000 lines of code, but I couldn´t catch the error. if ($stmt = $con->prepare('UPDATE cb_coachingreport SET pdfsr1 = ?, pdfsr2 = ?. pdfsr3 = ?, pdfgesamt = ? WHERE id = ?')); { $stmt->bind_param('ssssi',…
rambrand
  • 1
0
votes
0 answers

PHP MySql Prepared Statement Parameter Limitations

I'm trying to conditionally add some WHERE constraints to a SELECT by using bound parameters as strings. Eg $sql = $con->prepare(" SELECT `SomeCol` FROM `Table` WHERE ? AND ?"); $sql->bind_param('ss', $p1 = $start ? "`Id` >…
SteveCinq
  • 1,920
  • 1
  • 17
  • 22
0
votes
0 answers

Why does bindValue set fields to the last value?

I am trying to run an UPDATE from a $_POST array using a foreach statement with bindValue. But the fields in the table are always set to the last values. I thought that this problem would arise only if I used bindParam? I call the bind function as…
Giuseppe
  • 1
  • 1
0
votes
0 answers

Executing mysqli prepared statment within while loop that's executing another mysqli prepared statment

I have one mysql table which contains information of all products except their photos and looks like this : watchID | watch_serial | ....> and so on Then I have my product picture table looks like this : picID | name_prod | watch_serial | ....>…
T U
  • 11
  • 2
0
votes
1 answer

How to use variable as parameter name in PHP SQLite3 bindparam

I am using SQLite3 and PHP, and try to write a generic function to execute my queries. For this I would like to retrieve the name of the parameters from variables in the bindParam. But it doesn't seem to work. Here is a code showing the unexpected…
Tuckbros
  • 417
  • 3
  • 13
0
votes
0 answers

what is my error in this prepare statement mysql?

I'm working with prepare on statement but i get this error: Call to a member function bind_param() on boolean public function getUtenteInfo($conn,$email,$password){ $sql = "SELECT utenti.cognome " . "FROM utenti" . "INNER JOIN agenzia " …
Tech Spot
  • 464
  • 3
  • 10
0
votes
0 answers

PHP PDO Bind Param with Having Clause where aggregate function mixed with variable

I am building an SQL Library for my framework which I am making for a university project. I have finished all the helper methods and I am confused about one thing. How do I bind a parameter or value in a Having clause where the left hand side…
user11995521
0
votes
1 answer

Question about Date format when you use mysqli_stmt_bind_param

I get the value of Date from DatePickerDialog and want to send this through Volley. Date variable --> Date community_Date I requested below code and this is my PHP code.
원준호
  • 33
  • 6
1 2 3
…
17 18