PHP - How To Extract Information From An Existing Array To A New Array?

I'm a newbie . I've been stuck on this error message for 2 days:
I get this error message: extract() expects parameter 1 to be array, boolean given in C:\x\xampp\htdocs\user_personal.php on line 30

Code: [Select]
<?php
$query = 'SELECT
        about_me, job, hobbies, contact
    FROM
        site_user u JOIN
        site_user_profile p ON u.user_id = p.user_id
    WHERE
        username = "' . mysql_real_escape_string($_SESSION['username'], $db) . '"';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_array($result);
extract($row);
mysql_free_result($result);
mysql_close($db);
?>
I think joining table is hard, I just want to create a profile that would be linked to a user name. Please be my friend and help me so I can have PHP phun time.

Hi - I have an array which is created from a session variable I must have constructed my array wrong, as for the life of me I can not extract the individual values.  I have tried innumerable $key=>$value combinations. I must be doing something stupid, maybe it is obvious, but not to me.   I'll be darn grateful if you can help me !  Many  Thanks


MY array looks like this:

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

    [name] => Array
        (
            [0] =>  Ribs Large pack 20 pieces
            [1] => 25 Piece Bag
            [2] => Sirloin Steak
            [3] => 50 piece bag of Scalops
            [4] => Sirloin Steak
        )

    [prodid] => Array
        (
            [0] => 17
            [1] => 28
            [2] => 27
            [3] => 25
            [4] => 27
        )

)




The CodeIgniter form which generated this array looks like this:

Code: [Select]

 <?php foreach ( $_SESSION['openorders'] as $key=>$value) {  ?>
<tr align="center">
<td width="30"><?php $data=array('name' =>'quantity[]','value'=>$value['quantity']); echo form_input($data); ?></td>
<td><?php echo $value['prodid']; ?></td>
    <td><?php echo $value['name'];?></td>
    <td><?php echo $value['ordervalue']; ?></td>
<td><?php echo $value['pricelb']; ?></td>
<td align="right"><?php echo form_checkbox('delete','delete',FALSE);
echo form_hidden('prodid[]', $value['prodid']);
echo form_hidden('name[]', $value['name']);
echo form_hidden('orderid', $value['orderid']);
   $totalordervalue += $value['ordervalue'];
} ?>

Hello everyone,

I have been trying several things,recently, and I can't figure out how to get a series of numbers, grouped together as a string of number, instead of it adding or grabbing the last number that was randomly generated.

I'm wanting to save it in a variable (of course), so I can pass it though a query when it is needed.


foreach($array as $number){
echo $number;
}


$array is the variable where it is an array but all the randomly generated numbers are stored there.

All / any help would be gratefully appreciated.

My array is

$arr = array(
	'global' => array(
		array('tabs', 'tabs', 'tabs', array(
			'Main' => 'main',
			'Gallery' => 'galleryID',
			'mera' => 'mera',
		)),

		array('main','div',  'div'),
		array('egice', 'Eice', 'text', '', ''),
		array('closeHere', 'closeHere', 'closeHere'),


		array('galleryID','div',  'div'),
		array('gallery', 'Gallery #1', 'image', '', ''),
		array('closeHere', 'closeHere', 'closeHere'),


		array('networking', 'div', 'div'),
		array('siLype', 'SiLype', 'text', '', ''),
		array('gpXCge', 'GpXCge',  'toggle_button', '1', 'Yes', 'No', ''),
		array('closeHere', 'closeHere', 'closeHere'),


		array('mera', 'div', 'div'),
		array('maimera', 'Maimera', 'repeatedText', 'resYI', 'GYL',''),
		array('closeHere', 'closeHere', 'closeHere'),



		array( 'moures','div', 'div'),
		array('meLmo', 'MeLmo', 'text', '', ''),
		array('cYSlot', 'CYSlot', 'text', '', ''),
		array('closeHere', 'closeHere', 'closeHere'),

		array('clT', 'clT', 'clT'),



	),

);

Simply, I want to split the main array to multiple arrays
extract new Array if “div” value found

I had tried here to do it but I can’t
https://3v4l.org/ppj1O 1
Could you help?

I have a function that is supposed to find the email address of the user that's logged in my application. going by their ID:

function getUserEmail($userID){
    $sqll="SELECT id,email FROM users WHERE id='".$userID."'";
    $result1=mysql_query($sqll);
    $row11=mysql_fetch_assoc($result1);
    $processor=$row11["email"]; 
    return $processor;
}

