Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How do you get a GET protein variable?

C
chanisef last edited by

Reference <a href="page.php?del=test test">link</a>In PHP, I'll catch catch her from $_GET["del"] I'm trying to remove the text field from the base. test test but the field is not removed! From the phpMyAdmin manually, this request is correctly handled by me, and I concluded that the text was stored in the US-GET[ "del " How do you get out of this situation?
The request for the database is: "DELETE FROM services WHERE service=$_GET[del]"
Reply Quote 0
1 Reply Last reply
D
Duquan last edited by
Normally, the text with gaps and other non-requirementable symbols is codified or by a function rawurlencode()which replaces the gap in sequence \%20or by function urlencode()that replaces the pros. In this case, the data can be correctly transmitted through the GET parameter.
```
$del = rawurlencode('test test');
echo '<a href="page.php?del='.$del.'">link</a>';
```
Modern browsers and servers usually decode themselves. However, if you need to decode data on your own for reasons, there is a reverse for each of the above functions: rawurldecode() and rawdecode()respectively.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Z

MySQL Profiling
SQL, Database Testing • mysql profiler • • zymir

2

0
Votes

2
Posts

0
Views

There are several options to do so. 1# Probably the easiest is to turn on general query logging: set global general_log=ON; set global general_log_file='/tmp/query.log'; Then you can see all the queries being executed in the file. 2# Another option is to use slow logs with long_query_time=0. This you can manage on session level: set long_query_time = 0; Slow log also has a bit more information than general log. 3# You can use tcpdump and percona-toolkit to retrieve the queries: tcpdump -s 65535 -x -nn -q -tttt -i any -c 1000 port 3306 > mysql.tcp.txt pt-query-digest --type tcpdump mysql.tcp.txt 4# Profiling also work set profiling=1 show profiles; +----------+------------+--------------------------+ | Query_ID | Duration | Query | +----------+------------+--------------------------+ ... | 3 | 0.01397050 | select * from mysql.user | +----------+------------+--------------------------+ 3 rows in set, 1 warning (0.00 sec) show profile for query 3; This has the biggest overhead and also in my opinion the most cumbersome.
How to get 4 last numbers from a variable?
Software Programming • java variable • • Mystic

2

0
Votes

2
Posts

0
Views

E

You can use the http://docs.oracle.com/javase/tutorial/java/nutsandbolts/op1.html to take the rest of the division of 10 (our numerical base) high to 4 (the digits you want to catch), i.e. 10000.import java.util.Calendar; class Program { public static void main(String[] args) { System.out.println(aleatoriar()); } public static int aleatoriar() { Calendar lCDateTime = Calendar.getInstance(); return (int)(lCDateTime.getTimeInMillis() % 10000); } } See https://ideone.com/ZaSVbt . And https://repl.it/join/whvjozdh-maniero . Also https://github.com/maniero/SOpt/blob/master/Java/Math/GetLastDigits.%2Cjava .The intermediate variable is unnecessary (when it has difficulty giving a significant name to it, it is probably not useful).
S

Connecting JavaScript into bitrix
Software Programming • javascript php bitrics • • shizuka

2

0
Votes

2
Posts

0
Views

A

You don't need to add this piece of code to the JS report. He's cashing and getting the file either rewriting or the cash will be inaccurate. So just add that JS code in footer.footer.php:... <script type="text/javascript"> <?=$jsStr?> </script> </body> </html>
C

Regular expression sought (n,m (a, b) <span> and <br/>and the shadows <a></a></span>
Software Programming • php regular expression • • courtlanda

2

0
Votes

2
Posts

0
Views

M

I think I found an answer, but if there's any mistakes, don't throw stones.)It's regular:#<a name((?!<\/span>).)*<\/span>((?!<br\/?>).)*(н|м|а|я)вк.*?<br\/?>$#miusIt's a piece of code. php with the author ' s sword:<?php $html = '<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru" lang="ru"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title>***@conference.***.us - 25.06.2017</title>  <style type="text/css"> <!-- ///.... </style> </head> <body> <div style="text-align: right;"> <a style="color: rgb(170, 170, 170); font-family: monospace;" href="../../../">Home</a> </div> <div class="roomtitle">tulpae-flood</div> <a class="roomjid" href="xmpp:***@conference.***.us?join">***@conference.***.us</a> <div class="logdate">25.06.2017<span class="w3c"><a class="nav" href="../../2017/06/24.html">&lt;</a> <a class="nav" href="./">^</a> <a class="nav" href="../../2017/06/26.html">&gt;</a></span> </div> <br/> ... <a name="00:00:00" href="#00:00:00" class="ts">[00:00:00]</a> <span class="mn">&lt;Nick&gt;</span> " Шаблон " <br> <a name="00:01:00" href="#00:01:00" class="ts">[00:01:00]</a> <span class="mn">&lt;Nic2&gt;</span> " Шаблон2 " <br> <a name="09:43:11" href="#09:43:11" class="ts">[09:43:11]</a> <span class="mn">&lt;Hankl&amp; Blr&gt;</span> О, Навка, Навка! <br/>'; $reg = '#<a name((?!<\/span>).)*<\/span>((?!<br\/?>).)*(н|м|а|я)вк.*?<br\/?>$#mis'; preg_match_all($reg, $html, $matches); echo '<pre>'; echo $matches[0][0]; ?> That's the conclusion. echo '<pre>'; echo $matches[0][0];:<pre> <a name="09:43:11" href="#09:43:11" class="ts">[09:43:11]</a> <span class="mn"><Hankl& Blr></span> О, Навка, Навка! <br> </pre>
D

Get a variable from AJAX to php file
Software Programming • javascript php mysql jquery ajax • • derk

2

0
Votes

2
Posts

0
Views

D

In the same ajax request, add the php-scrypt value to a page element or to the same console. To this end, success is assigned a function of retrieval with a parameter datawhich provides data from the crypt:$(document).ready(function(){ $(".table_info td a").click(function(e){ e.preventDefault(); var name = $(this).text(); $.ajax({ url: "http://myproject/pages/admin.php", type: "POST", data: ({fname: name}), dataType: "html", success: function(data) { console.log(data); } }); }); });
A

Loading of avatar
Software Programming • php mysql • • Avante

2

0
Votes

2
Posts

0
Views

Joining the above-mentioned post, I just want to add that to know the id of the newly added record in the current connection with mysql can be requested.SELECT LAST_INSERT_ID(); So you'll know the user.
A

Automate get from a list of tuples for variables JSON
Software Programming • python json • • Avante

2

0
Votes

2
Posts

0
Views

N

I practically solved my problem with a tie. I always get position 0 from my list but at the end of the script I delete index 0, that is, my code takes the new index 0 that was before 1 until it was finished.import requests Here is my list of tupleslista = [(1, 'ADMINISTRADOR', 'ADMIN'), (2, 'CEO', 'USER'), (3, 'ALEATÓRIO', 'USER')] Here I seek the first value of my tuplecont = len(lista) while cont > 0: id_user = lista[0][0] nome_user = lista[0][1] tipo_user = lista[0][2] #aqui começo a montar o JSON para o post payload = { "id": id_user, "nome": nome_user, "usuario": tipo_user } try: #ENVINDO POST PARA API url = 'https://lssy4bswv8.execute-api.us-east-2.amazonaws.com/dev/gravar' print('URL API Post: ', url) headers = { "Content-Type": "application/json", 'Accept': 'application/json' } response = requests.post(url, json=payload, headers=headers) finally: print('FINISH') lista.pop(0)
A

Why do I get undefined from my variable in sight?
Software Programming • laravel laravel 7 • • Amritpal

2

0
Votes

2
Posts

0
Views

If you only do:$someVariable = ['hello']; view('some_view', $someVariable); What you do is store it this way:"__data" => [ ... 0 => "hello" ] That's why you should use compact('someVariable') or use key-value ["key" => value], https://laravel.com/docs/8.x/views#passing-data-to-views .view('some_view', compact('someVariable')); To do debug of what you are sending, and how you are sending it, in your sight, you can use the following:{{ dd(get_defined_vars()) }}
How to show the latest articles by category in Gutenberg blocks (WP)
Software Programming • php wordpress • • Marcee

2

0
Votes

2
Posts

0
Views

C

The first thing you have to do is get the current post category and then go back to the query://Modifico tu función para pasarle la anterior en las categorías. function Last5posts() { //Guardamos la categoría del post actual. foreach((get_the_category()) as $category) { $categories = $category->cat_name; } $args = array( 'posts_per_page' => 5, 'category_name' => $categories); $last_5_posts_query = new WP_Query( $args ); while($last_5_posts_query->have_posts()) : $last_5_posts_query->the_post(); $link = get_permalink(); $title = get_the_title(); $date = get_the_date(); $content .= '<div class="latest-posts">'; $content .= '<h3><a href='.$link.' target="_top">'.$title.' / '.$date. '</a></h3>'; $content .= '<p class="excerpt">' .get_the_excerpt(). '</p>'; $content .= '</div>'; endwhile; return $content; } add_shortcode('Last5Posts', 'Last5posts' );
G

As passwords should be in pgadmin, and wamp
Software Programming • php password pgadmin wampserver • • guilherme

2

0
Votes

2
Posts

0
Views

R

Let's go somewhere:Wamp lifts a server in Windows where there is an Apache, MySQL and a PHP.You are connecting with a PostgreSQL, therefore, the credentials you have in the PostgreSQL should be the same in your web application.The configurations of the config.inc.php I don't think you should touch them because they're alien to the PostgreSQL unless you use anything from MySQL/MariaDB.Greetings
T

How do you get the dynamic request to the variable?
Software Programming • sql plsql • • terrea

2

0
Votes

2
Posts

0
Views

A

There's no way that this question isn't a barn. And you just missed the right answer:declare str1 varchar2(100); str2 varchar2(10) := 'dual'; begin execute immediate 'SELECT ''Нужно больше золота'' from '|| str2 into str1; dbms_output.put_line(str1); end; / A little explanation. INTO- is the key word for PL/SQL, not for SQL. Accordingly, if you're performing dynamic SQLI need to write a SQL request. INTO♪ Like I'm above. If you want. PL/SQL and c INTOYou have to pee. EXECUTE IMMEDIATE PL/SQL block:declare str1 varchar2(100); str2 varchar2(10) := 'dual'; begin execute immediate 'begin SELECT ''Нужно больше золота'' into :P from ' || str2 || '; end;' using out str1; dbms_output.put_line(str1); end; /
B

How do you get the variable from mysql?
Software Programming • mysql sql pdo • • baileigh

2

0
Votes

2
Posts

0
Views

G

Why? fetchAll if you do. https://www.php.net/manual/ru/pdostatement.fetch.php $result = $pdo->query('SELECT max(id) as max_id FROM authorized_user')->fetch(PDO::FETCH_ASSOC); echo $result['max_id']; $result = $pdo->query('SELECT max(id) as max_id FROM authorized_user')->fetch(PDO::FETCH_OBJ); echo $result->max_id; In fact, when you get the results of your functions, it's useful to use the ayases. as The name of the Razulty Kolonki."In your case, when only one column value is needed, it might also be useful. https://www.php.net/manual/ru/pdostatement.fetchcolumn.php ♪ Then, $result It will be important.$max_id = $pdo->query('SELECT max(id) as max_id FROM authorized_user')->fetchColumn(); echo $max_id;
C

Get the weights to the current <br/> variables
Software Programming • php regular expression dom • • Cleofas

2

0
Votes

2
Posts

0
Views

K

Since the sectioner of the line is generally clear in your text, it can simply be broken with the help of the text. explode()or as an option preg_split (if any of us could be <br> and <br/> Tae /<br\/?>/g)After the crash, the third element of the acquired mass will contain the required line. So there are options.$data = explode('<br>', $txt); $shipping = $data[3]; Libo list(,,,$shipping) = explode('<br>', $txt); Orlip 7[,,,$shipping] = explode('<br>', $txt); However, it must be sure that the lines (FIO, telephone) above do not contain <br>i.e. the data input should be screened and there is no challenge before the html code is established nl2br()For example.
T

Where's the mistake?
Software Programming • php mysql • • tahishae

2

0
Votes

2
Posts

0
Views

K

There is more than one mistake, the way it is whenever a record is not of level 4 it fell on the else.There is also error in the closing of quotation marks on two lines (5 and 30)The correct code would be: while ($row = mysql_fetch_assoc($result)) { if ($row['level'] = '0') { echo("Fundador"); //pode fazer tudo } else if ($row['level'] = '1') { echo('Admin'); // nao pode adicionar nem remover e/ou edit users } else if ($row['level'] = '2') { echo('Moderador de canais'); //n tem acesso a pagina de jogos e filmes } else if ($row['level'] = '3') { echo('Moderador de jogos'); // n tem acesso a pagina canais e filmes } else if ($row['level'] = '4') { echo('Moderador de filmes'); //n tem acesso a pagina de canais e jogos. } else { echo("Membro"); //sem permissoes p ver as paginas } }
R

Get the data from the Mysql table, assign the variables to each.
Software Programming • php mysql • • Raziyah00

2

0
Votes

2
Posts

0
Views

R

I've done it myself, I don't know how right it is, but it works.$mysqli = new mysqli($host, $user, "", $db); //подключение $mysqli ->query("SET NAMES 'utf8' "); //вся выборка будет в юникоде $sql = 'SELECT name,razmer,price FROM zabor_price ORDER BY name'; $result = $mysqli ->query($sql); //запрос //переменная не может быть на кириллице $cyr = [ 'а','б','в','г','д','е','ё','ж','з','и','й','к','л','м','н','о','п', 'р','с','т','у','ф','х','ц','ч','ш','щ','ъ','ы','ь','э','ю','я', 'А','Б','В','Г','Д','Е','Ё','Ж','З','И','Й','К','Л','М','Н','О','П', 'Р','С','Т','У','Ф','Х','Ц','Ч','Ш','Щ','Ъ','Ы','Ь','Э','Ю','Я',' ' ]; $lat = [ 'a','b','v','g','d','e','io','zh','z','i','y','k','l','m','n','o','p', 'r','s','t','u','f','h','ts','ch','sh','sht','a','i','y','e','yu','ya', 'A','B','V','G','D','E','Io','Zh','Z','I','Y','K','L','M','N','O','P', 'R','S','T','U','F','H','Ts','Ch','Sh','Sht','A','I','Y','e','Yu','Ya','_' ]; while(($row = $result->fetch_assoc()) != FALSE){ //Транслитерируем и добавляем размер $poz = str_replace($cyr, $lat, $row['name']).'_'.$row['razmer']; $$poz = $row['price']; //тут то и присваиваю нужное имя переменной } //var_dump($row); // array(6) { // ["id"]=> string(3) "281" // ["name"]=> string(31) "труба профильная" // ["razmer"]=> string(11) "10х10х1,2" // ["price"]=> string(1) "0" // ["mernost"]=> string(4) "6.00" // ["date"]=> string(19) "2021-04-05 12:58:31" // } // array(6) { // ["id"]=> string(3) "282" // ["name"]=> string(31) "труба профильная" // ["razmer"]=> string(11) "15х15х1,5" // ["price"]=> string(2) "57" // ["mernost"]=> string(4) "6.00" // ["date"]=> string(19) "2021-04-05 12:58:31" // } echo 'Арматура 10мм - '.$armatura_10.'<br/>'; echo 'Труба профильная 20х20х2 - '.$truba_profilynaya_20x20x2;

How do you get a GET protein variable?

Suggested Topics

MySQL Profiling SQL, Database Testing • mysql profiler • • zymir

How to get 4 last numbers from a variable? Software Programming • java variable • • Mystic

Connecting JavaScript into bitrix Software Programming • javascript php bitrics • • shizuka

Regular expression sought (n,m (a, b) <span> and <br/>and the shadows <a></a></span> Software Programming • php regular expression • • courtlanda

Get a variable from AJAX to php file Software Programming • javascript php mysql jquery ajax • • derk

Loading of avatar Software Programming • php mysql • • Avante

Automate get from a list of tuples for variables JSON Software Programming • python json • • Avante

Why do I get undefined from my variable in sight? Software Programming • laravel laravel 7 • • Amritpal

How to show the latest articles by category in Gutenberg blocks (WP) Software Programming • php wordpress • • Marcee

As passwords should be in pgadmin, and wamp Software Programming • php password pgadmin wampserver • • guilherme

How do you get the dynamic request to the variable? Software Programming • sql plsql • • terrea

How do you get the variable from mysql? Software Programming • mysql sql pdo • • baileigh

Get the weights to the current <br/> variables Software Programming • php regular expression dom • • Cleofas

Where's the mistake? Software Programming • php mysql • • tahishae

Get the data from the Mysql table, assign the variables to each. Software Programming • php mysql • • Raziyah00

MySQL Profiling
SQL, Database Testing • mysql profiler • • zymir

How to get 4 last numbers from a variable?
Software Programming • java variable • • Mystic

Connecting JavaScript into bitrix
Software Programming • javascript php bitrics • • shizuka

Regular expression sought (n,m (a, b) <span> and <br/>and the shadows <a></a></span>
Software Programming • php regular expression • • courtlanda

Get a variable from AJAX to php file
Software Programming • javascript php mysql jquery ajax • • derk

Loading of avatar
Software Programming • php mysql • • Avante

Automate get from a list of tuples for variables JSON
Software Programming • python json • • Avante

Why do I get undefined from my variable in sight?
Software Programming • laravel laravel 7 • • Amritpal

How to show the latest articles by category in Gutenberg blocks (WP)
Software Programming • php wordpress • • Marcee

As passwords should be in pgadmin, and wamp
Software Programming • php password pgadmin wampserver • • guilherme

How do you get the dynamic request to the variable?
Software Programming • sql plsql • • terrea

How do you get the variable from mysql?
Software Programming • mysql sql pdo • • baileigh

Get the weights to the current <br/> variables
Software Programming • php regular expression dom • • Cleofas

Where's the mistake?
Software Programming • php mysql • • tahishae

Get the data from the Mysql table, assign the variables to each.
Software Programming • php mysql • • Raziyah00