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).

Name of methods of work with MySql PDO

E
esther last edited by

I'm writing my class to work with MySql through PDO. I'd like to simplify the pysanine, the only question is how to name a method that would not be a problem in the next PHP versions. Suddenly, they'll figure out a similar with the name of my methods.
I just want to ask for data in bud. I'm writing a method that will be in (ключ массива, ключ массива) VALUES (значение массива, значение массива)♪
If I call method selectIt's gonna be understandable, but it's stupid, and if it's called DB_select or PDO_select ?
Reply Quote 0
1 Reply Last reply
C
courtlanda last edited by

Why stupid?
There's nothing to do with Nemespeis. They belong to names. Class♪ There's no need for any nemspeis inside the class. The R.R. won't come up with new functions for your class.
What's the point of repeating and writing? $pdo->pdo_select() or DB::db_select()? That's what's gonna be stupid.
And it's stupider to call the word select the method that meets the INSERT request.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

How does the cloneNode method work?
Software Programming • javascript c languagelone • • carriann

2

0
Votes

2
Posts

0
Views

Basically, https://developer.mozilla.org/en-US/docs/Web/API/Node/cloneNode copy the nodebut the clone doesn't have a relative and will not be part of the document unless you add it somewhere.It receives a parameter Boolean indicating whether the copy should be deep deep deep deep deep deep deep deep deep or not.In case of non-copyingdeep deep deep deep deep deep deep deep deep, only the node and their attributes are copied. Not even the text that is inside Tag is copied. In the event of events, only those defined inline will be copied. Already those added by addEventListener will not be.If the copy is deep deep deep deep deep deep deep deep deep, all of us children are copied. But events added by addEventListener will continue not being copied.Example:document.querySelector('#paragrafo').addEventListener('click', function() { alert('cliquei no paragrafo'); }); function clonar(deep) { let clone = document.querySelector('#paragrafo').cloneNode(deep); // remover o id, senão você terá mais de um elemento com o mesmo id clone.removeAttribute('id'); document.querySelector('#main').appendChild(clone); }p { padding: 2px; color: blue; border: 1px solid blue; } #paragrafo { color: red; border: 1px solid red; }<div id="main"> <p id="paragrafo" onclick="alert(inline onclick ${this.id})">lorem <b>ipsum</b> etc</p> </div> <form> <input name="deep" type="checkbox">Deep clone<br> <input type="button" value="clonar parágrafo" onclick="clonar(this.form.deep.checked)"> </form>I put an edge around the paragraphs so that it is possible to view in cases of non-copyingdeep deep deep deep deep deep deep deep deep, since in such cases the paragraph will have no text (only empty tag). But note that still clones keep the event set by onclick (but it does not have what was defined by addEventListener).Another detail quoted in the documentation is that the value default parameter deep, when not specified, may vary according to implementation (in old versions of some browsers it was true, but in the newer specifications became false). So the most guaranteed is to always pass the parameter according to what you need.About the styles, in the examples I used did not have problems, but researching found https://stackoverflow.com/q/1848445 saying that https://developer.mozilla.org/en-US/docs/Web/API/Window/getComputedStyle were not copied. If that's your case, the solution is in the answers there.
A

Method slice() does not work for mass
Software Programming • javascript slice • • Anderson

2

0
Votes

2
Posts

0
Views

D

'Cause need to write English letters, not Russians: sliceNot sliсe♪
E

The function of returning the name and the name is not working well.
Software Programming • c++ regular • • emerson

2

0
Votes

2
Posts

0
Views

You have a problem with the code. Keep the file in Windows-1251 and edit the function changePlayerName.std::wstring changePlayerName() { SetConsoleCP(1251); SetConsoleOutputCP(1251); std::wstring playerName; std::getline(std::wcin, playerName); const std::wregex nameProperties(L"^[А-Яа-яA-Za-z'’-]{2,64}\\s[А-Яа-яA-Za-z'’-]{2,64}$"); while (std::regex_match(playerName, nameProperties) != 1) { std::wcout << "\nНеверный формат. ФИ хоккеиста должно содержать два слова, написанных на русском или английском языке." "\nМожет включать в себя дефис(-) и апостроф('|’)" "\nПопроуйте снова... "; std::getline(std::wcin, playerName); } std::wcout << "Имя " << playerName << " принято!" << std::endl; return playerName; }
J