What I'm trying to do is incorporate that into sending a simple email to the person that's logged in after they submit a file. But the email is not being sent and I'm getting this message: Warning: mail() expects parameter 1 to be string, array given   Here is what I have for sending the email :

$sendto = getUserInfo($_REQUEST[1][email]);
$subject = "File recieved";
$message = "Hello " . getUser($_REQUEST["user"]) . ". you successfully submitted: $title";
mail($sendto, $subject, $message);

How do I extract just the email address to prevent giving the array?  

I suck with arrays, there I said it .  With that said, hopefully someone can help me here. I have two multi-dimensional arrays called $allteams and $chosenteams (the contents of which are listed below).  I simply want to compare them and make a new array of the items that are in the first array ($allteams) but NOT in the second array ($chosenteams). NOTE: I tried to use array_diff() but couldn't get it to work since they are multidimensional...

FYI, I'm also confused why the info appears to be listed twice but I think that just has to do with associative vs. numeric arrays (i.e. I think I just need to specify one and the amount info would be cut in half), but I'll research this more on my own as it seems like it has to be easy to find

$allteams

Array ( => Array ( => 1 [teamid] => 1 [1] => Philadelphia [teamcity] => Philadelphia [2] => Eagles [teamname] => Eagles ) [1] => Array ( => 2 [teamid] => 2 [1] => Dallas [teamcity] => Dallas [2] => Cowboys [teamname] => Cowboys ) [2] => Array ( => 3 [teamid] => 3 [1] => New York [teamcity] => New York [2] => Giants [teamname] => Giants ) [3] => Array ( => 4 [teamid] => 4 [1] => Washington [teamcity] => Washington [2] => Redskins [teamname] => Redskins ) [4] => Array ( => 5 [teamid] => 5 [1] => Detroit [teamcity] => Detroit [2] => Lions [teamname] => Lions ) [5] => Array ( => 6 [teamid] => 6 [1] => Minnesota [teamcity] => Minnesota [2] => Vikings [teamname] => Vikings ) [6] => Array ( => 7 [teamid] => 7 [1] => Green Bay [teamcity] => Green Bay [2] => Packers [teamname] => Packers ) [7] => Array ( => 8 [teamid] => 8 [1] => Chicago [teamcity] => Chicago [2] => Bears [teamname] => Bears ) [8] => Array ( => 9 [teamid] => 9 [1] => Tampa Bay [teamcity] => Tampa Bay [2] => Buccs [teamname] => Buccs ) [9] => Array ( => 10 [teamid] => 10 [1] => New Orleans [teamcity] => New Orleans [2] => Saints [teamname] => Saints ) [10] => Array ( => 11 [teamid] => 11 [1] => Carolina [teamcity] => Carolina [2] => Panthers [teamname] => Panthers ) [11] => Array ( => 12 [teamid] => 12 [1] => Atlanta [teamcity] => Atlanta [2] => Falcons [teamname] => Falcons ) [12] => Array ( => 13 [teamid] => 13 [1] => Seattle [teamcity] => Seattle [2] => Seahawks [teamname] => Seahawks ) [13] => Array ( => 14 [teamid] => 14 [1] => San Francisco [teamcity] => San Francisco [2] => 49ers [teamname] => 49ers ) [14] => Array ( => 15 [teamid] => 15 [1] => St. Louis [teamcity] => St. Louis [2] => Rams [teamname] => Rams ) [15] => Array ( => 16 [teamid] => 16 [1] => Arizona [teamcity] => Arizona [2] => Cardinals [teamname] => Cardinals ) [16] => Array ( => 17 [teamid] => 17 [1] => New York [teamcity] => New York [2] => Jets [teamname] => Jets ) [17] => Array ( => 18 [teamid] => 18 [1] => Miami [teamcity] => Miami [2] => Dolphins [teamname] => Dolphins ) [18] => Array ( => 19 [teamid] => 19 [1] => Buffalo [teamcity] => Buffalo [2] => Bills [teamname] => Bills ) [19] => Array ( => 20 [teamid] => 20 [1] => New England [teamcity] => New England [2] => Patriots [teamname] => Patriots ) [20] => Array ( => 21 [teamid] => 21 [1] => Baltimore [teamcity] => Baltimore [2] => Ravens [teamname] => Ravens ) [21] => Array ( => 22 [teamid] => 22 [1] => Cincinnati [teamcity] => Cincinnati [2] => Bengals [teamname] => Bengals ) [22] => Array ( => 23 [teamid] => 23 [1] => Pittsburgh [teamcity] => Pittsburgh [2] => Steelers [teamname] => Steelers ) [23] => Array ( => 24 [teamid] => 24 [1] => Cleveland [teamcity] => Cleveland [2] => Browns [teamname] => Browns ) [24] => Array ( => 25 [teamid] => 25 [1] => Houston [teamcity] => Houston [2] => Texans [teamname] => Texans ) [25] => Array ( => 26 [teamid] => 26 [1] => Tennessee [teamcity] => Tennessee [2] => Titans [teamname] => Titans ) [26] => Array ( => 27 [teamid] => 27 [1] => Jacksonville [teamcity] => Jacksonville [2] => Jaguars [teamname] => Jaguars ) [27] => Array ( => 28 [teamid] => 28 [1] => Indianapolis [teamcity] => Indianapolis [2] => Colts [teamname] => Colts ) [28] => Array ( => 29 [teamid] => 29 [1] => Denver [teamcity] => Denver [2] => Broncos [teamname] => Broncos ) [29] => Array ( => 30 [teamid] => 30 [1] => Kansas City [teamcity] => Kansas City [2] => Chiefs [teamname] => Chiefs ) [30] => Array ( => 31 [teamid] => 31 [1] => Oakland [teamcity] => Oakland [2] => Raiders [teamname] => Raiders ) [31] => Array ( => 32 [teamid] => 32 [1] => San Diego [teamcity] => San Diego [2] => Chargers [teamname] => Chargers ) )

