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

http 500 error trying to PDO:bindParam

I am trying to create a register form. Having it sucessfully executed in my localhost (XAMPP), I uploaded it to a webserver(000webhost). But when I ran the file, the browser gave me a 500 http error. I tried to debug the code, and figured out that…
Hoàng Tùng
  • 100
  • 1
  • 2
  • 10
0
votes
2 answers

How to resolve fatal error in bind_param() when executing update statement

I am going to update the user profile details(name, password, contact_no, email). Please help me check how can I improve the code so that I can update successfully. Here is DbOperations.php updateUser class: public function updateUser($user_id,…
NRZDYZXLUTMD
  • 9
  • 5
0
votes
2 answers

PDO PHP bindParam() repeated use of same parameters

Yesterday i decided to learn PDO and rewrite our server php to PDO. The thing that jumped to my mind while rewriting the code is the need of repeated use of bindParam for the same parameters i already used. Here is an…
Ariel Estrin
  • 11
  • 1
  • 5
0
votes
0 answers

Setting the bindParam string length of a $_POST variable (php)

i'm trying to insert values into a mysql table using inputs from another page using $_POST and a prepared statement. My understanding is that you need to use the bindParam function for each of the variables being inserted because you cant use…
Rosco verheij
  • 63
  • 6
0
votes
0 answers

Unable to PDO::bindParam() on OUT parameters in PHP on mySQL Stored Procedure (bindValue on IN param works)

I am calling a mySQL Stored Procedure with OUT parameters using PDO and PHP. I cannot get the bindParam() function to execute at all. After much research, I have put together a remedial php script to try to figure this out. The stored procedure…
Darrell Oller
  • 1
  • 1
0
votes
2 answers

Mysqli bind parameters not working

I'm trying to use prepared statements to enter data in a database. The unprepared statement works but this prepared statement does not. I can't find out why. Prepared version: $stmt = $mysqli->prepare("INSERT INTO videos (file_name, upload_by, date,…
Steve Mack
  • 21
  • 6
0
votes
1 answer

php, mysqli-stmt.bind-param]: Number of elements in type definition string doesn't match number of bind variables

// if the 'id' variable is not set in the URL, we must be creating a new record else { // if the form's submit button is clicked, we need to process the form if (isset($_POST['submit'])) { …
Michael
  • 6,377
  • 14
  • 59
  • 91
0
votes
2 answers

How to prepare number of bind variables to match the number of fields in prepared statement

Firstly, I know that this is a repeating question and I'm asking the same question. But I have read all the solution provided that linked to the same problem, but when I followed the suggested solution, it will trigger more warnings to appear. This…
WanHazyan
  • 257
  • 1
  • 12
0
votes
0 answers

bindParam as function argument doesn't pass value

I have a question, namely - I have created a function that selects certain things from the base. I passed the function argument as bindParam, but I get an empty array. The only way in this case is to insert a variable from the argument directly into…
sauero
  • 259
  • 2
  • 15
0
votes
1 answer

php mysql pdo bindparam data not insert

When I Call this function , it shows no error, But Data not inserted. Database Connection is checked and its OK , Connection type PDO. public function insert(){ $table = "category"; $data = array( 'cat_id' => 5, …
MSISHIHAB SHIHAB
  • 3
  • 1
0
votes
0 answers

why is prepared statement not working for creating tables?

Can someone tell me what is wrong with my code. It is giving a syntax error. $email = $email."_account"; $stat1 = $conn->prepare("create table ?(acc varchar(50) NOT NULL)"); echo mysqli_error($conn); $stat1->bind_param("s",$email); $b =…
Piyush Patil
  • 55
  • 9
0
votes
2 answers

PHP - notice: Array to string conversion on call_user_func_array

Notice : Array to string conversion every time i try to call call_user_func_array ("mysqli_stmt_bind_param", array_merge (array ($stmt, $types),refValues ($params_array))) $param_array contains the parameter values and the function refValues…
Th3Wolf
  • 149
  • 1
  • 10
0
votes
0 answers

PHP mysqli binding parameter from array

I use this function to bind parameters into prepared statement , the parameters are a string inside $_POST["params"] and it looks like that: {type1:value1}{type2:value2}.... This function is supposed to bind each param with the statement but i get…
Th3Wolf
  • 149
  • 1
  • 10
0
votes
3 answers

bind_param issue PHP prepared Insert statement

I have a user reg form which then inserts into the db however its throwing up a bind param error if(isset($_POST['submit'])){ // Login Query // Connection $mysqli = new mysqli("localhost", "root", "", "pg"); if ($mysqli->connect_errno) { echo…
Chris
  • 3
  • 1
  • 4
0
votes
1 answer

PDO BindParam and BindValue not working

I've tried looking but cannot find why my code is not working. Here is what I cannot get to work - the query doesn't return anything, in fact the processing stops at the execute. If I hardcode the values in the execute it works: $CID = $_POST […
TenG
  • 3,843
  • 2
  • 25
  • 42
1 2 3
…
17 18