Asksearch_php.cn

Community Learn Tools Library Leisure

English

Popular searches：
PHP
MySQL
jquery
HTML
CSS

javascript - Python or JS beautifies and compresses SQL statements

When building a SQL audit system, I want to compress the SQL statements entered by users (for storage in DB) and beautify (for interface display). I found two python-related libraries: {code...} Do you have any relevant libraries to recommend? JS related libraries are also available

为情所困 2017-05-18 10:48:12

mysql - If PHP does not use PDO, how to prevent injection when constructing SQL statements?

If PHP does not use PDO, how to prevent injection when constructing SQL statements? Can sprint format string be eliminated?

三叔 2017-06-22 11:54:34

PHP query data has no results

Weird problem. The code that worked before suddenly failed to produce results today. I used SQL statements to check the database and could find it. I don’t know where the problem lies. The PHP version number is 5.2.0. The code is as follows: {code...}

曾经蜡笔没有小新 2017-05-24 11:31:07

Back-end development - How to write sql statements for mysql statistics by time segment?

My database table structure is as follows: The fields are ID, NUM1, NUM2, TIME1, TIME2, MONEY. I want to count the number of IDs at intervals of 15 minutes. The effect is the same as the following sql statement. {Code...} But there is a lot of repetitive code like the one above, and if I change it t...

黄舟 2017-05-25 15:08:22

How to synchronize development and production databases

Do you know of any application that synchronizes two databases - during development sometimes you need to add a table row or two or a new table or column. Normally I write each sql statement to some file and execute the lines on my production database during the upload path (backing it up before). I...

P粉520204081 2023-10-22 23:37:30

What does $mysqli->query() return?

$sql="SELECT * FROM stu where id='$id'"; $jg=mysqli_query($mysqli,$sql); Baidu says that as long as there is no error, it will return true. This is a statement to query the database. I know $ jg is a piece of data. In what form does it exist? I

葫芦娃平衡盘 2017-08-20 23:05:16

javascript - Why do many projects serialize the data in the request body before sending a post request?

I found that many projects use "querystring parsing and stringifying library" to serialize the data to be transmitted in post requests, such as qs. {Code...} There is a sentence in the introduction in qs: "A querystring parsing and stringif...

天蓬老师 2017-06-15 09:23:20

Display html-Input-value as a number in german format when input changes while tracking decimal numbers

So German decimal numbers use decimal commas. When formatting, we also use periods to group numbers. So the number 10000.45 will be formatted as 10.000,45. Now I want an input field (number or text) where you can enter the "German" way using periods and commas. However, I also want to trac...

P粉615886660 2023-09-12 15:55:33

mysql optimization - How to create an index using mysql fuzzy query and order by?

For example, there is a mysql statement like this: {code...} How to create an index for such a sql statement. If you are building a composite index, use: {code...} Since created_at is in front, it is based on the leftmost matching principle of the index. Degenerated into key(created_at). {code...} I...

高洛峰 2017-06-14 10:50:40

PHP - Fatal Error: Uncaught Error: Attempt to assign property on null and warning for reading property

I'm coding in PHP and I'm getting some errors, it's also skipping my else statement <?php//putyourcodehere//$select_query="Select*from`user_table`whereusername='$user_username'";//$result =mysqli_query($con,$select_query);$sql="Select*f

P粉195402292 2024-01-06 21:48:58

Preventing SQL injection attacks in Java programs

I have to add a statement to my java program to update the database table: Stringinsert="INSERTINTOcustomer(name,address,email)VALUES('"+name+"','"+addre+"','"+email+"'); ";I've heard this can be exploited via SQL injection, for example: DROPTABLEcustomer

P粉328911308 2023-10-20 20:06:17

Regular expression - find a regular expression in vim

The original text is simplified as follows (several table creation statements, some tables have the same fields): {code...} I need to select the table creation statements with field2 field in the table, that is, select the following text { Code...} I thought of a regular CREATE\_.\{-}F_class_type\_....

天蓬老师 2017-05-16 16:40:06

Query the data of a specified date in a specified table in mysql database? There are details

{Code...} The above is the existing query statement, which can find all the tables in the entire database and how much data is in the table. Now I want to break it down: For example, there are 1,000 tables in the test database, and I only want to check 200 of them (specified) that contain the specif...

PHP中文网 2017-05-18 10:49:37

Dynamically modify inline CSS styles in Javafx

I'm trying to change the background image of a pane when the application is maximized. My background is set using inline css. I have two different variables and an if statement set up for the style. However, I'm having no luck getting it to change style. StringcssStyle="-fx-background-image:url...

P粉311089279 2024-04-06 20:57:16

How to compare mysql time type fields (accurate to hours, minutes and seconds)?

I need to filter data based on the create_time field. The current sql statement is as follows: {code...} However, I found that this method has a bug, that is, when the upper limit time (arrow in the above picture) is too large, an error will be reported. As shown below: The reason is that the unix_t...

阿神 2017-06-06 09:52:27

Programmatically determine whether an object is described by "a" or "an"?

I have a database of nouns (e.g. "house", "exclamation mark", "apple") that need to be output and described in an application. It's difficult to put together a natural-sounding sentence to describe an item without using "a" or "an" - "the house ...

P粉764785924 2023-08-25 09:15:32

Static image service implementation - PHP, JS and HTML technology

Good morning. I know nothing about HTML, CSS, PHP or HTML but for some reason I managed to put together a website. The website queries a mysql database, loads Google Maps, and displays a marker on the queried address. I have correctly written the Python code to scrape the data, and the data in the S...

P粉990568283 2023-08-13 14:24:45

centos - How to run the python environment in the one-click installation environment of lnmp (php)

The server is centos. The backend language of the server is php, but there is an open source library that is a Python version. How can I run two environments on one server? I'm a newbie, please give me some guidance. Thank you.

淡淡烟草味 2017-05-19 10:06:58

Dynamically generate type definition strings for prepared statements

I'm writing a script that essentially loads data from an API into a local MySQL database. These values change based on what the API returns. Everything is working fine so far until I try to actually insert rows into the MySQL database. Specifically, I know I'm supposed to use prepared statements, ...

P粉031492081 2024-02-03 21:09:39