$chosenteams

Array ( => Array ( => 2 [teamid] => 2 [1] => Dallas [teamcity] => Dallas [2] => Cowboys [teamname] => Cowboys ) [1] => Array ( => 3 [teamid] => 3 [1] => New York [teamcity] => New York [2] => Giants [teamname] => Giants ) )

Again, I just want to compare those two multi-dimensional arrays and end up with another array that only has the items that are in the first but NOT in the second.   So now I'm trying to do it the way below using simply "array_push" Code: [Select]
$remainingteams = array();
foreach($allteams as $teamname=> $value) {
if (in_array($teamname, $chosenteams)) {
} else {
array_push($remainingteams,$teamname);
}
}
My end result based on the way the arrays are in this example should be...

$remainingteams  (really the only difference is that the Cowboys and Giants info is gone)

Array ( => Array ( => 1 [teamid] => 1 [1] => Philadelphia [teamcity] => Philadelphia [2] => Eagles [teamname] => Eagles ) [3] => Array ( => 4 [teamid] => 4 [1] => Washington [teamcity] => Washington [2] => Redskins [teamname] => Redskins ) [4] => Array ( => 5 [teamid] => 5 [1] => Detroit [teamcity] => Detroit [2] => Lions [teamname] => Lions ) [5] => Array ( => 6 [teamid] => 6 [1] => Minnesota [teamcity] => Minnesota [2] => Vikings [teamname] => Vikings ) [6] => Array ( => 7 [teamid] => 7 [1] => Green Bay [teamcity] => Green Bay [2] => Packers [teamname] => Packers ) [7] => Array ( => 8 [teamid] => 8 [1] => Chicago [teamcity] => Chicago [2] => Bears [teamname] => Bears ) [8] => Array ( => 9 [teamid] => 9 [1] => Tampa Bay [teamcity] => Tampa Bay [2] => Buccs [teamname] => Buccs ) [9] => Array ( => 10 [teamid] => 10 [1] => New Orleans [teamcity] => New Orleans [2] => Saints [teamname] => Saints ) [10] => Array ( => 11 [teamid] => 11 [1] => Carolina [teamcity] => Carolina [2] => Panthers [teamname] => Panthers ) [11] => Array ( => 12 [teamid] => 12 [1] => Atlanta [teamcity] => Atlanta [2] => Falcons [teamname] => Falcons ) [12] => Array ( => 13 [teamid] => 13 [1] => Seattle [teamcity] => Seattle [2] => Seahawks [teamname] => Seahawks ) [13] => Array ( => 14 [teamid] => 14 [1] => San Francisco [teamcity] => San Francisco [2] => 49ers [teamname] => 49ers ) [14] => Array ( => 15 [teamid] => 15 [1] => St. Louis [teamcity] => St. Louis [2] => Rams [teamname] => Rams ) [15] => Array ( => 16 [teamid] => 16 [1] => Arizona [teamcity] => Arizona [2] => Cardinals [teamname] => Cardinals ) [16] => Array ( => 17 [teamid] => 17 [1] => New York [teamcity] => New York [2] => Jets [teamname] => Jets ) [17] => Array ( => 18 [teamid] => 18 [1] => Miami [teamcity] => Miami [2] => Dolphins [teamname] => Dolphins ) [18] => Array ( => 19 [teamid] => 19 [1] => Buffalo [teamcity] => Buffalo [2] => Bills [teamname] => Bills ) [19] => Array ( => 20 [teamid] => 20 [1] => New England [teamcity] => New England [2] => Patriots [teamname] => Patriots ) [20] => Array ( => 21 [teamid] => 21 [1] => Baltimore [teamcity] => Baltimore [2] => Ravens [teamname] => Ravens ) [21] => Array ( => 22 [teamid] => 22 [1] => Cincinnati [teamcity] => Cincinnati [2] => Bengals [teamname] => Bengals ) [22] => Array ( => 23 [teamid] => 23 [1] => Pittsburgh [teamcity] => Pittsburgh [2] => Steelers [teamname] => Steelers ) [23] => Array ( => 24 [teamid] => 24 [1] => Cleveland [teamcity] => Cleveland [2] => Browns [teamname] => Browns ) [24] => Array ( => 25 [teamid] => 25 [1] => Houston [teamcity] => Houston [2] => Texans [teamname] => Texans ) [25] => Array ( => 26 [teamid] => 26 [1] => Tennessee [teamcity] => Tennessee [2] => Titans [teamname] => Titans ) [26] => Array ( => 27 [teamid] => 27 [1] => Jacksonville [teamcity] => Jacksonville [2] => Jaguars [teamname] => Jaguars ) [27] => Array ( => 28 [teamid] => 28 [1] => Indianapolis [teamcity] => Indianapolis [2] => Colts [teamname] => Colts ) [28] => Array ( => 29 [teamid] => 29 [1] => Denver [teamcity] => Denver [2] => Broncos [teamname] => Broncos ) [29] => Array ( => 30 [teamid] => 30 [1] => Kansas City [teamcity] => Kansas City [2] => Chiefs [teamname] => Chiefs ) [30] => Array ( => 31 [teamid] => 31 [1] => Oakland [teamcity] => Oakland [2] => Raiders [teamname] => Raiders ) [31] => Array ( => 32 [teamid] => 32 [1] => San Diego [teamcity] => San Diego [2] => Chargers [teamname] => Chargers ) )

