PHP - Set Of Values Searched For

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:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</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'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

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

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)

Hi all,

Just curious why this works:

Code: [Select]
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";
}
And this does not:

$headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)";
}it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to.

I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement.

Thanks

Hello, I have read tutorials, searched forums for 2 weeks, and not found the assistance I require. I now jump in to ask my questions with the assistance from those much wiser then I...

I am new to this arena, so I honor your understanding to my situation.

I have 2 Solar Inverters that I have at my home, and I have a RS232 data port on each that is now connected to my home network via an IP converter to upload the data of the power they make each hour to a simple website I made, so I can see what is going on durring the hours I am at work. The information goes to my FTP site and the data falls into the MySQL table perfectly. I am trying to get the PHP and MySQL code to list the data into the forms/tables on the web page.

For this project I have set up Dreamweaver CS5 and a test server on my home PC, to get this working. All the data on the web host MySQL table is the same as in the test server (other then the host, name, and password but it works fine).

I have a very basic MySQL Named "inverters", and the table below named "feed"...

+---------+----------+------------+---------+------------+----------+
| Unit ID | Date | Time | Power | Volts | Current |
+---------+----------+------------+---------+------------+----------+
| 1 |YYYY-MM-DD| 12:00:00 | 560 | XXXX | XXXX |
+---------+----------+------------+---------+------------+----------+
| 1 |YYYY-MM-DD| 13:00:00 | 565 | XXXX | XXXX |
+---------+----------+------------+---------+------------+----------+
| 1 |YYYY-MM-DD| 14:00:00 | 890 | XXXX | XXXX |
+~~~~~~+~~~~~~+~~~~~~~~+~~~~~~+~~~~~~~+~~~~~~~+

Etc....

The 'Time' has 24 rows for each day, each 'Date" shows the same date for each of the 24 rows of 'Time".

The 'Power', is assigned as double the Volts and Current are "float".

I am able to SUM the Total "Power" of all the "Power" Rows with...

<?
$con = mysql_connect("localhost","NAME","PASWORD");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("inverters", $con);
$qry = mysql_query(" SELECT SUM(Power) AS total FROM feed ");
$row = mysql_fetch_assoc($qry);
echo $row['total'];
mysql_close($con);
?>

I have been trying for weeks to get "the CURRENT DAY power", Week Power, the month power etc to show the data on the webpage with no luck.

A very simple table on the website... As seen on the website.

+-----------+----------------+-----------------+-----------------+
| Today | This Month | This Year | Lifetime Power |
+-----------+----------------+-----------------+-----------------+
|????????| ??????????|???????????|----working----|
+-----------+----------------+-----------------+-----------------+

For the Current Day, I have tried this, but it does not work...

$query = mysql_query("SELECT(date), SUM(Power) AS 'day_total' FROM feed WHERE (date) = CURDATE() GROUP BY (date) ORDER BY (date) ");
$result = mysql_fetch_array($query);
$daytotal = $result["day_total"];
echo $row['day_total'];
mysql_close($con);

For the Month, I have tried this, but it does not work...

$query = mysql_query("SELECT MONTH(date), SUM(Power) AS month_total FROM feed GROUP BY Month(date)");
$result = mysql_fetch_array($query);
echo $row['month_total'];
mysql_close($con);

For the YEAR, I have tried this, but it does not work...

$query = mysql_query("SELECT date, SUM(Power) AS total FROM feed GROUP BY date");
$result = mysql_fetch_array($query);
echo $row['year_total'];
mysql_close($con);

I am reading and reading. Online I see how to get user names, and the time they register, and how many 'visitor' hits per year or month etc, but none have been informative to my situation. I think the more I read on the PHP and MySQL website manual, the more stupid I have become...

Using Google to seach "how to get the SUM of Current Date" only showes me how to enter the current date on a webpage or in a table row, not how to SUM the values of a table of the current day.

I also want to have a PHP graph (I have PHPgraphLIB now) on another page, and control the graph images by using a simple "Date Picker" or calendar, but that ran into the same type of issues as anything I write does not generate or show the results. I spent days using Prototype.js calendars and AJAX to connect the server side to the graphs and calendar etc..., but that is a different issue... hahaha

I would greatly honor any assistance to my learning and functioning of this.

Thank You,

Alan

Hi, I have this $_POST array coming from a paypal transaction

