Learn VBA & Macros in 1 Week!

PHP - Php Need Nested User Array Values To Dump Into Html Table Cell

Full Excel VBA Course - Beginner to Expert

Php Need Nested User Array Values To Dump Into Html Table Cell	View Content

I have a stdClass Object array with nested User arrays as a value that I would like to display in a table cell.

I am struggling and have exhausted a lot of time. I am hoping to get a shove in the right direction if possible.

The image below will show what I am trying to do.

$someArray = json_decode($token_result);

foreach ($someArray as $key => $value) {
    $combined[] =
        "<tr><td>" .
        $value->customer .
        "</td><td>" .
        $value->city .
        '</td>
           <td>' .
        $value->state .
        "</td><td>" .
        $value->zipcode .
        '</td>
           <td>' .
        $value->totalUsers .
        "</td><td>" .
        $value->totalActiveUsers .
        "</td><td>" .
        $value->totalInActiveUsers .
        '</td><td>
           <a href="">' .
        $value->users .
        "</a></td></tr>";
}

foreach ($combined as $value) {
    print $value;
}

Here is what my Array and Objects look like

Array
(
    [0] => stdClass Object
        (
            [customer] => SWSH
            [city] => Thomasville
            [state] => GA
            [zipcode] => 31792
            [totalUsers] => 6
            [totalActiveUsers] => 6
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => xxx
                            [lastName] => xxx
                            [phoneNumber] => 
                            [userName] => cb_igwrth@xxx.com
                            [createdBy] => 
                            [isActive] => 1
                        )

                    [1] => stdClass Object
                        (
                            [firstName] => Dan
                            [lastName] => Stewart
                            [phoneNumber] => +11111111111
                            [userName] => dan.sxx@xxx.ga.gov
                            [createdBy] => kwilliams@xxx.com
                            [isActive] => 1
                        )
                )

        )

    [1] => stdClass Object
        (
            [customer] => xxxx
            [city] => Carver
            [state] => MA
            [zipcode] => 02330
            [totalUsers] => 3
            [totalActiveUsers] => 3
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => Leo
                            [lastName] => Furtado
                            [phoneNumber] => 781-000-0000
                            [userName] => LFurtado@xxx.com
                            [createdBy] => TConger@ccccc.com
                            [isActive] => 1
                        )                

                )

        )
)

Table is attached

Full Excel VBA Course - Beginner to Expert

Table Issue - Multiple Location Values For User Pushes Values Out Of Row Instead Of Wrapping In Cell

Similar Tutorials

View Content

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites. When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell. It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in. Both cases mess up the table and formatting. I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<thead>

<tr>

<th>FirstName</th>

<th>LastName</th>

<th>Username</th>

<th>Phone #</th>

<th>Location</th>

<th>Title</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php

//QUERY TO SELECT ALL USERS FROM DATABASE

$query = "SELECT * FROM users";

$select_users = mysqli_query($connection,$query);

// SET VARIABLE TO ARRAY FROM QUERY

while($row = mysqli_fetch_assoc($select_users)) {

$user_id = $row['user_id'];

$user_firstname = $row['user_firstname'];

$user_lastname = $row['user_lastname'];

$username = $row['username'];

$user_phone = $row['user_phone'];

$user_image = $row['user_image'];

$user_title_id = $row['user_title_id'];

$user_role_id = $row['user_role_id'];

// POPULATES DATA INTO THE TABLE

echo "<tr>";

echo "<td>{$user_id}</td>";

echo "<td>{$user_firstname}</td>";

echo "<td>{$user_lastname}</td>";

echo "<td>{$username}</td>";

echo "<td>{$user_phone}</td>";

//PULL SITE STATUS BASED ON SITE STATUS ID

$query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

$select_site = mysqli_query($connection, $query);

while($row = mysqli_fetch_assoc($select_site)) {

$site_name = $row['site_name'];

echo "<td>{$site_name}</td>";

}

echo "<td>{$user_title_id}</td>";

echo "<td>{$user_role_id}</td>";

echo "<td class='table-action'>

</td>";

//echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

echo "</tr>";

}

<tr>

<td>FirstName</td>

<td>LastName</td>

<td>Username</td>

<td>Phone #</td>

<td>Location</td>

<td>Title</td>

</td>

</tr>

</tbody>

<tfoot>

<tr>

<th>FirstName</th>

<th>LastName</th>

