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

Choice from two bases for one request

O
obi last edited by

Good afternoon. Wanted to know if it was possible to select information from different databases for one request?
Reply Quote 0
1 Reply Last reply
A
Avante last edited by
If the request indicates the table in the name of the database database1.table1the table is selected from database1if it's just table1- from the active database.
General principle of cross-request for two bases within one MySQL server:
```
SELECT t1.*, t2.*
FROM database1.table1 AS t1
INNER JOIN database2.table2 AS t2 ON t2.field1 = t2.field1
```
Alias t1 and t2 Not necessarily. But they reduce the demand, and improve the readability.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

A

duplicate results with INNER JOIN
Software Programming • php mysql • • authera

2

0
Votes

2
Posts

0
Views

R

I would need the descriptions of the tables, but when you join (in this case, the "inner" leftover...) you usually do it with the PKs or some other key or index, and not with values like name or phone. The user should then have a reference with the main user table using the pk of the user table. That would be very easy (and much faster) to reference both data.Join uses indexes. In the clause where you can then search by name.If possible, use USING instead of ON in the join, it will help you with duplicates.If you don't want to invest time in improving your sql, use "SELECT DISTINCT" to get rid of duplicates.It would then be JOIN i using the ids, more or less like this: Select * from usuarios join seguidores on userID = idseguidores where userseguido = '$username' If you have the userid of the log user, use it in the where clause, is better (with difference) than using names.
A

Get the data out of the two tables with one request. MySql
Software Programming • mysql select • • Avante

2

0
Votes

2
Posts

0
Views

T

(1) select defCategory from defCategories2) select userCategory from userCategories where user_id = bunch you want
Close Chrome with Javascript or PHP
Software Programming • php chrome • • irl

2

0
Votes

2
Posts

0
Views

C

I believe that in javascript you can only close a page that you open beforewindow.open('https://www.google.com'); // y antes usar window.close();
How do you bring two Dictionary into one new one?
Software Programming • c sharp words • • Laycee

2

0
Votes

2
Posts

0
Views

O

If you're sure there's no matching keys, you can try: var dict1 = Enumerable.Range(0,10).ToDictionary(x=>x); var dict2 = Enumerable.Range(15,10).ToDictionary(x=>x); Using Union or Concat methods can be used to combine dictionaries. The difference between them is that the Union removes pre-publishers, which is not required in this context. There's no difference for little dictionaries, which way to use, for the big ones I think Concat will work fast. var combined_version_1 = dict1.Union(dict2).ToDictionary(x=>x.Key, x=>x.Value); var combined_version_2 = dict1.Concat(dict2).ToDictionary(x=>x.Key, x=>x.Value); As you can see, there's a third vocabulary at the entrance that can be returned as a result.
Wucomers removes goods from a certain category
Software Programming • php wordpress woo trade • • Demir

2

0
Votes

2
Posts

0
Views

After the end, we need to add wp_reset_postdata(). You need to change the arguments for a sample of goods by category. $args = [ 'post_type' => 'product', 'post_status' => 'publish', 'posts_per_page' => 40, 'orderby' => 'menu_order', 'order' => 'ASC', 'tax_query' => [ [ 'taxonomy' => 'product_cat', 'field' => 'term_id', 'terms' => 21, 'operator' => 'IN' ], ], ]; $loop = new WP_Query($args );
T

Creation of bread crumbs ных Zend framework
Software Programming • php zend framework 2 • • terrea

2

0
Votes

2
Posts

0
Views

S

It's settled. There was a mistake in one word... ♪ as usual:
N

Request for two tables
Software Programming • sql • • nishika

2

0
Votes

2
Posts

0
Views

Look join and left outer join on SQL specifications.select table1.col1, table2.col2 from table1 join table2 on table2.id=table1.id_from_table2 and select table1.col1, table2.col2 from table1 left outer join table2 on table2.id=table1.id_from_table2 https://ru.wikipedia.org/wiki/Join_%28SQL%29
R

Two JOINs in one request
Software Programming • mysql • • rosemadder

2

0
Votes

2
Posts

0
Views

B

Yes, of course. There's a syntaxy in the john's: A JOIN B ON blah-blah JOIN C ON blah-blah-blah. ♪ ♪Do a copy of the database and experiment freely.
D

Improving pagination scheme - PHP and Javascript
Software Programming • javascript php page • • derk

