[RESOLVED] primary key != consecutive numeration. how to 'pull all rows data'?

[ATS16805]

hi. although my production db will most likely not have the gaps in primary key autoincrement id which have resulted from my test db here on localhost, due to deleted, duplicate entries, i nevertheless wish to compensate for this situation. it doesn't seem that difficult-- only i have never tried before, and the complexity is a getting a little beyond me... (forgive me if i don't have the jargon correct. i'm only just learning about classes n objects, etc)

i've come to ask: is there a better way to gather this data for a sensible, manageble, selectable (via dropdown, perhaps) output later? if so-- how would you approach it?

one iteration of the selectAll() method in my data object reveals (content irrelevant, please).. :

mainData Object wrote:

(
[numrows] => 10
[alldata] => Array
(
[master_id] => 1
[created] => 2006-11-03 15:30:22
[scheduled] => 2007-01-03
[event] => crazy ladies - bigg bumms
[room] => times_bubble
[detail] => the should call it the Booble room tonight, baby!
)

[allque] => SELECT * FROM event;
[allresult] => Resource id #3

)

so, i know i've got 10 rows-- 10 "Events" i want to make available for viewing by selection, but none of which have any consistent number through which a simple $i++ technique will be sufficient for running up the keys, pulling the row data at each instance.

so, i've decided that to create multidimentional array such that it's keys 1 - 10 would each represent an iteration (i.e. one row ) of the data object selectAll() function
-- but that's where i get a little foggy because it's not familiar territory at all for my experience level... thanks for having a look!: (ps. i realize i could stand to improve this naming convention)

require_once '../class/maindata.class.php';
$selectall = new mainData();
$select = $selectall->selectAll('event');
?>
<pre>
<?php
$x = 0;
$myarray = array('$x','array('master_id','editing','calendar','event','room','detail')');

while($x <= $selectall->numrows) {

   print_r($myarray[$x][$select]);
   $x++;
}
?>
</pre>

i actually made an edit here which i haven't yet tried, but i'm guessing it's still wrong. thanks for reading. i really appreaciate any advice you might lend, specific or general 😉

[NogDog]

If I'm interpreting your data object correctly (not a given), it looks like you could just do a foreach loop on the "alldata" attribute:

echo "<ul>\n";
foreach($selectall->alldata as $row)
{
  // $row is now an array of fields for one result row, so you could do, for example:
  echo "<li>{$row['scheduled']}: {$row['event']}</li>\n";
}
echo "</ul>\n";

[ATS16805]

hey there, NogDog! thanks for your attention.

