Ggtcf

Resetting two CD4017 counters simultaneously, only one resets

Partial sums of primes

Can the harmonic series explain the origin of the major scale?

The One-Electron Universe postulate is true - what simple change can I make to change the whole universe?

I2C signal and power over long range (10meter cable)

Latex for-and in equation

How do ultrasonic sensors differentiate between transmitted and received signals?

Simple image editor tool to draw a simple box/rectangle in an existing image

Pronouncing Homer as in modern Greek

Freedom of speech and where it applies

Perfect riffle shuffles

What (else) happened July 1st 1858 in London?

Can the electrostatic force be infinite in magnitude?

How to prevent YouTube from showing already watched videos?

Hostile work environment after whistle-blowing on coworker and our boss. What do I do?

Can a Bard use an arcane focus?

Proof of Lemma: Every integer can be written as a product of primes

Calculating the number of days between 2 dates in Excel

Bob has never been a M before

Have I saved too much for retirement so far?

The most efficient algorithm to find all possible integer pairs which sum to a given integer

Could solar power be utilized and substitute coal in the 19th century?

A known event to a history junkie

Java - What do constructor type arguments mean when placed *before* the type?

Handling Multiple Places ID trick

MySQL pivot tableCan I concatenate multiple MySQL rows into one field?How do you handle multiple submit buttons in ASP.NET MVC Framework?How do I specify unique constraint for multiple columns in MySQL?Tab space instead of multiple non-breaking spaces (“nbsp”)?Changing the next dropdown value with previous dropdown onchange eventMySQL Timezone for different rowsDisplay database table value in HTML dropdown <select> listDisplaying Results from database, based on two dropdown menusRecord padding in MySQLSymfony 3.4 ChoiceType dynamicly add choices

3

Currently I have 3 tables countries, routes and route_place

countries

• id


• name

table routes

• id


• title

table route_place

• id


• parent_id (id from table routes)


• from (id from countries)


• to (id from countries)


• place_name

I have 3 destination China - Dubai - London from countries table, currently I save the data into route_place table like this:

• China (from column) - Dubai (to column)


• Dubai (from column) - London (to column)

I wanted to save the data into the route_place like this

• China (from column) - Dubai (to column)


• China (from column) - London (to column)


• Dubai (from column) - London (to column)

I couldnt figured the logic after an hour, is there any method or some guidelines for it

for instance, I submitted China - Dubai - London routes, and manually choose routes place by sequence

• China - Dubai


• Dubai - London

what I wanna do is it will automatically create another route from China to London without needing me to insert manually, because China to is one way trip to London too by sequence.

php html mysql mysqli

share|improve this question

edited Mar 8 at 9:21

Daniel Sufian

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're looking for a pivot table. Have a look here.
  
  – Andrei
  Mar 8 at 8:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you exlpain more , this is not totaly clair , where the data is comming ? do you want only a php script that insert into the table route_place static information ?
  
  – Mohammed Yassine CHABLI
  Mar 8 at 8:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have edited the question, did I make myself clear? @MohammedYassineCHABLI
  
  – Daniel Sufian
  Mar 8 at 9:22
  

  
  
  
  

add a comment | 

3

Currently I have 3 tables countries, routes and route_place

countries

• id


• name

table routes

• id


• title

table route_place

• id


• parent_id (id from table routes)


• from (id from countries)


• to (id from countries)


• place_name

I have 3 destination China - Dubai - London from countries table, currently I save the data into route_place table like this:

• China (from column) - Dubai (to column)


• Dubai (from column) - London (to column)

I wanted to save the data into the route_place like this

• China (from column) - Dubai (to column)


• China (from column) - London (to column)


• Dubai (from column) - London (to column)

I couldnt figured the logic after an hour, is there any method or some guidelines for it

for instance, I submitted China - Dubai - London routes, and manually choose routes place by sequence

• China - Dubai


• Dubai - London

what I wanna do is it will automatically create another route from China to London without needing me to insert manually, because China to is one way trip to London too by sequence.

php html mysql mysqli

share|improve this question

edited Mar 8 at 9:21

Daniel Sufian

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're looking for a pivot table. Have a look here.
  
  – Andrei
  Mar 8 at 8:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you exlpain more , this is not totaly clair , where the data is comming ? do you want only a php script that insert into the table route_place static information ?
  
  – Mohammed Yassine CHABLI
  Mar 8 at 8:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have edited the question, did I make myself clear? @MohammedYassineCHABLI
  
  – Daniel Sufian
  Mar 8 at 9:22
  

  
  
  
  

add a comment | 

Currently I have 3 tables countries, routes and route_place

countries

• id


• name

table routes

• id


• title

table route_place

• id


• parent_id (id from table routes)


• from (id from countries)


• to (id from countries)


• place_name

