PHP - Updating A Single Row From Within A Array Result Of 10 Items

Hi,

I'm hoping someone can help me with a simply array problem.

I have a table with two columns: "ID" and "Name" and 100 Names.

I also have an array called $myIDList containing 10 IDs. I want to display 10 Names from the table that correspond with the IDs from my array.

Originally, I tried to implode the array, adding commas and inserted into my MySQL query using:

$myQuery = "SELECT ID, Name FROM namesTable WHERE ID IN ($myImplodedIDList)";

The problem was that duplicated names (i.e. the same Name, but assiged to different IDs) would only be displayed once.

So now I'm trying to use the original array to loop through a second array and display Names where the ID matches an ID from my first array. I have succesffuly listed the table like this:

$myQuery = "SELECT ID, Name FROM myTable ORDER BY ID";

$myResult = mysql_query($myQuery) or die(mysql_error());

    while($row=mysql_fetch_array($myResult)) {
         echo $row['ID'];
         echo $row['Name'];
    }

But I want to do something like:

    while($row=mysql_fetch_array($myResult)) {
      while $row['ID'] = $myIDList {
      echo $row['Name']
      }
    }

Can someone shed some light onto this for me please?

Thank you!
Bryan

Hello
can anyone  help me out with code to create a 2 dimension array from 2 single dimension array. for example
$path = array('base', 'category', 'subcategory', 'item');
$location=array('india','USA','UK','RUSSIA',);
now i need to have a @D array which have the following structure
$final[0]=array('base','india');
$final[1]=array('category','USA');
$final[2]=array('subcategory','UK');
$final[3]=array('item','RUSSIA');

How can I check if an array contains two items that are the same?

For example ("apples", "bananas", "oranges") returns false
But ("apples", "bananas", "bananas") returns true

I have an array of products. The array has an ID and price. I'd like to know the most efficient way of adding up all the same ID fields in the array.

Code: [Select]
<?php
$items[] = array(
'id' => 1,
'price' => 5.99,
);
$items[] = array(
'id' => 2,
'price' => 1.99,
);
$items[] = array(
'id' => 3,
'price' => 2.40,
);
$items[] = array(
'id' => 2,
'price' => 6.99,
);
$items[] = array(
'id' => 4,
'price' => 8,
);
$items[] = array(
'id' => 2,
'price' => 3,
);
$items[] = array(
'id' => 3,
'price' => 1,
);

function add_like_items($items)
{
//manipulation

return $sums;
}

//$sums would be an array like 
//$sum[1] = 5.99
//$sum[2] = 11.98
//$sum[3] = 3.40
//$sum[4] = 8 

?>
Anybody have suggestions on the best way to go about doing this?

Hi,  learning as I go here, and I appreciate the help in advance ..

I have some working php code that retrieves sql results using php.  I assign the resutls to an array by doing this

$bobreport = array();
while ($row=db2_fetch_array($querystmt)) {
   array_push($bobreport, $row);
}

i can then write the rows of returned data after some column headers using this...

foreach ($bobreport as $value) {

echo "<tr><td>$value[0]</td><td>$value[1] .....

}

The particular report I'm working on now has a redundant date and time in every row that I omit in the foreach loop because I just want to show it once above the table somewhere.  This doesn't seem to work in accomplishing that...

echo "This data was updated ".$bobreport[0][9]." at ".$bobreport[0][10] ;

All I seem to get in the report is "This data was updated at".

Please help.

hey everyone

will you please assist.

I'm getting data from a mysql database.

And I want to assign the data to a single value, if possible

For example, in my database I have 2 columns, name and group

Lets say John, Peter and Cathy belongs to group 555, where Sally and Marcus belongs to group 777.

So my sql query outputs all users in group 555

Is there a way to assign the search result to a vlue, for example $result = ???

and If I said echo $result, it should show the users who belongs to group 555 as an example.

I tried to use row[Name][1]; but it doesnt work.

The thing is, I can display the data the way I am familiar with, but I'm sending an automated email to myself, containing the users. So if I would used a for each statement, the mail will trigger and send a copy for every count, in this case, 3 times. And thats my huge problem.

The mail must trigger only once, containing the users in my search query, in this case, group 555.

Any help will be appreciated

Thank you

Hi all,

I have a table that shows data from an xml response that has been converted to an array.

I have successfully managed to get that to work but it's showing more items than I want.

I'm trying to isolate the items by state. There are 11 or so different states, of which I only want 7. 

I've tried the following with a while loop but I keep getting the message "undefined index: job_status"  

Here's my code (partial)

$projects = array();    
    
        $xml=simplexml_load_string($response) or die("Error: Cannot create object");
     
    foreach($xml->Jobs->Job as $item) {
     
    $projects[] = array(
                     'job_no'          => (string)$item->ID,
                     'job_name'        => (string)$item->Name,
                     'job_due'         => (string)$item->DueDate,
                     'job_status'      => (string)$item->State,
                     'job_staff'       => (string)$item->Assigned->Staff->Name,
                    );
     }
     
 usort($projects, function($a,$b) {return $a['job_due'] <=> $b['job_due']; } );

