Home / Questions

All Questions

Martin Hope
A. Cedano
Asked: 2020-06-02 09:09:35 +0800 CST
  • 32

The goal of the question is to have one or more well-crafted answers to serve as a reference when using the extension mysql_*in code.

Answering questions here on Stackoverflow I am surprised by the number of users who continue to maintain code that includes the API or extension mysql_*to handle the data, despite the fact that in the PHP Manual it says the following:

This extension is deprecated as of PHP 5.5.0, so it has been removed as of PHP 7.0.0. The mysqli or PDO_MySQL extension should be used instead . See also the MySQL API Overview for help choosing a MySQL API.

That means the functions:

  • mysql_result
  • mysql_select_db
  • mysql_num_rows
  • mysql_connect
  • mysql_db_query
  • mysql_fetch_assoc
  • mysql_*... todas las que empiecen así ....

All of these features, and many others listed here , should be avoided.

To add insult to injury, the functions are almost identical to those of the extension mysqli, which is recommended in conjunction with PDO. The only difference between the deprecated functions listed above and MySQLi's is the letter ibefore the underscore _.

So the question is this: What are the main serious reasons why I should stop using the extension mysql_*to query my data?

PS: I am willing to reward one or several good answers.

php
Martin Hope
Jorius
Asked: 2020-04-19 12:07:55 +0800 CST
  • 32

Lately I've seen a lot of problems in Google Chrome (in other browsers it works fine, except also Safari on Mac) when loading a new version of a style sheet ( .css) or a javascript script ( .js), I thought I could solve it by A simple:

<link rel="stylesheet" href="/private/css/visual.css?v=1" />
<script src="/private/js/visual.js?v=1"></script>

But it doesn't always work for me and I have to be constantly changing the value of v=1so that it loads the new versions of the respective files

Is there any way to prevent the cache properly?

Get a library, native javascript code, something to add to my files .cssor .js, change on my server, change on my machine, browser settings, etc... and avoid this problem.

NOTE: The cache remains both locally and already hosted on a server / domain

UPDATE: Maybe at first I wasn't very clear, although JuankGlezz's answers and derivatives help me in the development environment, I'm looking for an answer that can serve my end users without them having to touch anything...

javascript
Martin Hope
Chofoteddy
Asked: 2020-12-09 12:44:45 +0800 CST
  • 32

Added Details

I found on the internet the following two ways to deny:

  • ?!
  • [^\w]

But I can't find documentation in Spanish and English that they use to describe the operation, I consider it too advanced to understand the meaning of both and how to use them properly to obtain the expected result. The current answer fixes the problem but gives no usage definition.

Problem Statement

I want to select all those words that are not in quotes within a text. I know how to do the opposite.

Example:

Lorem ipsum "pain sit amet" , consectetur adipiscing elit, maecenas est felis "sit amet" .

With the following regular expression you could take the words that are in parentheses:

/"([\w\s]+)"/gim

The result

[
    1 => 'dolor sit amet',
    2 => 'sit amet'
]

What I look for

[
    1 => 'Lorem ipsum ',
    2 => ', consectetur adipiscing elit, maecenas est felis ',
    3 => '.',
]

Another example would be, from the following list:

  • Hello
  • hello
  • hello
  • hi*
  • hello

Print / select those that do not use alphanumeric characters (I know how to take the opposite of the established indication). Take everything that is not an alphanumeric character, take all those words that do not have an "l", take everything that does not start with the letter "z", etc.

Working example: http://www.regextester.com/15

I would expect to do something like this for everything that doesn't start with "a":

/!^a.*/

But obviously it doesn't work for me, I'm waiting for your feedback.

Clarification

I would also like to understand the solution proposed and not just a copy-paste to solve the problem.

Note: The regular expression that I quote here to obtain the text works for me in PHP and JavaScript (languages ​​that I use to solve the problem), I have seen that there are small variations of regular expressions in the different languages ​​but between these 2 it is not something substantial. Therefore I would like the proposed solution to work in one of the 2.

Support sources

javascript
Martin Hope
Alvaro Montoro
Asked: 2020-12-08 08:25:37 +0800 CST
  • 32

How can I copy the content of an div(or any element) to the clipboard using only JavaScript/jQuery without using Flash?

For example, if I have this code:

<p id="mi_parrafo">
  Texto que quiero copiar
</p>
<button>Copiar al portapapeles</button>

What should I do so that, after pressing the button, when I press Ctr+ Vthe content is pasted inside the label marked as #mi_parrafo?

javascript
Prev
Next