PHP :: ODBC: Fetch Results As Associative Array

Weird Warning: Db2_fetch_array() [function.db2-fetch-array]: Fetch Failure
I've written a class Cars that is a holder class for <code>Car</code> and it's designed to fetch Car records from out DB2 database. And it works fine until I return the $result to the calling function.

I can use my $result to print html table but only inside the getAll method.
When the $result is returned to the calling function the $result source is no more working properly as expected by me though the resource id stays the same. Code:

View Replies !

Need To Fetch The Minimal Value Of The Items In The Array And Fetch The Key
function func_select_min_id($type_id_array){
foreach ($type_id_array as $type_id)
$item_query = 'SELECT * FROM prefs'." WHERE id='".mysql_real_escape_string($type_id)."'";
$item_result = mysql_query($item_query) or die ("Error doing query for this item ");
$item_row = mysql_fetch_array($item_result);
$rewards[] = ($item_row['paid']*$item_row['paid2']);
}
}

what this function does isnt that hard, I pass it an array of possible id's, which are basically mysql field id nr's and it looks up the concerning row, fetches 2 values and multiplies the 2, then the result is stuffed in a new array . My problem is I need to fetch the minimal value of the items in the array and fetch the key (so I need to re-establish which key actually corresponds to the product of the 2 values) .

View Replies !

Function To Fetch Database Results
I have a function that is supposed to fetch all the results from my table "games". There are two database records in that table. My function is supposed to display all of the records, but it only displays one. I also use a function to display a certain template. Here is the coding for both functions and my index. Code:

View Replies !

Fetch Results For Specified Keyword From Google
just want to get the url for the first natural listing for a specified key word on google.com. not sure where to start, can any one give me some direction.

View Replies !

ODBC Query Results
Consider the following:

<?

$username = "foo";
$password = "bar";
$host = "db";

$connect = odbc_connect("$host", "$username", "$password") or die;

$query = "SELECT id, name, address, city, state, comments1, comments2
FROM data.table1, data.table2 WHERE id = ô˜'";

$result = odbc_exec($connect, $query);

while(odbc_fetch_row($result)){
$id = odbc_result($result, 1);
$name = odbc_result($result, 2);
$address = odbc_result($result, 3);
$city = odbc_result($result, 4);
$state = odbc_result($result, 5);
$zip = odbc_result($result, 6);
$comments1 = odbc_result($result, 7);
$comments2 = odbc_result($result, 8);
print("ID: $id Name: $name Address: $address City:
$city State: $state Zip: $zip Comments1:
$comments1 Comments2: $comments2 
");

}
?>

Only one record is returned from data.table1 (containing the id, name,
address, city, state, & zip). However, there are multiple records
returned from data.table2 (records from comments1 & comments2). What
is happening is that when I run this script, all of the data returned
from data.table1 is printed over & over again along with each record
returned from data.table2. How can I make it such that id, name,
address, city, state & zip are only printed once - and allow comments1
& comments2 to be printed multiple times for each occurance in the
database?

I've thought about just creating a second database query for the
records in data.table2, however I need the join I'm getting by using
the existing query.

For what it's worth, I'm connecting to a DB2 database using PHP /
Apache on Linux.

I'm confused by this.

View Replies !

ODBC Results Sorting And Adding?
I need to go through ODBC results and add Quantity for like items. Quick example:

Database Is:

ItemQntyDate
foo11-10-99
bar51-15-00
foo21-11-99

I need to somehow search through results and add matching Item Quantities together. In this example, the return I would expect is:

ItemQntyDate
bar51-15-00
foo31-10-99/1-11-99

because the foo Qnty added together became 3.

Any thoughts on how to accomplish this? Load the ODBC results into an array and somehow sort through the array? Never done that before...

View Replies !

ODBC Multiple Page Results
I am querying a database which is great, but I want to make it more efficient by displaying the results on multiple pages, prime example google, page 1 of 5 or how many is needed. Especially at times when I am retrieving over a 2000 records at a time. I have managed to find a solution for use with MySQL, but I am querying MS Access via ODBC. Now in terms of coding I am not sure if it is the same, or ODBC takes its own format, because I know it does usually.

View Replies !

Using The $value Of An Associative Array
I am using an associative array to populate one field of a form. I use the $key to obtain the numeric value I want to enter into one of my tables. I use the $value to display in nice text what the numeric key represents. I have no problem entering the $key into the table or displaying the $value on the form. My problem is in displaying the results of the processed form to the user:

My form "action" is "processform". In processform I do the INSERT query and return a message to the user. It is in the message to the user where my problem comes in. I've only captured the $key from the form. How can I capture also the $value from the form post, so that when I display to the user what he or she has chosen on the form, the nice text will display rather than the (to them) meaningless id number? Code:

View Replies !

Associative Array
I have to search a db table, and count distinct records to get some results from a survey we've done. The record needs to be echoed along with the number of times it is recorded. Each field in the table has to be searched individually, so that we can see the answers for each question separately.

I thought that I could do this with one query, maybe 'count distinct', but I couldn't get it to show both the value of the row, and the amount of times that value had been recorded.

So, I have to do 2 queries, one getting the distinct values of the field, the other counting how many times they are recorded. Here's the 2 queries: Code:

View Replies !

2 D Associative Array
This an example of what I try to achieve:

(never been in love with those :) )
<<<
$products= array( array( Code=> "AAA",
Description => $aaa,
Price => $p_a
),
array( Code=> "BBB",
Description => $bbb,
Price => $p_b
),
array( Code=> "CCC",
Description => $ccc,
Price => $p_c
)
);

