[prepared-statement] Forum Topics

Hello, Got questions on Sql and Php Prepared Statements. How would you check whether the SQL managed to update a row or not ? Which one of the following lines would you add the IF condition to ? 1). mysqli_stmt_execute() 2). mysqli_stmt_affected_rows() Which of the following examples A-D are a …

Hiya, I know it is possible to auto generate prepared statements based on table column names and numbers. But how to achieve it ? I have many tables and I want to allow visitors to be able to search these tables. Now, if I have 20 different tables, I do …

$city = "Amersfoort"; if ($stmt = $mysqli->prepare("SELECT District FROM City WHERE Name=?")) { $stmt->bind_param("s", $city); $stmt->execute(); $stmt->bind_result($district); $stmt->fetch(); printf("%s is in district %s\n", $city, $district); $stmt->close(); } This brings many questions: - What is `s` on the line 4? Do I need to bother with that? - What if I …

Hello, I'm trying to insert values from a form to a table (employee) on my database using prepared statements. From what I can tell the connections are fine, am able to query the database (as shown in the code to check the user type of the current logged in user). …

Hi All, I have problem while using prepared statements. i have a "Select" query in a xml & i m reading it through XML parser & supplying inputs throughs prepared statements. When i execute i am not getting desired results. Below is the snippet : String res=query (query is String …

Since no one answered to my previous thread about a similar issue I rephrase the problem and try my luck again :) I have rather recently started working with prepared MySQLi-statements in php. From what I've learned is it supposed to be much more effective and secure so I've tried …

Hye I have a question: Suppose I use JDBC, JDBCTemplate in order to execute a sql query. The query is something like: query = "SELECT ... FROM ... WHERE user = ? AND password = ? AND x='valuex' AND y='valuey' ..." Where user,password - I got from the web user …