php-windows Digest 8 Nov 2004 03:10:01 -0000 Issue 2459
Topics (messages 24924 through 24930):
Re: Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result
24924 by: %u
Variables not retaining values
24925 by: Anne Shroeder
24926 by: Michael Purdy
Re: Apache, PHP4, MySQL installation
24927 by: Svensson, B.A.T. (HKG)
Performance question?
24928 by: George Pitcher
Re: 2 sites accessing 1 db - problem
24929 by: Svensson, B.A.T. (HKG)
mail function not working
24930 by: William Lee
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Hi there,
I´ve had the same problem a few minutes ago.
I my case, I wrote the line:
mysql_free_result($VAR);
at the end of the code for all my variables like
$var1 = mysql_query("select blablabla");
I am not a master at PHP and MySQL, but if you still have the problem please
let me know.
Tomas Schweizer
--- End Message ---
--- Begin Message ---
A very kind soul helped me a few months back with the problem of variables
not being passed through forms (due to a setting in php.ini that the web
hosting service will not change). Solution was to refer to the variable in
the receiving page as $_POST["variablename"]
That worked great! But now I have a problem with a slightly different
flavor. I want to call a page that passes a variable through (in this case
id) - I've tried everything to get the receiving page to recognize the
variable, but it always comes out blank. Example:
I want to delete an item:
<A HREF=keywords_delete_ask.php?id=$keywordid>DELETE</A>
And the item I've selected has ID=145. The URL tells me that I've gone to
keywords_delete_ask.php?id=145
Yet the value of id is most definitely not passed through. This is probably
a very simple fix, but I am at my wits end.
Anne
--- End Message ---
--- Begin Message ---
Anne
On your keywords_delete_ask.php page what error does
echo $_REQUEST['id'];
Produce?
Mike
----- Original Message -----
From: "Anne Shroeder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 07, 2004 10:16 AM
Subject: [PHP-WIN] Variables not retaining values
> A very kind soul helped me a few months back with the problem of variables
> not being passed through forms (due to a setting in php.ini that the web
> hosting service will not change). Solution was to refer to the variable
in
> the receiving page as $_POST["variablename"]
>
>
> That worked great! But now I have a problem with a slightly different
> flavor. I want to call a page that passes a variable through (in this
case
> id) - I've tried everything to get the receiving page to recognize the
> variable, but it always comes out blank. Example:
>
> I want to delete an item:
> <A HREF=keywords_delete_ask.php?id=$keywordid>DELETE</A>
>
> And the item I've selected has ID=145. The URL tells me that I've gone to
> keywords_delete_ask.php?id=145
>
> Yet the value of id is most definitely not passed through. This is
probably
> a very simple fix, but I am at my wits end.
>
> Anne
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Of courcse you dont get errors, since you supress them with the at-sign (@)
before the function name. While still doing alpha development it is
stroingly suggested not to supress error output on espacilay database
functions calls.
That is why you only see the first echoed string.
-----Original Message-----
From: Jeroen
To: [EMAIL PROTECTED]
Sent: 5-11-2004 22:48
Subject: Re: [PHP-WIN] Apache, PHP4, MySQL installation
Hello Walter,
No errors, just not the results I want.
I run the following script:
<?
echo "DB connection testing !";
$mySQL = @mysql_connect("localhost", "user", "password")
or exit();
echo "DB selecting !";
if (!mysql_select_db("my"))
exit();
echo "DB connection okay !";
?>
I only see the string DB connection testing.
Regards,
Jeroen
"Phpwalter" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>> Hello,
>>
>> I installed Apache 2.0.52 en PHP4.3.9 on a Windows XP SP2 machine.
>> Everything runs fine.
>> I also installed MySQL 4.1 and it also runs fine.
>>
>> However when I try to connect to a exisiting database from within a
PHP
>> script it fails.
>>
>> I followed several installation tutorials on the net but nu success
>> sofar.
>
> #1 - what errors, if any are you getting
>
> #2 - what kind of display ar you getting?
>
> #3 - try this install dox
> http://web.torres.ws/dev/php/walters_way
>
> Works every time.
>
> Walter
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi,
I'm currently rebuilding a site previously constructed using
Lasso/Filemaker. I'm using PHP5/MySQL4/PEAR::DB and Smarty.
The site holds course content information for universities and colleges.
My first page after logging on displays courses for the user. This lists
relevant courses, their status and some stats for items that require
attention.
This involves one SQL query to a course table containing 3,100 records, and
in my sample returned 4 records. The stats and status data require another
12 SQL queries to a transaction table containing over 32,000 records. In
both these tables, I have indexed all the columns.
My testing this weekend is producing disappointing results with the page
taking between 20 and 50 seconds to appear.
I'm running this on a fairly fast laptop with XP, IIS5, using the ISAPI
method. The deployment is going to be on slower NT servers.
Does anyone have any tips to improve performance?
MTIA
George
--- End Message ---
--- Begin Message ---
Does MySQL allow remote and/or local connections to the system?
Each MySQL user has security checks on weather it is allowed to do local
respectively remote connections.
-----Original Message-----
From: George Pitcher
To: [EMAIL PROTECTED]
Sent: 5-11-2004 15:33
Subject: [PHP-WIN] 2 sites accessing 1 db - problem
======================================================================
[...]
Am I missing something obvious?
Cheers
George in Oxford
--- End Message ---
--- Begin Message ---
My system:
Windows XP
Apache
SMTP server: MailEnable
PHP 5.0.2
Whenever I try to use the mail function, it returns me a value of "false".
My php.ini settings are:
[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25
Here's the function I'm using:
<?php
$r = mail("[EMAIL PROTECTED]", "my subject", "line1") ;
var_dump($r);
?>
This always returns: bool(false)
What else do I need to setup in order for this to work???
I can send a regular email through using outlook express. any ideas?
--- End Message ---