2

0
Votes

2
Posts

0
Views

A

You will need to create 2 new variations and make the following calculations. 1st Variable: Página * Quantidade_de_Página2nd Variable: (Página * Quantidade_de_Página) - Quantidade_de_Página + 1;Ai you will get the results as you want. Ex: Pag 1 from 1 to 10
S

Two span, one with icon and one with text, makes me a line jump using d-none d-*-block MD Bootstrap
Software Programming • bootstrap bootstrap 4 • • simrah

2

0
Votes

2
Posts

0
Views

Maybe this is what you're looking for:<button type="button" (click)="refreshFilter()" class="btn btn-default"> <span class="fa fa-eraser"></span> <span class="d-none d-md-inline-block d-lg-inline-block d-xl-inline-block"> Limpiar</span> </button> Instead of using d-*-block, uses d-*-inline-block.Greetings!
O

How can I make it more difficult for a user to create multiple accounts?
Security, Penetration Testing • php network vpn ip spoofing mac language spoofing • • Oba22

2

0
Votes

2
Posts

0
Views

C

There is no effective way to prevent a dedicated attacker from creating multiple accounts. No matter what you do, the attacker will still be able to create multiple "sock puppet" accounts. The best you can do is raise the cost of creating additional accounts. One approach is to require the user to provide a mobile phone number, authenticate the user's phone number (by calling it, speaking a random auth code, and having the user enter in the auth code into the web site, like Google Voice does). Then you can ensure that each mobile phone number is linked to at most one account. This does not prevent creating multiple accounts -- an attacker can still buy multiple disposable phones, for instance -- but it raises the attacker's costs and might be enough to convince him/her to bother someone else instead. The disadvantage is that it prevents some people from using your site, e.g., if they don't have a mobile phone, or if they are not willing to share their mobile phone number with you (people will probably be reluctant to share their mobile number with a site they don't already have a very good trust relationship with). Another possible approach is to require the user to authenticate with a Facebook account, and rely upon Facebook to check uniqueness. This is also far from perfect: people can still create fake Facebook accounts. The disadvantage is that requiring people to log in via Facebook may prevent many people from using your site and is bad for privacy. It is unfriendly to people who don't want to log in with Facebook, don't use Facebook, or don't want to share their Facebook information with you. See also How to prevent cheating (extra votes) in online contests? for more discussion about a variety of mitigations.
E

Request prop based on another prop
Software Programming • vue.js • • esther

2

0
Votes

2
Posts

0
Views

A

There's one https://github.com/vuejs/vue/issues/3495#issuecomment-241430642 . What is suggested there by one of the members of the Vue team is doing this check within the created which is called before the component is mounted on the DOM.At first I thought that https://vuejs.org/v2/guide/components.html#Prop-Validation could help here, but in this function that makes it possible to make a customised check prop it is not possible to access the instance because it has not yet been created or other properties.
C

What are the relationships in SQL: One to one, one to several, several to several?
Software Programming • sql relational algebra • • Cleofas

2

0
Votes

2
Posts

0
Views

A

Some examples of application could be:Relationship one to one:A person can only have a nose and a nose can only have one person.A population register (CURP in Mexico) can only have one person and one person can only have a curp.Relationship one to severalA parent may have many children but a child can only have a father.A cart can have many wheels (In this case you restrict one to 4 in the most common case) and a tire can only have a car. Depending on the context in which you work and being more practical you can have that a customer can be served only by a seller but a seller can have many customers. Relationship many to manyMany customers can buy many products and many products can be purchased by many customers. Many friends may have many friends. In a system many users can access many modules.The main idea is to first take into account that type of interaction we will have with the data and this data that type of interaction will have with whom it is related. Speaking in database schemes usually in a first step you create the identities you need, simply without entering into details. Then you apply normal forms for each level. According to theory, more than enough is grade 3 of normalization. For this point the relationships between the tables are more than clear. Something about this: https://es.wikipedia.org/wiki/Normalizaci%C3%B3n_de_bases_de_datos#Tercera_Forma_Normal_.283FN.29 Knowing this and an idea I use questions like:How many times will I repeat a data on the table? How many times am I gonna call him? Who are you pointing at? Do you have a single identifier?Then the answer number (to whom do you point? = 3 tables) It tells me that the relationship is at least one to three or more, if you don't want to limit it. Well, it's a little idea how I resolve this dilemma.
A