// to read it
...............

View Replies !

Associative Array (1=>'a','b','c','d')
Is there any Function by which I have the associative array

(1=>'a','b','c','d') and the keys to show (1,2) i.e. and the result should be ('a','b')?

PHP Function is also Ok But If I get smarty tag then i would be grateful i.e. a function by which if I give the input

Input
---------
associative array (1=>'a','b','c','d')
(1,2)

OutPut
--------
('a','b')

View Replies !

Associative Array With ID As Key And Other Associative Array As Value?
I want to create an associative Array with a PHP variable (article ID)
as Key and another associative array as it's value.

How do I instanciate it, how can I fill it?

I want something like this:

$articleTable= array( $articleNr => array("name" => $name, "price " =>
$price ,"amount" => 0 );

( Amount will be filled later in a form.) Code:

View Replies !

Associative Array()
I've two arrays $template_vars_keys and $template vars I wanna create a third array $template_vars with associative nature containing keys from first array and values from second array.

View Replies !

Associative Array
I have an array that looks something like this:

array(
a=>123,
b=>456,
c=>789,
d=>123
);

I want to remove a key=>value, so the finished array looks like this:

array(
a=>123,
c=>789,
d=>123
);

View Replies !

Associative Array In Class
In PHP Version 4.3.6 I am trying get a value from a class member that
is an associative array...

class MyClass
{
$var row;

function MyClass()
{
$this->$row = array("A"=>"Apple", "B"=>"Bob");
echo "One: " . $this->$row["A"] . " ";
echo "Two: " . $this->row["A"] . " ";
$cache = $this->$row;
echo "Three: " . $cache ["A"] . " ";
}
}

But this is the output...

One: Array
Two:
Three: Apple

How can I get at the value of the associative array without making a
local copy first!

View Replies !

Array_push() With An Associative Array?
Is there a way to add a key/value pair to an associative array? I'm tryint to do this, but it dosn't work.

$author = array();
while ($row = mysql_fetch_array($result)){
array_push($author,$row[id],$row[name]);}

View Replies !

Largest Value In Associative Array
Does anybody know a simple way to retrieve the largest value (and that value's key name) from an associative array? Basically what I've got is a database of categorized articles. Here's what I've tried so far: Code:

View Replies !

Unset An Associative Array
I have a shopping basket that needs to allow a user to 'remove' an item from their basket. The basket is a session variable:

[php]$_SESSION['basket'][$_POST['product']}PHP]

and when echoed it looks like this: .....

View Replies !

How To Update Associative Array
I am working on my first online shop system and would like help with the following:

when a user adds items to the basket, I store the data in a session variable

$_SESSION['mybasket'][$_POST['productid']] = array('quantity' => $_POST['quantity'], 'productprice' => $_POST['productprice']);

Now, in my Basket View page, I want to allow the user to update the quantities as you would expect of each item if they choose to do so, but this is where I am stuck.

For each product item in my array I echo the product details but also a Quantity Field as such: PHP Code:

View Replies !

Cycling Through An Associative Array
The quality and quantity of help in this forum has been so great, I can't help pushing my luck with another question. I've created user defined classes in one Javascript application I developed and for C++ and Java courses I was taking. I knew how, but I didn't understand the why. My outlook was this. It's so easy to extract information from a multi-dimensional array by cycling through it, why would you use classes? How the heck would you cycle through all the objects in a class anyway?

I've been reading Beginning PHP5 and MySQL, and I started thinking about classes. This syntax came to mind.

foreach ($_POST as $key=>$value) {echo "$key = $key and $value = $value"; }

Cycling through a class to extract information--all the employees who make over $50k, for instance--is some variation on this syntax for cycling through an associative array, isn't it? By the way, adding a Thank You message to the end of a Resolved problem seems a waste of space, so let me thank you in advance for any help or insight you provide.

View Replies !

SQL Query And Associative Array
I am using a SQL query to pull data that I need for a report. I can get it to print out just fine on screen, but I can't figure out how to get the data into an associative array. I have been playing with this for the past few days and cannot get over the hump on this one.

The reason i need to get this data into an associative array is because the data represents a report I need to export into Excel via the xlsStream class.

View Replies !

Simple Associative Array
Here's my problem: I have a list of ~2,000 email addresses from subscribers in a flat file on disk. Due to the newsletter being personalized per domain, I'd like to read the entire file into a structure like this:

aol.com->[sherrij, foobar]
mindspring.net->[tom111, t23s,13223]
lycos.com->[dog,cat,tree]

where the index (key?) of the array is the domain, and it points to another array of actual user names.

my thought process is that i could use array_key_exists to search the array for an existing domain; if it exists, i'll then push it onto the array the domain points to.

View Replies !

Associative Array And Checkboxes
I've created a list of email addresses from my database and I want to add a checkbox next to each email address to be able to subscribe or unsubscribe them from a mailing list.

I've successfully created the list and checkboxes (checked if they're subscribed otherwise unchecked), but I'm stuck on how to create the correct array and process it. Code:

