Styjun

What are these things that surround museum exhibits called?

Real mode flat model

2000s space film where an alien species has almost wiped out the human race in a war

I was promised a work PC but still awaiting approval 3 months later so using my own laptop - Is it fair to ask employer for laptop insurance?

Permutations in Disguise

Read string of any length in C

How do I create indestructible terrain?

geschafft or geschaffen? which one is past participle of schaffen?

Some Prime Peerage

How to give my students a straightedge instead of a ruler

How to write characters doing illogical things in a believable way?

How To Make Earth's Oceans as Brackish as Lyr's

Telling my mother that I have anorexia without panicking her

In what sequence should an advanced civilization teach technology to medieval society to maximize rate of adoption?

What is the mathematical notation for rounding a given number to the nearest integer?

Usage of blank space in trade banner and text-positioning

Where is it? - The Google Earth Challenge Ep. 2

Does a succubus' charm end when it dies?

Does my opponent need to prove his creature has morph?

Output a Super Mario Image

Absolutely wonderful numerical phenomenon. Who can explain?

What makes a smart phone "kosher"?

What was the ultimate objective of The Party in 1984?

Are there successful ways of getting out of a REVERSE MORTGAGE?

Changing code from an while loop to array_shift

Deleting an element from an array in PHPSubcategories MySql and phpHow do I get a YouTube video thumbnail from the YouTube API?Selecting min idReference - What does this error mean in PHP?Using <option> to get ID and post it in another queryhow to get path of linked categories in MysqlWhile inside while inside whileUnable to connect my sql server from PHPHow to Optimize COUNT() when using in Large Loop

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have a DB with categories and subcategories and I want to find the original parent of a subcategory. For example if I have C1->C2->C3->C4 where C1 is the original parent, I want to find the id of C1, knowing the id of C4. I have succeded to find it using an if statement with a while loop but I was told to change it to a array_shift() because the while would be very slow when there will be a lot of data going through it. The problem is that I cannot figure out how to change the code from while to array_shift, not even where to start. This is what I have right now:

 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $cToPutInto";
 $result = $conn -> query($sql);

 if($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 while ($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 
 

php

share|improve this question

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is $con a PDO object here?
  
  – Simon Brahan
  Mar 28 at 11:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if i understand , your code work fine with the while loop , is that true ?
  
  – Mohammed Yassine CHABLI
  Mar 28 at 11:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @MohammedYassineCHABLI, yes it does!
  
  – fullstackwannabe
  Mar 28 at 11:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @SimonBrahan, I am using MySQLi Object-Oriented. $conn comes from where I create the connection.
  
  – fullstackwannabe
  Mar 28 at 11:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if you want , you can use Recursive CTE , it like a recursive query , at the end , you will have the final parent . wanna some example ?
  
  – Mohammed Yassine CHABLI
  Mar 28 at 11:43
  

  
  
  
  

 | 
show 3 more comments

0

I have a DB with categories and subcategories and I want to find the original parent of a subcategory. For example if I have C1->C2->C3->C4 where C1 is the original parent, I want to find the id of C1, knowing the id of C4. I have succeded to find it using an if statement with a while loop but I was told to change it to a array_shift() because the while would be very slow when there will be a lot of data going through it. The problem is that I cannot figure out how to change the code from while to array_shift, not even where to start. This is what I have right now:

 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $cToPutInto";
 $result = $conn -> query($sql);

 if($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 while ($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 
 

php

share|improve this question

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is $con a PDO object here?
  
  – Simon Brahan
  Mar 28 at 11:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if i understand , your code work fine with the while loop , is that true ?
  
  – Mohammed Yassine CHABLI
  Mar 28 at 11:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @MohammedYassineCHABLI, yes it does!
  
  – fullstackwannabe
  Mar 28 at 11:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @SimonBrahan, I am using MySQLi Object-Oriented. $conn comes from where I create the connection.
  
  – fullstackwannabe
  Mar 28 at 11:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if you want , you can use Recursive CTE , it like a recursive query , at the end , you will have the final parent . wanna some example ?
  
  – Mohammed Yassine CHABLI
  Mar 28 at 11:43
  

  
  
  
  

 | 
show 3 more comments

I have a DB with categories and subcategories and I want to find the original parent of a subcategory. For example if I have C1->C2->C3->C4 where C1 is the original parent, I want to find the id of C1, knowing the id of C4. I have succeded to find it using an if statement with a while loop but I was told to change it to a array_shift() because the while would be very slow when there will be a lot of data going through it. The problem is that I cannot figure out how to change the code from while to array_shift, not even where to start. This is what I have right now:

 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $cToPutInto";
 $result = $conn -> query($sql);

 if($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 while ($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 
 

php

share|improve this question

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $cToPutInto";
 $result = $conn -> query($sql);

 if($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 while ($result -> num_rows > 0) 
 $parent = $result -> fetch_assoc()['parent_id'];
 $sql = "SELECT `parent_id` FROM c_assoc WHERE c_id = $parent";
 $result = $conn -> query($sql);
 
 

share|improve this question

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

share|improve this question

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

asked Mar 28 at 11:16

fullstackwannabefullstackwannabe

533 bronze badges

1 Answer
1

active

oldest

votes

0

Here is a simple example that you can try :

Let's suppose you have a table categorie like :

 "id"|"parent_id"|"name"
 "1" | NULL | "PHP"
 "2" | "1" |"Symfony"
 "3" | "1" |"Laravel"
 "4" | NULL |"JAVA"
 "5" | "4" |"Spring"
 "6" | "4" |"JEE"
 "7" | "2" |"Command"
 "8" | "2" |"Request"

the root parent categorie has parent_id equal to null , so you can mae a simple query to select the root parent without making while loop , like :

select * from (select name, id, @parent:=parent_id as parent from 
(select @parent:=8 ) a join (select * from categorie order by id desc) b
 where @parent=id) as res WHERE res.parent IS NULL

In your can , you can inject the id of the categorie you want (in my example , i'm using 8 value )

The result return :

|id|name|parent|
| | | |
|1 |PHP | NULL |

Hope that help you.

share|improve this answer

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges

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/4.0/"u003ecc by-sa 4.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%2f55396241%2fchanging-code-from-an-while-loop-to-array-shift%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Here is a simple example that you can try :

Let's suppose you have a table categorie like :

 "id"|"parent_id"|"name"
 "1" | NULL | "PHP"
 "2" | "1" |"Symfony"
 "3" | "1" |"Laravel"
 "4" | NULL |"JAVA"
 "5" | "4" |"Spring"
 "6" | "4" |"JEE"
 "7" | "2" |"Command"
 "8" | "2" |"Request"

the root parent categorie has parent_id equal to null , so you can mae a simple query to select the root parent without making while loop , like :

select * from (select name, id, @parent:=parent_id as parent from 
(select @parent:=8 ) a join (select * from categorie order by id desc) b
 where @parent=id) as res WHERE res.parent IS NULL

In your can , you can inject the id of the categorie you want (in my example , i'm using 8 value )

The result return :

|id|name|parent|
| | | |
|1 |PHP | NULL |

Hope that help you.

share|improve this answer

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges

add a comment
 | 

0

Here is a simple example that you can try :

Let's suppose you have a table categorie like :

 "id"|"parent_id"|"name"
 "1" | NULL | "PHP"
 "2" | "1" |"Symfony"
 "3" | "1" |"Laravel"
 "4" | NULL |"JAVA"
 "5" | "4" |"Spring"
 "6" | "4" |"JEE"
 "7" | "2" |"Command"
 "8" | "2" |"Request"

the root parent categorie has parent_id equal to null , so you can mae a simple query to select the root parent without making while loop , like :

select * from (select name, id, @parent:=parent_id as parent from 
(select @parent:=8 ) a join (select * from categorie order by id desc) b
 where @parent=id) as res WHERE res.parent IS NULL

In your can , you can inject the id of the categorie you want (in my example , i'm using 8 value )

The result return :

|id|name|parent|
| | | |
|1 |PHP | NULL |

Hope that help you.

share|improve this answer

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges

add a comment
 | 

Here is a simple example that you can try :

Let's suppose you have a table categorie like :

 "id"|"parent_id"|"name"
 "1" | NULL | "PHP"
 "2" | "1" |"Symfony"
 "3" | "1" |"Laravel"
 "4" | NULL |"JAVA"
 "5" | "4" |"Spring"
 "6" | "4" |"JEE"
 "7" | "2" |"Command"
 "8" | "2" |"Request"

the root parent categorie has parent_id equal to null , so you can mae a simple query to select the root parent without making while loop , like :

select * from (select name, id, @parent:=parent_id as parent from 
(select @parent:=8 ) a join (select * from categorie order by id desc) b
 where @parent=id) as res WHERE res.parent IS NULL

In your can , you can inject the id of the categorie you want (in my example , i'm using 8 value )

The result return :

|id|name|parent|
| | | |
|1 |PHP | NULL |

Hope that help you.

share|improve this answer

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges

 "id"|"parent_id"|"name"
 "1" | NULL | "PHP"
 "2" | "1" |"Symfony"
 "3" | "1" |"Laravel"
 "4" | NULL |"JAVA"
 "5" | "4" |"Spring"
 "6" | "4" |"JEE"
 "7" | "2" |"Command"
 "8" | "2" |"Request"

select * from (select name, id, @parent:=parent_id as parent from 
(select @parent:=8 ) a join (select * from categorie order by id desc) b
 where @parent=id) as res WHERE res.parent IS NULL

|id|name|parent|
| | | |
|1 |PHP | NULL |

share|improve this answer

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges

answered Mar 28 at 13:37

Mohammed Yassine CHABLIMohammed Yassine CHABLI

1,61222 gold badges77 silver badges3131 bronze badges