$projects = array_reverse($projects);
     
while ($projects['job_status'] == ('Feasibility') 
          && ('Measure Up') 
          && ('Model Drawing') 
          && ('Concept Design') 
          && ('Developed Design') 
          && ('Resource Consent') 
          && ('Construction Documentation')) {
    
foreach ($projects as $proj) {
$formatted = date('d/m/Y', strtotime($proj['job_due'])); 
    $job_no ="{$proj['job_no']}";
    $job_name ="{$proj['job_name']}";
    $job_due ="$formatted";
    $job_status ="{$proj['job_status']}";
    $job_staff ="{$proj['job_staff']}";

Any help would be much appreciated thanks. 

Hi,

Im wondering if there is an easy way to get items out of an array returned by a function inside a class.   A code example would be:

Code: [Select]
class modDB {

public function getPwdSalt() {
$arr = array("salt", "password");
return $arr;
}

}
?>
And what i would like to be able to do is something like:

Code: [Select]
$modDB = new modDB;

echo $modDB->getPwdSalt()->[1];
and just get returned 'password'.  Is something like that possible?

Many Thanks.

Hi guys,
I'm just working on a script to get menu items from a database, sorted by a sort column. Each item needs to be checked to see if it has a parent, then paired with the parent.

Would it be best to get all of the items at once and pair them with PHP, or get the children of each item when as a separate array?

id label link parent sort 1 Home index.php 0 10 2 About about.php 0 20 3 Contact Us contact.php 2 10

Running a simple query:

SELECT team, rank from table ORDER BY rank ASC

returns 8 records in order from 1 to 8

I then want to a assign a new variable to each that I can use for later queries ie:

team with rank 1 = $team1
team with rank 2 = $team2
team with rank 3 = $team3

etc....


Thanks in advance.

I came up with this but it outputs the value 3 times... (because there are 3 variables)

ie mathsmathsmaths

How do I fix this or do it the correct way? Thanks

Code: [Select]
$subject = "maths";
$phone = "1235";
$colour = "red";
$all_vars = compact("subject", "phone", "colour");

get_value($subject);

function get_value($variable){
global $all_vars;
foreach($all_vars as $key=>$value){
if ($key = $variable) {
echo $key;
}
}
}

Hi Guys,

I have 6 file upload fileds in an array. When i try to return the error messages at this link: http://www.php.net/manual/en/features.file-upload.errors.php i get an error displayed for every upload box. I was wondering if it is possible to simply return 1 error instead of the 6? For example rather than getting "No File Uploaded No File Uploaded No File Uploaded No File Uploaded No File Uploaded No File Uploaded" i simply get "No File Uploaded". Also If only some files are uploaded no error should be displayed.

The code i am using is:

foreach ($_FILES['image']['error'] as $key => $error)

{

if ($error == UPLOAD_ERR_NO_FILE)

{

echo "No File Uploaded";

}


I have tried using "break;" which works in leaving only 1 error, however the error is still displayed if less than 6 files are uploaded.

All help greatly appreciated.

Thanks

Hi,

I'm a beginner at PHP and am I'm trying to update an array but cant get it to work:

This is my 'rates' page, There are 6 boxes that are the headings, and 6 boxes per line below for the data, I can get the headings to save but not the data lines below:

rates-edit.php

Code: [Select]
<?php

error_reporting(E_ALL);
ini_set('display_errors', 2);

     // Include the necessary files
    include_once '../inc/db.inc.php';

    // Open a database connection
    $db = new PDO(DB_INFO, DB_USER, DB_PASS);

   // Extract details from database
    $sql = "SELECT title1, title2, title3, title4, title5, title6 
   FROM rates
WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch(); 

$sql2 = "SELECT 1, 2, 3, 4, 5, 6
FROM ratestable
ORDER BY id ASC";
$stmt2 = $db->prepare($sql2);
$stmt2->execute();
$e2 = $stmt->fetch();

?>
<!DOCTYPE html>
<html lang="en">
<head>

   <h3>Rates Table</h3>
 
   <form method="post" action="rates-editupdate.php" enctype="multipart/form-data">
   
   <input type="text" name="title1" maxlength="10" value="<?php echo $e['title1'] ?>" class="rates" />
   <input type="text" name="title2" maxlength="10" value="<?php echo $e['title1'] ?>" class="rates" />
   <input type="text" name="title3" maxlength="10" value="<?php echo $e['title3'] ?>" class="rates" />
   <input type="text" name="title4" maxlength="10" value="<?php echo $e['title4'] ?>" class="rates" />
   <input type="text" name="title5" maxlength="10" value="<?php echo $e['title5'] ?>" class="rates" />
   <input type="text" name="title6" maxlength="10" value="<?php echo $e['title6'] ?>" class="rates" />
   
   <?php
  while($e2 = $stmt2->fetch())
  {
?>
   <input type="text" name="1" maxlength="10" value="<?php echo $e2['1'] ?>" class="rates" />
   <input type="text" name="2" maxlength="10" value="<?php echo $e2['2'] ?>" class="rates" />
   <input type="text" name="3" maxlength="10" value="<?php echo $e2['3'] ?>" class="rates" />
   <input type="text" name="4" maxlength="10" value="<?php echo $e2['4'] ?>" class="rates" />
   <input type="text" name="5" maxlength="10" value="<?php echo $e2['5'] ?>" class="rates" />
   <input type="text" name="6" maxlength="10" value="<?php echo $e2['6'] ?>" class="rates" />
   <?php
      }
   ?>
   
              <input id="button-upload" class="button" type="submit" name="submit" value="Save Changes" />
              <input id="button-upload" class="button" type="submit" name="submit" value="Add New Row" />
              </form>

</body>
</html>
This is the page that updates the database, I cant get the loop/foreach to work...

rates-editupdate.php

Code: [Select]
<?php

error_reporting(E_ALL);
ini_set('display_errors', 2);

     // Include the necessary files
    include_once '../inc/db.inc.php';

    // Open a database connection
    $db = new PDO(DB_INFO, DB_USER, DB_PASS);


// Check if coming from a POST command and Save Changes
// THIS BIT WORKS :)
    if($_SERVER['REQUEST_METHOD']=='POST'
    && $_POST['submit']=='Save Changes')
{
        $sql = "UPDATE rates
                SET title1=?, title2=?, title3=?, title4=?, title5=?, title6=?
                WHERE id=1
                LIMIT 1";
        $stmt = $db->prepare($sql);
        $stmt->execute(
            array(
                $_POST['title1'],
                $_POST['title2'],
$_POST['title3'],
$_POST['title4'],
$_POST['title5'],
$_POST['title6']
            )
        );
        $stmt->closeCursor();

//
// THIS IS THE BIT THAT DOES NOT UPDATE:
//

$sql = "UPDATE ratestable SET 1=?, 2=?, 3=?, 4=?, 5=?, 6=? WHERE id=?";
$stmt = $db->prepare($sql);

if(count($_POST['1']) > 0)
{
  foreach($_POST AS $key => $val)
  {
    $stmt->execute(array(
($key),
($_POST['2'][$key]),
($_POST['3'][$key]),
($_POST['4'][$key]),
($_POST['5'][$key]),
($_POST['6'][$key]),
($val)
)
  );
}
$stmt->closeCursor();
}


// once updated return to rates page
header('Location: rates-edit.php?success=1');
exit;
}

?>
thanks in advance

I'm new at PHP and have a problem.
I have a MySql database with lists of students grouped into classrooms. A typical group is shown in the attached screenshot screenshot.docx. I want to be able to select one or more of the names by using the associated checkbox, and upgrade a student or students into a different group as defined in the radio button list also in the screenshot.
I have the rudiments of the file attached, but I have absolutely no idea how I can post the array so that the records are updated.
Each student has an individual record with a field name userGroup which holds a string nominated by their classroom teacher, such as "year7", "year 8" and so on while they are in one of the several classrooms, but when they leave school this is recorded in a field named noGroup with a value of 0 or 1.
I can post further details as required, but it would be great if someone could help me.

-First I want to say that I love this site and always check google before I submit questions but im lost.

I'm into security and trying to learn a little Apache, Mysql, and PHP to understand the development cycle better. As practice im creating a notecard test review site. Create notecard Decks, add/delete questions etc. shuffle, then test yourself.

I though I was doing good until I got to the page that shows the questions (test.php).


Right now I pass the "deck_id" field in a GET to a "test.php?id=" page that runs a script that pulls out all the questions for that deck from my "questions" table and loops to show each question for that "deck".

My loop  works, (gets array from database and  shows questions one by one), but it writes all the questions to the page at the same time. DUH. I want it to show one question with a "NEXT" button to show next question. This button clears the first question and writes the next one until they are all done. No grading or anything needed.


Is there a way to do this gracefully?

I dont know much javascript but looked up innerHTML and see i can update text that way but the PHP loop I have goes so fast it just end up showing the last question with no way to pause it between questions. Can anyone think of a way to do this? My problem is passing the data from page to page to page (I lose the array data)


If this is impossible my other thoughts a

1) store current list of Q/A's in cookie    (OR)
2) pass Q/A to another page with POSTS   (OR)
3)store Q/A's to temporary sql table and use GETS in loop to show each one by one. "testing.php?question=1"
4) can i set a global variable that can pass the data to separate pages?
5)user iFrame so it looks like one page (dont know how)


Im leaning to number 3 but want to hear your suggestions. (sorry very new)