View Replies !

Array String Into Associative Array
On one server I have a mysql query pulling data out of a database, and then printing the results. These results are then pulled from another server Code:

View Replies !

Associative Array Question - Newbie
I am in the process of designing (before coding) my first serious PHP/MySQL application and I have a question about the best way to store information.

The application will allow users to view the voting record of different legislators. I have concluded that the most efficient way to store the data is in two tables: one that has details about each legislator (mp) and another that has the details of each piece of legislation (bill). Each legislators record will have a field that holds info in an associative array in the form (bill ID, vote result). This way, when a new piece of legislation is added to the database, one more value pair (bill ID, vote result) will be added to each legislators voting record field.

My question is two part:

Is this the most efficient way to store the data?

and

I suspect I will have to be using regular expressions to extract and format the data from the MySQL query. Are there some PHP or MySQL functions or syntax I would find useful in this process of retrieving the data? Any online tutorials? (mysql_fetch_array appears to create an array out of two fields - not really what I am looking for...) I realize this is a rather vague question, but if you have any suggestions, please let me know.

View Replies !

Make Associative Array Out Of String
I have a string that look something like this:

$string = "weight, kg|1200|width, mm|220|prize|20000";

and I would like it to an associative array and print keys and value:

weight, kg: 1200
width, mm: 220
prize: 20000

(The string above is fetched from a database)

Anyone have any bright ideas how to do it?

View Replies !

Adding Values Onto An Associative Array...
I'm trying to develop a simple class which through the interface you can add elements to an array. The method I have used to add the elements is setContentFields($name, $field_type), I have used an array counter variable to increment the array index each time. To me this seems like a workaround, and I wondered if there was a more elegant way of doing this.

The class is as follows:

View Replies !

Sorting An Associative Array Of Objects By Value?
I'm trying to sort an array of objects within an object. Included is a
dumbed down example so that we can get at the meat of the issue without
worrying about complexity or validation. Basically, Funk is an object that
has a name (string) and a value(int). FunkThis represents an object
containing a list of Funks, with each key corresponding to the name of the
Funk. I want to sort this list by val, but I get a Warning: usort():
Invalid comparison function error when I run the script. Keep in mind that
this is for PHP 4