How does the method notifyDataSetChanged() work in RecyclerView
Software Programming • android recyclerview retrofit rxjava • • Jolied

2

0
Votes

2
Posts

0
Views

S

Replace.@Override public void onBook(List list) { books = list; Log.d("My_Tag", "Уведомить адаптер " + list.size() + " " + books.size()); Log.d("My_Tag", "адаптер " + rc); rc.getAdapter().notifyDataSetChanged(); } ♪@Override public void onBook(List list) { books.clear(); books.addAll(list); Log.d("My_Tag", "Уведомить адаптер " + list.size() + " " + books.size()); Log.d("My_Tag", "адаптер " + rc); rc.getAdapter().notifyDataSetChanged(); } The reason is, you didn't change the status of the list that had previously been reassured by the adapter, replaced the reference to reference to the list.
CORS does not work with the POST method
Software Programming • php angular post cors • • Laycee

2

0
Votes

2
Posts

0
Views

N

RESOLUTIONI'll leave the solution if it'll help someone else.The problem was that I was sending the jsons in json format directly. He had tried to do the post by sending directly user and using JSON.parse(JSON.stringigy(user)) and it didn't work. The right way was JSoN.stringify(user). This solves the problem.
S

Working with "named pipe" on python
Software Programming • python • • Saumya

2

0
Votes

2
Posts

0
Views

I answer myself... Named Pipe in Linux with a Python Example – roman10 http://www.roman10.net/2011/04/21/named-pipe-in-linux-with-a-python-example/ This url explains how reading and writing works using a named pipe. The detail is that for each writing the pipe should be opened and closed. py1.pypipe = open('psquid', 'w') pipe.write('hola') pipe.close() py2.pypipe2 = open('psquid', 'r') pipe2.read() 'hola' Greetings
O

How's WooCommerce on the id order to get a client's phone number?
Software Programming • php wordpress woo trade • • Oba22

2

0
Votes

2
Posts

0
Views

N

You answered your question. $order = new WC_Order($order_id); $user_id = $order->user_id; // id пользователя $email = $order->billing_email; // email $phone = $order->billing_phone; // телефон The variable phone contains the phone.
String comparison problem in AJAX
Software Programming • javascript php ajax • • inna

2

0
Votes

2
Posts

0
Views

You are not having a problem with comparison, but with return. Currently your request is asynchronous, so it doesn't make sense you return data about it directly in the code. Another problem is that you do not return anything in the scope of VerificaCPF.If your request was synchronous, you could get your information directly. Unfortunately or fortunately, synchronous requests will be removed in the future as they spoil user interaction with the page.Synchronous requests stop code execution, affecting the page around until it is finished. A request from these "pauses" all while it is not finished. for (; xhr.readyState !== 4 ;);, it is like an infinite loop that breaks until the request is made, only that is something native.What I would recommend you do is use functions like callbacks, passing extra arguments for them. I currently do this: return an instant object from an interface, where I hope events like done by calls. But, to leave the most basic code I will leave a specified callback in a parameter of your function (now missing the request error callback).function VerificaCPF(strCPF, callback) { $.ajax({ type: 'post', url: 'daoAssociado.php', data: { "action": 'VerificaCPF', "cpf": strCPF } }).done(function(resultado) { var valid = '4b2c518cb740685b1b29f477283165b732651f05' callback(resultado === valid) }) }
A

Regex, finding all matches.
Software Programming • php regular expression • • Anderson

2

0
Votes

2
Posts

0
Views

K

\s At the end of your term, it means "any missing symbol." Your example ends with a point, not a gap, and the second reference is not appropriate. However, after the first reference there is a gap, it is correctly defined. That's what Mike said.
O