Can anyone help me figure this out?  i've been trying for hours (I know, that's pathetic )

Hi all,

I have an array $n[] and have made a DB query with fetch_array ($result[]). Now I'm trying to get the information out of the $result[] with $n[] so I made the following and it doesn't work. I checked if they're filled and they are and when I enter in the $result[] array with hardcoded info I do get what I need but I need it trough the array...
Can anyone help me out??

Thnx Ryflex
$sql = "SELECT * FROM units WHERE member_id = '$member_ID'";
$result = mysql_fetch_array(mysql_query($sql)) or die("Could not find amount of troops");
$troop_one = $result['$n[0]'];
$troop_two = $result['$n[1]'];
$troop_three         = $result['$n[2]'];
$troop_four = $result['$n[3]'];

Dear All,

How can I get information that return from this array

Array ( [0] => Array ( [id] => 5 [t_test_date] => 2021-02-11 [t_test_number] => 1 [t_uid] => 202102110001 [t_test_type] => 1 [t_status_id] => 4 [t_test_result_pcr] => 1 [t_test_result_rdt] => 0 [t_test_time] => 2021-02-11 11:39:00 [t_report_date] => [p_first_name] => tesdt [p_last_name] => tesdt [p_gender] => 0 [p_nationality] => [p_date_birth] => [p_passport_no] => [p_personal_id] => [p_issue_country] => [p_date_expiry] => [phone] => [email] => [t_price] => 0 [p_valid] => 1 [created_date] => 2021-02-11 [modified_date] => 2021-02-11 11:40:18 [t_status_type] => ຂັ້ນຕອນທີ່ 4. ອອກການຢັ້ງຢືນ [t_status_typeEng] => Stage 4. Certificate Issued [t_status] => 4. ຢັ້ງຢືນແລ້ວ [t_statusEng] => 4. Issued [test_time] => 11/02/2021 11:39 ) [1] => Array ( [id] => 7 [t_test_date] => 2021-02-11 [t_test_number] => 3 [t_uid] => 202102110003 [t_test_type] => 2 [t_status_id] => 4 [t_test_result_pcr] => 1 [t_test_result_rdt] => 1 [t_test_time] => 2021-02-11 18:38:00 [t_report_date] => [p_first_name] => Hhh [p_last_name] => Tttt [p_gender] => 0 [p_nationality] => [p_date_birth] => [p_passport_no] => [p_personal_id] => [p_issue_country] => [p_date_expiry] => [phone] => [email] => [t_price] => 0 [p_valid] => 1 [created_date] => 2021-02-11 [modified_date] => 2021-02-11 18:38:51 [t_status_type] => ຂັ້ນຕອນທີ່ 4. ອອກການຢັ້ງຢືນ [t_status_typeEng] => Stage 4. Certificate Issued [t_status] => 4. ຢັ້ງຢືນແລ້ວ [t_statusEng] => 4. Issued [test_time] => 11/02/2021 18:38 ) );

 

