Richard Kurth wrote:
> I am trying to pass the data from a table to a
> google.visualization.OrgChart javascript
> I have converted the data to an array called $customf_array.
> Look down in the script to where I need to pull the data out of the
> array to see the reset of my question
>
>
> $query = "SELECT * FROM member WHERE members_id = '$_SESSION[members_id]'";
> $result=mysql_query($query);
> $row = mysql_fetch_array($result);
> $memberrep=$row['repnumber'];
>
>
> $query1 = "SELECT sponserrep,rep,firstname,lastname,phonenumber FROM
> contacts WHERE members_id = '8' AND sponserrep != ''";
> $result1=mysql_query($query1);
> $num_rows = mysql_num_rows($result1);
> while($row1=mysql_fetch_array($result1)){
Change the previous line to this
while ( $row1 = mysql_fetch_assoc($result1) ) {
> $customf_array[]=$row1[0] . "," . $row1[1] . "," . $row1[2] . "," .
> $row1[3];
Change the previous line to this
$customf_array[] = $row1;
> }
>
>
>
> foreach ($customf_array as $value) {
> echo "Value: $value<br />\n";
> }
>
> this is the data that is put out by the foreach
> Value: 0000,1234,top,manager
> Value: 1342,4523,Leeann,Rodriguez
> Value: 4325,1111,Carolyn,Sanderssandifer
> Value: 1342,4567,Annie B,Scott
> Value: 1234,4325,Jessica,Hobirk
> Value: 1234,12356,Kaye,Meadows
> Value: 1234,1342,Misty,Coe
> Value: 1234,3462,Donald,Skinner
>
>
>
> ?>
> <html>
> <head>
> <script type="text/javascript" src="http://www.google.com/jsapi";></script>
> <script type="text/javascript">
> google.load("visualization", "1", {packages:["orgchart"]});
> google.setOnLoadCallback(drawChart);
> function drawChart() {
> var data = new google.visualization.DataTable();
> data.addColumn('string', 'Name');
> data.addColumn('string', 'Manager');
> data.addRows(<? echo $num_rows?>);
> data.setCell(0, 0, '<? echo$row["firstname"]?> <?
> echo$row["lastname"]?>','<font size="+1" color="#FF0000"><?
> echo$row["firstname"]?> <? echo$row["lastname"]?>
> </font><br><? echo$row["phonemember"]?>');
>
>
>
>
>
> <*****************************look at this section***********************>
> This is what I do not understand how to do if you can give me some
> examples on how to sort and pull this data out of the array or if there
> is a better way to do this
> I have been working with this for a few days and do not no where to go
>
> This is the section I need to loop through the array and add the data
> it needs to number each recored and the add the members name according
> to the rep# and the managers name according to the sponserrep#
> $number //the recored number
> $addname // the members name
> $addmanager// the managers name
> data.setCell($number, 0,
> '$addname','<h1>$addname</h1>'); data.setCell($number, 1,
> '$addmanager');
>
>
> <*****************************l***********************>
Having no knowledge of how the setCell() methods deals with input, this is my
best guess at how it should go together.
data.addRows(<? echo count($customf_array); ?>);
foreach ( $customf_array AS $row_id => $row ) {
foreach ( $row AS $cell_id => $value ) {
$value = htmlspecialchars($value);
echo "data.setCell({$row_id}, {$cell_id}, '{$value}',
'<h1>{$value}</h1>');\n";
}
}
Hope this helps.
> var table = new
> google.visualization.OrgChart(document.getElementById('chart_div'));
> table.draw(data, {allowHtml:true});
> }
>
> </script></head>
> <body><div id="chart_div"></div></body>
> </html>
>
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
