PHP - Displaying Associated Array Element?

Hi Everyone

I am looking to just grab the first element of an array and do something to it but i only want this extra bit off code on the first value off the array.

Here is my array

echo "<pre>";
print_r($_SESSION);
echo "</pre>";
Array
(
    [attach] => Array
        (
        )

    [backups-2] => true
    [dnb] => true
    [house] => true
    [tech-house] => true
    [uk-garage] => true
    [uk-grime] => true
    [uk-hip-hop] => true
    [uncategorized] => true
    [warehouse] => true
    [value] => Array
        (
            [0] => Array
                (
                    [tune_name] => Music/dnb/Abort_Delta Heavy_192.mp3
                    [tune] => http://isdmusic.s3.amazonaws.com/Music/dnb/Abort_Delta Heavy_192.mp3
                    [submit] => Listen
                )

            [1] => Array
                (
                    [tune_name] => Music/dnb/Acid Bath (Northern Lights remix)_Twisted Individual_192.mp3
                    [tune] => http://isdmusic.s3.amazonaws.com/Music/dnb/Acid Bath (Northern Lights remix)_Twisted Individual_192.mp3
                    [submit] => Listen
                )

            [2] => Array
                (
                    [tune_name] => Music/dnb/Awkward_Inside Info_192.mp3
                    [tune] => http://isdmusic.s3.amazonaws.com/Music/dnb/Awkward_Inside Info_192.mp3
                    [submit] => Listen
                )

            [3] => Array
                (
                    [tune_name] => Music/dnb/Awkward_Inside Info_192.mp3
                    [tune] => http://isdmusic.s3.amazonaws.com/Music/dnb/Awkward_Inside Info_192.mp3
                    [submit] => Listen
                )

        )

)


so i just what to effect the first value what to and autostart to it???

Here is my code.

session_start();

header("Content-type: text/xml"); 
$xml_output = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n";
$xml_output .= '<playlist version="1" xmlns="http://xspf.org/ns/0/">\n'; 
$xml_output .= "<trackList>\n";

    $xml_output .= "\t<track>\n";  
    $xml_output .= "\t\t<location>" .  $_SESSION['value'][0]['tune_name'] . "</location>\n"; 
    $xml_output .= "\t\t<creator>sdf</creator>\n";
$xml_output .= "\t\t<album>sdf</album>\n"; 
$xml_output .= "\t\t<title>" . $_SESSION['value'][0]['tune_name'] . "</title>\n";
$xml_output .= "\t\t<annotation>I love this song</annotation>\n"; 
$xml_output .= "\t\t<duration>32000</duration>\n"; 
$xml_output .= "\t\t<image>covers/smetana.jpg</image>\n";
$xml_output .= "\t\t<info></info>\n";
$xml_output .= "\t\t<link>" . $furl . "</link>\n";
    $xml_output .= "\t</track>\n"; 

foreach ($_SESSION['value'] as $value) {  

$furl = "http://isdmusic.s3.amazonaws.com/".urlencode($value['tune_name']);
if(preg_match("/\.mp3$/i", $furl))
{ 

    $xml_output .= "\t<track>\n"; 
    $xml_output .= "\t\t<location>" . $furl . "</location>\n"; 

    $xml_output .= "\t\t<creator>" . $value['tune_name'] . "</creator>\n";
$xml_output .= "\t\t<album>" . $value['tune_name'] . "</album>\n"; 
$xml_output .= "\t\t<title>" .  $value['tune_name'] . "</title>\n";
$xml_output .= "\t\t<annotation>I love this song</annotation>\n"; 
$xml_output .= "\t\t<duration>32000</duration>\n"; 
$xml_output .= "\t\t<image>covers/smetana.jpg</image>\n";
$xml_output .= "\t\t<info></info>\n";
$xml_output .= "\t\t<link>" . $furl . "</link>\n";
    $xml_output .= "\t</track>\n"; 
} 
}
$xml_output .= "</trackList>"; 
echo $xml_output; 

Thanks

I am trying to break down an array to make it easier to read. An array that looks like Array ( => 0 [1] => 0 [2] => 0 [3] => 0012844 1 [4] => 37 [5] => 1 etc...) I want to display it like: Code: [Select]
[0] => 0
[1] => 0
[2] => 0
etc...
how can this be accomplished.

I am using session variables to keep track of what is in a shopping cart. I can add the items to the cart quite easily enough. But my problem is that I can't delete a specific item in the cart. Below is a summary of what the array looks like