Hi;   I have an array of header information that i want to send before doing an echo to the page. Something like :

// Send the header information in the array below, then
echo $html;
die();

The information in the array is for example :

HTTP/1.1 200 OK
Date: Sat, 09 Aug 2014 00:01:36 GMT
Server: Apache/2.2.22 (Ubuntu)
X-Powered-By: PHP/5.4.9-4ubuntu2
X-Logged-In: False
P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"
Cache-Control: public, must-revalidate, proxy-revalidate
Expires: Sat, 09 Aug 2014 02:01:36 GMT
Connection: keep-alive, close
Pragma: public
Vary: Accept-Encoding
Content-Type: text/html; charset=utf-8

Thank you.

Hi,

I am trying to find a way that will allow me to convert information passed via POST into array so I can run foreach on the array. For example if information in $_POST[ids] is 1000, 1001, 1002, 1003 I would like to get it into an array $array = array("1000", "1001", "1002", "1003")

Thanks

Hello I post this message because I am trying to extract information from a site that has the same system of visacentral, I cannot give access to this system because is in a Intranet, but the system is more or less the same that this site:

visacentral.co.uk/ajax/ajax.visaPopup.php?passport_from=BOL&traveling_to[0]=BHS&traveling_for%5B0%5D=T&traveling_to%5B1%5D=&traveling_for%5B1%5D=&traveling_to%5B2%5D=&traveling_for%5B2%5D=&traveling_to%5B3%5D=&traveling_for%5B3%5D=&account_number=BRITTRAV&account_exists=N

The problem that I have either I use CURL or file_get_contents then they have a redirection and I cannot get the final content from http://visacentral.co.uk/requirements.php

Someone has any idea how this can be done?

Thank you very much!!

Hello,

Anyone know a way I could extract information from YouTube. If I have the URL for the video, how could I get the title, runtime, tags and so on into different strings?

    url = "http://www.youtube.com/watch?v=kMAI26FPeyM";


Thanks

Hi all,

just to get this out of the way i have now been working on html / css / php / mysql coding for about 3 weeks.

So i dont know too much, on to the problem...

I am creating a database for asset managment in and out of our shop I have setup the db and it works with no issues.
So I am currently trying to add fluff as i put it.

The guys in the shop want the web page to have a table of information on what is in the shop and when they click on the asset number in the table they want it to open a new page where you can edit the database information of that item.

I have no clue how to emplement this after reading diffrent ideas for about 4 hours today I am just stuck and confused.
any ideas or tips would be helpfull


This first block of code is my status page.
Code: [Select]

<style>

tr
{font-size:24px;}
button
{width:120px}

</style>

<body topmargin="50px">

<?php
 session_start(); 

include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);

$currenttime = getdate();

$result = mysql_query("SELECT * FROM shop_inventory WHERE In_Shop='1'");
$test = mysql_fetch_array($result);

echo "<table border='1' align='center' style='text-align:center' cellpadding='10' width='100%'>
 <tr>
 <th>Asset number</th>
 <th>Building</th>
 <th>Room number</th>
 <th>In date</th>
 </tr>";