well-- after looking at this w/ a fresh head, today-- i can totally see why my mulit/dim array wasn't going to do anything-- i'm trying to make a key as a value... or something! i dunno. confused.... (obviously!)
at ths part: $myarray= array('$x','array('all','my','values'..)). but, i guess i'm barking up the wrong tree anyway?

and upon reading your reply, i thought 'Eureka! i'm so dumb, and it's a good thing ND rocks so much!'
'cept, when i plugged it in, i'm getting something totally unexpected,

<ul>
<li>1: 1</li>
<li>2: 2</li>
<li>2: 2</li>
<li>c: c</li>
<li>t: t</li>
<li>t: t</li>
</ul>

(EDIT)the alphabeticals appear to be the first letter of the key's?
and why have we only done one iteration? (by one iteration, i mean-- only one key of the array, only one pass seems to be output, yet there are ten rows?) (end EDIT)
... well, it's not quite what i need... but i should be able to make progress going from this idea... err...

i only wish i had some better mastery / more experience w/ Multidimensional Arrays-- it's something similar to this which caused me to study the whole OOP thing in the first place-- in fact, this very database-- the goal of course being for the end user to select his choice of event date, for which there exists a table (shown above)-- only i'm just stumped on how to get to it. i don't know why i can't 'see' a solution, but i'm really struggling w/ this.

any other input is appreciated. thanks!

EDIT: wait a minute. maybe i didn't quite get what NogDog was trying to tell me. (missed his //comments first time). let's see here....

EDIT-2: here's the method from the object. would it be better to have mysql_fetch_array(str, MYSQL_NUM) instead ?

class mainData {

var $numrows; // tells us how many rows
var $alldata; // the select all info array for print_r

function selectAll($tableall) {

$dbconnect = mysql_connect("secret-stuff-for-db-conn");

$this->allque = "SELECT * FROM $tableall;";
$this->allresult = mysql_query($this->allque) or die(mysql_error());
$this->numrows = mysql_num_rows($this->allresult);
$this->alldata = mysql_fetch_array($this->allresult, MYSQL_ASSOC);

return $this->alldata;
}

[ATS16805]

...still trying to work this thing out.
surely, i must be on the cusp of the solution, but-- i'm missing a vital parameter / function.
from this:

require_once '../class/maindata.class.php'; 
$selectall = new mainData(); 
$select = $selectall->selectAll('event'); 

$x=0;
while($x <= $selectall->numrows) {
echo "<br />here we have the print_r inside of the while:<br />";
   print_r($select);
   $x++;
echo "<br />";
} 

i get my ten rows, however, i don't doubt that it's arbitrary to the purpose. nevertheless, certainly i can use this to get what i DO want. ...
obviosly, not quite w/ the print_r's as shown above... which currently output 10 rows of the same db query-- that same data shown in my first post, which is the first row of the db. it's the advancing to the next row which i can't figure out.
NOTE: realizing the value of foreach(), i'm using this while thing so i can have that $x if i needed it... for, as i was originally imagining, a multidimensional array.

EDIT:

$i=0;
foreach($select as $x => $row) {

echo $row[$i][$x]['master_id'];
echo $row[$i][$x]['editing'];
echo $row[$i][$x]['calendar'];
echo $row[$i][$x]['event'];
echo $row[$i][$x]['room'];
echo $row[$i][$x]['detail'];

$i++;
}

the following yeilds an interesting result -- the object properties are going in as array key offset's, causing notice errors, but .... maybe useful for something somday, if tweaked.... [he thought to himself... ])

$i=0;
while($i<=$selectall->numrows) {
foreach($selectall as $x => $row) {

$myArray= array($row);
echo "<br />print_r(\$row):<br />";
print_r($row);
echo "<br />print_r(\$myArray[\$x])<br />";
print_r($myArray[$x]);
echo "<br />print_r(\$myArray[".$x."]) (actual vaule of x shown)<br />";
print_r($myArray[$x]);
echo "<br />";

$i++;
}
}

[NogDog]

I think you want a loop in your selectAll method:

class mainData {

var $numrows; // tells us how many rows
var $alldata; // the select all info array for print_r

function selectAll($tableall) {

$dbconnect = mysql_connect("secret-stuff-for-db-conn");

$this->allque = "SELECT * FROM $tableall;";
$this->allresult = mysql_query($this->allque) or die(mysql_error());
$this->numrows = mysql_num_rows($this->allresult);
$this->alldata = array(); // initialize it;
while($row = mysql_fetch_assoc($this->allresult)) // a little less typing using *_assoc
{
    // use [] to add a "row" to the array:
    $this->alldata[] = mysql_fetch_array($this->allresult, MYSQL_ASSOC);
}
return $this->alldata;
}

[ATS16805]

i was just coming back here to say... i think it's my (object) method which is wrong-- after studying that EVERY loop through the whole object seemed to give me the same row every time.... or somethng like that. 😉
cool! i'll check this out!

thank you sooo much!

[ATS16805]

that's odd-- wonder why it's only showing 5 of the 10 rows? using this to see what's in there:

$maindata = new mainData(); 
$select=array($maindata->selectAll('event')); 

$i=0;
$myArray = array();
while($i<=$maindata->numrows) {

foreach($select as $x => $row) {	
	$myArray[$i] = $row;

echo "<pre>";
	print_r($row);
	print_r($myArray[$i]);
echo "</pre>";
	$i++;
}
}

maybe my "probe" loops are wrong too? i was thinking it would show me all of the rows at least once...

EDIT: it is showing every-other row, beginnnig w/ the 2nd

[NogDog]

I believe this...

$select=array($maindata->selectAll('event'));

...should just be this...

$select=$maindata->selectAll('event');

...?

Then just do a print_r($select); to see if you got all the data.

[ATS16805]

unfortunately, nothing changed (that i could see). it's still doing a total of 5 keys-- five db rows.

$maindata = new mainData(); 
 $select=$maindata->selectAll('event');

echo "<pre>";
   print_r($select); 
echo "</pre><br />";

actually-- the reason i put this under db is i was thinking that perhaps i needed to do something more MySQL oriented-- as in... is there a way to get it to do like a "temp" value ? -- i was imagining a 7th field, created by MySQL only for the moment of the query, which could take care of that counter for us... sort of the way the $i++ works, but under its own process. is there any such mySQL thing? would that be a "stored procedure"? (sorry-- i feel really stupid for asking, but i just haven't gotten that far...)

i mean-- all i need is a way to count the rows of this table, and then reference them later. so-- there needs to exist a reference for each row. maybe there's something about my data that i haven't shown? i think you've seen everything. is this unusual?

[ATS16805]

i think i might have figured it out-- pretty simple really (once i get it right)... and a PERFECT example of the 'object' idea, in my opinion....

i've got to pass dynamic data to that selectAll method-- that being a value to tell it which row of NogDog's loop to show.

$select = array($maindata->selectAll('event', $i));

BTW - the reason for the array() around the $maindata->selectAll() is because i was trying to do the multidimensional array there. (shown again here for illustration ... but i think it needs to come out, as NogDog said)

#################
EDIT (progress?):
modified to the much smaller
######## CALL THE OBJECT HERE #############

if (empty($i)) {
$i=0;
}

$maindata = new mainData(); 
$select = $maindata->selectAll('event', $i);

for($i=0;$i<=$maindata->numrows;$i++) {
echo $maindata->row;
}

and this change to the selectAll method, including suggested loop
################## THE METHOD ITSELF ################

function selectAll($tableall,$i) {
//connect db

$this->allque = "SELECT * FROM $tableall;";
    $this->allresult = mysql_query($this->allque) or die(mysql_error());
    $this->numrows = mysql_num_rows($this->allresult);
     $this->alldata = array(); // initialize it;
    while($row = mysql_fetch_assoc($this->allresult))  {// a little less typing using *_assoc

    $this->alldata[$i] = mysql_fetch_array($this->allresult, MYSQL_ASSOC);
 }
    return $this->alldata; 
}

Although, i'm currently getting NO output, i feel i'm doing something better here... plus, SciTE reports no errors under "Tools -> Go" ... (which i assume parses the code for errors somehow?)

[ATS16805]

... uh, just a little excited about it...

check it out. so easy-- and i was right about the need to really "use" the object along w/ dynamic data. (vs. just passing the same little table name to it all the time as i was before)

the Object:

function selectAll($tableall,$i) {

$dbconnect = mysql_connect("localhost", "...");

$this->allque = "SELECT * FROM $tableall;";
   $this->allresult = mysql_query($this->allque) or die(mysql_error());
    $this->numrows = mysql_num_rows($this->allresult);
    $this->counter = array();
    for($z=0;$z<=$this->numrows;$z++) {
    $counter[$z]=  mysql_fetch_array($this->allresult, MYSQL_ASSOC);
    }

return $counter[$i];
} 

and the code which grabs it

if (empty($i)) {
$i=0;
}
$maindata = new mainData(); 
for($i=0;$i<=$maindata->numrows;$i++) {
echo "<br />Iteration no. $i <br /><pre>";
print_r($maindata->selectAll('event',$i));
}
echo "</pre>";

whaddaya think? i'm so happy i finally got this stupid thing to do what i needed! i've literally been at this, in truth, for weeks-- starting way back before i had any idea about OOP stuff, so i'm happy for all of the learning which took place for me over the past couple of weeks. i appreciate the help from phpbuilder.com too, by the way.

[FONT=serif]...where are all of the phpbuilder.com t-shirts? i'd wear one!![/FONT] :rolleyes:

Springer's Final words for the day

$maindata = new mainData(); 
$myArray = array();
for($i=0;$i<=$maindata->numrows;$i++) {
echo "<br />Iteration no. $i <br /><pre>";
$myArray[$i] = $maindata->selectAll('event',$i);
echo "\$myArray[".$i."] representing row $i of the table is valued at<br />";
print_r($maindata->selectAll('event',$i));
echo "</pre>";
}

for anyone who might Google upon this someday, the code just above made for a nice way for me to see what is what in each new rows array.