$Item1=array("ProdID"=>"Hat","Color"=>"Not Needed","Size"=>5);
$Item4=array("ProdID"=>"Shirt","Color"=>"Green","Size"=>"L");
$Item2=array("ProdID"=>"Pants","Color"=>"Not Needed","Size"=>"32x32");
$Item3=array("ProdID"=>"Socks","Color"=>"Not Needed","Size"=>"Not Needed");
$NumItems=4;
$TestArray=array("NumItems"=>$NumItems,1=>$Item1,2=>$Item2,3=>$Item3,4=>$Item4);

However when I attempt to delete any of the top level elements (1,2,3,4,NumItems), I either end up deleting only the last element (4) or somehow taking out 2 of them. I know that this must be an easy fix but I've looked at it for so long that I can't seem to figure out what the problem is.
below is the code that I use to delete the Item from the array
Code: [Select]
$ItemNum=$_GET['item'];
if ($ItemNum=="All"){
$ItemNum=$_GET['item'];
if ($ItemNum=="All"){
unset($TestArray);
unset($TestArray['NumItems']);
unset($_SESSION['OrderTotal']);
//header("Location:Cart.php?act=view");
}
else{
$TestArray['NumItems']=$TestArray['NumItems']-1;
if($TestArray['NumItems']<1)
{
unset($_SESSION['OrderTotal']);
unset($TestArray);
unset($TestArray['NumItems']);
}
else
{
unset($TestArray[$ItemNum]);
}


Can anyone take a look at this and point me in the correct direction? What I am after is to delete any element of the top array and keep the rest.

Hi, I have an array key whose value is a line of html in quotes, the problem is , I don't know how to do it. Lol. Any help greatly appreciated because the below code is generating an error in my editor. Thank you. Derek

here is the line.

Code: [Select]
'level_1'=>"<img src='<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>'",
EDIT:

actually I managed to fix the error adding a semicolon after the parenthesis. Is this array correct please?

Code: [Select]
$currentLocation = array
(
'teardrop_ocean_bg' => array
(
'level_1'=>"<img src='<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>'"



)

);

it's not finished yet.

Hello All,


I have used a function to collect a users information from the database. This is then returned as an array.


Using this returned array, I wish to pass it into another function.


Here is the code:


The array is created in the collect() function and needs to be passed to the ipn_data function



Code: [Select]
/*


This script is responsible for handling all subscription payments. It will collect all information, insert data into the relevant databases and then forward the user to PayPal with the relevant transaction ID. On return, the IPN listener will
deal with all account changes whilst the user is held in a queue.


*/


/* ------------------------------------- */
/* DATABASE CONFIGURATION               */
/* ------------------------------------- */


include_once "../config/config.php";


/* ------------------------------------- */
/* COLLECT SESSION INFORMATION            */
/* ------------------------------------- */


session_start();
$id = "100000002"; // ID of logged in user
$next_year = date("Y-m-d", strtotime("+365 day", time())); //Date next year


/* ------------------------------------- */
/* SET VARIABLES                     */
/* ------------------------------------- */


$reason = $_GET["reason"];


/* ----------------------------------------- */
/* COLLECT USERS INFORMATION FROM DATABASE    */
/* ----------------------------------------- */


function collect($id) {
   
   //Select the subscriber from the database
   $query = "SELECT * FROM subscribers WHERE id='$id'";
   $query = mysql_query($query);
      //Collect the subscribers first name, last name and email address
      while($row=mysql_fetch_array($query)) {
         $fname = $row["fname"];
         $lname = $row["lname"];
         $email = $row["email"];
      }
   
   //Collate subscribers information into an array
   return array('fname' => "$fname", 'lname' => "$lname", 'email' => "$email");
   
}


/* ----------------------------------------- */
/* CREATE TIMESTAMP OF CURRENT TIME          */
/* ----------------------------------------- */


function mktimestamp() {
   
   //Set date variables
   $day = date("d");
   $month = date("m");
   $year = date("Y");
   
   //Make timestamp
   return mktime(0, 0, 0, $month, $day, $year);


}


/* ----------------------------------------- */
/* INSERT USERS DATA INTO ipn_data           */
/* ----------------------------------------- */


//Create random identifier
$ident = rand("1", "10000");


function ipn_data($info, $reason, $timestamp) {
   
   //WANT THE ARRAY TO BE PASSED INTO HERE!!
       //I TRIED PASSING THE $info VARIABLE INTO THE FUNCTION, WHICH IS WHAT I ASSIGNED TO THE COLLECT FUNCTION LATER IN THE SCRIPT
   
}


/* ----------------------------------------- */
/* Get ID of inserted ipn_data row           */
/* ----------------------------------------- */


function get_id($ident, $timestamp) {


   //Setup Query to find ID
   $query = "SELECT * FROM subscribers WHERE timestamp='$timestamp' AND identifier='$ident'";
   
   //Run Query
   $query = mysql_query($query) or mysql_error();
   
   //Using query find ID
   while($row=mysql_fetch_array($query)) {
      $ltj_txn_id = $row["id"];   
   }
   
   return $ltj_txn_id or mysql_error();
   
}



/* ------------------------------------- */
/* SWITCH REASON                     */
/* ------------------------------------- */


switch($reason) {


   case "subscribe":
   break;
   
   case "renew":
   
      //Collect array from user information array function
      $info = collect($id);
     
      //Get timestamp from our mktimestamp function
      $timestamp = mktimestamp();
     
      //Insert users data into ipn_data table
      $run_ipn = ipn_data($reason, $timestamp, $ident);
     
      //Collect ID of record just inserted
      $get_id = get_id($ident, $timestamp);
     
      echo "$run_ipn";
     
   
   break;
   
   case "upgrade":
   break;
   
   default:
   break;


}

Any ideas?

Hi
I am trying to modify my database and am using the following part of code which isn't working. $bad is various values seperated by a newline. The strange thing about the code is that it works when their is only one $value but won't work if their are two or more values even though it is too easy to be wrong. Please help

 $badarray=explode(array("\r\n", "\r", "\n"),$bad);
   foreach($badarray as $value){
      $value= str_replace(array("\r\n", "\r", "\n"),NULL,trim($value));
      echo $value;
      $query="Update googlevacancies_junk SET exist='$no'    WHERE email='$value' ";
      mysql_query($query);   
   }

Code: [Select]
    Array
    (
        [Comment] => Array
            (
                [post_id] => 1
                [name] => cc
                [email] =>
                [body] => spam
            )     
    )

How can i check if email is empty or not? Is there any php built in function? Should i use foreach?

I'm wondering if this is at all possible:-

Code: [Select]

$i = 7;

$row_item['comment$i_name'] = "john";


with the $i in $row_item['item$i_id'] being replaced with whatever $i is set as sort of like this:-

$row_item['comment.'$i'._name']

Is this sort of concatenation possible inside array element names as I can't seem to get it to work?

Is there any limit to the length of an array element in a flat data file?

For instance, I have a flat file that I might end up having 200 rows, with each row containing 15 elements.  Most of the elements will be about 20 characters or less, but a couple of the elements might be 300-400 characters.

I'm guessing there is no limit.

And since each row will be longer than one "line" in a .txt file, how best to mark the end of a row?

[I assume that using a database is probably the better way to do this, but on this particular website I'm working on that isn't an option.]

i am trying to check if the array element (which would be a file) is null or not.  when i run it, uploading one file, it says "Please select some files to upload first!" X 3.  what am i doing wrong?

my code: http://pastebin.com/m0k3fEd2

Hi all,

Is there a function or method to delete element from current position in array without knowing the index. For example:




$ar = array( 1, 2, 3, "test", 4, 5, "test2" );

while( $v  = current( $ar ) )
{
    if( key( $ar ) == "test" )
     {
          // remove element from the array where key equals "test"
          // i could count every cycle and splice from that index but i wonder can that be done without it
          // i am looking at the php array functions but i can't find any that will delete from element from current position in array

          echo 'key( $ar ) je test. key( $ar ): ' . key( $ar );
     }

      next( $ar );
}



One thing that i don't understand is that when i run example above the "test" key is found and when i echo it it gives me 0.

Folks,

I am not able to find any function that will sort an array elements by its element's length. Does such function exist?

I have a user table that holds email addresses and for testing purposes I am trying to replace every email address with an email address defined in an array.  I would like to randomly choose an email address from the array and update the table with this address.  When I run the following code it randomly chooses a email address from the array but then updates every row with this one email address.  Can you someone please let me know what I am doing wrong.  Thanks in advance.

Code: [Select]
$query = "SELECT * FROM user '";
$result = mysql_query($query);

$input = array('email1', 'email2', 'email3', 'email4', 'email5', 'email6', 'email7');
$rand_keys = array_rand($input, 2);
$replaceStr = $input[$rand_keys[0]];

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
 $rand_keys = "";
 $rand_keys = array_rand($input, 2);
 $replaceStr = $input[$rand_keys[0]];

 mysql_query("UPDATE user SET email = '$replaceStr'");

}

Hey All.   I'm currently using the following code to source some information from a Mysql Database.   I've limited the results to 6 Values. I'm using the WHILE function to display a table with the results populated in.   As you'll see from the attached picture, the WHILE function is causing 5 tables to be created, each with 5 of the same image displayed. How do I go about displaying only 1 table with the 5 different pictures displayed in?

<?php

$result = mysqli_query($con, "SELECT * FROM photo ORDER BY id DESC LIMIT 6"); 
while($row = mysqli_fetch_array($result)){

echo
'<table>
<tr><td class="left">

<a href="photo.php?id='.$row['id'].'"><img src="images/'.$row['id'].'.jpg"  height="232"  alt=""/></a>


</td>
<td class="center">
<a href="photo.php?id='.$row['id'].'"><img src="images/'.$row['id'].'.jpg"  height="112"  alt=""/></a>
<a href="photo.php?id='.$row['id'].'"><img src="images/'.$row['id'].'.jpg"  height="112"  alt=""/></a>
</td>
<td class="right">

<a href="photo.php?id='.$row['id'].'"><img src="images/'.$row['id'].'.jpg"  height="72"  alt=""/></a>
<a href="photo.php?id='.$row['id'].'"><img src="images/'.$row['id'].'.jpg"  height="72"  alt=""/></a>
<a href="photo.php?id='.$row['id'].'"><img src="images/'.$row['id'].'.jpg"  height="72"  alt=""/></a>

</td></tr></table>';
}
?>

 Screen Shot 2014-08-20 at 15.46.31 (2).jpg   35.86KB   0 downloads   Thanks
Edited by JimmyLeaman, 20 August 2014 - 09:49 AM.

Thanks to the great help from some great people on this message board I'm right at the finish line on this page.

I'm trying to mesh all the coding together at this point, and make it display the information. 

I keep getting 'mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource....etc..(filename/location) on line 51.

Am I way off here???
Code: [Select]
<?php

        $db_host = 'localhost';
        $db_user = 'root';
        $db_pass = '';

        $db_in = new MySQLi ( $db_host, $db_user, $db_pass, 'sign_in' );
        $db_out = new MySQLi( $db_host, $db_user, $db_pass, 'sign_out' );

        if( $db_in->connect_error || $db_out->connect_error ) trigger_error( 'Unable to initiate database connections', E_USER_ERROR );

        $q_in =  'SELECT * FROM `customer sign-in`';
        $q_out = 'SELECT * FROM `customer sign-out`';

        if( ($r_in = $db_in->query($q_in)) === FALSE || ($r_out = $db_out->query($q_out)) === FALSE )
           trigger_error( 'Unable to grab ticket information from databases', E_USER_ERROR );

        $data_in = array(); $data_out = array();

        while( $row = $r_in->fetch_assoc() )
           $data_in[ $row['Ticket #'] ] = $row;
        $r_in->free();
           
        while( $row = $r_out->fetch_assoc() )
           $data_out[ $row['Ticket #'] ] = $row;
        $r_out->free();

        $result = array_diff_key( $data_in, $data_out );

           echo "<table border='1'>
        <tr>
        <th>ID</th>
        <th>Sign In Date</th>
        <th>RANK/CIV</th>
        <th>First Name</th>
        <th>Last Name</th>
        <th>Unit</th>
        <th>DSN/Roshan</th>
        <th>Classifications</th>
        <th>Services Requested</th>
        <th>Service Tag/ Serial Number</th>
        <th>Ticket #</th>
        <th>Make/ Model</th>
        </tr>";

    while($row = mysql_fetch_assoc($result)) {  // Retrieve data until no more
          {
          echo "<tr>";
          echo "<td>" . $row['ID'] . "</td>";
          echo "<td>" . $row['Sign in Date'] . "</td>";
          echo "<td>" . $row['Rank/CIV'] . "</td>";
          echo "<td>" . $row['First Name'] . "</td>";
          echo "<td>" . $row['Last Name'] . "</td>";
          echo "<td>" . $row['Unit'] . "</td>";
          echo "<td>" . $row['DSN/Roshan'] . "</td>";
          echo "<td>" . $row['Classifications'] . "</td>";
          echo "<td>" . $row['Services Requested'] . "</td>";
          echo "<td>" . $row['Service Tag/ Serial Number'] . "</td>";
          echo "<td>" . $row['Ticket #'] . "</td>";
          echo "<td>" . $row['Make/ Model'] . "</td>";
          echo "</tr>";
          }
        }
    ?>