Code: [Select]
Array
(
    [address_city] => San Jose
    [address_country] => United States
    [address_country_code] => US
    [address_name] => Test User
    [address_state] => CA
    [address_status] => confirmed
    [address_street] => 1 Main St
    [address_zip] => 95131
    [business] => test1_biz@gmail.com
    [charset] => windows-1252
    [custom] =>
    [first_name] => Test
    [item_name1] => Product Name 1
    [item_name2] => Product Name 6
    [item_name3] => Product Name 8
    [item_number1] => 1
    [item_number2] => 6
    [item_number3] => 8
    [last_name] => User
    [mc_currency] => USD
    [mc_fee] => 0.82
    [mc_gross] => 18.00
    [mc_gross_1] => 14.00
    [mc_gross_2] => 2.00
    [mc_gross_3] => 2.00
    [mc_handling] => 0.00
    [mc_handling1] => 0.00
    [mc_handling2] => 0.00
    [mc_handling3] => 0.00
    [mc_shipping] => 11.00
    [mc_shipping1] => 11.00
    [mc_shipping2] => 0.00
    [mc_shipping3] => 0.00
    [notify_version] => 3.4
    [num_cart_items] => 3
    [payer_email] => test_biz@gmail.com
    [payer_id] => TRCLJTHLNCJ7Q
    [payer_status] => verified
    [payment_date] => 22:52:56 Jan 27, 2012 PST
    [payment_fee] => 0.82
    [payment_gross] => 18.00
    [payment_status] => Completed
    [payment_type] => instant
    [protection_eligibility] => Eligible
    [quantity1] => 1
    [quantity2] => 1
    [quantity3] => 1
    [receiver_email] => test_biz@gmail.com
    [receiver_id] => 74PV23B8KSK84
    [residence_country] => US
    [tax] => 0.00
    [tax1] => 0.00
    [tax2] => 0.00
    [tax3] => 0.00
    [test_ipn] => 1
    [transaction_subject] => Shopping CartProduct Name 1Product Name 6Product Name 8
    [txn_id] => 7BS85664SB906284D
    [txn_type] => cart
    [verify_sign] => AJ2IuqHp8G0lIxhedAqrwRQbv8fVA4-Gum9e7DMZmEWIFrljEwFCJDfP
)
1

as you can see, there are key value pairs like this,
Code: [Select]
[items_name1] => Product Name 1
[items_name2] => Product Name 2
[items_name3] => Product Name 3

those keys aren't constant, I mean, it came from a shopping cart, so the item name depends on how many items were placed in the shopping cart to be purchased.. now my question is,
How to loop to that post array, and get only the item_names plus their corresponding values ?, because I need them and save in a db table 

hey guys
i am  stuck at one part. i am coding a site where on the index page there are 5 categories. Now on click of these it takes me to a page where i can search within a particular category. i can do it by statically giving <href="localhost/xampp/abc.php">and a fixed page path. but i want the name of the category passed when i click and the search page to open when i open search.


thanks

I have a table with a list of towns and cities with their postcode and latitude and longitude. Since a lot of small towns in an area have the same postcode.

I have a search which I want to return all towns that have the same postcode.

the table is set up as:

postcode:::::::town::::::::lat:::::::::long

I'm working on a small project that requires a user login function. There's only going to be about 10 members in the database. I've followed a tutorial of how to make a login system. I've never really worked with sessions before, but I did some research and get the general concept of them.

What I want to do is store the user's username in a session when they log in, so I can run queries and such later specific to that user. How would I do that? I was able to manually set a session, but I need to set the session equal to what their username is on login. I've tried doing that below, but I don't think it's working. Either that, or I'm not calling the session correctly in the other page where I want to display their username.

Here's the code for the page that checks if the login is correct:

Code: [Select]
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
$_SESSION['myusername'] = $myusername;
$_SESSION['password'] = $encrypted_mypassword;
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>
Thanks in advance for any replies

I have a php page where user/db info is being passed:


<?php
include "include/dbc.php";

include "include/header.inc";

$exerciseid = $_POST["exerciseid"];
$duration = $_POST["duration"];
$distance = $_POST["distance"];
$metric = $_POST["metric"];

echo'<h1>Added Activities</h1>';



// name of array
echo '<h1>Exercise</h1>';
if (is_array($exerciseid)) {
        foreach ($exerciseid as $key => $value) {

        echo $key .' : '. $value .'<br />';

        }
}



