Questions tagged [Prepared expressions] (13)

0
answer

How to add an article to a specific page?

Do your first draft on WP, faced with the complexity: there are two pages with "Articles" and "news". The content should be appropriate. I rummaged through the headings, and did not understand how to bind a category to a page and is it possible at all, and when you create a test newsletter, it appears in a weird "Blog" wher...
Brayan_Ernser99 asked March 31st 20 at 16:01
3
answers

Inhibiting Prepared statement on Oracle

Colleagues, Have the following sql query, which fetches 20 records sorted by date and transaction: select rd from ( select /*+ INDEX(OUT_SMS OUT_SMS_CREATE_TS_TRX_ID_IX) */ rowid rd from OUT_SMS where TRX_ID between 34621422135410688 and 72339069014638591 and CREATE_TS between to_timestamp('2013-02-01 00:00:00', 'yy...
daphnee.Hane asked October 3rd 19 at 17:40
2
answers

In PHP MySQLi to get the number of matches in the database?

In PHP MySQLi to get the number of matches in the database? $stmt -> affected_rows returns -1. why?
Kavon.Fisher21 asked September 25th 19 at 18:33
1
answer

How to write the query with LIKE operator when using PREPARED STATEMENTS?

In php using prepared statements while fetching from mysql database. Encountered a problem when using the LIKE operator. You need to pass in the query expression of type 'string%', that is, to find all headers starting with 'string'. Actually, the question is, where in the syntax to push the '%'character?$res = $db->prep...
ricky40 asked September 25th 19 at 15:11
2
answers

How to get the result in the ResultSet when processing the SELECT statement in MySQL?

Work units are responsible for INSERT and UPDATE with SELECT - acceptintry { String nCard = jTextField1.getText(); String deprecate = jTextField2.getText(); DriverManager.registerDriver(new com.mysql.jdbc.Driver()); String url = "jdbc:mysql://localhost:3306/visits"; Connection conn1 = DriverManager.getConnection(url, "...
marcella.Luettgen asked September 19th 19 at 14:18
1
answer

WHERE query IN Mysqli — how?

Hi all. In General, the problem is the following: Feature request:$query = $mysqli->prepare('SELECT id FROM Publication WHERE id in (?)'); $query->bind_param('s', $field_cat); $query->execute(); Where $field_cat = "1,2,4"; As I understand it, due to bind_param, the query just inserted (1). And the query is not pe...
eloise_Denesik45 asked September 16th 19 at 22:29
3
answers

What's the point of Prepared Statements MySQL if the external data are in the query SET?

Hello. Studying mysql I stumbled on something that is not quite clear, please help me! All say that prepared queries improve security, but it is not clear what? If you conduct the experiment:CREATE TABLE child (id INT, name VARCHAR(100), count INT); -- prepare the query PREPARE prQuery FROM 'SELECT `id` FROM `article` WHER...
Monty.Ziemann67 asked September 9th 19 at 14:52
1
answer

Where better to make the creation of a prepared statement?

Actually, a subject. Situation: learn MVC. The condition is to create singleton for work with databases. There is an object whose fields you want to update, in parallel, saving the changes to the database. The question is where to declare prepared statements. In the model, in the class database, or in a method of the object...
daron asked August 23rd 19 at 16:25
2
answers

If PDO prepared to use a lot of the queries they will have the resources?

For example. I want to place all prepared queries to be used in the project list in a separate file. And connect it to each location where the project should run the queries. Prepared queries can be about 60-100. Want you to know: if I need to make only one request of 100, other requests which I do not do not send data fai...
bridie_Zie asked August 12th 19 at 18:21
0
answer

ADOdb.Prepared queries.How to do??

Good day,ladies and gentlemen) The fates had to deal with such a thing as ADODB. Nothing complicated,but there's the small matter of how to bust a prepared statement? At the docks all work directly.That,in my humble opinion, is not good,as it is unsafe. Online found this option:$rs = $db->Execute('select * from table whe...
Kale_Schimmel39 asked August 8th 19 at 16:32