ORDER BY doesn't work MySQL
Software Programming • mysql mysqli mysql workbenc languageh • • obi

2

0
Votes

2
Posts

0
Views

A

Don't use the alias that you put on the unbtened column:SELECT CREDITO, DATE_FORMAT(FECHA_PROM, '%W %d de %M %Y') AS FECHA_PROM, CR, COMENTARIO, MONTO_PP, AGENTE, DATE_FORMAT(FECHA, '%W %d de %M del %Y, %h:%m %p') AS FECHA, TELEFONO FROM ( SELECT * FROM comentarios WHERE CREDITO = '123456789' ) AS COMENTARIOS ORDER BY DATE_FORMAT(FECHA, '%W %d de %M del %Y, %h:%m %p') DESC; You do your query but in the order by place the same thing you put in the select, that is:ORDER BY DATE_FORMAT(FECHA, '%W %d de %M del %Y, %h:%m %p') DESC This way you must order well, as the alias is not valid for use as a field to order.
the cycle does not work while it has to work.
Software Programming • javascript while • • morde

2

0
Votes

2
Posts

0
Views

E

So?var ask = prompt("enter your login"); while(ask != "Admin") { ask = prompt("enter your login"); console.log(ask != "Admin"); // true } if (ask == "Admin") { alert("Hello, Admin"); }
C

Div hidden/visible do not disappear when clicking the search button
Software Programming • php java html • • charlenef

2

0
Votes

2
Posts

0
Views

S

First you will need to identify the click on each button to prevent the submission of the form, with this you "intercept" this action and can manipulate as you find necessary. Below follows a functional example, in place of alert you will add the actions you will take with the data of the intercepted form, I assume by the actions of the forms you will seek something from somewhere, so you will need to implement a Ajax to do that.$(document).ready(function() { $('#div1').hide(); $('#div2').hide(); $('#div3').hide(); $('#comboBox').change(function() { if ($('#comboBox').val() == 'Boletos') { $('#div1').show(); $("#div2").hide(); $('#div3').hide(); acao = 'div1.php'; form = '#form_1'; } else if($('#comboBox').val() == 'Folhas'){ $('#div1').hide(); $("#div2").show(); $('#div3').hide(); acao = 'div2.php'; form = '#form_2'; }else if($('#comboBox').val() == 'Guias'){ $('#div1').hide(); $("#div2").hide(); $('#div3').show(); acao = 'div3.php'; form = '#form_3'; }else{ $('#div1').hide(); $("#div2").hide(); $('#div3').hide(); } }); $(document).on('click', '.botao', function(e){ e.preventDefault(); $.ajax({ url: acao, type: "post", data: $(form).serialize(), complete: function (response) { $('#output').html(response.algumaCoisa); }, error: function () { $('#output').html('Bummer: there was an error!'); }, }); }); });<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> <select id="comboBox" name="comboBox"> <option>Selecione sua opção aqui</option> <option value='Boletos'>Boletos</option> <option value='Folhas'>Folhas</option> <option value='Guias'>Guias</option> </select> <form action="div1.php" id="form_1" method="POST"> <div id="div1"> <select id="combo1" name="combo1"> <option value='selecione'>Selecione sua opção aqui</option> <option value='Pagamento 1'>Pagamento 1</option> <option value='Pagamento 2'>Pagamento 2</option> </select> <button type="submit" class="botao" id="btn1" value="btn1">Buscar</button> </div> </form> <form action="div2.php" id="form_2" method="POST"> <div id="div2"> <select id="combo2" name="combo2"> <option>Selecione sua opção aqui</option> <option value='Folha 1'>Folha 1</option> <option value='Folha 2'>Folha 2</option> </select> <button type="submit" class="botao" id="btn2" value="btn2">Buscar</button> </div> </form> <form action="div3.php" id="form_3" method="POST"> <div id="div3"> <select id="combo3" name="combo3"> <option>Selecione sua opção aqui</option> <option value='Anual 1'>Anual 1</option> <option value='Anual 2'>Anual 2</option> </select> <button type="submit" class="botao" id="btn3" value="btn3">Buscar</button> </div> <div id="output"></div>
T

How do remove the empty lines at the end of the file?
Software Programming • php web programming • • Trenton

2

0
Votes

2
Posts

0
Views

Function http://www.php.su/trim Truth removes not only at the end, but at the beginning.$str = 'Строка Строка '; $str = trim($str);
K

PHP 7 as I can see the error I am having in an input file
Software Programming • php html php7 fileupload • • Kadyn

2

0
Votes

2
Posts

0
Views

S

From documentation https://www.php.net/manual/es/features.file-upload.errors.php :UPLOAD_ERR_INI_SIZEValue: 1; The uploaded file exceeds the directive https://www.php.net/manual/es/ini.core.php#ini.upload-max-filesize de php.ini.
A

yii2 in relation to httpclient and proxy, exemptions
Software Programming • php yii2 curl proxy • • authera

2

0
Votes

2
Posts

0
Views

M

try { // ваш код внутри цикла, либо только send() } catch (Exception $e) { continue; } For if ($response->isOk) I'd create a class to throw away. $response and inside the class already check the validity and put the good in one, the bad in the other. And after the cycle, it's only good proxy. One record!

Name of methods of work with MySql PDO

Suggested Topics

How does the cloneNode method work? Software Programming • javascript c languagelone • • carriann

Method slice() does not work for mass Software Programming • javascript slice • • Anderson

The function of returning the name and the name is not working well. Software Programming • c++ regular • • emerson

How does the method notifyDataSetChanged() work in RecyclerView Software Programming • android recyclerview retrofit rxjava • • Jolied

CORS does not work with the POST method Software Programming • php angular post cors • • Laycee

Working with "named pipe" on python Software Programming • python • • Saumya

How's WooCommerce on the id order to get a client's phone number? Software Programming • php wordpress woo trade • • Oba22

String comparison problem in AJAX Software Programming • javascript php ajax • • inna

Regex, finding all matches. Software Programming • php regular expression • • Anderson

ORDER BY doesn't work MySQL Software Programming • mysql mysqli mysql workbenc languageh • • obi

the cycle does not work while it has to work. Software Programming • javascript while • • morde

Div hidden/visible do not disappear when clicking the search button Software Programming • php java html • • charlenef

How do remove the empty lines at the end of the file? Software Programming • php web programming • • Trenton

PHP 7 as I can see the error I am having in an input file Software Programming • php html php7 fileupload • • Kadyn

yii2 in relation to httpclient and proxy, exemptions Software Programming • php yii2 curl proxy • • authera

How does the cloneNode method work?
Software Programming • javascript c languagelone • • carriann

Method slice() does not work for mass
Software Programming • javascript slice • • Anderson

The function of returning the name and the name is not working well.
Software Programming • c++ regular • • emerson

How does the method notifyDataSetChanged() work in RecyclerView
Software Programming • android recyclerview retrofit rxjava • • Jolied

CORS does not work with the POST method
Software Programming • php angular post cors • • Laycee

Working with "named pipe" on python
Software Programming • python • • Saumya

How's WooCommerce on the id order to get a client's phone number?
Software Programming • php wordpress woo trade • • Oba22

String comparison problem in AJAX
Software Programming • javascript php ajax • • inna

Regex, finding all matches.
Software Programming • php regular expression • • Anderson

ORDER BY doesn't work MySQL
Software Programming • mysql mysqli mysql workbenc languageh • • obi

the cycle does not work while it has to work.
Software Programming • javascript while • • morde

Div hidden/visible do not disappear when clicking the search button
Software Programming • php java html • • charlenef

How do remove the empty lines at the end of the file?
Software Programming • php web programming • • Trenton

PHP 7 as I can see the error I am having in an input file
Software Programming • php html php7 fileupload • • Kadyn

yii2 in relation to httpclient and proxy, exemptions
Software Programming • php yii2 curl proxy • • authera