// name of array
echo '<h1>Duration</h1>';
if (is_array($duration)) {
        foreach ($duration as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}


// name of array
echo '<h1>Distance</h1>';
if (is_array($distance)) {
        foreach ($distance as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}

// name of array
echo '<h1>Metric</h1>';
if (is_array($metric)) {
        foreach ($metric as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}

?>


And here is the output from that code:

Added Activities

Exercise
0 : Canoeing, on camping trip
1 : Canoeing, rowing, over 6 mph, vigorous effort
2 : Canoeing, rowing, crewing, competition
3 : Canoeing, rowing, light effort
4 : Canoeing, rowing, moderate effort
5 : Diving, springboard or platform
6 : Kayaking
7 : Sailing, boat/board, windsurfing, general
8 : Sailing, in competition
9 : Skiing, water
10 : Ski-mobiling, water
11 : Skin diving, scuba diving, general
12 : Snorkeling
13 : Surfing, body or board
14 : Swimming laps, freestyle, fast, vigorous effort
15 : Swimming laps, freestyle, light/moderate effort
16 : Swimming, backstroke, general
17 : Swimming, breaststroke, general
18 : Swimming, butterfly, general
19 : Swimming, leisurely, general
20 : Swimming, sidestroke, general
21 : Swimming, sychronized
22 : Swimming, treading water, fast/vigorous
23 : Swimming, treading water, moderate effort
24 : Water polo
25 : Water volleyball
26 : Whitewater rafting, kayaking, or canoeing

Duration
Canoeing, on camping trip : 20
Canoeing, rowing, over 6 mph, vigorous effort :
Canoeing, rowing, crewing, competition :
Canoeing, rowing, light effort :
Canoeing, rowing, moderate effort :
Diving, springboard or platform :
Kayaking :
Sailing, boat/board, windsurfing, general :
Sailing, in competition :
Skiing, water :
Ski-mobiling, water :
Skin diving, scuba diving, general :
Snorkeling :
Surfing, body or board :
Swimming laps, freestyle, fast, vigorous effort :
Swimming laps, freestyle, light/moderate effort :
Swimming, backstroke, general :
Swimming, breaststroke, general :
Swimming, butterfly, general :
Swimming, leisurely, general :
Swimming, sidestroke, general :
Swimming, sychronized :
Swimming, treading water, fast/vigorous :
Swimming, treading water, moderate effort :
Water polo :
Water volleyball :
Whitewater rafting, kayaking, or canoeing :

Distance
Canoeing, on camping trip : 20
Canoeing, rowing, over 6 mph, vigorous effort :
Canoeing, rowing, crewing, competition :
Canoeing, rowing, light effort :
Canoeing, rowing, moderate effort :
Diving, springboard or platform :
Kayaking :
Sailing, boat/board, windsurfing, general :
Sailing, in competition :
Skiing, water :
Ski-mobiling, water :
Skin diving, scuba diving, general :
Snorkeling :
Surfing, body or board :
Swimming laps, freestyle, fast, vigorous effort :
Swimming laps, freestyle, light/moderate effort :
Swimming, backstroke, general :
Swimming, breaststroke, general :
Swimming, butterfly, general :
Swimming, leisurely, general :
Swimming, sidestroke, general :
Swimming, sychronized :
Swimming, treading water, fast/vigorous :
Swimming, treading water, moderate effort :
Water polo :
Water volleyball :
Whitewater rafting, kayaking, or canoeing :

Metric
0 : mile
1 : mile
2 : mile
3 : mile
4 : mile
5 : mile
6 : mile
7 : mile
8 : mile
9 : mile
10 : mile
11 : mile
12 : mile
13 : mile
14 : mile
15 : mile
16 : mile
17 : mile
18 : mile
19 : mile
20 : mile
21 : mile
22 : mile
23 : mile
24 : mile
25 : mile
26 : mile


As you can see, null values are being passed as well. I am hoping that someone can show me the correct way to use php unset to get rid of these null values. Thank you.

I have two pages of php. one is page1.php and the other is page2.php.

In page1.php there is a function which dynamically creates a form of html and return the full form at the end of the function.
And I want to the function to return a 2nd variable with the form. and i get that variable on page2.php.

How can i do this???

I connected to a database.  i want to know how i can get the value out of that field and add it to the values of another.  i don't want to make any changes to the database.  i just want to use the values for coding.  please, if anyone knows how to do this, let me know.

Hey! How've you been? This should be simple but I can't make it work. I have a few database values from a user entry. The page queries the database and I can print them no problem. I want to add them and display the total of these values. I've tried about two dozen ways of doing and I just can't get them to add. Where I have "fee_total" I want it to be the sum of the values "fee+upgrade7+tax". This is the snippet of what I'm working on. I won't attach any of what I have tried because, well, there are too many attempts and nothing worked

    $sql = ("SELECT * FROM Teamregister WHERE pkSoloregisterID=$pkSoloregisterID");
    $query = mysql_query($sql);
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);

    printf ('<form action="https://www.mysite.com/cgi-bin/webscr" method="post">
      <p>Your registration fee is <strong>$%s</strong>.</p>', $myrow['total_fee']);
      echo ("<input type='hidden' name='item_name_1' value='Registration Fee'>");
      printf ('<input type="hidden" name="amount_1" value="%s">', $myrow['total_fee']);
      echo ("<br /><div align='center'>
      <input type='submit'' value='Pay Online'>
      </form>');

Make sense? Like I said, the values are already there but the math isn't happening. To check I tried using individual DB values instead of "total_fee" and the numbers show up. Just cannot get them to add.

How to get the cookie value,when we login for a website,also how to access the site by using the cookie values?

Hey guys,
What would you recommend to store db values for later?

the only thing I can come up with is doing it this way:

$result = mysql_query("SELECT * FROM users WHERE name='$user'");
while($row = mysql_fetch_array($result))
{
}
  {
and then using the $row['dbvariable'] later

is that the best way?

Ok so heres the deal we need to figure out what type of value this is. If we know the type of the value it will be easier to decode.
First example:
http://www.bungie.net/stats/reach/playermodel.ashx?rpis=Wn75LC7tNRPCzuCGiHcGa86qfjGywE9l952YIGX-xFA=

The value is the "Wn75LC7tNRPCzuCGiHcGa86qfjGywE9l952YIGX-xFA"

Second Example
http://www.bungie.net/stats/reach/playermodel.ashx?rpis=XkwTJb7m$0Rl3YjPpAPwyQ==

The value is the "XkwTJb7m$0Rl3YjPpAPwyQ="


Thank you for you time.