<th>Username</th>

<th>Phone #</th>

<th>Location</th>

<th>Title</th>

</tr>

</tfoot>

</table>

Dump Data From One Table To Another

Similar Tutorials

View Content

Hi,

I have 2 tables t1 and t2. They have identical columns only except t1 has one extra column x1. What I want is to dump data from t2 to t1, and in the x1 column, put the person's name (get from SESSION).

So, I want the best optimized way to do something like

Code: [Select]
mysql_query("INSERT INTO `t1` '".$usename."' , SELECT * FROM `shareltp`"); //which obviously doesn't work

please help

Random And Unique Values From Mysql Table To Html Table?

Similar Tutorials

View Content

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?

Thanks in advance,
Vero

Return Array Of Values From Table 2

Similar Tutorials

View Content

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)

How To Separate Values From Array For Saving In Table.

Similar Tutorials

View Content

Hey guys,

I need your help on this please.

I am working on a php web application. I have a form that gets information for Supplier and his traveling details.

The values are stored in arrays. I would like to store supplier details in Supplier table and the travelling details in the Travel table.

Here is the code with the comments.

<?php
    if (isset($_VARS['submitSuppliers']))
    {
        //error checking starts here
        $isError = false;
        if (empty($_VARS['supplierName']))
        {
            $isError = true;
            $_VARS['supplierRequest']['supplierName']['errorMessage'] = 'You need to provide a Supplier Name.';
        }

        if (empty($_VARS['address']))
        {
            $isError = true;
            $_VARS['supplierRequest']['address']['errorMessage'] = 'You need to provide an Address.';
        }
        if (empty($_VARS['travel']))
        {
            $isError = true;
            $_VARS['supplierRequest']['city']['errorMessage'] = 'You need to provide travelling details.';
        }

        #this checks if there is no error and then proceeds to save form values
        if (!$isError)
        {
            #This function adds the details and Returns the autoincremented Supplier ID
            $SupId = add_suppliers($_VARS);
            if ($SupId)
            {
                #=== Now here I would like to save the travelling details in the Travel table  using the generated supplier id
                # $travId = add_Travel($_VARS); //==== how do I segregate only travel details from the $_VARS array to store in travel table?
                REDIRECT('/supplier/index.html', array('confirmationMessage' => 'Your details have been saved.'));
            }else
            {
                notify_admin('supplierjoin.php');
            }
        }else
        {
            $_VARS['supplierRequest']['errorMessage'] = "There was a problem with the information you provided. Please check the form and try again.";
        }
    }

?>

Kindly help.

Any comment or feedback is always welcome.

Thank you

Store Fetched Values In Array -> Update Into Mysql Table

Similar Tutorials

View Content

I am pulling 5 addresses and I am wanting to store these 5 addresses in columns in a separate table. On the query string I put LIMIT 5. How can I store the results of each of the 5 loops into columns in a separate table? The columns are A1(for name), A2(for address), A3 (for city), A4 (for state), A5 (for zip), A6 (for phone), A7 (for miles), .... then I also have B1-B7, C1-C7, D1-D7, and E1-E7.

I am basically wanting to store up to 5 addresses in an array and then update them into a mysql table.

Code: [Select]
foreach ($zips as $key => $value) {

$result = mysql_query("SELECT State FROM extreme WHERE Zip = '$key' AND Type='store' AND `InStore` <> 'NO' LIMIT 5", $db);
$num_rows = mysql_num_rows($result);

while($myrow = mysql_fetch_array ($result))
{

$Dealer=$myrow['Dealer'];
$Address=$myrow['Address'];
$City=$myrow['City'];
$State=$myrow['State'];
$Zip=$myrow['Zip'];
$Phone=$myrow['Phone'];
$Miles = $value;

}

}

Convert Html Table To Comma Separated Values

Similar Tutorials

View Content

I have a file that is uploaded by the user that has a series of rows of data in an html table.

The columns are always a constant, but the number of rows in the file can change. These rows of the html table are the only information in the file when I am processing it.

I need to either convert the file to a CSV file or write the values to a CSV list so that I can then insert them into a database.

Any suggestions would be wonderful...I've spent the last three hours spinning my wheels.

Here is an example of one row of data from the file:

Code: [Select]
<tr><td bgcolor=#dddddd class=dataFT >5 (Excellent)</td><td bgcolor=#dddddd class=dataFT >5 (Excellent)</td><td bgcolor=#dddddd class=dataFT >5 (Excellent)</td><td bgcolor=#dddddd class=dataFT > </td><td bgcolor=#dddddd class=dataFT > </td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >1015020</td><td bgcolor=#dddddd class=dataFT >155498322</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >4731751</td><td bgcolor=#dddddd class=dataFT >2011-09-25 11:18:33 (-5:00)</td><td bgcolor=#dddddd class=dataFT >2011-09-25 12:16:50 (-5:00)</td><td bgcolor=#dddddd class=dataFT >0:58:17</td><td bgcolor=#dddddd class=dataFT >0:58:16</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >Resolved</td></tr>

Html Table From Array

Similar Tutorials

View Content

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?

Populate Html Table With Array

Similar Tutorials

View Content

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???

Putting Array Contents Into Html Table

Similar Tutorials

View Content

Hi Everyone,

I have a problem displaying some information from an array (selected from my database). The array is below.

Array ( [0] => Array ( [ssc_skill_categories] => Web [sc_skill_categories] => Programming )
[1] => Array ( [ssc_skill_categories] => Actionscript [sc_skill_categories] => Programming )
[2] => Array ( [ssc_skill_categories] => C# [sc_skill_categories] => Programming )
[3] => Array ( [ssc_skill_categories] => CSS [sc_skill_categories] => Programming )
[4] => Array ( [ssc_skill_categories] => Graphic [sc_skill_categories] => Designers )
[5] => Array ( [ssc_skill_categories] => Logo [sc_skill_categories] => Designers )
[6] => Array ( [ssc_skill_categories] => Illistration [sc_skill_categories] => Designers )
[7] => Array ( [ssc_skill_categories] => Animation [sc_skill_categories] => Designers ) )

What i would like to to is display this information in a table like so:

<html>
<body>
   <table>
      <tr>
         <td>Programming</td><td>Web</td><td>Actionscript</td><td>C#</td><td>CSS</td>
      <tr>
      <tr>
         <td>Designers</td><td>Graphic</td><td>Logo</td><td>Illistration</td><td>Animation</td>
      <tr>
   <table>
</body>
</html>

I have been trying and failing all day to do this. Posting my "progress" will clog up the thread, so for now i wont post it. Does anyone have an idea how i would achieve this?

Regards,
-Ben

User Login Combine With Second Table Php For User To List Mutiple Entries

Similar Tutorials

View Content

I would appreciate your assistance, there are tons of login scripts and they work just fine. However I need my operators to login and then list their activities for the other operators who are logged in to see and if desired send their clients on the desired activity. I have the login working like a charm and the activities are listed just beautifully. How do I combine the two tables in the MySQL with PHP so the operator Logged in can only make changes to his listing but see the others.

FIRST THE ONE script the member logges in here to the one table in MSQL:
<?php
   session_start();

   require_once('config.php');

   $errmsg_arr = array();

   $errflag = false;

   $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
   if(!$link) {
      die('Failed to connect to server: ' . mysql_error());
   }

   $db = mysql_select_db(DB_DATABASE);
   if(!$db) {
      die("Unable to select database");
   }

   function clean($str) {
      $str = @trim($str);
      if(get_magic_quotes_gpc()) {
         $str = stripslashes($str);
      }
      return mysql_real_escape_string($str);
   }

   $login = clean($_POST['login']);
   $password = clean($_POST['password']);

   if($login == '') {
      $errmsg_arr[] = 'Login ID missing';
      $errflag = true;
   }
   if($password == '') {
      $errmsg_arr[] = 'Password missing';
      $errflag = true;
   }

   if($errflag) {
      $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
      session_write_close();
      header("location: login-form.php");
      exit();
   }

   $qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])."'";
   $result=mysql_query($qry);

   if($result) {
      if(mysql_num_rows($result) == 1) {
         session_regenerate_id();
         $member = mysql_fetch_assoc($result);
         $_SESSION['SESS_MEMBER_ID'] = $member['member_id'];
         $_SESSION['SESS_FIRST_NAME'] = $member['firstname'];
         $_SESSION['SESS_LAST_NAME'] = $member['lastname'];
         session_write_close();
         header("location: member-index.php");
         exit();
      }else {
         header("location: login-failed.php");
         exit();
      }
   }else {
      die("Query failed");
   }
?>

................................................. ................................
Now I need the person who logged in to the table above to be able to make multiple entries to the table below