I'm open to suggestions to getting this to work.

<?php
class Funk {
var $name;
var $val;
function Funk($name,$val) {
$this->name = $name;
$this->val = $val;
}
function getVal() {
return $this->val;
}

function getName() {
return $this->name;
}
}

class FunkThis {
var $list;
function FunkThis() {
$this->list = null;
}
function add($funk) {
$this->list[$funk->getName()] = $funk;
}

function compareFunks($a,$b) {
$aVal = $a->getVal();
$bVal = $b->getVal();
if ($aVal == $bVal) return 0;
if ($aVal $bVal) return 1;
if ($aVal < $bVal) return -1;
}

function sortByFunk() {
$list = $this->list;
$this->list = uasort($list,"compareFunks");
}

function show() {
print_r($this->list);
}
}

$a = new Funk("A",3);
$b = new Funk("B",7);
$c = new Funk("C",1);
$d = new Funk("D",9);
$e = new Funk("E",6);

$funkthat = new FunkThis();

$funkthat->add($a);
$funkthat->add($b);
$funkthat->add($c);
$funkthat->add($d);
$funkthat->add($e);
$funkthat->sortByFunk();
$funkthat->show();
?>

View Replies !

[smarty] Addressing Associative Array
Given this assoc array:

$dtl_array[0]['uom_array'][0][0]='key1'
$dtl_array[0]['uom_array'][0][1]='value1'
$dtl_array[0]['uom_array'][1][0]='key2'
$dtl_array[0]['uom_array'][1][1]='value2'
$dtl_array[1]['uom_array'][0][0]='key3'
$dtl_array[1]['uom_array'][0][1]='value3'
$dtl_array[1]['uom_array'][1][0]='key4'
$dtl_array[1]['uom_array'][1][1]='value4'

$sample->assign("dtl_array",$dtl_array);
$sample->display();

How could I create a combobox out of $dtl_array in the templates?
The following does not work:

<select name="aname">
{section name=mm start=0 loop=$dtl_array.0.uom_array step=1}
<option value="{$dtl_array.0.uom_array.mm.0}">
{$dtl_array.0.uom_array.mm.1}
{/section}
</select>

View Replies !

Values From Form Via Associative Array
I have a form which has a text field and a select box. There are many other fields also in the form . I need get the value of the text field or the select box, depending on which one has a value. Additionally it has to give the value only from the text field even if there is a selection made from the select box. I know that i can get post values from form like this: PHP Code:

View Replies !

How To Add An Element To The Middle Of An Associative Array ?
I got an array that consists of elements that are arrays also. Now I
wish I could add an element to the middle of it. Let mi give you an
example:

array (
- array(1,15,apple),
- array(2,28,banana),
- array(3,41,orange)
}

I would like to add, let's say, carrot on 2nd position:

array (
- array(1,15,apple),
- array(2,57,carrot),
- array(3,28,banana),
- array(4,41,orange)
}

Array_splice() does not work (or maybe i use it in a wrong way? - it
splits an adding element for, in that case, 3 elements). Array_push()
adds only to the end of an array. can samobody tell me how to add and
element to the middle of an associative array?

View Replies !

Sort An Associative Array Alphabetically
I am working on a product catalog where it displays a product type on a page via the type variable. The products should be displayed alphabetically by $make and $model and i couldn't find any snippets or info other than asort etc. Just curious if anyone else needed such a sort function and how they did it.

ie: product makes Maico, Madsen, Bio-logic etc and their models MA-300, Itera, AC-200. So I would have listings like Maico MA-300, Maico MA-800, Madsen Itera etc., and I need these alphabetical using make and model values. PHP Code:

View Replies !

How To Print A Multidimensional Associative Array?
I have the following associative array:

$user["john"]["mozilla"]=1;
$user["john"]["xmms"]=1;
$user["doe"]["mozilla"]=0;
$user["doe"]["office"]=1;
$user["paul"]["mozilla"]=0;
$user["paul"]["xmms"]=1;
$user["paul"]["office"]=1;

