PHP - Insert Into Table Associative Array

I have a associative array and I need to compare it to a normal array.

Code: [Select]
associative will have anywhere from 2-8 of these
['name']
['color']
['uid']

Code: [Select]
normal array will have anywhere from 1-8 names
['name']

What I need to do is get the name of the people that are in the associative array that are not in the normal array.

I've tried all sorts of different loops and what not and I cant seam to get anything to work in every case.

Hi again all,

Why does the foreach loop im doing, put the array values from collection, into seperate table rows rather than 1 row per whole array?



    <?php
        class registration{                    
            public $fields = array("username", "email", "password");
            public $data = array();
            public $table = "users";
            public $dateTime = "";
            public $datePos = 0;
            public $dateEntryName = "date";
            public $connection;
            
            function timeStamp(){
                return($this->dateTime = date("Y-m-d H:i:s"));
            }
            
            function insertRow($collection){      
                    //HERE
                    foreach($this->fields as $row => $value){
                        mysql_query("INSERT INTO $this->table ($value)
                        VALUES ('$collection[$row]')");
                    }
                    
                    mysql_close($this->connection->connectData);
            }
            
            function validateFields(){            

                $this->connection = new connection();
                $this->connection->connect(); 
                        
                foreach($this->fields as $key => $value){
                    array_push($this->data, $_POST[$this->fields[$key]]);
                }
                $this->dateTime = $this->timeStamp();
                array_unshift($this->data, $this->dateTime);                
                array_unshift($this->fields, $this->dateEntryName);   
                
                foreach($this->data as $value){
                    echo "$value";
                }
                
                $this->insertRow($this->data);
            }
        }
        
        $registration = new registration();
        $registration->validateFields();
    ?>




I end up with 3 rows

row 1: username
row 2: email
row 3 : password

rather than row 1:username email password.

First page adds a new job number, then the order page loaded with the job number id as a get id. Basically there is a while loop in the order page which shows products/services client can order and he chooses what he requires 'one or eight services' (8 in total) and some other variables like date of order and client name etc. Here is the order item code

The first sql statement executes fine, but in the second sql query nothing happens


$sql="insert into job_order(order_num,order_date,order_customer_id, order_remarks) values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');"; $res=mysql_query($sql);  $id=mysql_insert_id();   foreach($_POST as $key => $value) {          if(!empty($value)) {           $key.' => '.trim(strip_tags($value));            $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES ('$_GET[id]','$value','$value','$value');"; $orderres=mysql_query($order) or die(mysql_error()); } }?>$sql="insert into job_order(order_num,order_date,order_customer_id,
order_remarks)
values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');";
$res=mysql_query($sql);

$id=mysql_insert_id();


foreach($_POST as $key => $value) {


        if(!empty($value)) { 
 
         $key.' => '.trim(strip_tags($value));  
     
         $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES
('$_GET[id]','$value','$value','$value');";
$orderres=mysql_query($order) or die(mysql_error());
}
}
?>



=============

This is the formI have removed parts which are irrelevant. Please note that dateBox and companyBox are not required to be looping as they are only for first table,



echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";?><table><tr><td><h4>JOB ORDER</H4></TD><TD></TD></TR><TR><TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td></tr><tr><td>ORDER DATE</td><td><input type=text name=dateBox></td></tr> <tr><td>COMPANY NAME</td><td><?PHP$sql="select * from customers";$res=mysql_query($sql);echo "<select name=companyBox><option value=''>Please select</option>";WHILE($fetch=mysql_fetch_assoc($res)){ echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";} echo "</select>"; echo "</td></tr>"; ?>   </table> <table><tr><th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th></tr><tr><?PHP$sql="select * from products";$res=mysql_query($sql); WHILE($fetch=mysql_fetch_assoc($res)){ echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td><td><input type=text name=quantBox></td><td><input type=text name=teethBox></td>";echo "</tr>";}echo "</table>";?>echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";
?>
<table>
<tr>
<td><h4>JOB ORDER</H4></TD><TD></TD>
</TR>
<TR>
<TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td>
</tr>
<tr>
<td>ORDER DATE</td><td><input type=text name=dateBox></td>
</tr>

<tr>
<td>COMPANY NAME</td><td>
<?PHP
$sql="select * from customers";
$res=mysql_query($sql);
echo "<select name=companyBox><option value=''>Please select</option>";
WHILE($fetch=mysql_fetch_assoc($res)){

echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";}
echo "</select>";
echo "</td></tr>";
?>



</table>

<table>
<tr>
<th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th>
</tr>
<tr>
<?PHP
$sql="select * from products";
$res=mysql_query($sql);

WHILE($fetch=mysql_fetch_assoc($res)){

echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text name=quantBox></td>
<td><input type=text name=teethBox></td>";
echo "</tr>";}
echo "</table>";
?>



HERE IS THE IMAGE showing the populated services.
http://dubads.com/images/order.jpg

I WANT HELP WITH ASSOCIATIVE ARRAY THERE IS ARRAY LIKE THIS

$ARRAY= array(

'dd'=>1,
'dde'=>233,
'qww'=2231
)
i want to store this array in database which data type i should i use want to use mixed data mixed string-numeric type which data type is suitable and i want to print  indexes only but values only what should i do

Hello all!!

I need help with an associative array I've been working on. I'm not sure if I should have typed the weekday in the index because I'm supposed to use the getdate() function to pull the day of the week into the array. I'm also supposed to use string functions to pull apart the value where it's connected with the colon ":". I've tried using explode() and strtok but I don't quite understand how they work...just like the getdate()..I don't understand. Thanks for any 'nudge' in the right direction you can offer.

Code: [Select]
<?php
$title = "Associative Array";
$heading = "Daily Specials";


$specials = array(
"Sunday" =>"52in Flat Screen TV:425.00",
"Monday" =>"Amplifier:145.00",
"Tuesday" =>"HP Computer:355.00",
"Wednesday" =>"500GB External Harddrive:99.00",
"Thursday" =>"Internal Speakers:55.00",
"Friday" =>"Ergonomic Keyboard:85.00",
"Saturday" =>"Wacom Tablet:175.00",
);


echo "<html>
<head>
<title>
$title
</title>
</head>
<body>
   <h1>
  $heading
   </h1>
   <pre>\n";
//prints left and right aligned headers with 30 spaces
printf ("%-30s%30s\n", "Items", "Price"); 
printf ("%'-60s\n", "");
foreach ($specials as $key=>$value);
{
//prints the key left aligned and the value right aligned 
//formats to two decimals spaces
printf ("%-20s%20.2f\n", $key, $value);

echo "     </pre>\n"; 
$delimeter=":";
$inventory=strtok($inventory,$delimeter);
   while(is_string($inventory))
   {
if($inventory)
   {
echo "      $inventory\n";
   }
   $inventory=strtok($delimiter);
   }  
$inventory=explode($delimeter,$inventory);
foreach ($items as $item=>$price)
   {
   echo"     $item, $price\n";
   }
echo "     </pre>\n"; 
  "</body>
      </html>\n";
?>

Hi guys.

I have an associative array called $VisitorCountryID

$VisitorCountryID = filter_countries(array('Country' => $_SESSION['UserCountryName'])); 

and the function filter_countries() returns all the information relating to the visitors country from the database.

To find out what we have in the array, we do:

print_r($VisitorCountryID); 

and it gives us:

Array ( [14] => Array ( [CountryId] => 14 [Country] => Australia [FIPS104] => AS [ISO2] => AU [ISO3] => AUS [ISON] => 36 [Internet] => AU [Capital] => Canberra [Comment] => ISO includes Ashmore and Cartier Islands,Coral Sea Islands [sortOrder] => 1 ) ) 

Which is OK. Now i just want the CountryId which you can see in the array is 14 therefore I write:

 print_r($VisitorCountryID['CountryId']);

Which should give me 14 but it return blank no output.

I am surprised. What do you think is missing here.

Any response / feedback always welcomed!

Cheers!

Hello,
I am not sure if you can help me or if this is the place but...
I am running linux and php5.3.6
I am having problems that I did not experience on my Windows box and it has to do with arrays

if ($answer['correct']) {           
(which contains 1 or 0) is throwing Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
removing the quotes works but just curious why it is not working and if there is a setting i can change

Also
$answers[] = $answer[id];
is throwing  Parse error: syntax error, unexpected ']', expecting T_STRING or T_VARIABLE or T_NUM_STRING

Thank you to anyone who might be able to help.

Hello

I have been taking a look at associative arrays.
I 'sort' of get the key/value idea, but I'm not quite sure if they appropriate for use with 3 items (as opposed to the 2 key/value items.)

In the code below, I can incorporate the 'company' and 'table' values - but I'm not sure how to add the 'id' value (from the query).

I would very much appreciate some guidance here.

Thank you.

Code: [Select]
$a = array(); // 'A' table array
$b = array(); // 'B' table array
$c = array(); // 'C' table array

$query = "SELECT id, company, `table` FROM EXHIBITORS WHERE year = $year ORDER BY company ASC";
$result = mysql_query($query) or die("There was a problem with the SQL query: " . mysql_error());

if (mysql_num_rows($result) > 0) {

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

$testCol = substr($row['table'], 0, 1);

if ($testCol == 'A') { $a[$row['company']] = $row['table']; }
else if ($testCol == 'B') { $b[$row['company']] = $row['table']; }
else if ($testCol == 'C') { $c[$row['company']] = $row['table']; }
}

echo "<table>";
foreach($a as $key => $value){ echo "<tr><td>company: $key</td><td>Table: $value </td></tr>"; }
echo "</table>";

echo "<table>";
foreach($b as $key => $value){ echo "<tr><td>company: $key</td><td'>Table: $value </td></tr>"; }
echo "</table>";

echo "<table>";
foreach($c as $key => $value){ echo "<tr>"<td>company: $key</td><td>Table: $value </td></tr>"; }
echo "</table>";

}

else { echo "No Exhibitor data for the year $_POST[selectByYear]"; }

Hi guys,
I'm really struggling trying toremove duplicates from an associative array. I've tried array_unique but it doesn't work.
Can you point me in the right direction please?

I'm populating my array using the following code
Code: [Select]
foreach($category['manufacturers'] as $manufacturer) {
  list($name, $id) = explode("|", $manufacturer);
  $brands[] = array("id" => $id, "name" => $name);
}

If the array contains:

id = 1, name = brandA
id = 2, name = brandB
id = 1, name = brandA

I'd like to remove either the first or third entry.

I always struggle with associative arrays 

Hi there!

Ok I've a very simple code he

$character = array (name=>"Joe",
                    occupation=>"Programmer",
                    age=>30,
                    "Learned language "=>"Java"
);
print_r($character);

echo "<br/>";
foreach ( $character as $key=>$val ){
   print "$key = $val <br>";
}

The output is:

Code: [Select]
Array ( [name] => Joe [occupation] => Programmer [age] => 30 [Learned language ] => Java )
name = Joe
occupation = Programmer
age = 30
Learned language = Java
Now instead of returning all the other elements, I just need to display only the first element in the array that is the value 'Joe'.

I tried
$val[name];

Output I get is not what I want:

Code: [Select]
J
P

J
All responses/feedbacks is always welcomed

Thank you!

i need some help sorting my arrays. i have a class that selects data from database, and holds it inside a class to be used multiple times. rather then executing multiple queries. i know how to sort an array. but i am sorting arrays inside an array



$data = arrray(

array(

'id'=>1,

'_name'=>'Server A',

'_date_added'=>1298207645.5424,

);

array(

'id'=>2,

'_name'=>'Server B',

'_date_added'=>1298247384.4839,

);

array(

'id'=>3,

'_name'=>'Server C',

'_date_added'=>1298218493.0493,

);
);



i want to sort my array descending by key _date_added
hope you understand...

i have problem to get the sum from the associative array. i have to get sum for the 3 result that being display from the array

rsort($sub);
$a=0;
$arrlength = count($sub);
for($x = 0; $x < 3; $x++) {
  echo $sub[$x];
  

}

 

 

<HTML>

<?php

 $arr = array("sue" => "betsy", "frank" => "marge");

?>

</HTML>


This produces the following HTML page:

"betsy", "frank" => "marge");

Its like when I use the => to make my associative array, the code thinks I'm closing the php codeblock and then just prints the rest of it to the screen...

I'm scraping a housing website with html source:
Code: [Select]
         <tr><td>&nbsp;</td><td> Bedrooms       </td><td>&nbsp;</td><td >3</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Full Baths     </td><td>&nbsp;</td><td >1</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Partial Baths  </td><td>&nbsp;</td><td >1</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Interior Sq Ft </td><td>&nbsp;</td><td >1,356</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Acres          </td><td>&nbsp;</td><td >0.16</td><td>&nbsp;</td></tr>
What i'm trying to do is create an associative array with only the details I  want from the above. I've already got a function that steps through the HTML and creates an array element for each row with the contents of each <td> statement as follows:

Code: [Select]
$repl = array(" ", "(", ")");
$repl_with = array("", "", "");
foreach ($rows_feat as $id2 => $row2){
$features_raw = $scrape->fetchAllBetween('<td','</td>',$row2,true);
//$features_data[str_replace($repl,$repl_with,strtolower(trim($features_raw[1])))] = trim($features_raw[3]);
$countid=$countid+1;

}
The array produced by this would look like:

features_raw[1] = Bedrooms
features_raw[3] = 1



Basically, I want to take data like this:

Beds       1
Baths      1
Garage    Yes

and create an array on the fly:
House[beds]=1
House[baths]=1
House[garage]="yes"


The problem is that the order of Beds, Baths and Garage changes. So on some house pages the order would be Baths, Garage, Beds.. etc.

Any pointers out there?

Thanks,
Brett

This is the cart array:
$cart = array( "1" => "2", "3" => "4", "5" => "6");
var_dump($cart);
array(3) { [1]=> string(1) "2" [3]=> string(1) "4" [5]=> string(1) "6" }
This is the cart items array:
$cart_items = array();
$cart_items["id"] = $id;
$cart_items["quantity"] = $quantity;
var_dump($cart_items);
array(2) { ["id"]=> array(2) { [0]=> string(1) "1" [1]=> string(1) "1" } ["quantity"]=> array(2) { [0]=> string(1) "1" [1]=> string(1) "1" } }

I want the key to be "id" and the value to be "quantity" like it is for the cart array. How do I define my cart_items array using variables?