Re: [PHP-DB] array issue
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Clare Media wrote:
Guys really in need of some assistance here.
I am reading an xml file and want to loop through the entire file and
display the information.
Unfortunately I am only showing 1 item. how can I go about showing all news
item?
I've tried array and loop however I am not versed with any of them.
Thanks in advance
eg.
-
item
titletitle 1/title
descriptionDescription 1/description
/item
item
titletitle 2/title
descriptionDescription 2/description
/item
item
titletitle 3/title
descriptionDescription 3/description
/item
-
My current code
+
function getNews()
{
$file = NEWS_FILE..xml;
if(!file_exists($file) || filemtime($file)
time() - 43200) {
$this-data =
@file_get_contents(http://feeds.mydomain.com/dailynews;);
$fp = @fopen($file, 'w');
@fwrite($fp, $this-data);
@fclose($fd);
}
else $this-data =
@file_get_contents($file);
if(strlen($this-data) = 0) return;
Count the elements in $this-data = @file_get_contents( $file );
If more then one then loop else use the code below:
ex:
if( count( $this-data = @file_get_contents( $file ) 1 ) ) {
foreach( $this-data as $key = $value ) {
// show your titles etc.
}
} else {
// get the location
$attr = explode('', $this-tag('item'));
$return['title'] = $attr[1];
$return['title'] = substr($return['title'],
6);
$return['description'] = $attr[7];
$return['description'] =
substr($return['description'], 2);
return $return;
}
function view_news()
{
$currentNews = newsfeed::getNews();
$NEWS=
'strong'.$currentNews['title'].'/strongbr'.$currentNews['description']
..'br/';
return $NEWS;
}
function tag($tag, $skip=0)
{
$start = -1;
for($i = 0; $i = $skip; $i++)
$start = strpos($this-data,
{$tag}, $start + 1);
if($start === false) return false;
$start += strlen($tag) + 1;
$end = strpos($this-data, /{$tag},
$start);
if($end === false)
$end = strpos($this-data,
'/', $start);
return trim(substr($this-data, $start, $end
- $start));
}
- --
Jason Gerfen
I practice my religion
while stepping on your
toes...
~The Ditty Bops
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFHTGMM5vk8bwKVAaIRAhAjAJ9FklveFH1PORVl0HC9nCb+klgcUACeOren
RgXSIP0bl/bt9rI6g9a/6Uk=
=y9XX
-END PGP SIGNATURE-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array
That is not a two dimensional array. Its two one dimensional arrays and yo
do it like this
while ($row = mysql_fetch_array($result))
{
$title[] =$row['title'];
$description[] =$row['description'];
}
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net php-db@lists.php.net
Subject: [PHP-DB] array
Date: Thu, 29 Mar 2007 13:29:45 -0700 (PDT)
Hi all,
I want to put result of query in a two dimensional array like this:
title[0]=x description [0]=y
title[1]=z description [1]=w
.
any idea would be appreciated
$query = SELECT * FROM photo;
$result=mysql_query($query);
while ($row = mysql_fetch_array($result))
{
$title=$row['title'];
$description=$row['description'];
}
-
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
_
Check Out Our List Of Trendy Restaurants. You'll Eat It Up!
http://local.live.com/?mkt=en-ca/?v=2cid=A6D6BDB4586E357F!378
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
Sancar Saran [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Sunday 04 March 2007 23:04, Sancar Saran wrote: Hi, I want to know is there any db server around there for store php arrays natively. Regards Sancar Thanks for responses, it seems I have to give more info about situation. In my current project, we had tons of arrays. They are very deep and unpredictable nested arrays. Currently we are using serialize/unserialize and it seems it comes with own cpu cost. Xdebug shows some serializing cost blips. Sure it was not SO BIG deal (for now of course). My db expertise covers a bit mysql and mysql does not have any array type field (enum just so simple). Wrong! Take a look at the SET datatype http://dev.mysql.com/doc/refman/4.1/en/set.html. This allows you to have an array of values in a single field, and the user can select any number of them. -- Tony Marston http://www.tonymarston.net http://www.radicore.org I just want to know is there any way to keep array data type natively in a sql field. Regards. Sancar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
Wrong! Take a look at the SET datatype http://dev.mysql.com/doc/refman/4.1/en/set.html. This allows you to have an array of values in a single field, and the user can select any number of them. Sort of, but not really: This is a really specialized keyword, and depends on binary mapping of enum-ish sets. As a results you have a maximum of 64 possible values, and only 1 dimension. Large or multdimensional arrays wouldn't work with this. -Micah -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
Sancar Saran wrote: Thanks for all those replies. It seems there was no easy solution (and or serializing was better solution) for us. Our arrays contains lots of things.. XML may not fit because content of array may broke xml structure. Before you give up, take a look at the XMLDBX PHP extension at http://www.mohawksoft.org It uses XML and works really well. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
another option might be to store xml snippets that match the array.
if you are using large numbers of arrays, perhaps a revamping of the db
structure to map the arrays to sub-tables might be in order
bastien
From: Micah Stevens [EMAIL PROTECTED]
To: Sancar Saran [EMAIL PROTECTED]
CC: php-db@lists.php.net, php-general@lists.php.net
Subject: Re: [PHP-DB] array field type
Date: Sun, 04 Mar 2007 15:04:42 -0800
Not a single field, but there's several methods of storing trees of
information, which is what an array is. Here's one:
Nested Array storage table:
ArrayID (int, autonumber)
keyname (text)
parent (int)
data (bigtext or whatever would be appropriate for the data you're storing)
For an array like this:
array('one'=1, 'two'=array('three'=3, 'four'=4))
the table would store these rows:
1, 'one', 0, 1
2, 'two', 0, 2
3, 'three', 2, 3
4, 'four', 2, 4
You can use a recursive function to restore the array, unless you require
the granular functionality this type of process would give you such as
sorting and filtering and statistics gathering.
-Micah
However, I think in the long run, you'd be better off serializing the data.
-Micah
On 03/04/2007 02:15 PM, Sancar Saran wrote:
On Sunday 04 March 2007 23:04, Sancar Saran wrote:
Hi,
I want to know is there any db server around there for store php arrays
natively.
Regards
Sancar
Thanks for responses, it seems I have to give more info about situation.
In my current project, we had tons of arrays. They are very deep and
unpredictable nested arrays.
Currently we are using serialize/unserialize and it seems it comes with
own cpu cost. Xdebug shows some serializing cost blips. Sure it was not SO
BIG deal (for now of course).
My db expertise covers a bit mysql and mysql does not have any array type
field (enum just so simple).
I just want to know is there any way to keep array data type natively in a
sql field.
Regards.
Sancar
_
Win a trip for four to a concert anywhere in the world!
http://www.mobilelivetour.ca/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
Thanks for all those replies. It seems there was no easy solution (and or serializing was better solution) for us. Our arrays contains lots of things.. XML may not fit because content of array may broke xml structure. Thanks for help. Regards Sancar. Hi, I want to know is there any db server around there for store php arrays natively. Regards Sancar Thanks for responses, it seems I have to give more info about situation. In my current project, we had tons of arrays. They are very deep and unpredictable nested arrays. Currently we are using serialize/unserialize and it seems it comes with own cpu cost. Xdebug shows some serializing cost blips. Sure it was not SO BIG deal (for now of course). My db expertise covers a bit mysql and mysql does not have any array type field (enum just so simple). I just want to know is there any way to keep array data type natively in a sql field. Regards. Sancar _ Win a trip for four to a concert anywhere in the world! http://www.mobilelivetour.ca/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
On Sunday 04 March 2007 23:04, Sancar Saran wrote: Hi, I want to know is there any db server around there for store php arrays natively. Regards Sancar Thanks for responses, it seems I have to give more info about situation. In my current project, we had tons of arrays. They are very deep and unpredictable nested arrays. Currently we are using serialize/unserialize and it seems it comes with own cpu cost. Xdebug shows some serializing cost blips. Sure it was not SO BIG deal (for now of course). My db expertise covers a bit mysql and mysql does not have any array type field (enum just so simple). I just want to know is there any way to keep array data type natively in a sql field. Regards. Sancar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array field type
Not a single field, but there's several methods of storing trees of
information, which is what an array is. Here's one:
Nested Array storage table:
ArrayID (int, autonumber)
keyname (text)
parent (int)
data (bigtext or whatever would be appropriate for the data you're storing)
For an array like this:
array('one'=1, 'two'=array('three'=3, 'four'=4))
the table would store these rows:
1, 'one', 0, 1
2, 'two', 0, 2
3, 'three', 2, 3
4, 'four', 2, 4
You can use a recursive function to restore the array, unless you
require the granular functionality this type of process would give you
such as sorting and filtering and statistics gathering.
-Micah
However, I think in the long run, you'd be better off serializing the data.
-Micah
On 03/04/2007 02:15 PM, Sancar Saran wrote:
On Sunday 04 March 2007 23:04, Sancar Saran wrote:
Hi,
I want to know is there any db server around there for store php arrays
natively.
Regards
Sancar
Thanks for responses, it seems I have to give more info about situation.
In my current project, we had tons of arrays. They are very deep and
unpredictable nested arrays.
Currently we are using serialize/unserialize and it seems it comes with own
cpu cost. Xdebug shows some serializing cost blips. Sure it was not SO BIG
deal (for now of course).
My db expertise covers a bit mysql and mysql does not have any array type
field (enum just so simple).
I just want to know is there any way to keep array data type natively in a sql
field.
Regards.
Sancar
Re: [PHP-DB] Array
Hi Ron, how do I put each word into an array (so there would be 12 components in the array) as well as remove the period and make the C in Check and the Y in You lower case This isn't a DB question, please ask questions in the appropriate list. But for reference, look up the str_replace, strtolower, and explode functions. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array
Use the strtolower function to reduce all letters to lower case. Then use the stripos() function to find where the spaces are in the string and use that position in the substr() function to parse out the individual words in the string. From there you can put the chunks into an array or a query or whatever you're going to do with them. You can also consider using the str_word_count(mystring, 1) to obtain an array containing the words in the string. Check out the function in the documentation to see how it treats different string types though - the results may not be what you need. You can also use the above strategy to find the periods in the sentences and either remove them or just exclude them from whatever it is you're going to do with the results of your parsing. Probably a few other ways to get the results you're looking for including a couple pre-built functions or classes if you Google for them. -Original Message- From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 11:21 AM To: PHP DB Subject: [PHP-DB] Array If I have the sentences Check one two three four. You did well to count to four. how do I put each word into an array (so there would be 12 components in the array) as well as remove the period and make the C in Check and the Y in You lower case Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array
Title: RE: [PHP-DB] Array This is hardly database related but nonetheless. ? $myString = Check one two three four. You did well to count to four.; $myString = str_replace(.,,$myString); $myString = strtolower($myString); $myWords = explode( , $myString); // do stuff here with your array ? How is that? ___ Shaun Riches Computer Science Student http://www.sh4un.co.uk -Original Message- From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]] Sent: Fri 29/09/2006 16:21 To: PHP DB Subject: [PHP-DB] Array If I have the sentences Check one two three four. You did well to count to four. how do I put each word into an array (so there would be 12 components in the array) as well as remove the period and make the C in Check and the Y in You lower case Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array problem...
Dunno if its relevant, but the recommended way to use sessions is to assign
stuff to a $_SESSION['varname']...I don't really see anything wrong with the
code...
Also, what arrays are causing the problems?
bastien
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Array problem...
Date: Fri, 16 Sep 2005 09:04:34 -0500
I am migrating a web app from an old server running PHP 4.2.3 to
a new server running 4.3.8. The problem I am running into at the moment
is building an array and passing it to another page. This code works
fine on the old server, but the array is not coming across to the new
page on the new server. Help...
mysql_select_db($database, $Prod);
$shell_list = getEnumOptions('accounts','shell');
$shell_tmp = select size=\1\ name=\shell[]\\n;
$shell_tmp .= optionDefault Shell/option\n;
$shell_tmp .= option-/option\n;
foreach ($shell_list as $item) {
$shell_tmp .= option$item/option\n;
}
$shell_tmp .= /select\n;
$query_groups = SELECT name FROM grps;
$groups_tmp = mysql_query($query_groups, $Prod) or die(mysql_error());
$grp_list = select size=\1\ name=\grp[]\\n;
$grp_list .= optionPrimary Group/option\n;
$grp_list .= option---/option\n;
while($item2 = mysql_fetch_row($groups_tmp)) {
$grp_list .= option$item2[0]/option\n;
}
$grp_list .= /select\n;
SNIP
?php
while (isset($_POST['system'][$cntr])) {
echo td width=\20%\div align=\center\font
class=\style3\.$_POST['system'][$cntr]./font/div/td;
echo td width=\20%\div
align=\center\.$shell_tmp./div/td;
echo td width=\20%\div
align=\center\.$grp_list./div/td;
echo td width=\20%\div align=\center\input
type=\text\ name=\other[]\ value=\\ size=\15\/div/td/tr;
$tmp = $sbcuid.-.$_POST['system'][$cntr];
$cntr++;
array_push( $accnts, $tmp );
}
?
/table
p align=centerfont class=style3strongIf the systems listed
above are correct, please
proceed. Otherwise, please hit the Back button on your browser and
review your
system selections again./strong/font/pp
align=centernbsp;/p
?php
session_register(accnts, shell, grp, other, cntr);
?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array and insert statement throws error
Where would that go?
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p )
{
$query = INSERT INTO Profiles_Industries
(ProfileID,
IndID)
VALUES ($LID, $p);
}
do you have a } for the if statement?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array and insert statement throws error
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p);
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array and insert statement throws error
Yep, I had found it shortly before.
Only it's not looping. It is taking last value only.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries
(ProfileID,IndID) VALUES
($LID, $p);
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array and insert statement throws error
where is your insert statement? I am guessing it is after your loop
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p);
/This is where your insert statement should
be**/
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array and insert statement throws error
Actually it did just loop. I need to test again.
The insert statement is the the one $query =
So it's after yes, but contained in the braces, like
you diagram below.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
where is your insert statement? I am guessing it is
after your loop
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries
(ProfileID,IndID) VALUES
($LID, $p);
/This is where your insert
statement should
be**/
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array and insert statement throws error
Hopefully these functions will explain it.
I'm starting the transaction, then provided it takes
with no errors it gets the commit
function begin()
{
mysql_query(BEGIN);
}
function commit()
{
mysql_query(COMMIT);
}
function rollback()
{
mysql_query(ROLLBACK);
}
begin();
$query = INSERT INTO...
$result = mysql_query($query);
--- Brent Baisley [EMAIL PROTECTED] wrote:
When are you actually performing the insert into the
database? The code
you posted is only changing the value of the
variable $query. You also
need to have the database function to insert into
the database.
Assuming it MySQL:
...
foreach(...) {
$query = INSERT INTO ...;
mysql_query($query);
}
On Oct 15, 2004, at 4:40 PM, Stuart Felenstein
wrote:
Yep, I had found it shortly before.
Only it's not looping. It is taking last value
only.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries
(ProfileID,IndID) VALUES
($LID, $p);
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
http://www.php.net/unsub.php
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search Advisory Services for Advanced Technology
Environments
p: 212.759.6400/800.759.0577
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array
$arr = array('key' = array('key2' = 'value', 'key3' = 'value', ...),
...);
$arr['key2'] = array('key2' = 'value', ...);
$arr['key3]['key2'] = 'value';
On Thu, 26 Aug 2004 16:11:27 -0500, Miguel Guirao [EMAIL PROTECTED] wrote:
Hi!!
I have a table with many options from when the user can select them,
after that, his/her selections will be stored in a database.
In the mean time, I want to store his/her selections in an array like
this one:
PN DescQty
|---|--|---|
|---|--|---|
|---|--|---|
How do I declare Duch an array like this??, let's call it Parts.
Miguel Guirao
Servicios Datacard
www.SIASA.com.mx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
!DSPAM:412dfd2d29942082615647!
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array
Since you provided no value's it's a little tough, but the general for would be: $parts = array( array(PN = $row1col1, Desc = $row1col2, Qty = $row1col3), array(PN = $row2col1, Desc = $row2col2, Qty = $row2col3) ); Depending on your implimentation, it maybe easier to use some sort of loop to assign things. If you wanted the array to be persistant across pages, you'd want to user instead of $parts, $_SESSION['parts']. (assuming of course you have initialized a session) I personally would skip the array stuff and just pop it in a database. -Micah On Thursday 26 August 2004 02:11 pm, 'Miguel Guirao' wrote: Hi!! I have a table with many options from when the user can select them, after that, his/her selections will be stored in a database. In the mean time, I want to store his/her selections in an array like this one: PNDescQty |---|--|---| |---|--|---| |---|--|---| How do I declare Duch an array like this??, let's call it Parts. Miguel Guirao Servicios Datacard www.SIASA.com.mx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array sorting question...
NIPP, SCOTT V (SBCSI) wrote: I am trying to populate an array from a MySQL database. I think I have the code correct to populate the array, but I need to somehow sort the array eliminating duplicate values. I think I can loop through the array doing a comparison and building a new array by discarding the value if it is a duplicate, but I was not sure if there was a more efficient way of doing this. You can ask for only unique values to be returned in the database result. Try something like this: $sql = SELECT UNIQUE username FROM table WHERE where_clause ORDER BY username; Katie Dewees Web Developer/PHP Programmer [EMAIL PROTECTED] http://www.evans-young.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array
Hi
From what I can work out you need to use a function called
in_array(value,array);
http://www.php.net/manual/en/function.in-array.php here is the php manual
link
Hope this is what you want
Brett
-Original Message-
From: peppe [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 16:07
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array
Hi
I have a variable cold $access and there are values 1,2,3,4,5
How can I check for example
If ($access =='2'){
echo go further;
}
How can I make this work
Thanx in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Email has been scanned for viruses by www.emf-systems.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array
Hi
Pete I forgot to write that $acces is a field from Db and there are values
1,2,3,4
a need to split those values to make that IF
Brettking thanx mate I think that is a solution
Brettking [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
From what I can work out you need to use a function called
in_array(value,array);
http://www.php.net/manual/en/function.in-array.php here is the php manual
link
Hope this is what you want
Brett
-Original Message-
From: peppe [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 16:07
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array
Hi
I have a variable cold $access and there are values 1,2,3,4,5
How can I check for example
If ($access =='2'){
echo go further;
}
How can I make this work
Thanx in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Email has been scanned for viruses by www.emf-systems.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array question
From: ShortStay [EMAIL PROTECTED] How do you delete a value and key from an array? I know the value. You need to know the key. unset($Array[$key]); There are various array functions that'll find the key for you if you know the value. Is it OK to post array questions to the db list? Not really... use php-general ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array issue
First, are you sure there is data in $my_array?
Add this after you set the array:
echo pre.print_r($my_array)./pre;
You'll need to loop through the array , writing each line in the file at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $value);
}
//close the file stuff here
HTH
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:31 AM
To: PHP-DB
Subject: [PHP-DB] array issue
Importance: High
hi ya'll
I am having a nightmare on this issue of mine.
I've got this array that I need to write to a file...
sample code below
while (something);
{
query data base
$r_ul=ifx_fetch_row($sideQuery4);
$type1 = array($rotation.\n);
switch ($r_ul['number'])
{
case '4';
$linea = $type1;
break;
}
$final = $linea[0];
$my_array = array();
array_push ($my_array, $final);
}
$file = 'db_dump.dat';
$fp = fopen($file, w);
fputs($fp, $my_array); --- I would like to write the complete array
into
the file
fclose($fp);
kindly assist with this issue..
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array issue
This may or may not make sense for your issue. but if you have the whole
array in memory you can serialize() it and write the string that the
function returns to the file.
$fp = fopen(yourfilename.txt, w);
$my_array_s = serialize($my_array);
if (isset($fp)) {
fwrite($fp, $my_array_s);
}
//to get it back into the same array as it was written, use
$fp_cache = fopen(yourfilename.txt, r) or die(can't open file);
$fp_readc = fread($fp_cache, filesize(yourfilename.txt);
$my_array_new = unserialize($fp_readc);
the data is exactly as it was returned from the db after you looped through
the record set.
another idea. --http://www.php.net/manual/en/function.serialize.php
hth
jeff
Aaron Wolski
[EMAIL PROTECTED]To: 'OpenSource' [EMAIL
PROTECTED], 'PHP-DB' [EMAIL PROTECTED]
z.com cc:
Subject: RE: [PHP-DB] array issue
08/17/2003 11:33
AM
First, are you sure there is data in $my_array?
Add this after you set the array:
echo pre.print_r($my_array)./pre;
You'll need to loop through the array , writing each line in the file at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $value);
}
//close the file stuff here
HTH
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:31 AM
To: PHP-DB
Subject: [PHP-DB] array issue
Importance: High
hi ya'll
I am having a nightmare on this issue of mine.
I've got this array that I need to write to a file...
sample code below
while (something);
{
query data base
$r_ul=ifx_fetch_row($sideQuery4);
$type1 = array($rotation.\n);
switch ($r_ul['number'])
{
case '4';
$linea = $type1;
break;
}
$final = $linea[0];
$my_array = array();
array_push ($my_array, $final);
}
$file = 'db_dump.dat';
$fp = fopen($file, w);
fputs($fp, $my_array); --- I would like to write the complete array
into
the file
fclose($fp);
kindly assist with this issue..
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array issue
Good point and nice find, Jeff!
I wasn't sure where he was going with the data.. was he trying to save
the actual array, intact, for say a chaching exercise or did he want to
insert the contents of that array into a file?
Could go either way I suppose :)
Aaron
P.S. Working on a Sunday too?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:48 AM
To: Aaron Wolski
Cc: 'PHP-DB'; 'OpenSource'
Subject: RE: [PHP-DB] array issue
This may or may not make sense for your issue. but if you have the
whole
array in memory you can serialize() it and write the string that the
function returns to the file.
$fp = fopen(yourfilename.txt, w);
$my_array_s = serialize($my_array);
if (isset($fp)) {
fwrite($fp, $my_array_s);
}
//to get it back into the same array as it was written, use
$fp_cache = fopen(yourfilename.txt, r) or die(can't open file);
$fp_readc = fread($fp_cache, filesize(yourfilename.txt);
$my_array_new = unserialize($fp_readc);
the data is exactly as it was returned from the db after you looped
through
the record set.
another idea. --http://www.php.net/manual/en/function.serialize.php
hth
jeff
Aaron Wolski
[EMAIL PROTECTED]To:
'OpenSource'
[EMAIL PROTECTED], 'PHP-DB' [EMAIL PROTECTED]
z.com cc:
Subject: RE: [PHP-DB]
array issue
08/17/2003 11:33
AM
First, are you sure there is data in $my_array?
Add this after you set the array:
echo pre.print_r($my_array)./pre;
You'll need to loop through the array , writing each line in the file
at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $value);
}
//close the file stuff here
HTH
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:31 AM
To: PHP-DB
Subject: [PHP-DB] array issue
Importance: High
hi ya'll
I am having a nightmare on this issue of mine.
I've got this array that I need to write to a file...
sample code below
while (something);
{
query data base
$r_ul=ifx_fetch_row($sideQuery4);
$type1 = array($rotation.\n);
switch ($r_ul['number'])
{
case '4';
$linea = $type1;
break;
}
$final = $linea[0];
$my_array = array();
array_push ($my_array, $final);
}
$file = 'db_dump.dat';
$fp = fopen($file, w);
fputs($fp, $my_array); --- I would like to write the complete array
into
the file
fclose($fp);
kindly assist with this issue..
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array issue
Hey guys thanks a lot
your method worked perfect Aaron, thanks
and that serialize() function, hummm i got to go do some reading and
testing.
thanks for enlightenment and the assistance guys.
RedHat.OpenSource.bz
- Original Message -
From: Aaron Wolski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: 'PHP-DB' [EMAIL PROTECTED]; 'OpenSource' [EMAIL PROTECTED]
Sent: Sunday, August 17, 2003 10:04 AM
Subject: RE: [PHP-DB] array issue
Good point and nice find, Jeff!
I wasn't sure where he was going with the data.. was he trying to save
the actual array, intact, for say a chaching exercise or did he want to
insert the contents of that array into a file?
Could go either way I suppose :)
Aaron
P.S. Working on a Sunday too?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:48 AM
To: Aaron Wolski
Cc: 'PHP-DB'; 'OpenSource'
Subject: RE: [PHP-DB] array issue
This may or may not make sense for your issue. but if you have the
whole
array in memory you can serialize() it and write the string that the
function returns to the file.
$fp = fopen(yourfilename.txt, w);
$my_array_s = serialize($my_array);
if (isset($fp)) {
fwrite($fp, $my_array_s);
}
//to get it back into the same array as it was written, use
$fp_cache = fopen(yourfilename.txt, r) or die(can't open file);
$fp_readc = fread($fp_cache, filesize(yourfilename.txt);
$my_array_new = unserialize($fp_readc);
the data is exactly as it was returned from the db after you looped
through
the record set.
another idea. --http://www.php.net/manual/en/function.serialize.php
hth
jeff
Aaron Wolski
[EMAIL PROTECTED]To:
'OpenSource'
[EMAIL PROTECTED], 'PHP-DB' [EMAIL PROTECTED]
z.com cc:
Subject: RE: [PHP-DB]
array issue
08/17/2003 11:33
AM
First, are you sure there is data in $my_array?
Add this after you set the array:
echo pre.print_r($my_array)./pre;
You'll need to loop through the array , writing each line in the file
at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $value);
}
//close the file stuff here
HTH
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:31 AM
To: PHP-DB
Subject: [PHP-DB] array issue
Importance: High
hi ya'll
I am having a nightmare on this issue of mine.
I've got this array that I need to write to a file...
sample code below
while (something);
{
query data base
$r_ul=ifx_fetch_row($sideQuery4);
$type1 = array($rotation.\n);
switch ($r_ul['number'])
{
case '4';
$linea = $type1;
break;
}
$final = $linea[0];
$my_array = array();
array_push ($my_array, $final);
}
$file = 'db_dump.dat';
$fp = fopen($file, w);
fputs($fp, $my_array); --- I would like to write the complete array
into
the file
fclose($fp);
kindly assist with this issue..
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array issue
Hey,
That's what we're here for :)
As for serialize? It's a great function if you need to preserve an array
in its original form.
Useful for sending back and forth between pages in the URL. Though, I'd
never use on an open URL for the general public. Maybe in an
Administration system not seen by many users.
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 12:28 PM
To: Aaron Wolski
Cc: PHP-DB; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] array issue
Importance: High
Hey guys thanks a lot
your method worked perfect Aaron, thanks
and that serialize() function, hummm i got to go do some reading and
testing.
thanks for enlightenment and the assistance guys.
RedHat.OpenSource.bz
- Original Message -
From: Aaron Wolski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: 'PHP-DB' [EMAIL PROTECTED]; 'OpenSource'
[EMAIL PROTECTED]
Sent: Sunday, August 17, 2003 10:04 AM
Subject: RE: [PHP-DB] array issue
Good point and nice find, Jeff!
I wasn't sure where he was going with the data.. was he trying to
save
the actual array, intact, for say a chaching exercise or did he want
to
insert the contents of that array into a file?
Could go either way I suppose :)
Aaron
P.S. Working on a Sunday too?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:48 AM
To: Aaron Wolski
Cc: 'PHP-DB'; 'OpenSource'
Subject: RE: [PHP-DB] array issue
This may or may not make sense for your issue. but if you have
the
whole
array in memory you can serialize() it and write the string that
the
function returns to the file.
$fp = fopen(yourfilename.txt, w);
$my_array_s = serialize($my_array);
if (isset($fp)) {
fwrite($fp, $my_array_s);
}
//to get it back into the same array as it was written, use
$fp_cache = fopen(yourfilename.txt, r) or die(can't open
file);
$fp_readc = fread($fp_cache, filesize(yourfilename.txt);
$my_array_new = unserialize($fp_readc);
the data is exactly as it was returned from the db after you
looped
through
the record set.
another idea.
--http://www.php.net/manual/en/function.serialize.php
hth
jeff
Aaron Wolski
[EMAIL PROTECTED]To:
'OpenSource'
[EMAIL PROTECTED], 'PHP-DB' [EMAIL PROTECTED]
z.com cc:
Subject: RE:
[PHP-DB]
array issue
08/17/2003 11:33
AM
First, are you sure there is data in $my_array?
Add this after you set the array:
echo pre.print_r($my_array)./pre;
You'll need to loop through the array , writing each line in the
file
at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $value);
}
//close the file stuff here
HTH
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:31 AM
To: PHP-DB
Subject: [PHP-DB] array issue
Importance: High
hi ya'll
I am having a nightmare on this issue of mine.
I've got this array that I need to write to a file...
sample code below
while (something);
{
query data base
$r_ul=ifx_fetch_row($sideQuery4);
$type1 = array($rotation.\n);
switch ($r_ul['number'])
{
case '4';
$linea = $type1;
break;
}
$final = $linea[0];
$my_array = array();
array_push ($my_array, $final);
}
$file = 'db_dump.dat';
$fp = fopen($file, w);
fputs($fp, $my_array); --- I would like to write the complete
array
into
the file
fclose($fp);
kindly assist with this issue..
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array fill/sort question
hi,
no the both sollutions won't work cause:
I can't sort within a query cause subnetaddr is a varchar (10.10.10.10)
so it will be ordere like this
10.10.10.10
100.10.10.10
60.10.10.10
and that's not good cause 60 is smaller as 100, so with the function
ip2long() i will first make an integer of it
the second array solution you gave, won't work, cause I need ALL the query
results in the array, and that's the problem I can't handle
if I would do it like you said, I can sort it, but then I have a sorted
array and for each element I have to do a query again to get the other
fields of the table, and that's not good (2500 rows)
so can please still somebody help me with this?
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: dinsdag 10 juni 2003 15:42
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] array fill/sort question
I might be overlooking something, but can't you just do this?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddr;
If you can't, you can sort the array like this.
?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets;
$results = mysql_query( $query );
while ( $iptable = mysql_fetch_array( $result ) ) {
$iptable['subnetaddr'] = ip2long( $iptable['subnetaddr'] );
}
?
You can subsequently sort the array for the desired result.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 08:55
Subject: [PHP-DB] array fill/sort question
hi,
I'm working on a ipaddres/subnet programm
now i have a talbe with a lot of information about ip-addresses
i'm having this query:
SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact,
ccn FROM subnets
the subnetaddr field looks like this : 100.20.20.1 and is ofcourse a
varchar field
BUT before displaying it on the screen i have to sort it by subnetaddr and
then show it
but i have to sort it as integer, so i use the php-function ip2long();
so you get a decimal...
so what i have to do:
do the query make a decimal field of the 'subnetaddr' put it in an array,
sort it and display it
BUT how can i put ALL of the fields in the query in an array, sort it, and
then display it?
please help me, I can't work it out :(
thanks, Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array fill/sort question
Another approach:
1. Load all results from the query in an array
2. Sort the array using a custom-defined user-defined comparison function
( usort() ). Study the example in the PHP manual.
Writing your own comparison function is easy:
- explode your IP addresses in 4 items each ( explode() )
- compare successively item by item
HTH
Ignatius
_
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: 'Becoming Digital' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 8:33 AM
Subject: RE: [PHP-DB] array fill/sort question
hi,
no the both sollutions won't work cause:
I can't sort within a query cause subnetaddr is a varchar (10.10.10.10)
so it will be ordere like this
10.10.10.10
100.10.10.10
60.10.10.10
and that's not good cause 60 is smaller as 100, so with the function
ip2long() i will first make an integer of it
the second array solution you gave, won't work, cause I need ALL the query
results in the array, and that's the problem I can't handle
if I would do it like you said, I can sort it, but then I have a sorted
array and for each element I have to do a query again to get the other
fields of the table, and that's not good (2500 rows)
so can please still somebody help me with this?
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: dinsdag 10 juni 2003 15:42
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] array fill/sort question
I might be overlooking something, but can't you just do this?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddr;
If you can't, you can sort the array like this.
?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets;
$results = mysql_query( $query );
while ( $iptable = mysql_fetch_array( $result ) ) {
$iptable['subnetaddr'] = ip2long( $iptable['subnetaddr'] );
}
?
You can subsequently sort the array for the desired result.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 08:55
Subject: [PHP-DB] array fill/sort question
hi,
I'm working on a ipaddres/subnet programm
now i have a talbe with a lot of information about ip-addresses
i'm having this query:
SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location,
contact,
ccn FROM subnets
the subnetaddr field looks like this : 100.20.20.1 and is ofcourse a
varchar field
BUT before displaying it on the screen i have to sort it by subnetaddr and
then show it
but i have to sort it as integer, so i use the php-function ip2long();
so you get a decimal...
so what i have to do:
do the query make a decimal field of the 'subnetaddr' put it in an array,
sort it and display it
BUT how can i put ALL of the fields in the query in an array, sort it, and
then display it?
please help me, I can't work it out :(
thanks, Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array fill/sort question
Snijders, Mark wrote: hi, no the both sollutions won't work cause: I can't sort within a query cause subnetaddr is a varchar (10.10.10.10) so it will be ordere like this 10.10.10.10 100.10.10.10 60.10.10.10 and that's not good cause 60 is smaller as 100, so with the function ip2long() i will first make an integer of it the second array solution you gave, won't work, cause I need ALL the query results in the array, and that's the problem I can't handle if I would do it like you said, I can sort it, but then I have a sorted array and for each element I have to do a query again to get the other fields of the table, and that's not good (2500 rows) so can please still somebody help me with this? can you change the database format ? store the address as four ints - then you can concatenate them when you need to, and sort as you wish SELECT s_id, subnet_name, concat(subnetaddr1, '.', subnetaddr2, '.', subnetaddr3, '.', subnetaddr4) as subnetaddr ,subnetmask,dnsdomain, location, contact, ccn FROM subnets ORDER BY subnetaddr1, subnetaddr2, subnetaddr3, subnetaddr4; -- Sean -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array fill/sort question
hi,
you can add the ip2long() function into your SELECT statement and have
an ORDER BY clause at the end like this...
SELECT s_id, subnet_name, ip2long('subnetaddr'), subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddrr;
hope it helps.
KD
On Tue, 10 Jun 2003, Snijders, Mark wrote:
hi,
I'm working on a ipaddres/subnet programm
now i have a talbe with a lot of information about ip-addresses
i'm having this query:
SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact,
ccn FROM subnets
the subnetaddr field looks like this : 100.20.20.1 and is ofcourse a
varchar field
BUT before displaying it on the screen i have to sort it by subnetaddr and
then show it
but i have to sort it as integer, so i use the php-function ip2long();
so you get a decimal...
so what i have to do:
do the query make a decimal field of the 'subnetaddr' put it in an array,
sort it and display it
BUT how can i put ALL of the fields in the query in an array, sort it, and
then display it?
please help me, I can't work it out :(
thanks, Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array fill/sort question
I might be overlooking something, but can't you just do this?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddr;
If you can't, you can sort the array like this.
?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets;
$results = mysql_query( $query );
while ( $iptable = mysql_fetch_array( $result ) ) {
$iptable['subnetaddr'] = ip2long( $iptable['subnetaddr'] );
}
?
You can subsequently sort the array for the desired result.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 08:55
Subject: [PHP-DB] array fill/sort question
hi,
I'm working on a ipaddres/subnet programm
now i have a talbe with a lot of information about ip-addresses
i'm having this query:
SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact,
ccn FROM subnets
the subnetaddr field looks like this : 100.20.20.1 and is ofcourse a
varchar field
BUT before displaying it on the screen i have to sort it by subnetaddr and
then show it
but i have to sort it as integer, so i use the php-function ip2long();
so you get a decimal...
so what i have to do:
do the query make a decimal field of the 'subnetaddr' put it in an array,
sort it and display it
BUT how can i put ALL of the fields in the query in an array, sort it, and
then display it?
please help me, I can't work it out :(
thanks, Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array Pointer
My database is set up in this way:
fan_roster: has player id (play_id) , week, and stats on that player for
that week. So there are 20 records for each player, because there are 20
weeks.
So what I need to do is add up all the players weekly totals. so pass_yrd1
for week1 + pass_yrd1 for week2 etc.
Then I need to put the season total for that players passing yards into my
roster table under pass_yrd. The roster table only as 1 record per player
and has season stats instead of weekly stats.
So when my loop goes through and doesn't match $i with ros_id. I need to
advance $i one but ros_id needs to stay the same until there is a match.
As you can see form this url:
http://55yardline.cflmain.com/55main/2003/fantasy/tests/update.php
it's kind of working, except where there are holes in the roster table..
for example, there is no ros_id equal to 12 so it should echo 12 no player
but it seems to skip.
Hope that makes sense.
Mike Ford [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
-Original Message-
From: Ian Fingold [mailto:[EMAIL PROTECTED]
Sent: 03 June 2003 16:58
Ok I'm trying to write this function to up date some fields
in my database
so i'm grabbing some info from a query and throwing it into
an array (with
mysql_fetch_array).
one of the values i'm puting into that array is the table id. I'm then
comparing the table id with the value of $i in my loop. Now
my problem is
when I loop through and the table id is not equal to $i I
need to add 1 to
$i but I need to move the array pointer back one.
In the code below I used prev() but i'm getting warnings
about the Passed
variable is not an array.
http://55yardline.cflmain.com/55main/2003/fantasy/tests/update.php
I'm thinking that prev() must not view an array fetch from a
database the
same or something. But what else can I use besides prev() to
rewind the
pointer by 1?
Thanks,
?php
include function.php;
connect1();
//query roster database and put results into an array.
$num1 = mysql_query(SELECT * FROM roster);
$num2 = mysql_fetch_array($num1);
//set i to zero
$i = 0;
//start loop to determine if $i matches the current roster id
do {
$i = $i + 1;
if ($num2[ros_id] == $i) {
//if a match is found, query the fan_roster database
where the play_id =
$i
//and put the results into a array
$upd = mysql_query(SELECT * FROM fan_roster WHERE play_id='$i');
$updr = mysql_fetch_array($upd);
//loop through the passing field and add them up
do {
$passing = $passing + $updr[pass_yrd1];
} while($updr = mysql_fetch_array($upd));
//Print feedback
echo Player:$i total Passing: $passing $updr[play_id]br;
//update the roster table with the total $passing where ros_id=$i
$upd1 = mysql_query(UPDATE roster SET pass_yrd='$passing' WHERE
ros_id='$i');
//reset passing for next loop
$passing = 0;
} else {
//if there isn't a match, add 1 to $i
$i = $i + 1;
//print feedback
echo $i no playerbr;
//put the array pointer back one for next loop
$num2 = prev($num2[ros_id];
(1) prev() takes an array as its argument, not an individual element, so
prev($num2) would be syntactically correct (but I doubt it's what you really
mean).
(2) anyway, this whole statement is pointless as you immediately do:
}
} while($num2 = mysql_fetch_array($num1));
Which promptly overwrites the value of $num2 you just put there!
What are you *really* trying to do?
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array Pointer
-Original Message-
From: Ian Fingold [mailto:[EMAIL PROTECTED]
Sent: 03 June 2003 16:58
Ok I'm trying to write this function to up date some fields
in my database
so i'm grabbing some info from a query and throwing it into
an array (with
mysql_fetch_array).
one of the values i'm puting into that array is the table id. I'm then
comparing the table id with the value of $i in my loop. Now
my problem is
when I loop through and the table id is not equal to $i I
need to add 1 to
$i but I need to move the array pointer back one.
In the code below I used prev() but i'm getting warnings
about the Passed
variable is not an array.
http://55yardline.cflmain.com/55main/2003/fantasy/tests/update.php
I'm thinking that prev() must not view an array fetch from a
database the
same or something. But what else can I use besides prev() to
rewind the
pointer by 1?
Thanks,
?php
include function.php;
connect1();
//query roster database and put results into an array.
$num1 = mysql_query(SELECT * FROM roster);
$num2 = mysql_fetch_array($num1);
//set i to zero
$i = 0;
//start loop to determine if $i matches the current roster id
do {
$i = $i + 1;
if ($num2[ros_id] == $i) {
//if a match is found, query the fan_roster database
where the play_id =
$i
//and put the results into a array
$upd = mysql_query(SELECT * FROM fan_roster WHERE play_id='$i');
$updr = mysql_fetch_array($upd);
//loop through the passing field and add them up
do {
$passing = $passing + $updr[pass_yrd1];
} while($updr = mysql_fetch_array($upd));
//Print feedback
echo Player:$i total Passing: $passing $updr[play_id]br;
//update the roster table with the total $passing where ros_id=$i
$upd1 = mysql_query(UPDATE roster SET pass_yrd='$passing' WHERE
ros_id='$i');
//reset passing for next loop
$passing = 0;
} else {
//if there isn't a match, add 1 to $i
$i = $i + 1;
//print feedback
echo $i no playerbr;
//put the array pointer back one for next loop
$num2 = prev($num2[ros_id];
(1) prev() takes an array as its argument, not an individual element, so prev($num2)
would be syntactically correct (but I doubt it's what you really mean).
(2) anyway, this whole statement is pointless as you immediately do:
}
} while($num2 = mysql_fetch_array($num1));
Which promptly overwrites the value of $num2 you just put there!
What are you *really* trying to do?
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array Question
CartArray['itemid'] = $itemid; note where $qty = CartArray['qty']; /note Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Boa Constructor [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 2:27 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Array Question Hello everyone. If I wanted to pass a item ID along with a quantity to an associative array called CartArray how would I pass it to the PHP script? I'll get this shopping cart working yet !! Cheers, Graeme :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array Question
RE: [PHP-DB] Array QuestionCheers Gary, and in the html would I put something like: a href=myscript.php?itemid=1qty=2buy this item/a Simple question I know! Jay, yup thats all I want to do, just assign two values into an array. Thank you, Graeme :) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Monday, June 02, 2003 8:30 PM Subject: RE: [PHP-DB] Array Question CartArray['itemid'] = $itemid; note where $qty = CartArray['qty']; /note Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Boa Constructor [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 2:27 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Array Question Hello everyone. If I wanted to pass a item ID along with a quantity to an associative array called CartArray how would I pass it to the PHP script? I'll get this shopping cart working yet !! Cheers, Graeme :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array Question
Hello everyone. If I wanted to pass a item ID along with a quantity to an associative array called CartArray how would I pass it to the PHP script? I'll get this shopping cart working yet !! If the question is how do you pass an array to another PHP page, you serialize() and urlencode() it, then pass it in the URL. On the following page you unserialize() it. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array key problem
On Wednesday 26 February 2003 00:37, Jorge Miguel Fonseca Martins wrote:
As this has nothing to do with databases you should post to the php-general
list.
$test[]=a;
$test[]=b;
foreach ($test as $key=$value)
{
if($key == something) echo $key
}
even though theres no key in the array named something the code will
print the key 0
PHP is doing automatic type conversion for you. Use:
if ($key === something { ... }
instead. See manual for details.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
If I were a grave-digger or even a hangman, there are some people I could
work for with a great deal of enjoyment.
-- Douglas Jerrold
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] array with two dimensions
There are really a few ways that you can solve this problem. I would use
and associative array to do this.
Making the array associative would work like this:
$ALL_VALUES[$year] += $value;
To retrieve the information back you would use the following loop:
While($element = each($ALL_VALUES))
{
echo $element[ key ]; //this would display the year
echo $element[ value ]; //displays the value associated with
the year
}
Hope that helps, I have tested it and it works for me
Kelly Protsko
-Original Message-
From: Lars Rasmussen [mailto:[EMAIL PROTECTED]]
Sent: February 17, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array with two dimensions
Hi all,
Got a little problem here,
I have a mysql query that looks like this
SELECT SUM(value) as value, YEAR(dileveret) as year FROM table GROUP BY
YEAR(dileveret)
It works just fine, but i need to make a array that can could do
somthing like this (know it doesent work)
$ALL_VALUES[$year] += $value;
The script is running the script up to 100 times to get all the specific
data's, i hope that you know a way that i can hold the values, and year
and later print one value for each year..
THANKS A LOT!
Regards
Lasse (newbie)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array trouble
On Friday 24 January 2003 14:18, Tyler Whitesides wrote: I have been having a lot of trouble getting an array into the MySQL table like I want it. This is supposed to take the current maintenance tasks from a table in the database on apple.php each of these is given a name $item[autoNo] where autoNo is the auto_increment id that task is associated with. This is passed to data.php where it is supposed to make a row in the maintenanceditems table, then in a loop directly below that it is supposed to run the array and place each array value into its associated column in the database. Considering all of the columns exist, I think the problem just has to do with how I am pulling the array values out and placing them into their column. Any help would be appreciated. Thanks in advance, Please post your code and DB schema. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Don't worry if you're a kleptomaniac; you can always take something for it. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array problems
on 1/22/03 12:08 AM, Michael Conway at [EMAIL PROTECTED] appended the
following bits to my mbox:
I find myself stuck in coming up with a way to cycle through this
array of db results for porting to a graphing script that I did not
write. My latest attempt to get around this problem is below. Outside
of the $graph-SetDataValues(array( ));, echoing $array[$i] produces the
desired results for three sets of two bar graphs with the corresponding
title. However, inside the $graph function, I get only the last
expected set of bar graphs and title. I originally iterated through
each anticipated result from mysql_fetch_array($result) and plugged each
of these values into an array calling the columns individually. I got
the desired graph, but, of course this is bad programming and not useful
for queries producing a greater number of rows (I simply needed to know
it worked). Any help would be appreciated.
What exactly is the Graph class expecting in terms of data? Is it supposed
to generate several graphs when you give it the data, or one graph per
specified dataset?
If it's the latter, move the $graph-DrawGraph(); call inside your while
loop.
If not, let us know what format it needs the data in and we'll help you
figure out how to get it from the database into that format.
If you can't figure out what format of data the class needs, you should let
us see the graph class source.
HTH.
Sincerely,
Paul Burney
http://paulburney.com/
?php
if ($your_php_version 4.1.2) {
upgrade_now(); // to avoid major security problems
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array Issue help please
On Monday 20 January 2003 17:50, Dave Carrera wrote: I have nearly got this working but it dose not seem to loop though or return the result I have done something wrong and I ask one of you coders that are much cleverer that I to glance over my code to see the obvious mistake / s. Can you describe in more detail how your code doesn't behave the way you expected it to behave? So do you see anything at all? What exactly does it do? Error messages? Have you checked the logs? Have you tried echo() on the important variables to see what they contain? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* The last time I saw him he was walking down Lover's Lane holding his own hand. -- Fred Allen */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array help please
$arr = array(.co.uk,.com,.net,.me.uk);
echo Top Level Domains: ;
while(list(,$tld)=each($arr)) {
echo $tld., ;
}
On Sun, 19 Jan 2003, Dave Carrera wrote:
Hi All
I am trying to create a tld lookup script for uk and main us domains.
I have success by creating multiple function hardcode the whois server
and tld but I would love to be able to make an array of tlds then step
through the array to check availability of domain.
Example
$arr = array(.co.uk,.com,.net,.me.uk);
How do I step though one at a time and give a viewable result?
I know I have to check the value of the array and assign the relevant
whois server. How do I do that?
Any help, guidance, code examples will be very much appreciated.
Thank you in advance as always
Dave Carrera
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array sorting
Just loop through the first index, then search on the second index:
while ( list( $key, $value ) = each( $my_arr ) ) {
// now $value is your ( [0] = 10 [1] = 40 [2] = 50 [3] = 80 [4] =
130 [5] = 220 [6] = 320 ) array
// sort your array by values
sort( $value ) ;
// get the last value
$last_value = array_pop( $value ) ;
// do something with this value...
}
But it seems to me there still misses a link between your two series of data
(years, values)
So try to get an array where keys are years, not numerical indexes?
HTH
Ignatius
- Original Message -
From: Martin Allan Jensen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 12, 2002 1:37 PM
Subject: [PHP-DB] array sorting
Hi everyone...
I got a bit longer now..
But i have some trouble sorting my arrays
I get this array returned.
Array ( [0] = Array ( [0] = 10 [1] = 40 [2] = 50 [3] = 80 [4] = 130
[5] = 220 [6] = 320 ) [1] = Array ( [0] = 10 [1] = 40 [2] = 50 [3] =
80 [4] = 130 [5] = 220 [6] = 320 [7] = 440 [8] = 570 ) [2] = )
I ain't good at it, but i guess this is a two dimesioned array...
The question is now, i need to get the highest values of each sub array
witch would be 320 570 in THIS CASE ??
Thanks so much!!
Martin Allan Jensen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array question
to precise:
$array = Array('name'='Maxim', 'surname'='Maletsky');
unset($array['name']);
// now array has this structure:
// Array('surname'='Maletsky')
--
Maxim Maletsky
[EMAIL PROTECTED]
Jason Wong [EMAIL PROTECTED] wrote... :
On Friday 08 November 2002 17:25, nikos wrote:
Does anybody know how to remove an item from an array?
Let's say
$array('banna', 'apple','cherry')
foreach ($array as $value) {
if ($value=='chery') DELETE $value FROM $array
...
unset().
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Kiss me, Kate, we will be married o' Sunday.
-- William Shakespeare, The Taming of the Shrew
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Array Initialization
$newInfo[$stripped] = $value;
---John Holmes...
-Original Message-
From: Rich Hutchins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 13, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Array Initialization
Please forgive me ahead of time, but I didn't want to subscribe to the
high-vol general list for a single question. Actually, I need this to
prep
data to be passed to a db, so it's kind of close.
I have a variable number of hidden fields being passed from page A
into
page
B via POST. On page B, I want to take those hidden fields and turn
them
into
an associative array. I am able to get the data out of the
$HTTP_POST_VARS
and make it look the way I want with the following code:
!-- BEGIN POST VARS --
!-- { mySelect = '40', mySelect_10 = 'Miami', mySelect_20 = 'New
England',
mySelect_30 = 'Buffalo', mySelect_40 = 'New York' } --
foreach ($HTTP_POST_VARS as $key = $value) {
if (preg_match(/mySelect_/, $key ))
{
echo(Found a match.br);
$stripped = substr_replace($key, , 0, 9);
echo(Content ID=.$stripped.br);
echo(Its text value is: .$value);
echo(brbr);
$newInfo = array($stripped = $value);
}
}
print_r($newInfo);
The resulting sample HTML data looks like this:
Found a match.
Content ID=10
Its text value is: Miami
Found a match.
Content ID=20
Its text value is: New England
Found a match.
Content ID=30
Its text value is: Buffalo
Found a match.
Content ID=40
Its text value is: New York
Array ( [40] = New York ) //here's the problem
The problem is in the $newInfo = array($strippd = $value); and it's
the
last line of the sample HTML code.
What I want to achieve is:
Array ( [10] = Miami, [20] = New England, [30] = Buffalo, [40] =
New
York ).
Any ideas how to get there?
Thanks in advance.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] array problem
On Thursday 20 June 2002 23:26, Richard Black wrote: By passing a second parameter to mysql_fetch_array, MYSQL_ASSOC This means you only get back an array with the values indexed by fieldname. Or just use mysql_fetch_assoc(). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* disks spinning backwards - toggle the hemisphere jumper. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array HELL!!!!
Try putting the hidden element statement down inside the while loop in he
second page, but change it to INPUT TYPE=\hidden\ NAME=\id[]\
VALUE=\$id\ and add
$id=$row['id'];
before it.
I will show below where it should go.
HTH
MB
jas [EMAIL PROTECTED] said:
I have made the changes you suggested which if you ask me have been the most
informative answers I have recieved thus far. I did run into a slight snag
on line 21 which is this on my confirmation page INPUT TYPE=\hidden\
NAME=\id[]\ VALUE=\$id[]\ and the parse error is as follows...
Parse error: parse error, expecting `STRING' or `NUM_STRING' or `'$'' in
/php/rem_conf_t.php3 on line 21
Wouldn't I need to adjust the value=\$id[]\ to something like
value=\.$id[].\ because we passed an array not a string? Not sure. Thanks
again. You are sincerely helping me understand this whole php bit. =)
Jas
[EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Ok, you have almost got it. I have made little remarks further down in
your
code which should just about do it for you.
jas [EMAIL PROTECTED] said:
I don't know what it is but I am having a hell of a time trying to get
some
results of a query setup into an array or variable (too much of a newbie
to
know which) that can be passed to a confirmation page before deleting
the
record from a table. I have given up working on this but for those of
you
that want to finish it here is the code and the table structure...
[Table Structure]
id int(30) DEFAULT '0' NOT NULL auto_increment,
car_type varchar(30),
car_model varchar(30),
car_year varchar(15),
car_price varchar(15),
car_vin varchar(25),
dlr_num varchar(25),
PRIMARY KEY (id)
[Page 1 - Queries DB table for records]
?php
require '../path/to/db.php';
$result = @mysql_query(SELECT * FROM cur_inv,$dbh) or die(Could not
execute query, please try again later);
echo table border=\0\ class=\table-body\ width=\100%\form
name=\rem_inv\ method=\post\ action=\rem_conf.php3\
trtd align=\center\ colspan=\3\font size=\4\BCurrent
Inventory/B/fonthr color=\33\/td/tr;
$count = -1;
$count should start at 0 and then increment at the bottom of the while
loop
while ($myrow = mysql_fetch_array($result)) {
$id = $row[id];
$row should be $myrow since that is what it is called above (or change
$myrow
above to $row)
$car_type = $row[car_type];
$car_model = $row[car_model];
$car_year = $row[car_year];
$car_price = $row[car_price];
$car_vin = $row[car_vin];
$count ++;
$count ++; should be moved to the bottom of the loop just before it is
closed
echo trtd width=\30%\BType Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_type));
mysql_result is not needed here, you have defined the variable $car_type
to
be this here as well as the rows below, so replace mysql_result($result,
$count, car_type) with just $car_type
echo /tdtdinput type=\checkbox\ name=\id[]\
value=\.$myrow[id].\remove/td/tr\n;
replace $myrow[id] with $id since it is already defined above
when id[] is passed to page 2, it will contain an array of the id numbers
that got checked
echo trtd width=\30%\BModel Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_model));
same as above, replace mysql_result($result,$count,car_model) with
$car_model
echo /td/tr\n;
echo trtd width=\30%\BYear Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_year));
same as above replace with $car_year
echo /td/tr\n;
echo trtd width=\30%\BPrice Of Car: /B/tdtd$;
printf(mysql_result($result,$count,car_price));
same as above replace with $care_price
echo /td/tr\n;
echo trtd width=\30%\BVIN Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_vin));
same as above replace with $car_vin
echo /td/trtrtd colspan=\3\hr
color=\33\/td/tr\n;
$count ++; should go here
}
echo trtdinput type=\submit\ name=\delete\
value=\delete\/td/tr/form/table;
?
[Page 2 - Takes records and confirms which ones to be deleted]
?php
print(
table border=\0\ class=\table-body\ width=\100%\
form name=\rem_inv\ method=\post\ action=\done2.php3\
send id[] array passed from previous page to the next page:
INPUT TYPE=\hidden\ NAME=\id[]\ VALUE=\$id[]\
If you are planning on deleting multiple items at a time, you won't need
the
following hidden elements at all, just make a database call at this point
using the id[] array passed to this page from the first page. The only
value
it needs for the 3rd page is the id value since that is what it uses to
determine what to delete.
Here is an example of the database call to make:
$i=0;
while ($id[$i]) {
$result = @mysql_query(SELECT * FROM cur_inv where id=$id[$i],$dbh) or
die
(Could not execute query, please try again later);
RE: [PHP-DB] Array HELL!!!!
That's not Array Hell, this is Array Hell:
$Hell = array(satan,fire,brimstone);
-Mike
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 4:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Array HELL
I don't know what it is but I am having a hell of a time trying
to get some
results of a query setup into an array or variable (too much of a
newbie to
know which) that can be passed to a confirmation page before deleting the
record from a table. I have given up working on this but for those of you
that want to finish it here is the code and the table structure...
[Table Structure]
id int(30) DEFAULT '0' NOT NULL auto_increment,
car_type varchar(30),
car_model varchar(30),
car_year varchar(15),
car_price varchar(15),
car_vin varchar(25),
dlr_num varchar(25),
PRIMARY KEY (id)
[Page 1 - Queries DB table for records]
?php
require '../path/to/db.php';
$result = @mysql_query(SELECT * FROM cur_inv,$dbh) or die(Could not
execute query, please try again later);
echo table border=\0\ class=\table-body\ width=\100%\form
name=\rem_inv\ method=\post\ action=\rem_conf.php3\
trtd align=\center\ colspan=\3\font size=\4\BCurrent
Inventory/B/fonthr color=\33\/td/tr;
$count = -1;
while ($myrow = mysql_fetch_array($result)) {
$id = $row[id];
$car_type = $row[car_type];
$car_model = $row[car_model];
$car_year = $row[car_year];
$car_price = $row[car_price];
$car_vin = $row[car_vin];
$count ++;
echo trtd width=\30%\BType Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_type));
echo /tdtdinput type=\checkbox\ name=\id[]\
value=\.$myrow[id].\remove/td/tr\n;
echo trtd width=\30%\BModel Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_model));
echo /td/tr\n;
echo trtd width=\30%\BYear Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_year));
echo /td/tr\n;
echo trtd width=\30%\BPrice Of Car: /B/tdtd$;
printf(mysql_result($result,$count,car_price));
echo /td/tr\n;
echo trtd width=\30%\BVIN Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_vin));
echo /td/trtrtd colspan=\3\hr color=\33\/td/tr\n;
}
echo trtdinput type=\submit\ name=\delete\
value=\delete\/td/tr/form/table;
?
[Page 2 - Takes records and confirms which ones to be deleted]
?php
print(
table border=\0\ class=\table-body\ width=\100%\
form name=\rem_inv\ method=\post\ action=\done2.php3\
INPUT TYPE=\hidden\ NAME=\id\ VALUE=\$id\
INPUT TYPE=\hidden\ NAME=\car_type\ VALUE=\$car_type\
INPUT TYPE=\hidden\ NAME=\car_model\ VALUE=\$car_model\
INPUT TYPE=\hidden\ NAME=\car_year\ VALUE=\$car_year\
INPUT TYPE=\hidden\ NAME=\car_price\ VALUE=\$car_price\
INPUT TYPE=\hidden\ NAME=\car_vin\ VALUE=\$car_vin\
tr
td align=\center\ colspan=\3\font size=\4\BConfirm Record
Deletion/B/fonthr color=\33\/td
/tr
tr
td width=\30%\BType Of Car: /B/td
td$car_type/td
/tr
tr
td width=\30%\BModel Of Car: /B/td
td$car_model/td
/tr
tr
td width=\30%\BYear Of Car: /B/td
td$car_year/td
/tr
tr
td width=\30%\BPrice Of Car: /B/td
td$car_price/td
/tr
tr
td width=\30%\BVIN Of Car: /B/td
td$car_vin/td
/tr
tr
td colspan=\3\hr color=\33\/td
/tr
tr
tdinput type=\submit\ name=\delete\ value=\delete\/td
/tr
/form
/table);
?
[Page 3 - Connects to DB and deletes selected records]
?php
require '../path/to/db.php';
$table_name = cur_inv;
$sql = DELETE FROM $table_name WHERE id = '$id';
echo($sql);
$result = mysql_query($sql,$dbh) or die(mysql_error());
print(body bgcolor=\ff9900\p class=\done\You have successfully
removed your items from the database.);
?
If anyone has the time to finish it or give me some pointers on what the
hell I am doing wrong please let me know, I would be very glad to
hear your
opinion and the correct way to accomplish this. (And, yes I went through
just about every tutorial I could find on how to delete records, which by
the way did nothing for putting the results of a select statement into an
array or variable for futher processing.) Have a good weekend everyone!!!
Pissed and frustrated...
Jas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array HELL!!!!
Well ok now that I know it isn't an array I am having problems with, how
exactly am I supposed to create a variable (that can be passed to another
page) from a selected set of records?
Thanks again for the politeness,
Jas
Spyproductions Support Team [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
That's not Array Hell, this is Array Hell:
$Hell = array(satan,fire,brimstone);
-Mike
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 4:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Array HELL
I don't know what it is but I am having a hell of a time trying
to get some
results of a query setup into an array or variable (too much of a
newbie to
know which) that can be passed to a confirmation page before deleting
the
record from a table. I have given up working on this but for those of
you
that want to finish it here is the code and the table structure...
[Table Structure]
id int(30) DEFAULT '0' NOT NULL auto_increment,
car_type varchar(30),
car_model varchar(30),
car_year varchar(15),
car_price varchar(15),
car_vin varchar(25),
dlr_num varchar(25),
PRIMARY KEY (id)
[Page 1 - Queries DB table for records]
?php
require '../path/to/db.php';
$result = @mysql_query(SELECT * FROM cur_inv,$dbh) or die(Could not
execute query, please try again later);
echo table border=\0\ class=\table-body\ width=\100%\form
name=\rem_inv\ method=\post\ action=\rem_conf.php3\
trtd align=\center\ colspan=\3\font size=\4\BCurrent
Inventory/B/fonthr color=\33\/td/tr;
$count = -1;
while ($myrow = mysql_fetch_array($result)) {
$id = $row[id];
$car_type = $row[car_type];
$car_model = $row[car_model];
$car_year = $row[car_year];
$car_price = $row[car_price];
$car_vin = $row[car_vin];
$count ++;
echo trtd width=\30%\BType Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_type));
echo /tdtdinput type=\checkbox\ name=\id[]\
value=\.$myrow[id].\remove/td/tr\n;
echo trtd width=\30%\BModel Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_model));
echo /td/tr\n;
echo trtd width=\30%\BYear Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_year));
echo /td/tr\n;
echo trtd width=\30%\BPrice Of Car: /B/tdtd$;
printf(mysql_result($result,$count,car_price));
echo /td/tr\n;
echo trtd width=\30%\BVIN Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_vin));
echo /td/trtrtd colspan=\3\hr
color=\33\/td/tr\n;
}
echo trtdinput type=\submit\ name=\delete\
value=\delete\/td/tr/form/table;
?
[Page 2 - Takes records and confirms which ones to be deleted]
?php
print(
table border=\0\ class=\table-body\ width=\100%\
form name=\rem_inv\ method=\post\ action=\done2.php3\
INPUT TYPE=\hidden\ NAME=\id\ VALUE=\$id\
INPUT TYPE=\hidden\ NAME=\car_type\ VALUE=\$car_type\
INPUT TYPE=\hidden\ NAME=\car_model\ VALUE=\$car_model\
INPUT TYPE=\hidden\ NAME=\car_year\ VALUE=\$car_year\
INPUT TYPE=\hidden\ NAME=\car_price\ VALUE=\$car_price\
INPUT TYPE=\hidden\ NAME=\car_vin\ VALUE=\$car_vin\
tr
td align=\center\ colspan=\3\font size=\4\BConfirm
Record
Deletion/B/fonthr color=\33\/td
/tr
tr
td width=\30%\BType Of Car: /B/td
td$car_type/td
/tr
tr
td width=\30%\BModel Of Car: /B/td
td$car_model/td
/tr
tr
td width=\30%\BYear Of Car: /B/td
td$car_year/td
/tr
tr
td width=\30%\BPrice Of Car: /B/td
td$car_price/td
/tr
tr
td width=\30%\BVIN Of Car: /B/td
td$car_vin/td
/tr
tr
td colspan=\3\hr color=\33\/td
/tr
tr
tdinput type=\submit\ name=\delete\ value=\delete\/td
/tr
/form
/table);
?
[Page 3 - Connects to DB and deletes selected records]
?php
require '../path/to/db.php';
$table_name = cur_inv;
$sql = DELETE FROM $table_name WHERE id = '$id';
echo($sql);
$result = mysql_query($sql,$dbh) or die(mysql_error());
print(body bgcolor=\ff9900\p class=\done\You have successfully
removed your items from the database.);
?
If anyone has the time to finish it or give me some pointers on what the
hell I am doing wrong please let me know, I would be very glad to
hear your
opinion and the correct way to accomplish this. (And, yes I went
through
just about every tutorial I could find on how to delete records, which
by
the way did nothing for putting the results of a select statement into
an
array or variable for futher processing.) Have a good weekend
everyone!!!
Pissed and frustrated...
Jas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Array HELL!!!!
Ok, you have almost got it. I have made little remarks further down in your
code which should just about do it for you.
jas [EMAIL PROTECTED] said:
I don't know what it is but I am having a hell of a time trying to get some
results of a query setup into an array or variable (too much of a newbie to
know which) that can be passed to a confirmation page before deleting the
record from a table. I have given up working on this but for those of you
that want to finish it here is the code and the table structure...
[Table Structure]
id int(30) DEFAULT '0' NOT NULL auto_increment,
car_type varchar(30),
car_model varchar(30),
car_year varchar(15),
car_price varchar(15),
car_vin varchar(25),
dlr_num varchar(25),
PRIMARY KEY (id)
[Page 1 - Queries DB table for records]
?php
require '../path/to/db.php';
$result = @mysql_query(SELECT * FROM cur_inv,$dbh) or die(Could not
execute query, please try again later);
echo table border=\0\ class=\table-body\ width=\100%\form
name=\rem_inv\ method=\post\ action=\rem_conf.php3\
trtd align=\center\ colspan=\3\font size=\4\BCurrent
Inventory/B/fonthr color=\33\/td/tr;
$count = -1;
$count should start at 0 and then increment at the bottom of the while loop
while ($myrow = mysql_fetch_array($result)) {
$id = $row[id];
$row should be $myrow since that is what it is called above (or change $myrow
above to $row)
$car_type = $row[car_type];
$car_model = $row[car_model];
$car_year = $row[car_year];
$car_price = $row[car_price];
$car_vin = $row[car_vin];
$count ++;
$count ++; should be moved to the bottom of the loop just before it is closed
echo trtd width=\30%\BType Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_type));
mysql_result is not needed here, you have defined the variable $car_type to
be this here as well as the rows below, so replace mysql_result($result,
$count, car_type) with just $car_type
echo /tdtdinput type=\checkbox\ name=\id[]\
value=\.$myrow[id].\remove/td/tr\n;
replace $myrow[id] with $id since it is already defined above
when id[] is passed to page 2, it will contain an array of the id numbers
that got checked
echo trtd width=\30%\BModel Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_model));
same as above, replace mysql_result($result,$count,car_model) with
$car_model
echo /td/tr\n;
echo trtd width=\30%\BYear Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_year));
same as above replace with $car_year
echo /td/tr\n;
echo trtd width=\30%\BPrice Of Car: /B/tdtd$;
printf(mysql_result($result,$count,car_price));
same as above replace with $care_price
echo /td/tr\n;
echo trtd width=\30%\BVIN Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_vin));
same as above replace with $car_vin
echo /td/trtrtd colspan=\3\hr color=\33\/td/tr\n;
$count ++; should go here
}
echo trtdinput type=\submit\ name=\delete\
value=\delete\/td/tr/form/table;
?
[Page 2 - Takes records and confirms which ones to be deleted]
?php
print(
table border=\0\ class=\table-body\ width=\100%\
form name=\rem_inv\ method=\post\ action=\done2.php3\
send id[] array passed from previous page to the next page:
INPUT TYPE=\hidden\ NAME=\id[]\ VALUE=\$id[]\
If you are planning on deleting multiple items at a time, you won't need the
following hidden elements at all, just make a database call at this point
using the id[] array passed to this page from the first page. The only value
it needs for the 3rd page is the id value since that is what it uses to
determine what to delete.
Here is an example of the database call to make:
$i=0;
while ($id[$i]) {
$result = @mysql_query(SELECT * FROM cur_inv where id=$id[$i],$dbh) or die
(Could not execute query, please try again later);
$row=mysql_fetch_array($result);
$car_type=$row['car_type'];
$car_model=$row['car_model'];
$car_year=$row['car_year'];
$car_price=$row['car_price'];
$car_vin=$row['car_vin'];
INPUT TYPE=\hidden\ NAME=\id\ VALUE=\$id\
INPUT TYPE=\hidden\ NAME=\car_type\ VALUE=\$car_type\
INPUT TYPE=\hidden\ NAME=\car_model\ VALUE=\$car_model\
INPUT TYPE=\hidden\ NAME=\car_year\ VALUE=\$car_year\
INPUT TYPE=\hidden\ NAME=\car_price\ VALUE=\$car_price\
INPUT TYPE=\hidden\ NAME=\car_vin\ VALUE=\$car_vin\
tr
td align=\center\ colspan=\3\font size=\4\BConfirm Record
Deletion/B/fonthr color=\33\/td
/tr
tr
td width=\30%\BType Of Car: /B/td
td$car_type/td
/tr
tr
td width=\30%\BModel Of Car: /B/td
td$car_model/td
/tr
tr
td width=\30%\BYear Of Car: /B/td
td$car_year/td
/tr
tr
td width=\30%\BPrice Of Car: /B/td
td$car_price/td
/tr
tr
td width=\30%\BVIN Of Car: /B/td
td$car_vin/td
/tr
$i++;
end loop here or after hr (wherever you prefer if you want hr between each
item end after hr)
?}?
tr
td colspan=\3\hr color=\33\/td
/tr
tr
tdinput type=\submit\ name=\delete\ value=\delete\/td
Re: [PHP-DB] array-problems
It looks like you need only one array, $date[begin] = $date[end].
Let's see, I think it'll work. I'll write it in your code then you try:
$i=0;
$result = mysql_query (SELECT DISTINCT date FROM linktracker WHERE name
LIKE '$PHP_AUTH_USER' ORDER BY date);
if ($row = mysql_fetch_array($result)) {
do {
$date[$i] = $row[date]);
$i++;
} while ($row = mysql_fetch_array($result));
} else {print (Sorry, no record were found.);
} file://end else $result
print(tabletrtdBegindate/tdtdEnddate/td/tr\n.
trtdform method=\post\ action=\index.php\
name=\date_select\.
input type=\hidden\ name=\action\ value=\date_select\.
select name=\date_begin\);
$i = 0;
while ($date[$i]) {
echo option value=\.$date_begin .\ . $date_begin .
/option\n;
$i++;
}
print(/select/tdtdselect name=\date_end\);
$i--;
while ($date[$i]) {
echo option value=\.$date_end .\ . $date_end .
/option\n;
$i--;
}
print(/select/td/tr\ntrtd colspan=\2\.
input type=\submit\ name=\Submit\ value=\Submit\.
/form/td/tr/table);
mysql_free_result ($result);
mysql_close();
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] array-problems
- Original Message -
From: Jim Lucas [EMAIL PROTECTED]
To: Bart Verbeek [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 12:42 PM
Subject: Re: [PHP-DB] array-problems
Try this:
BEGIN:PHP-CODE
$result = mysql_query (SELECT DISTINCT date FROM linktracker WHERE name
LIKE '$PHP_AUTH_USER' GROUP BY date ORDER BY date);
if (mysql_num_rows($result))
{
for($i=0;$icount($row);$i++)
{
$date = array(
begin = array($i = $row[date]),
end = array($i = $row[date])
);
}
} else {
print (Sorry, no record were found.);
}
function drawSelect($which)
{
global $date;
foreach($date[$which] AS $date_begin)
{
?
option value=?=$date_begin??=$date_begin?/option
?
}
}
?
table
tr
tdBegindate/td
tdEnddate/td
/tr
tr
tdform method=post action=index.php name=date_select
input type=hidden name=action value=date_select
select name=date_begin
?
drawSelect(begin);
?
/select
/td
tdselect name=date_end
?
rsort($date[end]);
drawSelect(end);
?
/select
/td
/tr
tr
td colspan=2input type=submit name=Submit
value=Submit/form/td
/tr/table
END:PHP-CODE
btw - you need to watch your closing '' you are missing a few. Plus to
get distince to work right you need to use the GROUP BY clause.
Jim
- Original Message -
From: Bart Verbeek [EMAIL PROTECTED]
To: Php-General-list [EMAIL PROTECTED]; PHP-DB mailinglist
[EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 12:23 PM
Subject: [PHP-DB] array-problems
Hello,
Can anyone help me with this script I'm using?
I've saved dates in a database and want to make two select-lists of
these
dates in a html-form.
I want to select each unique date one time (no doubles).
List 1 is used to set the begin-date of the query for the report, List 2
will
set the end-date and must be reversed.
When the form is processed the data selected between the begin-date and
the
end-date has to be show.
I can't seem to get my code to work: the select-lists stay empty after
processing the code below.
Can anyone help? Tips...
regards,
Bart
BEGIN:PHP-CODE
$i=0;
$result = mysql_query (SELECT DISTINCT date FROM linktracker WHERE
name
LIKE '$PHP_AUTH_USER' ORDER BY date);
if ($row = mysql_fetch_array($result)) {
do {
$date = array(
begin = array($i = $row[date]),
end = array($i = $row[date])
);
$i++;
} while ($row = mysql_fetch_array($result));
} else {print (Sorry, no record were found.);
} //end else $result
print(tabletrtdBegindate/tdtdEnddate/td/tr\n.
trtdform method=\post\ action=\index.php\
name=\date_select\.
input type=\hidden\ name=\action\
value=\date_select\.
select name=\date_begin\);
while (list($key, $date_begin) = each($date[begin])) {
echo option value=\.$date_begin .\ . $date_begin .
/option\n;
}
print(/select/tdtdselect name=\date_end\);
rsort($date[end]);
while (list($key, $date_end) = each($date[end])) {
echo option value=\.$date_end .\ . $date_end .
/option\n;
}
print(/select/td/tr\ntrtd colspan=\2\.
input type=\submit\ name=\Submit\
value=\Submit\.
/form/td/tr/table);
mysql_free_result ($result);
mysql_close();
END:PHP-CODE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] array from html form
For one, why are you redefining the array 3 times in that script? ...
I'm trying to follow here... and its not making sense.
-Original Message-
From: Larry Linthicum [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:14 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array from html form
Hi
I'm just a PHP hobbiest trying to build a points calculating system
for another hobby, please bear with me.
I need to build a multidimensional array from a html form,
the array would look like:
$needed_data = array (
array (id = $member_id,
points = $position ),
array ( id = $member_id,
points =$position),
array (id=$member_id,
points = $position);
$member_id will be used to dynamically build the html form, $position
will be an integer entered into a text field in that form similar to
this:
Fred($member_id=?) .. [ enter position=? ]
John)$member_id=?) ..[enter position=?]
etc
etc
[SUBMIT]
IF ( I can get the data into an array like above) {
I can make the rest of the script work }
but that is a big if G ... how can I stucture the form and get
that multidimen array from the single name/value pairs passed from an
html form?
OR
Maybe I can make a normal array work?
I know that enclosing form field names in [] makes them available as an
array
if the form were dynamically built like
PERSONS NAME (from database via $member_id )
input type = hidden name = [data] value = $member_id input type =
text name = [data] next PERSONS NAME (from database via $member_id )
input type = hidden name = [data] value = $member_id input type =
text name = [data] next PERSONS NAME (from database via $member_id )
input type = hidden name = [data] value = $member_id input type =
text name = [data] etc etc
I think I would then send an array containing all the $member_id (s)
and all the entries into the txt fields
first... am I correct in that?
second ... is the indexing order known and guaranteed? in other words
is
$data[0] and $data[1] OR $data[12] and $data[13]
ALWAYS going to represent a matched pair? ( from one line of the
form } or is the indexing of the array subject to variation and may NOT
be in the same order as the [data] fields in the html ?
What if nothing is entered into the txt field?I know that enclosing form
field names in [] makes them available as an array
if the form were dynamically built like
PERSONS NAME (from database via $member_id )
input type = hidden name = [data] value = $member_id input type =
text name = [data] next PERSONS NAME (from database via $member_id )
input type = hidden name = [data] value = $member_id input type =
text name = [data] next PERSONS NAME (from database via $member_id )
input type = hidden name = [data] value = $member_id input type =
text name = [data] etc etc
I think I would then send an array containing all the $member_id (s)
and all the entries into the txt fields
first... am I correct in that?
second ... is the indexing order known and guaranteed? in other words
is
$data[0] and $data[1] OR $data[12] and $data[13]
ALWAYS going to represent a matched pair? ( from one line of the
form } or is the indexing of the array subject to variation and may NOT
be in the same order as the [data] fields in the html ?
What if nothing is entered into the txt field?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] array from html form
the subarrays contain variable data and I tried to express that by showing
the array structure that way
if I access $needed_data[0]
it would be an array of two pieces of data ( both variable)
$needed_data[1] would also be an array of two variable pieces of data, etc
if I loop through them all I can use each member_id / positionpair to
update a database
but I have no way to know how many such pairs there will be, and the actual
values of $member_id
and of $position will be different in each case
I hope that helps, sorry I'm not more skilled at expressing this
For one, why are you redefining the array 3 times in that script? ...
I'm trying to follow here... and its not making sense.
I need to build a multidimensional array from a html form,
the array would look like:
$needed_data = array (
array (id = $member_id,
points = $position ),
array ( id = $member_id,
points =$position),
array (id=$member_id,
points = $position);
$member_id will be used to dynamically build the html form, $position
will be an integer entered into a text field in that form similar to
this:
Fred($member_id=?) .. [ enter position=? ]
John)$member_id=?) ..[enter position=?]
etc
etc
[SUBMIT]
IF ( I can get the data into an array like above) {
I can make the rest of the script work }
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] array in db field - actual array
Hi,
I think you can use the eval() function to execute the stored info. The code
will look something like this
$res=mysql_query(...)
eval($row_from_query);
If you want to change the name of the array you could use
eval(str_replace($array,$newarray,$row_from_query));
HTH
Dobromir Velev
-Original Message-
From: brendan [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, September 13, 2001 2:20 PM
Subject: [PHP-DB] array in db field - actual array
hi,
i am currently scouring the web for a solution to this but thought i
would try here as well ..
i have a text field in a mysql database
the textfield contains an array written out as
//
$array[0][1]=one;
$array[0][2]=two;
$array[0][3]=thre;
$array[1][1]=four;
$array[2][1]=five;
//
now i need to extract this from the db .. simple
and use it as an array for a function .. not as simple as i thought it
would be
ie
$newarray =mysqlquery('etc','etc','etc')
and $newarray should be
$newarray[0][1]=one;
$newarray[0][2]=two;
$newarray[0][3]=thre;
$newarray[1][1]=four;
$newarray[2][1]=five;
elp?
cheers
brendan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re:[PHP-DB] array in db field - actual array
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the textfield is parsed passed back affect the array?
cheers!
brendan
Dobromir Velev wrote:
Hi,
I think you can use the eval() function to execute the stored info. The code
will look something like this
$res=mysql_query(...)
eval($row_from_query);
If you want to change the name of the array you could use
eval(str_replace($array,$newarray,$row_from_query));
HTH
Dobromir Velev
-Original Message-
From: brendan [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, September 13, 2001 2:20 PM
Subject: [PHP-DB] array in db field - actual array
hi,
i am currently scouring the web for a solution to this but thought i
would try here as well ..
i have a text field in a mysql database
the textfield contains an array written out as
//
$array[0][1]=one;
$array[0][2]=two;
$array[0][3]=thre;
$array[1][1]=four;
$array[2][1]=five;
//
now i need to extract this from the db .. simple
and use it as an array for a function .. not as simple as i thought it
would be
ie
$newarray =mysqlquery('etc','etc','etc')
and $newarray should be
$newarray[0][1]=one;
$newarray[0][2]=two;
$newarray[0][3]=thre;
$newarray[1][1]=four;
$newarray[2][1]=five;
elp?
cheers
brendan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] array in db field - actual array
scratch that, i had a syntax error in the array..
you were completely right dobromir eval() works perfectly..
thanks!
Brendan wrote:
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the textfield is parsed passed back affect the array?
cheers!
brendan
Dobromir Velev wrote:
Hi,
I think you can use the eval() function to execute the stored info.
The code
will look something like this
$res=mysql_query(...)
eval($row_from_query);
If you want to change the name of the array you could use
eval(str_replace($array,$newarray,$row_from_query));
HTH
Dobromir Velev
-Original Message-
From: brendan [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, September 13, 2001 2:20 PM
Subject: [PHP-DB] array in db field - actual array
hi,
i am currently scouring the web for a solution to this but thought i
would try here as well ..
i have a text field in a mysql database
the textfield contains an array written out as
//
$array[0][1]=one;
$array[0][2]=two;
$array[0][3]=thre;
$array[1][1]=four;
$array[2][1]=five;
//
now i need to extract this from the db .. simple
and use it as an array for a function .. not as simple as i thought it
would be
ie
$newarray =mysqlquery('etc','etc','etc')
and $newarray should be
$newarray[0][1]=one;
$newarray[0][2]=two;
$newarray[0][3]=thre;
$newarray[1][1]=four;
$newarray[2][1]=five;
elp?
cheers
brendan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] array awry
In article 061201c0a063$08eab5a0$[EMAIL PROTECTED],
[EMAIL PROTECTED] ("Keith Spiller") wrote:
This associative array embedded within a function and declared as a global at
the start of the function, is meant to be a multidimensional array, but with
every loop of the while ($myrow = mysql fetch row($result)) statement, it's
previous values are replaced by the new ones. Any ideas on how I can fix
this?
If ($Selection == "3")
{
$tabledata[catid]= $myrow[0];
$tabledata[category] = "$myrow[1]";
$tabledata[under]= $myrow[2];
$tabledata[corder] = $myrow[3];
$tabledata[active] = $myrow[4];
}
So what you're saying is that want indexes 'catid', 'category', etc. to
have a distinct value for each row pulled from the database? Then you need
to add another dimension to that array.
--
CC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] array awry
All,
Perhaps I've misunderstood.
I thought this IS a PHP list (see Rolf Hopkins below).
Secondly, this list is not only for MySQL questions and issues (see Cal
Evans below). It is for all database questions, as we've seen from uestins
concerning other databases.
Am I incorrect?
Richard L. Emery
IT Sr. Project Manager
"There is no 'trying'...
There is only 'Do' or 'Not Do' "
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:50 AM
To: Keith Spiller
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] array awry
Hi Keith,
1: Don't cross-post. It's rude. Especially since this has nothing to do with
MySQL.
2: You are not building a multi-dimensional array. The code below won't even
build a single dimensional array because you didn't put your keys in quotes
so it's probably blowing chunks. At the very least, if you had put quotes
around your key names, it would have overwritten the data each loop.
Try something like this:
If ($Selection == "3")
{
$lcvA++;
$tabledata[$lcvA] = Array();
$tabledata[$lcvA]['catid']= $myrow[0];
$tabledata[$lcvA]['category'] = "$myrow[1]";
$tabledata[$lcvA]['under']= $myrow[2];
$tabledata[$lcvA]['corder'] = $myrow[3];
$tabledata[$lcvA]['active'] = $myrow[4];
}
This is a multidimensional array. The first dimension is a counter, $lcvA.
Make sure you init it at the top of your function. Now, each time you add a
row to the array, it' in a new row IN the array.
To access the data you use:
$myCOrder = $tabledata[$rowToAccess]['corder']
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 9:10 PM
To: Keith Spiller; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: array awry
This is a PHP question and should really be asked on the PHP list.
But a suggestion. Tried using field names instead of number? ie.
$myrow["catid"];
I'd have to read up the PHP manual to find out for sure but I'm sure you can
do that just as well as I can.
-Original Message-
From: Keith Spiller [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 8:15 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] array awry
This associative array embedded within a function and declared as a global
at the start of the function, is meant to be a multidimensional array, but
with every loop of the while ($myrow = mysql_fetch_row($result)) statement,
it's previous values are replaced by the new ones. Any ideas on how I can
fix this?
If ($Selection == "3")
{
$tabledata[catid]= $myrow[0];
$tabledata[category] = "$myrow[1]";
$tabledata[under]= $myrow[2];
$tabledata[corder] = $myrow[3];
$tabledata[active] = $myrow[4];
}
Keith
aka Larentium
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
