Top "Prepared-statement" questions

Binding params for PDO statement inside a loop

I'm trying to bind parametres for SQL query inside a loop: $db = new PDO('mysql:dbname=test;host=localhost', 'test', …

php foreach pdo prepared-statement

Storing dollar amounts in MySQL: INT vs LONG vs BIGINT

I am constructing a database where I need to store currency values. I am storing the currency values as cents ($100.00 = 10000 ¢). …

java mysql prepared-statement long-integer bigint

What does bind_param() do?

$resultSpendStmt = $connection->prepare(...); $array->bind_param("sdidi", $A, $B, $C, $D, $E); $array->execute(); $array->store_…

php mysqli prepared-statement bindparam

Should I use prepared statements for MySQL in PHP PERFORMANCE-WISE?

I understand the security benefits of prepared statements in MySQL. No need to cover that topic here. I'm wondering about …

php mysql performance pdo prepared-statement

mysql - Select all from one table and one column form another where $var is found

Ooooookay. I have two tables client and users. Both have AUTO_INCREMENT id but client table has credid-column whis is …

sql prepared-statement fetch multi-table

Do i need to sanitize input if using prepared PHP/MySQL queries?

Given the following piece of code, Do i need to escape and sanitize $city? <?php $mysqli = new mysqli("localhost", "…

php mysqli prepared-statement sanitization

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "(" at line

I'm executing the following: private void createTable() { try { PreparedStatement psCreateTable = con.prepareStatement("CREATE TABLE COMPANIES(" + "name VARCHAR(50), " + "location VARCHAR(50), " + "address …

java sql prepared-statement sqlexception

Prepared Statement Error

Recently just changed my statements in SQL to prepared statements for security reasons and here's what I came up with.. …

java sql jdbc prepared-statement incompatibletypeerror

Cassandra Java Driver- QueryBuilder API vs PreparedStatements

Datastax Java driver (cassandra-driver-core 2.0.2) for Cassandra supports PreparedStatements as well as QueryBuilder API. Any specific advantages using one over the …

java cassandra prepared-statement cassandra-2.0 datastax-java-driver

ERROR java.sql.SQLException: ORA-01722: invalid number while running a Prepared Statement to alter a Sequence

sqlStmt = new StringBuffer(" ALTER SEQUENCE " ); sqlStmt.append( ServerContext.getSchemaName() ); sqlStmt.append("SEQ_EDCD_TRACE_NUM"); sqlStmt.append( " INCREMENT BY " ); sqlStmt.…

java oracle jdbc prepared-statement ora-01722