PHP - Converting From Array To Table

Hello,
I made a mistake some days ago, which causes to incorrect data. So I need to insert some rows between the data, this will work if I can get the specific data from that table into an array. I got it like:
Code: [Select]
ID - Date - Username - Value1Is it possible to put every row in an array, and then in this way that when I say:
print $row[2010-10-05];
I've got an idea but that would take hours to create, so I was wondering if it's possible to do it in this way.

Regards,

Hey guys i need help with a CURL code. I need to retreive all the data in a table located at http://www.listenliv....php?g=1&page=0 and parse the data to finish with an array that looks like this:

$row[0][station_name] = '3BTV';
$row[0][stream_link] = '420';
$row[0][stream_type] = 'wma';
$row[0][country] = 'United Kingdom';
$row[0][genre][0] = 'Variety';
$row[0][genre][1] = 'Alternative';
$row[0][genre][2] = 'Culture';
$row[0][rating] = '1/5';

I need that for each rows of the table where the first array number would increment $row[1], $row[2] ...
My PHP code is incomplete. I currently have a loop for all the TR's of the page ... and when i loop all the TD's inside the TR's it returns a load of crap ... I am unsure where to go from here. Any help would be apreciated thx

This is my code:
 

$ch = curl_init();
$categ[url] = 'http://www.listenlive.nl/tvgenre.php?g=1&page=0';
curl_setopt($ch, CURLOPT_URL, $categ[url]);
curl_setopt($ch, CURLOPT_POST, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_COOKIEFILE, $cookies);
curl_setopt($ch, CURLOPT_COOKIEJAR, $cookies);
curl_setopt($ch, CURLOPT_COOKIE, $cookies);
curl_setopt($ch, CURLOPT_REFERER, $categ[url]);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_USERAGENT, $nav);
$data2 = curl_exec($ch);
$dom2 = new DOMDocument();
libxml_use_internal_errors(true);
$dom2->loadHTML($data2);
$trs = $dom2->getElementsByTagName('tr');
foreach ($trs as $tr) {
echo "<pre>";
print_r($tr);
echo "</pre>";
}

I have a table with x ammount of rows and x ammount of columns, in each TD there is an input box which the user fills in, when they press save the information is input into the database in this form at

6,1,2,3,4,5,6,A,1,2,3,4,5,6,B,1,2,3,4,5,6  - the first number is the number of columns, 1- 6 is the top line of TDs (column headers) and then A 1-6 is row 1, B 1-6 is row 2 etc..

 so i then out put the information into a table via a for loop :