How can I print such an associative array using a loop statement like foreach?

View Replies !

Setting Values In Associative Array To 0
Ive tried almost every combination of while,foreach, key, value ,
array,0 I can some up with

Ive got an associative array that Ive been using as a counter
eg if (blah blah blah )
{$array['beans']++}
elseif (something else){$array['peas']++}
else {$array['carrots']++}

I then want to reset all the values to zero

foreach ($array as $key=>$value)
{ ??????? }
or array_walk ?

View Replies !

XML Formatted String To Associative Array
I'm working on a php socket server for my chat room, and I need to parse some very short XML messages like this:

<msg t="usr"><body a="pubMsg" u="username"><![CDATA[some message]]></body></msg>

Right now I'm using a bunch of substrings (start laughing. lol), but it's very inflexible. However somehow it works...

The problem arises when I try to store user variables (ignore the indents and line brakes, in reality, there will be non of them; we don't want to waste bandwidth)

<msg t="usr">
<body a="updVar" u="username">
<var t="s" n="varname"><![CDATA[some variable]]></var>
<var t="n" n="someNum"><![CDATA[3]]></var>
</body>
</msg>

I have no idea how to parse those stuff from a string to an associative array... What I want is an associative array that I can access those stuff similar to this way:

echo myXML['firstChild']['firstChild']['firstChild']['attributes']['t'];

and it should output "s"

View Replies !

Check For Empty Associative Array?
Is there a quick way to see if an associative array is completely empty (ie. user filled in no boxes or fields, but hit the submit button anyway.)

ie. say the array print_r is like this:

Array (
[740] => Array ( [ANSWER] => )
[741] => Array ( [ANSWER] => )
[742] => Array ( [ANSWER] => )
[743] => Array ( [ANSWER] => )
[744] => Array ( [ANSWER] => )
[745] => Array ( [ANSWER] => )
[747] => Array ( [ANSWER] => )
[749] => Array ( [ANSWER] => )
[750] => Array ( [ANSWER] => )
[751] => Array ( [ANSWER] => )
)

(the first key is a question item id number. Answers may sometimes be numeric or text strings...I just want a quick check to see that the entire array was left empty.)

array_count_values does not quite do the trick.

I just want something that will quickly return a "0" or something like that.

View Replies !

Random Element From Associative Array
I've got an associative array named $pictures.
I've got there filenames for example: "picabc.jpg"

I want to randomize this array. Hmmm...
Maybe you will see, what I mean on example:

I wanna do something like:

drawOneOfElementsIntoVariable($picture);
echo("<img src="$picture" />");

View Replies !

How To Iterativley Populate An Associative Array
I know how to do this with an indexed array, but if i'm retrieving data
from a query and would like to add it to an associative array, how
should i go about that?

View Replies !

Multidimensional Associative Array As A Template
I have created the below multidimensional associative array as a template, and have got a search function saving the resulting array number to the variable $key.

<?php
//Leave the first variable in each array empty (temporary fix in the array_search function)
// $ReferenceNumber = array( "", "ReferenceNumber",

//create minor arrays
$product1 = array('mobile', 'phone', 'nokia');
$product2 = array('mobile', 'phone', 'nokia');
$product3 = array('mobile', 'phone', 'nokia');

//put them in the main array, with names
$ProductKeywords = array('product1' => $product1, 'product2' => $product2, 'product3' => $product3);
?>

View Replies !

How Do You Push A New Key/value Element Into An Associative Array
How do you push a new key/value element into an associative array using an html form.

View Replies !

Adding Values To An Associative Array
How exactly do you go about adding values to an associatve array. I tried this and it didnt work:

for($i=0;$i<=10;$i++)
{
$array .= array("$i" => "some value");
}

View Replies !

Can't Define Values On Associative Array.
$dataÂ Â Â Â Â Â Â Â Â Â = explode("/", $HTTP_SERVER_VARS['PATH_INFO']);
$queryStringÂ Â Â = array ('id_content'Â Â Â => $data[1],
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 'alias'Â Â Â Â Â Â Â Â => $data[2],
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 'content_page' => $data[3]);

Can someone please explain to me why each key from array $queryString is not getting any values defined from $data?

View Replies !

Fetch Array
I have designed a debit-system database with a PHP frontend. The amounts need to be updated on a monthly basis. now i have 10 clients in the system. i can get all the fields and display them, but next to that, i need to insert a field where we can enter an amount per client and after all the new amounts have been filled in, i need to update the database with those amounts entered.
I know that by using html forms to enter the info, i can submit the info and do a update statement but the problem is, is that i need to dynamically add the field to update the amount according to the amount of results resturned from the database.

View Replies !

PHP Stops Processing On Multidimensional Associative Array
When using a multidimensional associative array to cross-reference data
in a second, single-dimensional array, PHP stops processing data after
a few iterations. Memory usage according to the task manager doesn't
seem to spike and CPU usage only gets as high as 11 to 13 percent. A
sample script is provided below, any help or alternative solutions are
welcome. (By the way, the script below works fine on Linux with the
same version of Apache and PHP. Possibly a PHP configuration issue?)

View Replies !

Sorting An Associative Multi-Dimensional Array
I would like to sort array below using the last array of a multi-dimensional array. PHP Code:

View Replies !

Printing Out An Associative Array - Whats Wrong?
I have this code segment:

$query = "Select * from Payments order by CustID";
..
.. /* execute the query */
..
if (ora_exec($cursor))
{
$recordset=array();
while (ora_fetch_into($cursor,$recordset,ORA_FETCHINTO_N ULLS|
ORA_FETCHINTO_ASSOC))
{
echo $recordset["CustID"]." ";
echo $recordset["Amount"]." ";
}
}

Gives me the following error
Notice: Undefined index: CustID
Notice: Undefined index: Amount

The table Payments has only CustID and Amount as attributes. is my
usage of the array offset incorrect?

View Replies !

Complex Associative Array To XML FIle And Back
We're using php 4.1 and it doesn't seem to have built in support for
this. Coming from a dotnet background this surprised me...Anyways,
thats a different topic altogether...

I'm looking for a php class that can allow me to save a complex
associative array as an xml file on our server and also be able to read
in back into a complex array when needed. (you'll find an example of
the array below). Because of the complexity if the array, I feel it
would be easier to use this method as opposed to saving to a db.

I know i could write a class to do it, but I'm trying not to reinvent
the wheel. Googleing only refers me to extentions like pear which I
dont want. And I 'm sure someone else has had to do this before.

//ARRAY EXAMPLE ...

View Replies !

POST (or GET) Associative Array To Script From Form
Actually thought I understood this but I can't seem to make it happen this morning, and I can't seem to find a clear simple reference here.

Can I pass an associative array from a form (using either POST or GET) to a .php script all at once, in one simple step?

ie. Say I have the following variable/associative array

$graphtable = Array ( [TESTPHASE] => G085 [GRADE] => 3 [0_LE_1_A] => 0 [1_LE_1_A] => 7 [2_LE_1_A] => 28 [3_LE_1_A] => 22 [4_LE_1_A] => 7 [null_LE_1_A] => 0 [PROTOCOLS] => 64 )

And I pass it as a hidden variable in the following form: ....

View Replies !

Fastest Function In ADOdb To Get Associative Array?
What is the fastest function in ADOdb to get associative array?

View Replies !

Replace [text] With Info From Associative Array
I have a block of content that includes bracketed text such as [author], [revisedon], etc.

I would like to write a PHP script that matches the [...] patterns, extracts the text between the brackets as a lookup key in an assocciative array, and replaces the matched pattern with the value retrieved from the lookup array.

View Replies !

If Fetch Array Is Empty ?
I'm doing a fetch_array and I would like to display a "no records
found" message to screen. For some reason this is not working:

here's my Postgres SQL as proof:
surveys=# select othermore from table where othermore <> ''
othermore
-----------
(0 rows)

Then I have:
$result = pg_query($conn, "select othermore from table where
othermore <> ''");
while ($row = pg_fetch_array($result)) {
if (!$result) {
echo "no records 
";
} else {
echo "$row[0] ";
}
}

Strnage ? Can someone shed some light on what UI am doing wrong ?

View Replies !

ODBC: Fetch Results As Associative Array

Will PHP fetch the results of a query using ODBC as an associative array? I know that MySQL does that, but I couldn't find it for ODBC connections.