<?
$ID=$_POST['ID'];
$title=$_POST['title'];
$cost=$_POST['cost'];
$activity=$_POST['activity'];
$ayear=$_POST['aday'];
$aday=$_POST['ayear'];
$seats=$_POST['special'];
$special=$_POST['seats'];
mysql_connect("xxxxxx", "xxx350234427", "========") or die(mysql_error());
mysql_select_db("xxxx") or die(mysql_error());
mysql_query("INSERT INTO `activity` VALUES ('ID','$title', '$cost','$activity', '$aday', '$ayear', '$special', '$seats')");
Print "Your information has been successfully added to the database!"
?>
Click <a href="member-profile.php">HERE</a> to return to the main menu
<?php
?>

Searching Multidimensional For Values, Then Outputting Other Values In Array

Similar Tutorials

View Content

Mysql Dump

Similar Tutorials

View Content

Hello,

I'm having some issues with the following:

$file = fopen('dump.sql', 'r');
$temp = '';

while($line = fgets($file))
{
if ((substr($line, 0, 2) != '--') && (substr($line, 0, 2) != '/*') && (substr($line,0,1) != '#') && (strlen($line) > 1))
{
$last = trim(substr($line, -2, 1));
$temp .= trim(substr($line, 0, -1));
if ($last == ';')
{
mysql_query($temp) or die(mysql_error());
$temp = '';
}
}
}
fclose($file);

the sql files are either phpmyadmin dumps or heidi sql dumps. I'm not getting any error from the error() call but nothing is ever imported into the database. I'm able to login to phpMyAdmin and import the file without any issues but I'd really like to stay out of the cPanel/phpmyadmin as much as possible.

what am I missing? thanks!!

I Need Help With A Nested Array

Similar Tutorials

View Content

Hello everyone,

I'm trying to pull a list of email campaigns from constant contact and display them on our site,

require_once('ctctWrapper.php');
$data = new CampaignsCollection();
$campaigns = $data->listCampaigns();
foreach ($campaigns as $campaign) {

foreach ($campaign as $value) {

$feed .= $value . "\r\n";

Array Element In Each Cell

Similar Tutorials

View Content

Php String To Nested / Multidimensional Array

Similar Tutorials

View Content

I have this example php string:

Code: [Select]
$string = "@[item_1][door] @[mozart][grass] = yes @[mozart][green] = no @[mozart][human] @[blue][movie]=yes @[item_1][beat] = yes @[item_1][music] = no ";
now $string idented just to easy view:

Code: [Select]
@[item_1][door]
@[mozart][grass] = yes
@[mozart][green] = no
@[mozart][human]

@[blue][movie]=yes

@[item_1][beat] = yes
@[item_1][music] = no
I want to know how can i get this string ( or other string following this style ) and transform in an array that looks like:

Code: [Select]
Array
(
[item_1] => Array
(
[door] => Array
(
[mozart] => Array
(
[grass] => yes
[green] => no
[human] => Array
(
[blue] => Array
(
[movie] => yes
)
)
)
)
[beat] => yes
[music] => no
)
)
What i tried

I tried to use and recursive function to create an nested array but i can't have access to the array pointer ( in deep levels ) in recursive functions.. don't know why.. maybe is the wrong patch to the answer. thank you,

Fetch From The Server(mysql) And Then Dump Online Through A Php Page

Similar Tutorials

View Content

Is it possible to simply fetch from the server(mySql) and then dump it online through a PHP page?
Is there some link that you can share?

How To Properly Get Data From Database And Dump It Into Dropdown Menu?

Similar Tutorials

View Content

Hi,

I have a MySQL database called "2011_database" that has a table called "2011_list." In that table I have fields, amongst others, called "name" and "district."

I need to find way to get the data from the table and put them into a drop down list on other PHP page. But they need to be listed as "name - district" on one line.

I am PHP beginner and if I understand it correctly there need to be two references to get all the data in all records, a third reference to merge them together with " - " in between; and what eludes me the most, putting them in a drop down menu.

Any help is greatly appreciated
Thanks

Moved: Run Php In A Table Cell

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=355480.0

Empty Table Cell

Similar Tutorials

View Content

I am having a problem trying to show if cell is empty echo one thing if empty and starttime if there is one:

Code: [Select]
if(isset($rown['starttime'])) {
echo "Add Day";
} else {
echo $rown['starttime'];
}