Code: [Select]
while($row = mysql_fetch_array($r))
{
$data = explode(',',$row["content_bottom"]);
$datacount = count($data);

echo"<table border='1'><tr><td>Tool Type</td>";
$k = 1;
for ($i = 1; $i <= $datacount; $i++) {

if($data[$i] !=""){
echo "<td>".$data[$i]."</td>";
if($k == $data[0]-1)
{
echo"</tr><tr>";
$k = -1;
}
$k++;
}
}
echo"</table>";

I can see how i would delete a row of information, eg delete B 1-6, but any ideas how I could delete a column? or is there a better way of storing this information?

Hi,

I'm unsure on some code logic as to how to create a table, I have attached an image just to make sure you guys understand my interpretation of a matrix:


Ok, so using the above as a guide, there's in total 6 products in a 2x3 table. I have 100 products, resulting in a 10x10 table. How in PHP would I fill out a table like the above with my 100 products. I've managed with some code to create a rough table which puts the headings (on above example 16GB, WiFi etc) in on both axis, but don't understand how the table body (on above example, the prices) would be filled out accordingly.

Hopefully someone can point me in the right direction?!

Cheers.

hey guys im really stuck and need help with this. im trying to update a mysql table from an array.

basically i have 12 records what are pulled using a query. each record has its own ID to distinguish it from the rest. i then have 2 tick boxes for the user to select one for accept and one for deny. what i need is for the query to look at each record on the table and insert the selection boxes value if ticked.

my code is below but i have altered it to the hilt and cannot get it to work so please help 

Code: [Select]
<?php 
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/Apollo/dbc.php";
include_once($path);



$rs_results = mysql_query("SELECT * FROM off WHERE IsItAuthorised='0' and isitsick='0' ORDER BY DayOff");

?>
<html>
<head>
<title>Administration Main Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?php



if (isset($_POST['submit'])) {
//Assign each array to a variable
$id = $_POST['id'];
$approve = $_POST['approve'];
$deny = $_POST['deny'];


$limit = count($id);




$values = array(); // initialize an empty array to hold the values
for($k=0;$k<$limit;$k++){
$msg[] = "$limit Holidays Updated";
$id[k] = $id;
$approve[k] = $approve;
$deny[k] = $deny;

$id = implode($id);
$approve = implode( $approve);
$deny = implode( $deny);

  $query = "UPDATE off SET Authorised = $approve , Deny = $deny
  WHERE OffID =  $id " ;
}



$Event = "INSERT INTO events (UserName, Event ) VALUES ('$_SESSION[user_name]', 'Entered New KPI' )";
  



echo $query;
if (!mysql_query($query,$link)){
die('Error: ' . mysql_error());
} else {

mysql_query($Event);
echo "<div class=\"msg\">" . $msg[0] . "</div>";
}




}   
?>


</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="14%" valign="top"><?php

?>

</td>
    <td width="74%" valign="top" style="padding: 10px;">
     
      <p><?php 
  if(!empty($msg)) {
  echo $msg[0];
  }
  ?></p>

      <p>
        <?php 
  $cond = '';


 
  
 

  $sql = "select * from off ";
  

  
  $rs_total = mysql_query($sql) or die(mysql_error());
  $total = mysql_num_rows($rs_total);
  
     
  ?>
       
      <p>
     
<form name "searchform" action="/Apollo/Admin/HolidayRequests.php" method="post">
        <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
          <tr class="mytables">
            <td width="4%"><font color="white"><strong>ID</font></strong></td>
            <td width="4%"> <font color="white"><strong>Staff Member</font></strong></td>
            <td width="10%"><font color="white"><strong>Day Off</font></strong></div></td>
<td width="10%"><font color="white"><strong>Is It Authorized</font></strong></div></td>
            <td width="15%">&nbsp;</td>
          </tr>
 
 
          <tr>
            <td>&nbsp;</td>
            <td width="10%">&nbsp;</td>
            <td width="17%"><div align="center"></div></td>
            <td>&nbsp;</td>
          </tr>
          <?php while ($rrows = mysql_fetch_array($rs_results)) {?>
          <tr>
            <td><input name="id[]" id="id[]" size="4" value="<?php echo $rrows['OffID'];?>" /></td>
            <td><?php echo $rrows['StaffMember']; ?></td>
            <td><?php echo date('d/m/Y', strtotime($rrows['DayOff']));?></div></td>
           
            <td> <span id="approve<?php echo $rrows['id']; ?>">
              <?php if(!$rrows['IsItAuthorised']) { echo "Pending"; } else {echo "Authorized"; }?>
              </span> </td>
 
  <td>
 
     
<input type="hidden" name="approve[]" id="approve[]" value="0">
<input type="checkbox" name="approve[]" id="approve[]" value="1"> Approve
<input type="hidden" name="deny[]" id="deny[]" value="0">
<input type="checkbox" name="deny[]" id="deny[]" value="1"> Deny


</td>
          </tr>
     
          <?php } ?>
        </table>
      <input name="submit" type="submit" id="submit" value="Submit">
      </form>
 

      &nbsp;</p>
  <?php


  ?>
 

      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p></td>
    <td width="12%">&nbsp;</td>
  </tr>
</table>
</body>
</html>

Hello all,

I'm sure something like this has been brought up before but I think it's quite a unique problem and I didn't get anywhere searching... so here's my first post. Yay. 

Right, so, basically I have a database table that looks like this:

Code: [Select]
+----------+-------+
| name     | value |
+----------+-------+
| settingA | true  |
| settingB | false |
| settingC | false |
+----------+-------+

And I have been racking my brains trying to figure out how to get that data into an array formatted like so:

Code: [Select]
Array
(
[settingA] => true
[settingB] => false
[settingC] => false
)

The best I have been able to do, using nested foreach() statements, is this:

Code: [Select]
Array
(
    [0] => Array
        (
            [name] => settingA
            [value] => true
        )

    [1] => Array
        (
            [name] => settingB
            [value] => false
        )

    [2] => Array
        (
            [name] => settingC
            [value] => false
        )

)

...which is not very practical, or at least it isn't for what I want to do. Any ideas on what the best method might be for achieving this? I am using ADOdb Lite but even an example using PHP's native MySQL functions could help me figure out what to do.

Thanks!

I am trying to insert records from an foreach array, it only inserts the first record and I cannot work out how to get it to loop through all of the records.

Thank you


foreach($_SESSION['post_data_array'] AS $seat) {
     $rowId = substr($seat, 0, 1);
     $columnId = substr($seat, 1);
      echo $rowId . $columnId . ", "; 
}

$sql125 = "INSERT INTO booked_seats(booking_id, row_id, column_id) values ('$book_id', '$rowId', '$columnId')";

$result125 = mysql_query($sql125);

if ($result125)

{

echo "worked";

}

else

{

echo "didnt work";

}

I have a function which finds a list of companies associated with a country from a custom taxonomy. It finds their logo and creates an output which is all logos associated with a country, and the logo has a href to link to a company page. The code for this is:

function countryCompanies(){

global $post;

    $echo = f_print(array(
        'data' => 'p2p',
        'type' => 'mainlogo',
        'args' => array(
            'connection_type' => 'client'.$_set['lang_postfix'].'_to_location'.$_set['lang_postfix'].'',
            'post_type' => 'client',
            'connection_id' => $post->ID,
            'alternative' => "",
        ),
));

 

The f_print function finds the logos, and their sizes. So the 'mainlogo' type is a pull down of the thumbnail at 200px size.

 

What I need to do is write CSS and PHP which will display these results in a grid, 4 colums across, and as many down as results from the array. At the moment all I can get is all the results in one column.

What tutorials would I need to write appropriate CSS to create this, and then is it as simple as adding the div prior to the echo of the $echo variable?

Thanks

//First I'm assigning a $variable ($emailzipmatch) to query a database table called(repzipcodes) and having it pull and display 1 to 3 records based on matching up a customer's zip code (RepZipCode = $CustomerZipMatch) with 1 to 3 other people (GROUP BY RepId HAVING COUNT(1) <= 3") that want that customer's information from that particular zip code. <This code works fine>

// CODE WORKS BELOW
Code: [Select]
<?php
    $emailzipmatch = mysql_query("SELECT * FROM repzipcodes WHERE RepZipCode = $CustomerZipMatch GROUP BY RepId HAVING COUNT(1) <= 3") or die(mysql_error());

    $recipients = array();
    while($row = mysql_fetch_array($emailzipmatch)) 
    { 
    $recipients[] = $row['RepEmail'];

    echo "Agent's Email Address: ";
 
    echo 'font color="#FF7600"',$row['RepEmail'], '/font';
 
    echo '<br />'; 

    echo "Rep's ID: "; 
    echo '<br />';
    echo 'font color="#FF7600"',$row['RepId'], '/font';
    echo '<br />';
    echo 'hr align="left" width="50%" size="2" /';
    }


//MY PROBLEM BELOW

// For the NEXT step of the process above I would take $row['RepEmail'] and $row['RepId'] which can have 1 to 3 results and assign the 1 to 3 results a new $variable so it can be inserted into a different db table so I can track the results of the query ($emailzipmatch = ) from the top of the page: ie..

    <New Variable>   <Listed from above>
    $SentRepId 0   = RepId (results from above echo area)
    $SentRepId 1   = RepId (results from above echo area)
    $SentRepId 2   = RepId (results from above echo area)


// Below I'd like to insert the above results into a new database

    $?Variable??? = mysql_query("INSERT INTO sentemail 
   (SentRepId0, SentRepId1, SentRepId2,SentDateTime
   ) VALUES (
   '$_SESSION[RepId]', // ?????
   '$_SESSION[RepId]', // ?????
   '$_SESSION[RepId]', // ?????
    NOW()
     )") or die(mysql_error());

Thank ahead of time for any help you guys can give me. Please respond with ANY question if my coding or request isn't clear or if I've been confusing due to my lack of experience with PHP and MySQL.


MOD EDIT: code tags added.

SELECT field, (array of values from table 2) FROM $table1 t1 LEFT JOIN $table2 ON t1.id=t2.id

... is something like this possible? (where I return records from t1 in a LEFT JOIN, but also get an array of any of the fields/records from the table 2)

Hi all,

I want to create an array from the output of a table. In the table cell I have some numbers where for each number I would like to relate it to a value in another table. However using the code below I get Array ( => "26","27","28","29","30","31" ) from the print_r($arr); meaning that $range ins't being treated as an array, and hence, the second query only gives one value. Code: [Select]
$showIng = mysql_query("SELECT * FROM recipe WHERE name = '$dish'") or die(mysql_error());

$rowShowIng = mysql_fetch_assoc($showIng);

$range = $rowShowIng['keyno'];

$arr = array($range);
print_r($arr);

foreach ($arr as &$value) {
$getIng = mysql_query("SELECT * FROM keywords WHERE keyid = '$value'") or die(mysql_error());
$rowGetIng = mysql_fetch_assoc($getIng);
echo $rowGetIng['ingredient'];
}

So, I want to know how I can create the array from $range

Thanks

Good evening,   I am working on a program that takes images, and casts them into an associated array, I then want to display thumbnails of those images into a 3 column by 4 row table...   [image][image][image] [image][image][image] [image][image][image] [image][image][image]   (For my visual friends)   here is my current, pardon for the mess, but right now, functionality is more important.

<!DOCTYPE html>
<html>
<head>
	<title>Zodiac Gallery</title>
</head>
<body>
	
<h2 style="text-align:center">Zodiac Gallery</h2>
<p>Click a thumbnail image to see enlarged view.</p>
<?php

$ZodiacArray = array (
	"Images/rat.jpg" => "Rat",
	"Images/ox.jpg" => "Ox",
	"Images/tiger.jpg" => "Tiger",
	"Images/rabbit.jpg" => "Rabbit",
	"Images/dragon.jpg" => "Dragon",
	"Images/snake.jpg" => "Snake",
	"Images/horse.jpg" => "Horse",
	"Images/goat.jpg" => "Goat",
	"Images/monkey.jpg" => "Monkey",
	"Images/rooster.jpg" => "Rooster",
	"Images/dog.jpg" => "Dog",
	"Images/pig.jpg" => "Pig");

foreach ($ZodiacArray as $image => $zodiac)
	{
		echo "<table>
			<tr>
				<td><img src="$image"  alt="$zodiac" style="width:68px;height:65px"></td
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
			<tr>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
			<tr>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
			<tr>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
				<td><img src="$image" alt="$zodiac" style="width:68px;height:65px"></td>
			</tr>
		</table>";

?>

Help is welcome, thank you.

I'm trying to get stream to show if online or offline, the check.php works just fine if i don't have "$f3" in line 5 but I need to collect from array and put into there.
Usually the array works just fine but this time it's not

Well anyway the error I'm getting is
Code: [Select]
Warning: DOMDocument::load() [domdocument.load]: Couldn't resolve host name in /home/dahdop/public_html/pvpstreams.com/table/check.php on line 5

Warning: DOMDocument::load(http://x.api.channel.livestream.com/2.0/livestatus.xml) [domdocument.load]: failed to open stream: operation failed in /home/dahdop/public_html/pvpstreams.com/table/check.php on line 5

Warning: DOMDocument::load() [domdocument.load]: I/O warning : failed to load external entity "http://x.api.channel.livestream.com/2.0/livestatus.xml" in /home/dahdop/public_html/pvpstreams.com/table/check.php on line 5
Offline | Viewers:

To me its taking away an "x" and making the array blank for some reason.

My site is pvpstreams.com if you want to see error in action.

My table.php file
Code: [Select]
<script language="javascript">

imageX1='plus';
imageX2='plus';
imageX3='plus';

function toggleDisplay(e){
imgX="imagePM"+e;
tableX="table"+e;
imageX="imageX"+e;
tableLink="tableHref"+e;
imageXval=eval("imageX"+e);
element = document.getElementById(tableX).style;
 if (element.display=='none') {element.display='block';}
 else {element.display='none';}
 if (imageXval=='plus') {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='minus';");document.getElementById(tableLink).title='Hide WoW';}
 else {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='plus';");document.getElementById(tableLink).title='Show WoW';}
}
</script>

<?php
$username="x";
$password="x";
$tmp="x";

mysql_connect(localhost,$username,$password);
@mysql_select_db($tmp) or die( "Unable to select database");
$query="SELECT * FROM users";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table class="sortable" id="wow" border="1" cellpadding="0" cellspacing="0" style="margin-left:auto;margin-right:auto;text-align:left">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Character</font></th>
<th><font face="Arial, Helvetica, sans-serif">Xfire</font></th>
<th><font face="Arial, Helvetica, sans-serif">Livestream</font></th>
<th><font face="Arial, Helvetica, sans-serif">Livestream&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif">Team&nbsp;Members</font></th>
<th><font face="Arial, Helvetica, sans-serif">Realm</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"wowcharacter");
$f2=mysql_result($result,$i,"username");
$f3=mysql_result($result,$i,"livestream");
$f4=mysql_result($result,$i,"wowserver");

$f5=mysql_result($result,$i,"wowplayer1");
$f6=mysql_result($result,$i,"wowplayer2");
$f9=mysql_result($result,$i,"wowplayer3");

$f7=mysql_result($result,$i,"wowrealm");
$f8=mysql_result($result,$i,"xfire");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php Echo "<a class=blue href=http://$f9.battle.net/wow/en/character/$f7/$f1/simple>$f1</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php Echo "<a class=blue href=http://www.pvpstreams.com/xfire.php?user=$f2>$f8</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/livestream.php?user=$f2>$f3</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif">





<?php include("check.php"); ?>






</font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<img src=wclassicons/$f5.png><img src=wclassicons/$f6.png><img src=wclassicons/$f9.png>" ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
</tr>


<?php
$i++;
}
?>
</table>
My check.php file
Code: [Select]
<?php

$objDOM = new DOMDocument();
// channel name here **INSERT**
$objDOM->load("http://x$f3x.api.channel.livestream.com/2.0/livestatus.xml"); 

//make sure path is correct
$channel = $objDOM->getElementsByTagName("channel");  
foreach( $channel as $value )
  {
        $isLives = $value->getElementsByTagName("isLive");
$isLive  = $isLives->item(0)->nodeValue;
$viewers = $value->getElementsByTagName("currentViewerCount");
$viewer  = $viewers->item(0)->nodeValue;
  }
  
if($isLive == "true")
{
echo "<font color='#00FF00'>Online</font>";
echo " |   Viewers: " . $viewer;
}
else
{
echo "<font color='#FF0000'>Offline</font>";
echo " |   Viewers: " . $viewer;
}
?>

Any help appreciated!

I have a table that allows users to add rows, depending on how much data they need to insert. upon submit I'd like to populate another table for review. Now I can generate the data, but I'm having trouble putting the array into a table. Here is the output from the initial page:

Code: [Select]
Array
(
    [quantity] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [description] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [unit_cost] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [shipping] => 4
    [tax] => 5
    [review_po] => Review
)
I need it to look like this:
Quantity | Description | Unit Cost
1             | 1                | 1
2             | 2                | 2
3             | 3                | 3
                Tax              | 4
                Ship             | 5

I think it's a foreach statement, but I'm not having any luck..

If someone could point me in the right direction???