StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POphp mysql infinite loop
primarykey
Id
14188543
data
AcceptedAnswerId
14188661
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-01-07T01:04:50.450
FavoriteCount
0
LastActivityDate
2013-01-07T01:22:01.193
LastEditDate
LastEditorUserId
0
OwnerUserId
556462
ParentId
0
PostTypeId
1
Score
0
ViewCount
494
LastEditorDisplayName
text
Body
<p>I have the following code which stays in a constant loop unless I comment *$conn->query($insert_statement.$values);*. With that line commented I get exactly the correct printed output as it will finish the loop at the last insert statement.</p> <pre><code>for($count =0; $count < $rs->num_rows; $count++){ $values = ""; foreach($keys as $key){ $values = $values . "'".$row->$key."', "; } $values = substr($values, 0, strlen($values)-2) . ");\n"; echo $insert_statement.$values."\n"; $conn->query($insert_statement.$values); } </code></pre> <p>Here's the entire code. I am trying to make a script the backs up a table.</p> <pre><code><? $date = getdate(); $date = $date['month']."_".$date['mday']."_".$date['year']; $conn = new mysqli("localhost", "root", "ranger", "customers"); $conn->query("drop table if exists backup_$date"); $rs = $conn->query("DESCRIBE customers"); $create_statment = "create table backup_$date ("; $primary_key = ""; $keys = array(); $insert_statement = "insert into backup_$date ("; $count = 0; while($row = $rs->fetch_object()) { if($count > 0){ $keys[] = "".$row->Field.""; $insert_statement = $insert_statement . "`".$row->Field."` ,"; } if($row->Null == "NO"){ $create_statment = $create_statment . "`".$row->Field."` ".$row->Type." not null"; if($row->Extra == "auto_increment"){ $create_statment = $create_statment ." not null auto_increment, "; }else{ $create_statment = $create_statment . ","; } }else{ $create_statment = $create_statment . " `".$row->Field."` ".$row->Type.", "; } if($row->Key == 'PRI'){ $primary_key = "primary key(".$row->Field.")"; } $count++; } $create_statment = $create_statment . " $primary_key);"; $conn->query($create_statment); $rs = $conn->query("select * from customers;"); $insert_statement = substr($insert_statement, 0, strlen($insert_statement)-1).") values ("; $row = $rs->fetch_object(); for($count =0; $count < $rs->num_rows; $count++){ $values = ""; foreach($keys as $key){ $values = $values . "'".$row->$key."', "; } $values = substr($values, 0, strlen($values)-2) . ");\n"; echo $insert_statement.$values."\n"; $conn->query($insert_statement.$values); } ?> </code></pre>
Tags
<php><mysql><loops>
Title
php mysql infinite loop
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USbandito40
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COWhat happens if you also echo `$count`? That might give a lot of valuable debug info.
  singulars
  PostPostId
  POphp mysql infinite loop
  UserUserId
  USkokx
2. COAny reason you aren't using `CREATE TABLE [new table] LIKE [old table]`?
  singulars
  PostPostId
  POphp mysql infinite loop
  UserUserId
  USESG

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.