$_SESSION['array_row'] = $test;
 
while($row = mysql_fetch_array($result))
   {
   $style = '';
   //if ($currenttime - $row['Entered_Shop_Time'] == 0 || 1)
    $style = 'style="background-color:#00FF00"';
   
echo "<tr>";
echo "<td> <button onClick=../subpages/edititems.php>" . $row['Asset'] . "</button> </td>";
echo "<td>" . $row['Building'] . "</td>";
echo "<td>" . $row['Room_Number'] . "</td>";
echo "<td $style>" . date("F j, Y", strtotime($row['Entered_Shop_Time']))  . "</td>";
echo "</tr>";
   
   }
echo "</table>";
 
mysql_close($connect);
 
?>

</body>



This second block of code is the page where i want to dump the table info into for editing.

Code: [Select]

<?php
session_start(); 

include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);
//$Asset = $_POST['Asset'];
$Session = $_SESSION['array_row'];

//$data = mysql_query("SELECT * FROM shop_inventory WHERE Asset=$session");
//$query = mysql_query($data) or die ("Cannot select database." . mysql_error());
//$Session = mysql_fetch_array($data);

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Add Items</title>
</head>

    <body>
    <div style=" padding-top:5px;">
                <h1><center>Add New Items</center></h1>
        </div>
      <form name="myForm" action="afteredititems.php" method="post">
            Asset Number: <input type="text" name="Asset" value="<?php echo $Session['Asset']?>"/><br /><br />
            Manufactu <input type="text" name="Manufacture" value="<?php echo $Session['Manufacture']?>"/><br /><br />
            Model: <input type="text" name="Model" value="<?php echo $Session['Model']?>"/><br /><br />
            Serial Number: <input type="text" name="Serial_Number" value="<?php echo $Session['Serial_Number']?>"/><br /><br />
            Building: <input type="text" name="Building" value="<?php echo $Session['Building']?>"/><br /><br />
            Room Number: <input type="text" name="Room_Number" value="<?php echo $Session['Room_Number']?>"/><br /><br />
            <input type="hidden" name="In_Shop" value="1"/>
            Type of Equipment: <select name="Type" value="<?php echo $Session['Type']?>">
                                <option value="desktop">Desktop</option>
                                <option value="laptop">Laptop</option>
                                <option value="ipad">Ipad</option>
                                <option value="ipod">Ipod</option>
                                <option value="projector">Projector</option>
                                <option value="printer">Printer</option>
                               </select><br /> <br />
            <center><input type="submit" value="Add Item"/></center>
        </form>
    </body>
</html>



And lastly I have a page that redisplays the edited information.

Code: [Select]

<?php

//$Asset = $_POST['Asset'];

//$data = mysql_query("SELECT * FROM shop_inventory WHERE Asset=$Asset");
//$query = mysql_query($data) or die ("Cannot select database." . mysql_error());
//$data2 = mysql_fetch_array($data);


include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);
$Asset = $_POST['Asset'];
$Manufacture = $_POST['Manufacture'];
$Model = $_POST['Model'];
$Sn = $_POST['Serial_Number'];  //<---- possibly fubar check sn everywhere
$Building = $_POST['Building'];
$Room_Number = $_POST['Room_Number'];
$Type = $_POST['Type'];

$data = mysql_query("UPDATE `shop_inventory` SET  Manufacture='$Manufacture', Model='$Model', Serial_Number='$Sn', Building='$Building', Room_Number='$Room_Number', Type='$Type' WHERE Asset=$Asset");
//$query = mysql_query($data) or die("could not execute query.". mysql_error());

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<!-- display changes -->
Asset: <?php echo $Asset ?><br />
Manufactu <?php echo $Manufacture ?><br />
Model: <?php echo $Model ?><br />
Serial number: <?php echo $Sn ?><br />
Building: <?php echo $Building ?><br />
Room Number: <?php echo $Room_Number ?><br />
Type: <?php echo $Type ?><br /><br />

</body>
</html>



I know there is a lot of poorly formated code and more then likely it is hard to read as I was going to do cleanup after I had all my features working.

After doing all the digging i found out about sessions and how they are used to pass data, I thought it would be a good method but I just could not figure out how to send information from the table if the table is reciving its info from an array.

any help would be appreciated thanks.

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.