Additional forms
Software Programming • javascript php • • Avante

2

0
Votes

2
Posts

0
Views

S

If on a net JS, you can:<script> function append(id) { var node = document.getElementById(id), newNode = document.createElement('div'); newNode.innerHTML = '<input type="text" name="name" value="" />'; node.appendChild(newNode); return newNode; } </script> <div id="test"></div> <a href="" onclick="append('test'); return false;">CLICK</a> But with jQuery, these manipulations are easier.UPDif(isset($_POST['name'])){ $name = $_POST['name']; $user= $_POST['user']; $query = "INSERT INTO player_comands (id_user, name) VALUES "; for($i = 0; $i < count($name); $i++){ $query .= "('$user[$i]', '$name[$i]'),"; } $query = substr($query, 0, strlen($query)-1); // убираем лишнюю запятую $res = mysql_query($query); }
E

Blog2. Post removal problem
Software Programming • php yii2 crud • • emran

2

0
Votes

2
Posts

0
Views

With that code, I think it's okay. The problem seems to me in the river itself. Based on the logic, annex yii2 begins to work when requesting the image, which does not understand how to deal with uploads/c8792d9548210f5455f395cdc73386f3.png. This is being managed by web server structures (nginx or apache, as used).Now, at the disposal point, we need to debase or disband our exceptions to understand that, before disposal, a roguer can remove the image (see the use of EVENT_BEFORE_DELETE in the model) and, when the picture is removed, it may be missing rights on the side of the web server and then the event will not work and disposal will not occur. Anyway, xdebug to help.

Choice from two bases for one request

Suggested Topics

duplicate results with INNER JOIN Software Programming • php mysql • • authera

Get the data out of the two tables with one request. MySql Software Programming • mysql select • • Avante

Close Chrome with Javascript or PHP Software Programming • php chrome • • irl

How do you bring two Dictionary into one new one? Software Programming • c sharp words • • Laycee

Wucomers removes goods from a certain category Software Programming • php wordpress woo trade • • Demir

Creation of bread crumbs ных Zend framework Software Programming • php zend framework 2 • • terrea

Request for two tables Software Programming • sql • • nishika

Two JOINs in one request Software Programming • mysql • • rosemadder

Improving pagination scheme - PHP and Javascript Software Programming • javascript php page • • derk

Two span, one with icon and one with text, makes me a line jump using d-none d-*-block MD Bootstrap Software Programming • bootstrap bootstrap 4 • • simrah

How can I make it more difficult for a user to create multiple accounts? Security, Penetration Testing • php network vpn ip spoofing mac language spoofing • • Oba22

Request prop based on another prop Software Programming • vue.js • • esther

What are the relationships in SQL: One to one, one to several, several to several? Software Programming • sql relational algebra • • Cleofas

Additional forms Software Programming • javascript php • • Avante

Blog2. Post removal problem Software Programming • php yii2 crud • • emran

duplicate results with INNER JOIN
Software Programming • php mysql • • authera

Get the data out of the two tables with one request. MySql
Software Programming • mysql select • • Avante

Close Chrome with Javascript or PHP
Software Programming • php chrome • • irl

How do you bring two Dictionary into one new one?
Software Programming • c sharp words • • Laycee

Wucomers removes goods from a certain category
Software Programming • php wordpress woo trade • • Demir

Creation of bread crumbs ных Zend framework
Software Programming • php zend framework 2 • • terrea

Request for two tables
Software Programming • sql • • nishika

Two JOINs in one request
Software Programming • mysql • • rosemadder

Improving pagination scheme - PHP and Javascript
Software Programming • javascript php page • • derk

Two span, one with icon and one with text, makes me a line jump using d-none d-*-block MD Bootstrap
Software Programming • bootstrap bootstrap 4 • • simrah

How can I make it more difficult for a user to create multiple accounts?
Security, Penetration Testing • php network vpn ip spoofing mac language spoofing • • Oba22

Request prop based on another prop
Software Programming • vue.js • • esther

What are the relationships in SQL: One to one, one to several, several to several?
Software Programming • sql relational algebra • • Cleofas

Additional forms
Software Programming • javascript php • • Avante

Blog2. Post removal problem
Software Programming • php yii2 crud • • emran