Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 1 year ago. Improve this question When I go to edit anything other than the image and link I get this er…
Tag: prepared-statement
how can i send a value to other page via POST without Input Tag in PHP
How can I send a value to another page via POST without Input Tag in PHP? I tried this way but also it didn’t work. Answer You can’t send form with ‘a href’. You can use button or input button and style it to look like a regular link (correct solution). Or you can use Javascript to han…
How to avoid code repetition with PHP SQL prepared statements?
In most examples of SQL PHP prepared statements that I see, such as: the field names are nearly repeated … 4 times! once after the INSERT INTO(…): task_name (column name in SQL) once after the VALUES(…): :task_name once in the dictionary key: :task_name once in the dictionary value: $taskNam…
PHP – mysqli_stmt_execute() always returns false
Good afternoon, I am building a calculator, using JS and PHP, and need to INSERT the results and other things to a database. I am using prepared statements to achieve that, but for some reason, I am …
MYSQL prepared statment query not matching WRITTERID with WRITTER
I am trying to query a mysql statement to give match the writterid and writter in a drop down. How should i set this up because everything looks correct? I have already made the non-prepared …
How do I get a count on inserted rows for INSERT query with nested SELECT? No luck with affected_rows, result_id, num_rows
The INSERT statement with SELECT in VALUES: The below code loops through an array of user submited strings ($welds) and tries insert its ID into table weld_reference if it exists in table welds. I don’t want to do another query to see if the row exists, I was hoping that I could get the number of rows o…
PHP: update through array
I have a problem with the following code. index.php crud.class.php The code “works” but it doesnt do it the right way. It does update at the requested id in the correct table, but the values are both the same. The data base contains 2 cols (gerecht and omschrijving) and the values that will be upd…
lastInsertId() for UPDATE in Prepared Statement
The code above does not work. The value I am trying to get is primary key auto increment. As lastInsertId() suggests by its name, it may be intended for insert only. If so, what is the proper way to achieve the same goal on an UPDATE? The value I wish to return is the primary key of the table, if
Prepared statement inside while loop generated by prepared statement
So I was just wondering if this is a good practice or not, or for some reason does this type of code affect the speed and functionality of a system ? The first statement could generate 50 or more data, that means that another 50 or more statement will be produced, is this bad? Thanks for the answers. Answer E…
Using one parameter multiple times in prepared mysqli-statement
Is it possible to use one parameter in a prepared mysqli-statement multiple times with only binding it one time? something like this I think this is possible with PDO, but I don’t konw how to do this with mysqli. Answer Just to close the question: The answer is no. If you want to bind a parameter only o…