I have 3 destination China - Dubai - London from countries table, currently I save the data into route_place table like this:

• China (from column) - Dubai (to column)


• Dubai (from column) - London (to column)

I wanted to save the data into the route_place like this

• China (from column) - Dubai (to column)


• China (from column) - London (to column)


• Dubai (from column) - London (to column)

I couldnt figured the logic after an hour, is there any method or some guidelines for it

for instance, I submitted China - Dubai - London routes, and manually choose routes place by sequence

• China - Dubai


• Dubai - London

what I wanna do is it will automatically create another route from China to London without needing me to insert manually, because China to is one way trip to London too by sequence.

php html mysql mysqli

share|improve this question

edited Mar 8 at 9:21

Daniel Sufian

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

share|improve this question

edited Mar 8 at 9:21

Daniel Sufian

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

share|improve this question

edited Mar 8 at 9:21

Daniel Sufian

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

asked Mar 8 at 8:11

Daniel SufianDaniel Sufian

62110

2 Answers
2

active

oldest

votes

1

Since you only need the logic, here is my solution when using PHP. Let say that you query all the distinct destination on route_place table (route_place->to) and insert it into $destination variable.

foreach($destination as $destination) 
 foreach($route_place as $route_place) 
 if ($route_place->from == $destination->to and $route_place->id != $destination->id) 
 //save this route to database
 
 

share|improve this answer

answered Mar 8 at 9:55

deathscriptdeathscript

2618

add a comment | 

0

this should do the trick

$array = array('China','Dubai','London');

$array_length = count($array);

for ($i = 0; $i < $array_length - 1; $i++)

 for($j = $i+1; $j < $array_length; $j++)

 echo $array[$i] . " to " . $array[$j] .'<br>';

 

share|improve this answer

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55059068%2fhandling-multiple-places-id-trick%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

Since you only need the logic, here is my solution when using PHP. Let say that you query all the distinct destination on route_place table (route_place->to) and insert it into $destination variable.

foreach($destination as $destination) 
 foreach($route_place as $route_place) 
 if ($route_place->from == $destination->to and $route_place->id != $destination->id) 
 //save this route to database
 
 

share|improve this answer

answered Mar 8 at 9:55

deathscriptdeathscript

2618

add a comment | 

1

Since you only need the logic, here is my solution when using PHP. Let say that you query all the distinct destination on route_place table (route_place->to) and insert it into $destination variable.

foreach($destination as $destination) 
 foreach($route_place as $route_place) 
 if ($route_place->from == $destination->to and $route_place->id != $destination->id) 
 //save this route to database
 
 

share|improve this answer

answered Mar 8 at 9:55

deathscriptdeathscript

2618

add a comment | 

Since you only need the logic, here is my solution when using PHP. Let say that you query all the distinct destination on route_place table (route_place->to) and insert it into $destination variable.

foreach($destination as $destination) 
 foreach($route_place as $route_place) 
 if ($route_place->from == $destination->to and $route_place->id != $destination->id) 
 //save this route to database
 
 

share|improve this answer

answered Mar 8 at 9:55

deathscriptdeathscript

2618

foreach($destination as $destination) 
 foreach($route_place as $route_place) 
 if ($route_place->from == $destination->to and $route_place->id != $destination->id) 
 //save this route to database
 
 

share|improve this answer

answered Mar 8 at 9:55

deathscriptdeathscript

2618

answered Mar 8 at 9:55

deathscriptdeathscript

2618

answered Mar 8 at 9:55

deathscriptdeathscript

2618

0

this should do the trick

$array = array('China','Dubai','London');

$array_length = count($array);

for ($i = 0; $i < $array_length - 1; $i++)

 for($j = $i+1; $j < $array_length; $j++)

 echo $array[$i] . " to " . $array[$j] .'<br>';

 

share|improve this answer

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110

add a comment | 

0

this should do the trick

$array = array('China','Dubai','London');

$array_length = count($array);

for ($i = 0; $i < $array_length - 1; $i++)

 for($j = $i+1; $j < $array_length; $j++)

 echo $array[$i] . " to " . $array[$j] .'<br>';

 

share|improve this answer

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110

add a comment | 

this should do the trick

$array = array('China','Dubai','London');

$array_length = count($array);

for ($i = 0; $i < $array_length - 1; $i++)

 for($j = $i+1; $j < $array_length; $j++)

 echo $array[$i] . " to " . $array[$j] .'<br>';

 

share|improve this answer

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110

$array = array('China','Dubai','London');

$array_length = count($array);

for ($i = 0; $i < $array_length - 1; $i++)

 for($j = $i+1; $j < $array_length; $j++)

 echo $array[$i] . " to " . $array[$j] .'<br>';

 

share|improve this answer

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110

answered Mar 11 at 10:19

Daniel SufianDaniel Sufian

62110