python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - prepared-statement

PHP MySQL prepared statement: procedural Insert / update example

I struggle to understand prepared statements in PHP to allow users to edit a MySQL-database. The user input is UTF-8, typical examples are the name in Arabic, Chinese, ... It also generates a problem ...
test-img

Juergen

php

mysql

mysqli

prepared-statement

on-duplicate-key

Votes: 0

Answers: 1

Latest Answer

If I understood correctly, you want to make a mysql prepared query? (I apologize if I misunderstood the problem) But here my solution and explanation. First : $stmt = mysqli_prepare($link, "INSE...
test-img

TheHuman

Is using quoted_name safe way for parametrizing table name and fields in python's SQL Alchemy?

I spent a lot of time looking for solution to parametrize table names and field names in SQL Alchemy plain textual SQL queries for SQL Server. I stumbled upon several stackoverflow questions and other...
test-img

M.wol

python

sql-server

sqlalchemy

prepared-statement

sql-injection

Votes: 0

Answers: 1

Latest Answer

I don't get the impression from the documentation this is the purpose for which quoted_name is intended. My reading was that it's for cases where non-standard naming conventions for column or table na...
test-img

Paddy Alton

Preparing a SQL statement that contains paired single and double quotes in PHP

Here goes. I have a 200-line MySQL query that contains six different Excel formulas in one of the columns, like this: SELECT '%%%=""Greg''s #""&INDIRECT(""G"&quo...
test-img

AcresOfClams

php

mysql

string

excel-formula

prepared-statement

Votes: 0

Answers: 1

Latest Answer

HEREDOC does the trick. The following code does not get mangled: $csv_fields = array("Location","Location ID","Region","Area","Area #","Client&qu...
test-img

AcresOfClams

Retrive ids of ResultSet and return as java.sql.Array

I have the follow: def getIds(name: String): java.sql.Array = { val ids: Array[Integer] = Array() val ps: PreparedStatement = connection.prepareStatement("SELECT id FROM table WHERE nam...
test-img

wviana

mysql

scala

prepared-statement

Votes: 0

Answers: 1

Latest Answer

Researching more found this: It seems that MySQL doesn't have array variables. May U can try temporary tables instead of array variables So my solution was to create a temp table with just ids: val ...
test-img

wviana

Posts

Questions

Blogs

Jobs