AW: [PHP] can't pass complete URL (part of the query string) from one script to another --??
hi nicole, do you have an example what your query contains ? maybe urlencode($pageURL) or quoting will help greetings martin > -Ursprüngliche Nachricht- > Von: Nicole Lallande [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 26. November 2002 15:40 > An: [EMAIL PROTECTED] > Betreff: [PHP] can't pass complete URL (part of the query string) from > one script to another --?? > > > Gretings: > > I want to pass a URL query string to another php script. I > am able to > pass the complete query string with all the variables I want > through to > the javascript function call but then the string gets cut in the php > script: > > in the shopping cart: > this page > > where 'ref' is set correctly and $pageURL is returned as > 'http://mydomain.com/shop.php?val1=1&val2=2&val3=3' (this > shows up on my > status bar and I can 'echo' it on the shopping cart page - so > Iknow it > is getting captured correctly -- also - I removed the > javascript and saw > it get passet in the url as a 'get' correctly.) > > but in the email script I try to display 'ref' and what I get is: > > 'http://mydomain.com/shop.php?val1=1' -- everything past the > first '&' > gets cut off (ie, I lose the '&val2=2&val3=3' portion of the query > string ) > > Any ideas? Sorry if this is obvious - pulling an 'all nighter'... > > TIA, > > Nicole > > -- > > Nicole Lallande > [EMAIL PROTECTED] > 760.753.6766 > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP] special print function
hi ines, surely ther are several possibilities to solve this problem. i would do it like this: put your values in three arrays suggesting your icons represents links, put a variable after each link. with the 'switch; case' command you can evaluate the get variables, and generate the pages with the content you wish. the rest is a little javascript, that calls the system print dialog. hope that helps a little regards martin > -Ursprüngliche Nachricht- > Von: Ines [mailto:ines@;comprehend.de] > Gesendet: Dienstag, 5. November 2002 14:33 > An: [EMAIL PROTECTED] > Betreff: [PHP] special print function > > > Hello there! > > I am really new to PHP and in good old copy/paste tradition i > was looking > for a script that would serve my needs - unfortunately > without success. > Perhaps some of you could help me? > > I am looking for a special print function: > > I have three coloumns on the page. Under each there is a > printer icon. When > i press the printer icon underneath the left coloumn i only > want a print > version of that left coloumn. same goes for the middle and > right coloumn. > > Has anyone ever seen a script that can do that? > > Many thanks for your help! > > Ines > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP] Array questions...
hi leon, > > Hello, > > Assume I have the following array: > > $array = array ( > "apple" => "cherry", > "foo" => "bar", > "wom" => "bat" > ); > > How could I easy remove the key and the value of the key > "foo" from that > array? > unset ($array[foo]); > Also, what is the best (and quickest) way to add a key with a > value to the > end of this array? > $array[newkey]=newvalue; > Thanks in advance, > > Leon Mergen > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP] PHP to Excel?
hi chad, on http://www.cnovak.com/ you'll find a php-class that generates native excel-files, even with cell formatings and other more or less useful things. greetings martin > -Ursprüngliche Nachricht- > Von: Chad Day [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 18. Juni 2002 16:52 > An: [EMAIL PROTECTED] > Betreff: [PHP] PHP to Excel? > > > I'm trying to get data from my MySQL database into Excel > using PHP. I know > and I am doing it right now by generating a CSV file, but is > there any way I > can do formatting, like make certain cells bold, etc etc? Is > there a list > of codes somewhere I can use to put before my field output to > make a field > bold, stuff like that? > > Thanks, > Chad > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Strange problem with apache 2.0.39/php 4.2.1/gd-lib
hello everybody, i'm trying to use php 4.2.1 with apache 2.0.39. i compiled php as dso, with gd support (libjpeg6b, libpng-1.2.3 , gdlib-1.8.4, freetype-2.1.2) compiling and installation of the above packages went fine, but when i start apache, i get the following message from the apache error log: 'PHP Warning: Unable to load dynamic library '/usr/local/lib/php/extensions/gd.so' - /usr/local/lib/php/extensions/gd.so: undefined symbol: gdImagePngCtx in Unknown on line 0' i tried several versions of gd-lib and libpng and recompiled php, but i always got the same error message. does anybody have an idea ? thanks in advance martin Martin Lucas - ICT Manager - TechConsult GmbH European IT-Marketing Research Am Platz der Deutschen Einheit Leipziger Str. 35-37 34125 Kassel FON: +49(0)561 - 8109 172 FAX: +49(0)561 - 8109 2972 mailto:[EMAIL PROTECTED] http://www.techconsult.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP] More: Frustrating ?
hi john,
maybe this is the right way
$where="id like ".$id;
$query="select * from ccl where '".$where."' order by AU desc";
$result=mysql_query($query);
regards
martin
> -Ursprüngliche Nachricht-
> Von: jtjohnston [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 18. Februar 2002 08:00
> An: [EMAIL PROTECTED]
> Betreff: [PHP] More: Frustrating ?
>
>
> > > while ($mydata = mysql_fetch_object($news))
> > > So what am I doing wrong here:
> > > $where = "id like $id";
> > > $news = mysql_query('select * from ccl where '.$where.'
> order by AU desc');
> > //desc => z-a
>
> > A) Have you already confirmed that a valid database
> connection was made?
>
> Yes. A copy and paste of working code:
> $news = mysql_query("select * from ccl ORDER by AU asc");
> Connection was made.
>
> So I do?
>
> $news = mysql_query("select * from ccl where '.$where.' order
> by AU desc");
>
> or ?
>
> $news = mysql_query("select * from ccl where '.%$where%.'
> order by AU desc");
>
> The % are not necessary? because id is an auto_increment
> number from 0 to
> 1,000+.
>
> Why the ' inside " ?
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP] Query Help Needed
take a look at your table definiton.
maybe some of your fields have a diferent definition as the value you want
to insert. e.g.
fax_number in your query-string is defined as string and in your table as
integer or something like this
regards
martin
-Ursprüngliche Nachricht-
Von: Payzillee [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 29. November 2001 12:37
An: [EMAIL PROTECTED]
Betreff: [PHP] Query Help Needed
Hi, could anyone tell me what is wrong with this Insert query? I get an
'Invalid query' error but I can't see the problem at all. All the fields
match exactly what is in my database, it's all in lowercase too.
Cheers.
mysql_query ("INSERT INTO listserve (title, surname, forename, job_title,
org_name, address1, address2, address3, address4, city, region, postal_code,
country, email, mob_phone, tel_number, fax_number, org_web_address,
personal_web_address, special_interests, date, time)
VALUES ('$title', '$surname', '$forename', '$job_title', '$org_name',
'$address1', '$address2', '$address3', '$address4', '$city', '$region',
'$postal_code', '$country', '$email', '$mob_phone', '$tel_number',
'$fax_number', '$org_web_address', '$personal_web_address',
'$special_interests', '$date','$time')")
--
PHP General 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 General 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]
AW: [PHP] Query Help Needed
that seems to be easy:
put every string and varchar in single quotes eg '$surname'
and every number like $fax_number without quotes
regards martin
-Ursprüngliche Nachricht-
Von: Payzillee [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 29. November 2001 13:16
An: [EMAIL PROTECTED]
Betreff: Re: [PHP] Query Help Needed
error message is 'Invalid Query'.
"Douglas McKenzie" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Could be that the value you're trying to insert doesn't match up with
> the field type in the database - you know, putting a word in a number
> field. What exactly is the error message?
>
> Payzillee wrote:
>
> >Hi, could anyone tell me what is wrong with this Insert query? I get an
> >'Invalid query' error but I can't see the problem at all. All the fields
> >match exactly what is in my database, it's all in lowercase too.
> >
> >Cheers.
> >
> >mysql_query ("INSERT INTO listserve (title, surname, forename, job_title,
> >org_name, address1, address2, address3, address4, city, region,
postal_code,
> >country, email, mob_phone, tel_number, fax_number, org_web_address,
> >personal_web_address, special_interests, date, time)
> >
> >VALUES ('$title', '$surname', '$forename', '$job_title', '$org_name',
> >'$address1', '$address2', '$address3', '$address4', '$city', '$region',
> >'$postal_code', '$country', '$email', '$mob_phone', '$tel_number',
> >'$fax_number', '$org_web_address', '$personal_web_address',
> >'$special_interests', '$date','$time')")
> >
> >
> >
> >
> >
>
>
--
PHP General 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 General 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] associative arrays
Hi everybody
i have the following database query:
$result=mysql_db_query("database","select item1,item2 from table");
while ($row=mysql_fetch_array($result)){
$a=$row[item1];
$b=$row[item2];
}
what i need is an associative array, with $a as key and $b as value,
containing each item1 and item2 from the database
--
PHP General 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]
AW: [PHP] associative arrays
hi adrian,
many thanks for your tip. it works fine.
kind regards
martin
-Ursprüngliche Nachricht-
Von: Adrian Ciutureanu [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 12. Juli 2001 15:46
An: Martin Lucas
Cc: [EMAIL PROTECTED]
Betreff: RE: [PHP] associative arrays
$result = mysql_db_query("database","select item1, item2 from table");
while ($row = mysql_fetch_array($result)) {
$myArray[$row['item1']] = $row['item2'];
}
> -Original Message-
> From: Martin Lucas [mailto:[EMAIL PROTECTED]]
> Sent: 12 iulie 2001 16:25
> To: '[EMAIL PROTECTED]'
> Subject: [PHP] associative arrays
>
>
> Hi everybody
> i have the following database query:
>
> $result=mysql_db_query("database","select item1,item2 from table");
> while ($row=mysql_fetch_array($result)){
> $a=$row[item1];
> $b=$row[item2];
>
> }
> what i need is an associative array, with $a as key and $b as value,
> containing each item1 and item2 from the database
>
> --
> PHP General 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 General 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]
