Re: [PHP] PHP/LDAP Setup Problem

2006-04-26 Thread Richard Lynch
On Tue, April 25, 2006 9:43 pm, Crone, James wrote:
 I need to add LDAP support to my install of PHP.  I had my sysadmin
 download OpenLDAP and install the libraries.  Our current build of PHP
 is complex and I'd prefer not to have to rebuild just to add LDAP.
 I've
 been told to use the dl() function to load the LDAP library when
 needed
 in PHP.  Whenever I dl(libldap.so) PHP returns the following error:

   PHP Warning:  dl(): Invalid library (maybe not a PHP library)
 'libldap.so' in .

 What am I doing wrong?  Thanks in advance.

libldap.so is the LDAP library -- like, the WHOLE LDAP library, to
which PHP has an interface, if you re-compile PHP.

So you need to compile (or they need to compile) the PHP LDAP
interface down in the ext directory of PHP (or maybe it's in PECL
now).

This will result in a file with a name something like:
ldap_php.so

And *that* file is the one you would use dl() on.

What you did is kind of like buying an airplane when you need to fly
to another city...

You needed just the ldap_php.so, and you tried to load in libldap.so,
which is a system library.

Pretty much all of PHP's extensions work like this.

   PHPPHP Extensions  System Software Libraries
PHP Core +
 + mysql_php.so  libmysql.so
 + gd_php.so --- libgd.so
 + libpdf_php.so --- libpdf.so
.
.
.

That's the basic idea, anyway, even though I'm sure that at least one
of the above is actually incorrect, and the names of the libraries and
.so files vary a bit, here and there.

You only want to dl() the PHP Extension that bridges or provides the
glue to the System Software Library -- You don't want to dl() the
whole System Software Library.

Replace .so with .dll under Windows, and the same paradigm holds.

HTH

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP/LDAP Setup Problem

2006-04-26 Thread Sameer N Ingole

Crone, James wrote:

I need to add LDAP support to my install of PHP.  I had my sysadmin
download OpenLDAP and install the libraries.

This isn't correct way. You need these libraries but they are not enough.

[snip] I've
been told to use the dl() function

Read carefully. http://php.net/dl says
dl -- Loads a PHP extension at runtime

Note *PHP extension*. You cannot use LDAP libraries directly.

PHP Warning:  dl(): Invalid library (maybe not a PHP library)
'libldap.so' in .

What am I doing wrong?  Thanks in advance.
  
You are loading ldap library directly which provide C interface to ldap 
functions. You need PHP interface (which is what provided by PHP 
extension). It need to be compiled in PHP.


Read more about extensions:
http://www.zend.com/php/internals/extension-writing1.php#Heading2

--
Sameer N. Ingole
Blog: http://weblogic.noroot.org/
---
Better to light one candle than to curse the darkness.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Amazon WSDL

2006-04-26 Thread Richard Lynch
On Tue, April 25, 2006 7:13 pm, John Meyer wrote:
 Richard Collyer wrote:
 John Meyer wrote:
 Hey, is it possible to use the Amazon WSDL within PHP?


 Lookie what the first google entry for Amazon WSDL php was:

 http://www.onlamp.com/pub/a/php/2003/07/03/php_amazon_soap.html

 Richard


 Nice, now I need to navigate the bloody Amazon web services.  Is it
 just
 me, or does it look like, just by browsing Amazon itself, you have to
 use Alexis to do web queries.  Specifically, I'm trying to find out
 how
 to query using an ISDN.

I have not read the article in that link.

I have NO IDEA what Alexis is, other than some damn toolbar thingie
that my boss installed, and f'ed up his browser with...

But I'm betting a dollar that you do not need Alexis AT ALL, and that
it's only ONE choice of a zillion.

Maybe the Amazon Developer Forums, specifically set up to address
questions like yours, would be most appropriate:

http://developer.amazonwebservices.com/connect/index.jspa

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Upload Progress Meter - what's the latest?

2006-04-26 Thread Richard Lynch
On Tue, April 25, 2006 9:23 pm, D. Dante Lorenso wrote:
 Richard Lynch wrote:
 On Tue, April 25, 2006 5:28 pm, D. Dante Lorenso wrote:

 Everything PHP returns from a server is client side, so your

 Oh yeah.  I forgot to say...
 The above presumption is patently false.


 Let me clarify:  Assuming client/server architecture, if PHP is on the
 server side then something else needs to be on the client side to
 interpret the output of the PHP server.  That output is what PHP
 returns
 and it is interpreted and rendered on the client side by definition.

 Alternatively:  If it is not meant for the client to receive, it is
 not
 (should not) be output by PHP.

Guess I'd better throw away all my command-line scripts and cron jobs,
and all my PHP GTK half-finished projects, and...

Plus, all the times I've got a web page that initiates some
asynchronous process and outputs only a tiny fraction of its output to
the browser, while generating a GREAT DEAL of output elsewhere.

:-)

Maybe we're just posting at cross-purposes here, but PHP does a hell
of a lot more than spit out HTML web pages...

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Protecting index.php

2006-04-26 Thread chris smith
On 4/26/06, P. Guethlein [EMAIL PROTECTED] wrote:

 Initial index.php file:

 ?php
 if(isset($_GET['d'])){setcookie('disp',$_GET['d'],time()+(60*60*24*60));$_COOKIE['disp']=$_GET['d'];}
 include_once('writemenus.php');

 if(!isset($_GET['href'])) $include = 'startpage.htm';
 else {
   $include = $_GET['href']; $include = $include.php;
   if($include=='index.php')$include = 'startpage.htm';
 }
 include_once($include);
 include_once('footer.htm');
 ?

 =
 Hackers seem to be able to call a remote script by appending the URL
 to the href= command line . ( $include )

..because you're not checking it, you're just including it.

If you turn off allow_url_fopen then this will stop it, but it's best
to fix it properly.

You could do something like this:

$mydir = dirname(__FILE__);

$include = $_GET['href'].'.php';

if (realpath($mydir.'/'.$include) != $mydir.'/'.$include) {
  $include = 'startpage.htm';
} else {
  $include = $mydir .'/'.$include;
}

You use realpath to get rid of '../' and './' type references (see
http://www.php.net/realpath), then make sure that's the same file as
in the current directory.

If they don't match, it includes startpage.htm.

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Upload Progress Meter - what's the latest?

2006-04-26 Thread Richard Lynch
On Tue, April 25, 2006 9:55 pm, D. Dante Lorenso wrote:
 Richard Lynch wrote:
 that
 the replies I've gotten from this list so far suggest that internals
 of
 PHP development are seriously opposed to such a feature?

They may or may not be opposed to attempting to use server-side
technology to provide client-side statistical data, for a file that
the CLIENT is uploading.

Which is why I suggested that the request for server-side statistical
tracking of uploads in progress for the server-side statistical
analysis would be a Good Thing to propose.

 I am more
 interested in which project extensions are leading in momentum to
 solve
 the problem I am trying to solve and not blaming other projects
 (browsers) for not building the feature first.

The momentum, as far as I know, of all the project extensions to do
what you describe is zero (0).

 The back-and-forth you refer to is termed 'polling'.  With a protocol
 like HTTP, polling is really the only option unless I implement a
 socket
 server which is capable of sending events.

Gah!

I know what it's called.

Let's try AGAIN.

You want to use POLLING from server to client to measure how much data
the client has sent.

Does not the CLIENT already *KNOW* how much data it sent?

Why in the world would you generate all that traffic to compute data
already in existence on the client in the first place?

That is the fundamental problem to which objections are raised on this
issue.

It's just plain daft to poll the server to find out how much data you
sent it, when you're the one sending the data.

 Right.  Under the callback method example, I would have access to
 $_SESSION which would already contain enough information about the
 logged in account for my purposes.  This is trivial.

If it's trivial, code up the patch and send it.

 For tying the filenames back to the users who are logged in, you'd
 have to have an onClick() on the submit button which would send some
 kind of information (filename, filesize, user) to a PHP script that
 would log the upload about to begin in a database.  The onClick
 would
 then return false so that the normal form submission process would
 kick in.


 This will not work.  And this is exactly WHY an extention/patch is
 needed.  Between the time PHP choses a /tmp file name and the time the
 upload is completed, there is not execution of PHP code.  Therefor, we
 don't know the /tmp name assigned to an upload until AFTER the upload
 is
 completed and then it's too late.

Oh but there *IS* execution of all kinds of PHP code between that time
-- Just not in the script that is receiving the file.

Since you're building a statistical monitoring of the process, I'm
suggesting that you have ANOTHER PHP script running to examine the
state of /tmp and monitor the progress from outside the script
actually receiving the file.

It won't be pretty, but it can be done with what's available in PHP
today, without patches.

 You're not going to get ... accuracy ...
 It won't be so hot for tracking who's uploading what in real-time,

 It should be.  Using the patch, I already have this working.  I now
 want
 a cleaner, supported solution which doesn't involve a custom patch
 which
 will not be supported in the future.  Although the patch I am using
 works, it was build for PHP 5.0.3 RC1 and since I am using 5.1.2 you
 can
 understand my concerns that it will fail to continue working when the
 switch is made to PHP 5.2 or PHP 6.0.

If you submit a similar patch, and specifically label it as
server-side statistical analysis feature for uploaded files in
progress, I SUSPECT it has a much better chance of going than a
server-side hack to solve a client-side problem.

 Another option is to provide patch to PHP which gives a special
 INPUT
 parameter to a FORM that can be used to provide a callback file to
 load, and a callback function within that file to call, and then
 modify the file upload routine to load and call that function.

 Passing this from the client form is insecure and can not be trusted.
 Declaring callback functions needs to remain a server-side declaration
 either through code or an INI setting, etc.

You're right.  That would be a gaping security hole.

 It seems genuinely useful enough to this naive reader, and should
 not
 cause an undue burden for those who don't use it.  Check with
 PHP-Dev
 to see if such a patch is likely to be accepted before putting in
 TOO
 much time on it.


 My original email was searching for advice on which project has
 momentum
 and what the current state of any discussions about the issue were.
 Does anybody have information on the PEAR package which appears to be
 vapor?

 http://pecl.php.net/package/postparser

 I see the name Curt Zirzow, but no contact information for that
 author.

He posted a few zillion messages here in PHP-General...

His email has to be in the Marc archives.

 Is there not a package which has been adopted by the community or does
 every developer share Richard's opinion that 

[PHP] SQL query to array?

2006-04-26 Thread William Stokes
Hello,

Can someone please help me to put the results of a query to an array. Never 
done this before:

$sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri 
ASC;
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$cur = 1;

//create empty array that contains an array before loop
$arr = array(Team = array());

while ($num = $cur) {
$row = mysql_fetch_array($result);
$id = $row[jouk_id];
$srt = $row[sortteri];
$nimi = $row[jouk_nimi];

//append values to the array
$arr = array(Team$cur = array(0 = $id, 1 = $srt, 2 = $nimi));

$cur++;
}

Thanks
-Will 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: Serveral forms in a page.

2006-04-26 Thread William Stokes
it was just a question ?


Stut [EMAIL PROTECTED] kirjoitti viestissä:[EMAIL PROTECTED]
 William Stokes wrote:
 Mulkku?

 'Cause insulting us is the way to convince this list to answer your 
 irrelevant questions? Seriously tho, if I may, go join an HTML/Javascript 
 list for these questions and try to stick with PHP on this one.

 -Stut 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Protecting index.php

2006-04-26 Thread Richard Lynch
On Wed, April 26, 2006 12:53 am, P. Guethlein wrote:
 ?php
 if(isset($_GET['d'])){setcookie('disp',$_GET['d'],time()+(60*60*24*60));$_COOKIE['disp']=$_GET['d'];}

I suppose this isn't so terribly awful, since experienced users can
forge their Cookies as easily as GET, but as a matter of principle,
you SHOULD insure that $_GET['d'] has the data you expect.

 include_once('writemenus.php');

 if(!isset($_GET['href'])) $include = 'startpage.htm';

This is fine.

 else {
   $include = $_GET['href']; $include = $include.php;

This is SO not fine!!!

You are allowing the Bad Guys to include *ANY* file they want here!

Never ever ever ever use a variable in include() that the user gets to
pick whatever they want.

You need to decide, in advance, which files the user CAN include, like
your 'startpage.htm' and only allow $include to take on those values
you hvae pre-determined to be valid.

Here's one easy way to do this:
switch($_GET['href']){
  case 'startpage':
  case 'index':
  case 'about':
  case 'contact':
$include = $_GET['href'] . '.php';
  break;
  default:
error_log(HACK ATTEMPT $REMOTE_ADDR  . date('m/d/Y h:i:s a);
die(No.);
  break;
}

   if($include=='index.php')$include = 'startpage.htm';
 }
 include_once($include);
 include_once('footer.htm');
 ?

 =
 Hackers seem to be able to call a remote script by appending the URL
 to the href= command line . ( $include )

 What buttons do I need to push to stop this?  Does PHP have a setting
 to allow only local calls? or do I have to do it in the index.php file
 ? or ??

Required Reading:
http://phpsec.org/

All of it.

The whole damn site.

Now.

Sorry.

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] need help to put input text value into url

2006-04-26 Thread Richard Lynch
On Tue, April 25, 2006 6:19 pm, Patrick Aljord wrote:
 I have a form like this:
 form action=search.php method=post target=_self
 input type=text name=search_text cols=20 rows=10/input
 input type=submit name=submit_search value=search /
 /form

 while this is working fine, I would like the url of search.php to be
 something like search.php?q=value+of+search_text
 eg, if I enter php rules in my text box, the url should be
 http://myfakepage.com/search.php?q=php+rules;
 any idea how to do that?

The EASIEST way is to change post to get and to rename
search_text to q

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] SQL query to array?

2006-04-26 Thread Jim Lucas

William Stokes wrote:

Hello,

Can someone please help me to put the results of a query to an array. Never 
done this before:


$sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri 
ASC;

$result = mysql_query($sql);
$num = mysql_num_rows($result);
$cur = 1;

//create empty array that contains an array before loop
$arr = array(Team = array());

while ($num = $cur) {
$row = mysql_fetch_array($result);
$id = $row[jouk_id];
$srt = $row[sortteri];
$nimi = $row[jouk_nimi];

//append values to the array
$arr = array(Team$cur = array(0 = $id, 1 = $srt, 2 = $nimi));

$cur++;
}

Thanks
-Will 

  

You might try this as an alternative:

$cur = 0;
while (list($id, $srt, $nimi) = $mysql_fetch_array($result)) {
	$arr = array(Team{$cur} = array(0 = $id, 
	1 = $srt,

2 = $nimi));
$cur++;
}


Jim

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] SQL query to array?

2006-04-26 Thread Richard Lynch
On Wed, April 26, 2006 1:39 am, William Stokes wrote:
 Can someone please help me to put the results of a query to an array.

There are only a few thousand tutorials on this on the 'net...

 Never
 done this before:

 $sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY
 sortteri
 ASC;
 $result = mysql_query($sql);
 $num = mysql_num_rows($result);
 $cur = 1;

 //create empty array that contains an array before loop
 $arr = array(Team = array());

 while ($num = $cur) {

If you do not start indenting your code correctly now, you will most
likely never enjoy much success in your programming efforts.

 $row = mysql_fetch_array($result);
 $id = $row[jouk_id];
 $srt = $row[sortteri];
 $nimi = $row[jouk_nimi];

 //append values to the array
 $arr = array(Team$cur = array(0 = $id, 1 = $srt, 2 = $nimi));

While there is nothing technically wrong with this, it's going to
make life harder for you to deal with the Team$cur index.

Much easier to do:
$arr[] = $row;

to append to the array.

 $cur++;
 }

Or did I miss the part where you described what you saw and what you
expected to see?

Because what you posted is fine as far as it goes, as far as I can
tell.

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] SQL query to array?

2006-04-26 Thread Joe Wollard
Will,

Seems to me like you've just done it! Here's another way of doing it that
will utilize mysql_fetch_assoc() to allow your query to dictate the elements
of the array. Keep in mind, I haven't tested this, but since I'm not
entirely sure what you are asking the list, I'll offer it anyway ;-)

?php
/*...do connection stuff here...*/
$sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri
ASC;
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$Team = null; //We'll fill this up later - gotta love PHP ;-)

// loop over each row in the result set
for($i=0; $i$num; $i++){
$tmp = mysql_fetch_assoc($result);

// loop over each column in the current row
while(list($key, $val) = each($tmp))
   $Team[$key][$i] = $val;
}
// display the contents of the $Team array
print_r($Team);
?




On 4/26/06, William Stokes [EMAIL PROTECTED] wrote:

 Hello,

 Can someone please help me to put the results of a query to an array.
 Never
 done this before:

 $sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri
 ASC;
 $result = mysql_query($sql);
 $num = mysql_num_rows($result);
 $cur = 1;

 //create empty array that contains an array before loop
 $arr = array(Team = array());

 while ($num = $cur) {
 $row = mysql_fetch_array($result);
 $id = $row[jouk_id];
 $srt = $row[sortteri];
 $nimi = $row[jouk_nimi];

 //append values to the array
 $arr = array(Team$cur = array(0 = $id, 1 = $srt, 2 = $nimi));

 $cur++;
 }

 Thanks
 -Will

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Php function to Set focus On A form Field

2006-04-26 Thread Joe Wollard
PHP can't do that for you but Javascript can. Here's roughly 3 million (no
joke) examples of what you'd like to accomplish:
http://www.google.com/search?q=javascript+focus+first+input



On 4/26/06, marvin hunkin [EMAIL PROTECTED] wrote:

 Hi.
 is there any php or java script function, where i can embed into my php or
 html file, to set focus on to the first form field, like a text box, to go
 to that field first, and not to go to the link or button first.
 if there are any tips, tricks, or links or code examples, how to fix this
 problem.
 let me know.
 cheers Marvin.

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Re: Php function to Set focus On A form Field

2006-04-26 Thread Philipp Kopf

marvin hunkin schrieb:

Hi.
is there any php or java script function, where i can embed into my php 
or html file, to set focus on to the first form field, like a text box, 
to go to that field first, and not to go to the link or button first.
if there are any tips, tricks, or links or code examples, how to fix 
this problem.

let me know.
cheers Marvin.


Hi.

It is not possible to do that using PHP but you can use JavaScript 
instead. I recommend the function focus(). For example:

BODY OnLoad=document.nameform.user.focus();

Check this tiny tutorial: 
http://javascript.internet.com/page-details/focus-onload.html


Did you already remarked that http://www.google.com is using this 
function to automatically set the focus on the search field.


regards

Philipp

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] session

2006-04-26 Thread Sichta, Daniel
Hi there !!
 
I have web app which using frames. After session timeout my session is
killed.
The problem is that session is killed even when I doing requests to the
server. 
I know why (session is chain to the frameset page) but what's the
solution for this?
I have to use frames !! Don't ask why !! :-)
 
THX
 

Dan

 


Re: [PHP] SQL query to array?

2006-04-26 Thread William Stokes
Ooopps.

I just did have array too many. This did the append corretly:

$arr[Team$cur] = array(id = $id, sort = $srt, jnimi = $nimi);

-Will


Joe Wollard [EMAIL PROTECTED] kirjoitti 
viestissä:[EMAIL PROTECTED]
Will,

Seems to me like you've just done it! Here's another way of doing it that
will utilize mysql_fetch_assoc() to allow your query to dictate the elements
of the array. Keep in mind, I haven't tested this, but since I'm not
entirely sure what you are asking the list, I'll offer it anyway ;-)

?php
/*...do connection stuff here...*/
$sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri
ASC;
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$Team = null; //We'll fill this up later - gotta love PHP ;-)

// loop over each row in the result set
for($i=0; $i$num; $i++){
$tmp = mysql_fetch_assoc($result);

// loop over each column in the current row
while(list($key, $val) = each($tmp))
   $Team[$key][$i] = $val;
}
// display the contents of the $Team array
print_r($Team);
?




On 4/26/06, William Stokes [EMAIL PROTECTED] wrote:

 Hello,

 Can someone please help me to put the results of a query to an array.
 Never
 done this before:

 $sql = SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri
 ASC;
 $result = mysql_query($sql);
 $num = mysql_num_rows($result);
 $cur = 1;

 //create empty array that contains an array before loop
 $arr = array(Team = array());

 while ($num = $cur) {
 $row = mysql_fetch_array($result);
 $id = $row[jouk_id];
 $srt = $row[sortteri];
 $nimi = $row[jouk_nimi];

 //append values to the array
 $arr = array(Team$cur = array(0 = $id, 1 = $srt, 2 = $nimi));

 $cur++;
 }

 Thanks
 -Will

 --
 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] PHP 5 + Apache 2 on Windows: ms sql extension problem

2006-04-26 Thread Laszlo Nagy


Hello All,

I had a problem with a Win2003 server, IIS6 and PHP 5.1.2. The MS SQL 
extension was not working. I did not get an answer, but some people 
suggested me to use Apache. Now I installed Win 2000 server, Apache 
2.0.55 and PHP 5.1.2. The same computer has Microsoft SQL Server 
installed. I have only these lines in my php.ini file:


extension_dir=C:\PHP\ext
extension=php_mssql.dll

I checked phpinfo() and it tells that my php.ini file is at the correct 
location (C:\winnt\php.ini.) I can load other extensions. Another 
example: if I add php_curl.dll then I get a libsleay32.dll not found 
error message when I try to restart apache. But I do not get any error 
message about the php_mssql.dll. It is just not loaded. I'm sure that 
all the ms sql client libs are installed, because this is the same 
machine where the ms sql server is running. What can be the problem? 
Please help me. My bosses are killing me because I could not solve this 
problem for weeks. :-(


Thanks,

 Laszlo

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] (Apache|php) Bug using modproxy

2006-04-26 Thread Lmwangi
Hi all,
 First time on the list... sorry for any errs.
 I am using mod_proxy to pass requests to an internal server in our
lan. The setup looks like

Enduser---INet_link-Mod_proxy_serverLan---PHP_script

Now,

this  does not work:

Enduser---https---Apache_mod_proxy-http---Destination_server.

* When a user submits a form (php) with a file upload and  $_POST
vars, the $_POST array is mangled (missing) elements and the $_FILES
array is empty

while this works:

 Enduser---http---Apache_mod_proxy-http---Destination_server.

* When a user submits a form with a file upload and  $_POST vars,
Everything is all good
lmwangi

So something bad? happens when you use https in the request. Anyone
able to reproduce this. Is it a php bug (i doubt it) but you never
know until u waddle through the mod_proxy voodoo.
Here is a sample script


snip

?php
if(isset($_POST['btnSubmit'])){
print_r($_POST);
print_r($_FILES);
}
else{
?
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0
Strict//ENhttp://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;

html xmlns=http://www.w3.org/1999/xhtml;
 head
  meta http-equiv=Content-Type content=text/html; charset=utf-8 /
  titlePost Test/title
 /head

body
form action=?php echo $_SERVER['PHP_SELF']? method=post
name=frm_add_content id=frm_add_content
enctype=multipart/form-data
div
input name=id type=hidden value=0 /
input name=MAX_FILE_SIZE type=hidden value=2097152 /
table border=0

tr
td style=white-space: nowrap; background-color:
#CC; align=left valign=top colspan=2bAdd Media/b/td
/tr
tr
td align=right valign=topspan style=color:
#ff*/spanbMedia id/b/td
td valign=top align=leftinput class=inputbox
name=mediaid type=text //td
/tr

tr
td align=right valign=topbMedia File/b/td
td valign=top align=leftinput class=inputbox
name=mms_media type=file //td
/tr
tr
td align=right valign=topspan style=color:
#ff*/spanbSubject/b/td
td valign=top align=leftinput class=inputbox
name=subject type=text //td

/tr
tr
td align=right valign=topbMessage Body/b/td
td valign=top align=lefttextarea
class=inputbox name=msg_body/textarea/td
/tr
tr
tr

td align=right valign=topb/b/td
td valign=top align=leftinput class=button
name=btnClear value=Clear type=reset /nbsp;input
class=button name=btnSubmit value=Submit type=submit //td
/tr
tr
td/td
td align=left valign=topspan style=font-size:80%;
color:#ff;*/spanspan style=font-size:80%; denotes required
field/span/td
/tr

/table
/div
/form
/body
/html
?php
}
?
/snip

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Filter out MS Word 'quotes' for RSS

2006-04-26 Thread Kevin Davies
Hi All,

I've got a forum/blog system which is displaying correctly in the browser.
However, I've also got an RSS feed that is created from the data entered.

It seems that some of the users are copying and pasting from MS Word or
other packages, and this means that strange quote marks (among others) are
appearing, and breaking the RSS feed.

Obviously I need to convert these on entry, or on output into RSS. Does
anyone know of an easy way to do this, or is it a case of identifying each
unusual character individually?

I've been searching on Google for some advice on this, but not found
anything so far...

Thanks in advance,

Kev

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Book/Site for internernal PHP5 Core Developing

2006-04-26 Thread Thomas Munz
hi list!

Does someone know a good Book/website for Develop own C-Extensions for PHP5? 

http://us2.php.net/manual/en/zend.php
This site are just basic things, but i wanna do more things. Someone may help 
me?

thx

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Pear Package HTTP_Request

2006-04-26 Thread Markus Braun

Hello,

i try to install the HTTP_Request package.

I installed also the Net_Socket with

pear install Net_Socket-1.0.6

But it exists.

Than i try to install the HTTP_Request:

downloading HTTP_Request-1.3.0.tgz ...
Starting to download HTTP_Request-1.3.0.tgz (13,808 bytes)
.done: 13,808 bytes
requires package `Net_Socket' = 1.0.2
HTTP_Request: Dependencies failed


Then it comes this.

So i dont understand what the problem is.
I installed the new version of net socket already.

Thanks
marcus

_
Haben Spinnen Ohren? Finden Sie es heraus – mit dem MSN Suche Superquiz via  
http://www.msn-superquiz.de  Jetzt mitmachen und gewinnen!


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Pear Package HTTP_Request

2006-04-26 Thread chris smith
 i try to install the HTTP_Request package.

 I installed also the Net_Socket with

 pear install Net_Socket-1.0.6

 But it exists.

 Than i try to install the HTTP_Request:

 downloading HTTP_Request-1.3.0.tgz ...
 Starting to download HTTP_Request-1.3.0.tgz (13,808 bytes)
 .done: 13,808 bytes
 requires package `Net_Socket' = 1.0.2
 HTTP_Request: Dependencies failed


 Then it comes this.

 So i dont understand what the problem is.
 I installed the new version of net socket already.

You're better off asking the pear list: http://pear.php.net/support/lists.php

They will be able to help you a lot quicker than we can..

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Book/Site for internernal PHP5 Core Developing

2006-04-26 Thread chris smith
On 4/26/06, Thomas Munz [EMAIL PROTECTED] wrote:
 hi list!

 Does someone know a good Book/website for Develop own C-Extensions for PHP5?

 http://us2.php.net/manual/en/zend.php
 This site are just basic things, but i wanna do more things. Someone may help
 me?

This might help you out:

http://pecl.php.net/support.php#resources

If not, the internals list would be able to help you a lot better
since they are the ones writing the C code in the first place..

http://www.php.net/mailing-lists.php

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Filter out MS Word 'quotes' for RSS

2006-04-26 Thread chris smith
On 4/26/06, Kevin Davies [EMAIL PROTECTED] wrote:
 Hi All,

 I've got a forum/blog system which is displaying correctly in the browser.
 However, I've also got an RSS feed that is created from the data entered.

 It seems that some of the users are copying and pasting from MS Word or
 other packages, and this means that strange quote marks (among others) are
 appearing, and breaking the RSS feed.

 Obviously I need to convert these on entry, or on output into RSS. Does
 anyone know of an easy way to do this, or is it a case of identifying each
 unusual character individually?

I don't think there's anything to do this for you.

If it's only quotes you could do it quite simply.

str_replace lets you use arrays for both search and/or replace parameters, so:

$bad_chars = array(...);
$good_chars = ';

$text = str_replace($bad_chars, $good_chars, $text);

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP 5 + Apache 2 on Windows: ms sql extension problem

2006-04-26 Thread Wolf
This setup nagged me for a bit too, until I found the solution...

The DLL files in C:\php need to be put into system32 directory.  Once
that happens they work like a charm, but until then, you are plagued
with issues.  I have my path set for C:\php and everything as well, but
it was not until copying the DLLs into the C:\Windows\System32 that
everything started working.  Thankfully Google held the answer.

Wolf

 I checked phpinfo() and it tells that my php.ini file is at the correct
 location (C:\winnt\php.ini.) I can load other extensions. Another
 example: if I add php_curl.dll then I get a libsleay32.dll not found
 error message when I try to restart apache. But I do not get any error
 message about the php_mssql.dll. It is just not loaded. I'm sure that
 all the ms sql client libs are installed, because this is the same
 machine where the ms sql server is running. What can be the problem?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Filter out MS Word 'quotes' for RSS

2006-04-26 Thread Wolf
Low Tech Solution: Make them paste into Notepad, then Copy from there
and paste into the blog system.  If it is internal then it is part of
the process.

If external, check PHPClasses and see if they have one yet.

Wolf

Kevin Davies wrote:
 Hi All,
 
 I've got a forum/blog system which is displaying correctly in the browser.
 However, I've also got an RSS feed that is created from the data entered.
 
 It seems that some of the users are copying and pasting from MS Word or
 other packages, and this means that strange quote marks (among others) are
 appearing, and breaking the RSS feed.
 
 Obviously I need to convert these on entry, or on output into RSS. Does
 anyone know of an easy way to do this, or is it a case of identifying each
 unusual character individually?
 
 I've been searching on Google for some advice on this, but not found
 anything so far...
 
 Thanks in advance,
 
 Kev
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] session

2006-04-26 Thread chris smith
On 4/26/06, Sichta, Daniel [EMAIL PROTECTED] wrote:
 Hi there !!

 I have web app which using frames. After session timeout my session is
 killed.
 The problem is that session is killed even when I doing requests to the
 server.
 I know why (session is chain to the frameset page) but what's the
 solution for this?

Do you have session_start at the top of every page?

Does it happen on certain pages? Does it happen when you perform a
particular action? We need a lot more info about what's going on.

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Serveral forms in a page.

2006-04-26 Thread chris smith
On 4/25/06, William Stokes [EMAIL PROTECTED] wrote:
 Hello,

 This might be more HTML stuff but anyway...

 I have several forms in a page which is ok otherwise but the reset buttons
 doesn't clear anything that is queried from DB and printed to the text
 fields. Any idea how to create Reset buttons that clear the fields even when
 the data is not from user input? Or do I have to create reset buttons that
 are actually submit buttons and play with variables after that or something
 like that? Javascript is the way I don't want to go...

The reset button restores the form back to it's original state - if
you preload values or preselect options when you display the form,
then that's what it will reset it back to.

form
Blah: input type=text name=blah value=12345
input type=reset value=Reset
/form

Change 'blah', hit 'reset' and it will change it back to 12345.

If you want to completely reset the form, then you'll have to either
use javascript or refresh the page with a flag and check..

?php
if (isset($_GET['clearform'])) {
  $blah = '';
} else {
  $blah = '12345';
}
?

form
Blah: input type=text name=blah value=?php echo $blah; ?
input type=reset value=Reset
/form

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Pear Package HTTP_Request

2006-04-26 Thread Markus Braun

sorry



From: chris smith [EMAIL PROTECTED]
To: Markus Braun [EMAIL PROTECTED]
CC: php-general@lists.php.net
Subject: Re: [PHP] Pear Package HTTP_Request
Date: Wed, 26 Apr 2006 21:21:24 +1000

 i try to install the HTTP_Request package.

 I installed also the Net_Socket with

 pear install Net_Socket-1.0.6

 But it exists.

 Than i try to install the HTTP_Request:

 downloading HTTP_Request-1.3.0.tgz ...
 Starting to download HTTP_Request-1.3.0.tgz (13,808 bytes)
 .done: 13,808 bytes
 requires package `Net_Socket' = 1.0.2
 HTTP_Request: Dependencies failed


 Then it comes this.

 So i dont understand what the problem is.
 I installed the new version of net socket already.

You're better off asking the pear list: 
http://pear.php.net/support/lists.php


They will be able to help you a lot quicker than we can..

--
Postgresql  php tutorials
http://www.designmagick.com/


_
Haben Spinnen Ohren? Finden Sie es heraus – mit dem MSN Suche Superquiz via  
http://www.msn-superquiz.de  Jetzt mitmachen und gewinnen!


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] cURL cookies

2006-04-26 Thread Eric Butera
On 4/25/06, Richard Lynch [EMAIL PROTECTED] wrote:Sounds to me like we have
different versions of cURL and yours is

 better. :-)

 Mine phpinfo() curl section has:
 libcurl/7.15.3 OpenSSL/0.9.7d zlib/1.2.1

 which would seem to be the most current version...

 Or, perhaps, the order in which you set the options matters?  Ick.

 For me, at least, the Cookie jar did not work until I took out the
 CURLOPT_HEADER, and it DID work after I changed that, and only that.

 --
 Like Music?
 http://l-i-e.com/artists.htm


 Our production server uses this:
Php 4.4.0
CURL Information libcurl/7.15.1 OpenSSL/0.9.8a zlib/1.1.4

My local machine:
Php 4.3.11
CURL Information libcurl/7.10.5 OpenSSL/0.9.7i ipv6 zlib/1.2.3
(not by choice ;))


[PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
Hi all

I'm trying to execute two querys and they execute perfectly in fact,
but after the execution of the first query there suposed to be some
variable setted to a certain value. 

The problem is this variable is not available at the time the second
query runs. 

I`ll try to explain a little bit further

//This is my first query 

$quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
mysql_query($quer1);

// This is query #2

$query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 doesn`t
exist 


That wasn't really my first attempt. Originally
I've tryied the whole thing in just one single query but mysql gave me
an error message complinning about the semicolon

Please look at this

$quer1 = SET @var1=3 ;
SELECt * from table1 Where [EMAIL PROTECTED]  ;


This gave a syntax error from MySQL inmmediately before the ;
(semicolon),


Please any help greatefully appreciated

Thanks 
Mauricio 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread nicolas figaro

Mauricio Pellegrini a écrit :

Hi all

I'm trying to execute two querys and they execute perfectly in fact,
but after the execution of the first query there suposed to be some
variable setted to a certain value. 


The problem is this variable is not available at the time the second
query runs. 


I`ll try to explain a little bit further

//This is my first query 


$quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
mysql_query($quer1);

// This is query #2

$query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 doesn`t
exist 

  

why don't you build the second query directly with the value ?
$query2 = SELECT * from table where col1=.$value;

why do you need a query to set @VAR1=3 ?
(do you plan to use @VAR in another query ?).

N F


That wasn't really my first attempt. Originally
I've tryied the whole thing in just one single query but mysql gave me
an error message complinning about the semicolon

Please look at this

$quer1 = SET @var1=3 ;
SELECt * from table1 Where [EMAIL PROTECTED]  ;


This gave a syntax error from MySQL inmmediately before the ;
(semicolon),


Please any help greatefully appreciated

Thanks 
Mauricio 

  


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Filter out MS Word 'quotes' for RSS

2006-04-26 Thread Evan Priestley


On Apr 26, 2006, at 5:45 AM, Kevin Davies wrote:

Obviously I need to convert these on entry, or on output into RSS.  
Does
anyone know of an easy way to do this, or is it a case of  
identifying each

unusual character individually?


These high-ascii characters have ord() values greater than 126. If  
you're rendering to HTML, you can go through your string converting  
them into '#ord_value;', where `ord_value' is the return from ord()  
(so your result looks like #210;), which will fix the primary  
problem (things breaking) and should at least limit the damage on the  
secondary problem (loss of information). In my experience, however,  
this will clobber some entities pretty badly. Alternatively, you can  
just zap them (into * or ~ or some other printable character),  
which will work better for text rendering.


You can also mix the two, by identifying individually those  
characters that you are concerned with preserving and zapping the  
others, e.g.


?php

/**
* Validate a string as being gremlin-free text. Characters with  
ordinal value

* greater than 126 will be converted into the best equivalent.
*
* @param any Something which might be a string.
*
* @returns array|bool True (valid), false (not valid), or an array of
*  unconverted exception ordinal values (valid but dirty).
*/
function validate_text( $text ) {

static $conversions = array(
 // Windows  Word
 133= 'hellip;'
,145= 'lsquo;'
,146= 'rsquo;'
,147= 'ldquo;'
,148= 'rdquo;'
,149= 'bull;'
,150= 'ndash;'
,151= 'mdash;'

 // Mac
,165= 'bull;'
,208= 'ndash;'
,209= 'mdash;'
,210= 'ldquo;'
,211= 'rdquo;'
,212= 'lsquo;'
,213= 'rsquo;'
);

if( is_scalar( $text ) || is_null( $text ) ) {

$corpus = str_replace(
 array_map( 'chr', array_keys( $conversions ) )
,$conversions
,$text
);

$gremlins = array( );

for( $ii = 0; $ii  strlen( $corpus ); $ii++ ) {
if( ($ordv = ord( $corpus[ $ii ]) )  126 ) {
$gremlins[ $ii ] = $ordv;
$corpus[ $ii ] = '*';
}
}

$text = $corpus;

if( count( $gremlins ) ) {
return $gremlins;
}

return true;
}

return false;
}

?

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] bookmarking with a trademark sign in title

2006-04-26 Thread Angelo Zanetti

Hi all,

This might be slightly OT but it is related to a PHP project.
I have a link on the site Im developing to bookmark the site. The title is XYZ company™ but when the add bookmark window comes up for saving the bookmark, I cannot see the ™ sign. Does anyone have any 
idea of how to get this site to be saved with the name of the company?


TIA.

Angelo

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
 Mauricio Pellegrini a écrit :
  Hi all
 
  I'm trying to execute two querys and they execute perfectly in fact,
  but after the execution of the first query there suposed to be some
  variable setted to a certain value. 
 
  The problem is this variable is not available at the time the second
  query runs. 
 
  I`ll try to explain a little bit further
 
  //This is my first query 
 
  $quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
  mysql_query($quer1);
 
  // This is query #2
 
  $query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 doesn`t
  exist 
 

 why don't you build the second query directly with the value ?
 $query2 = SELECT * from table where col1=.$value;
 
 why do you need a query to set @VAR1=3 ?
 (do you plan to use @VAR in another query ?).
 
 N F
 
  That wasn't really my first attempt. Originally
  I've tryied the whole thing in just one single query but mysql gave me
  an error message complinning about the semicolon
 
  Please look at this
 
  $quer1 = SET @var1=3 ;
  SELECt * from table1 Where [EMAIL PROTECTED]  ;
 
 
  This gave a syntax error from MySQL inmmediately before the ;
  (semicolon),
 
 
  Please any help greatefully appreciated
 
  Thanks 
  Mauricio 
 



Yes, I need to do it exactly this way.
I mean , SET the value for the variable @var1 first.
Then execute an undefined number of querys that reference this variable
and its value.

Thanks 
Mauricio

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] session

2006-04-26 Thread chris smith
On 4/26/06, Sichta, Daniel [EMAIL PROTECTED] wrote:

 -Original Message-
 From: chris smith [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 26, 2006 2:18 PM
 To: Sichta, Daniel
 Cc: php-general@lists.php.net
 Subject: Re: [PHP] session

 On 4/26/06, Sichta, Daniel [EMAIL PROTECTED] wrote:
  Hi there !!
 
  I have web app which using frames. After session timeout my session is
  killed.
  The problem is that session is killed even when I doing requests to
 the
  server.
  I know why (session is chain to the frameset page) but what's the
  solution for this?

 Do you have session_start at the top of every page?
 A:Yes I do !

 Does it happen on certain pages?
 A:On every page !!

 Does it happen when you perform a particular action?
 A:No !! On any action

 We need a lot more info about what's going on.
 A: I have declared framesets in index.php and after that I'm sending
 request from frameset source pages.
 This is (IMHO)

Where's the rest of the sentence?

Always CC the list. You will get more people looking at your
questions/answers and you will most likely get a quicker response.

Can you explicitly pass the sessionid across:

  FRAMESET rows=100, 200
  FRAME src=blah1.php?session_id=?php echo SID; ?
  FRAME src=blah2.php?session_id=?php echo SID; ?
  /FRAMESET

?

Sounds like you're missing something really basic if you're having
issues with every page. Post some code in pastebin.com and send us the
url so we can see what you're doing..

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread chris smith
On 4/26/06, Mauricio Pellegrini [EMAIL PROTECTED] wrote:
 On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
  Mauricio Pellegrini a écrit :
   Hi all
  
   I'm trying to execute two querys and they execute perfectly in fact,
   but after the execution of the first query there suposed to be some
   variable setted to a certain value.
  
   The problem is this variable is not available at the time the second
   query runs.
  
   I`ll try to explain a little bit further
  
   //This is my first query
  
   $quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
   mysql_query($quer1);
  
   // This is query #2
  
   $query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 
   doesn`t
   exist

If you try this through a mysql console or through something like
phpmyadmin does it work?

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] bookmarking with a trademark sign in title

2006-04-26 Thread Jay Blanchard
[snip]
This might be slightly OT but it is related to a PHP project.
I have a link on the site Im developing to bookmark the site. The title
is XYZ company(tm) but when the add bookmark window comes up for saving
the bookmark, I cannot see the (tm) sign. Does anyone have any 
idea of how to get this site to be saved with the name of the company?
[/snip]

Use the html special character for the TM...I think it is #174;

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] session

2006-04-26 Thread Sichta, Daniel
Here is application flow
Index.php = login page, I need to start session here. From here
(successful login) I'm going to admin.php which is 
Frameset page with source pages.

DS

-Original Message-
From: chris smith [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 26, 2006 4:02 PM
To: Sichta, Daniel
Cc: php-general@lists.php.net
Subject: Re: [PHP] session

On 4/26/06, Sichta, Daniel [EMAIL PROTECTED] wrote:

 -Original Message-
 From: chris smith [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 26, 2006 2:18 PM
 To: Sichta, Daniel
 Cc: php-general@lists.php.net
 Subject: Re: [PHP] session

 On 4/26/06, Sichta, Daniel [EMAIL PROTECTED] wrote:
  Hi there !!
 
  I have web app which using frames. After session timeout my session
is
  killed.
  The problem is that session is killed even when I doing requests to
 the
  server.
  I know why (session is chain to the frameset page) but what's the
  solution for this?

 Do you have session_start at the top of every page?
 A:Yes I do !

 Does it happen on certain pages?
 A:On every page !!

 Does it happen when you perform a particular action?
 A:No !! On any action

 We need a lot more info about what's going on.
 A: I have declared framesets in index.php and after that I'm sending
 request from frameset source pages.
 This is (IMHO)

Where's the rest of the sentence?

Always CC the list. You will get more people looking at your
questions/answers and you will most likely get a quicker response.

Can you explicitly pass the sessionid across:

  FRAMESET rows=100, 200
  FRAME src=blah1.php?session_id=?php echo SID; ?
  FRAME src=blah2.php?session_id=?php echo SID; ?
  /FRAMESET

?

Sounds like you're missing something really basic if you're having
issues with every page. Post some code in pastebin.com and send us the
url so we can see what you're doing..

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] bookmarking with a trademark sign in title

2006-04-26 Thread chris smith
On 4/26/06, Angelo Zanetti [EMAIL PROTECTED] wrote:
 Hi all,

 This might be slightly OT but it is related to a PHP project.
 I have a link on the site Im developing to bookmark the site. The title is 
 XYZ company™ but when the add bookmark window comes up for saving the 
 bookmark, I cannot see the ™ sign. Does anyone have any
 idea of how to get this site to be saved with the name of the company?

There are a couple of different ways to print the TM..

http://www.w3schools.com/tags/ref_entities.asp

If that doesn't work, I guess you're stuck..

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread nicolas figaro

Mauricio Pellegrini a écrit :

$quer1 = SET @var1=3 ;
SELECt * from table1 Where [EMAIL PROTECTED]  ;


This gave a syntax error from MySQL inmmediately before the ;
(semicolon),

  

did you try to run the query above

( SET @var1=3 ; SELECt * from table1 Where [EMAIL PROTECTED] )

directly from a mysql client ?
perhaps the @ is interpreted and you have to put a \ before it.
try a print $quer1 once $quer1 is set.

Please any help greatefully appreciated

Thanks 
Mauricio 

  
  



Yes, I need to do it exactly this way.
I mean , SET the value for the variable @var1 first.
Then execute an undefined number of querys that reference this variable
and its value.

Thanks 
Mauricio


  


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] session

2006-04-26 Thread chris smith
On 4/27/06, Sichta, Daniel [EMAIL PROTECTED] wrote:
 Here is application flow
 Index.php = login page, I need to start session here. From here
 (successful login) I'm going to admin.php which is
 Frameset page with source pages.

That's nice.. but doesn't help us. We need to see code.

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] session

2006-04-26 Thread Sichta, Daniel
Login.php
?
// starting session here
require_once(include/init.inc);
?
table height=100% width=100% align=center cellpadding=2
cellspacing=0
tr
td align=rightUser/td
tdinput type=text name=loginUser/td
/tr
tr
td align=rightPasswrod/td
tdinput type=password name=loginPassword/td
/tr
tr
td/td
tdinput type=submit name=submit
value=?=$login[login_submit];?/td
/tr
/table
Login.php
?
// starting session here
require_once(include/init.inc);
Here is code for checking user and password
And if is ok do this
?
script type=text/javascript language=javascript
window.location.href = admin.php;
/script
?
}
Admin.php
?
require_once(include/init.inc);
require_once(include/check.inc);
?
html

frameset framespacing=0 border=false frameborder=0
cols=180,*
frame name=tree src=menu.php frameborder=0
marginwidth=0 marginheight=0 framespacing=0 scrolling=no
noresize
frame name=master src=blank.html frameborder=0
marginwidth=0 marginheight=0 framespacing=0 scrolling=auto
noresize
/frameset
noframes
body bgcolor=#FF
brbrcenter
h1No Frames!/h1
h4No frames in your browser!/h4
/center/body
/noframes

/html
And for example in menu.php I'm using
require_once(include/init.inc);

DS
-Original Message-
From: chris smith [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 26, 2006 4:10 PM
To: Sichta, Daniel
Cc: php-general@lists.php.net
Subject: Re: [PHP] session

On 4/27/06, Sichta, Daniel [EMAIL PROTECTED] wrote:
 Here is application flow
 Index.php = login page, I need to start session here. From here
 (successful login) I'm going to admin.php which is
 Frameset page with source pages.

That's nice.. but doesn't help us. We need to see code.

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] session

2006-04-26 Thread chris smith
On 4/27/06, Sichta, Daniel [EMAIL PROTECTED] wrote:
 Login.php
 ?
 // starting session here
 require_once(include/init.inc);

and what's in that file - only the session related stuff.

If you pass the sessionid across does it work:


frame name=tree src=menu.php?session_id=?php echo SID; ?


--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
On Wed, 2006-04-26 at 11:04, chris smith wrote:
 On 4/26/06, Mauricio Pellegrini [EMAIL PROTECTED] wrote:
  On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
   Mauricio Pellegrini a écrit :
Hi all
   
I'm trying to execute two querys and they execute perfectly in fact,
but after the execution of the first query there suposed to be some
variable setted to a certain value.
   
The problem is this variable is not available at the time the second
query runs.
   
I`ll try to explain a little bit further
   
//This is my first query
   
$quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
mysql_query($quer1);
   
// This is query #2
   
$query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 
doesn`t
exist
 
 If you try this through a mysql console or through something like
 phpmyadmin does it work?

Yes, It works perfectly!.

From Mysql console or MysqlCC or EMS MySQLmanager


 --
 Postgresql  php tutorials
 http://www.designmagick.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
On Wed, 2006-04-26 at 11:09, nicolas figaro wrote:
 Mauricio Pellegrini a écrit :
  $quer1 = SET @var1=3 ;
SELECt * from table1 Where [EMAIL PROTECTED]  ;
 
 
  This gave a syntax error from MySQL inmmediately before the ;
  (semicolon),
 



 did you try to run the query above
 
 ( SET @var1=3 ; SELECt * from table1 Where [EMAIL PROTECTED] )
 
 directly from a mysql client ?

Yes, I did and it Works perfectly.


 perhaps the @ is interpreted and you have to put a \ before it.
 try a print $quer1 once $quer1 is set.

I've tried this too. The output is sintactically correct.
I even copied the output of the query and pasted it to Mysqlcc an
executed it perfectly.



A few minutes ago I found that mysql_query() cannot execute more than
one query at a time 
so the form mysql_query(SET @var1=3 ; SELECT * from ) is invalid 


But the other way should work

Thanks 
Mauricio


  Please any help greatefully appreciated
 
  Thanks 
  Mauricio 
 


 
 
  Yes, I need to do it exactly this way.
  I mean , SET the value for the variable @var1 first.
  Then execute an undefined number of querys that reference this variable
  and its value.
 
  Thanks 
  Mauricio
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] bookmarking with a trademark sign in title

2006-04-26 Thread Satyam
The problem usually is that many of the 'things' surrounding the main window 
of the browser do not understand HTML and its special characters.   The 
favorites or history lists are often one of them.  Most have solved the 
rendering of the title but not all.


If your target is mainly Windows clients, the best option is using 
iso-8859-1 as the character set and use the native windows trademark symbol. 
In that way, your browser main window will understand it as per the 
character encoding, and windows itself will also understand it for the rest 
of the controls where the internal windows character set is used.


Satyam



- Original Message - 
From: chris smith [EMAIL PROTECTED]

To: Angelo Zanetti [EMAIL PROTECTED]
Cc: PHP List php-general@lists.php.net
Sent: Wednesday, April 26, 2006 4:09 PM
Subject: Re: [PHP] bookmarking with a trademark sign in title


On 4/26/06, Angelo Zanetti [EMAIL PROTECTED] wrote:

Hi all,

This might be slightly OT but it is related to a PHP project.
I have a link on the site Im developing to bookmark the site. The title is 
XYZ company™ but when the add bookmark window comes up for saving the 
bookmark, I cannot see the ™ sign. Does anyone have any

idea of how to get this site to be saved with the name of the company?


There are a couple of different ways to print the TM..

http://www.w3schools.com/tags/ref_entities.asp

If that doesn't work, I guess you're stuck..

--
Postgresql  php tutorials
http://www.designmagick.com/

--
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



RE: [PHP] Re: Php function to Set focus On A form Field

2006-04-26 Thread Ing. Edwin Cruz
Or if you have header.inc.php and the body tag is global then in your
form.inc.php(for example) or in your template, you can do this:

script
Window.onLoad=function(){
document.nameform.inputField.focus();
}
/script



Regards!



-Mensaje original-
De: Philipp Kopf [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 26 de Abril de 2006 01:42 a.m.
Para: php-general@lists.php.net
Asunto: [PHP] Re: Php function to Set focus On A form Field


marvin hunkin schrieb:
 Hi.
 is there any php or java script function, where i can embed into my 
 php
 or html file, to set focus on to the first form field, like a text box, 
 to go to that field first, and not to go to the link or button first.
 if there are any tips, tricks, or links or code examples, how to fix 
 this problem.
 let me know.
 cheers Marvin.

Hi.

It is not possible to do that using PHP but you can use JavaScript 
instead. I recommend the function focus(). For example:
BODY OnLoad=document.nameform.user.focus();

Check this tiny tutorial: 
http://javascript.internet.com/page-details/focus-onload.html

Did you already remarked that http://www.google.com is using this 
function to automatically set the focus on the search field.

regards

Philipp

-- 
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



RE: [PHP] PHP 5 + Apache 2 on Windows: ms sql extension problem

2006-04-26 Thread Ing. Edwin Cruz
Try changing your direcive extension_dir:
extension_dir=C:/PHP/ext  instead of extension_dir=C:\PHP\ext




-Mensaje original-
De: Laszlo Nagy [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 26 de Abril de 2006 04:01 a.m.
Para: php-general@lists.php.net
Asunto: [PHP] PHP 5 + Apache 2 on Windows: ms sql extension problem



 Hello All,

I had a problem with a Win2003 server, IIS6 and PHP 5.1.2. The MS SQL 
extension was not working. I did not get an answer, but some people 
suggested me to use Apache. Now I installed Win 2000 server, Apache 
2.0.55 and PHP 5.1.2. The same computer has Microsoft SQL Server 
installed. I have only these lines in my php.ini file:

extension_dir=C:\PHP\ext
extension=php_mssql.dll

I checked phpinfo() and it tells that my php.ini file is at the correct 
location (C:\winnt\php.ini.) I can load other extensions. Another 
example: if I add php_curl.dll then I get a libsleay32.dll not found 
error message when I try to restart apache. But I do not get any error 
message about the php_mssql.dll. It is just not loaded. I'm sure that 
all the ms sql client libs are installed, because this is the same 
machine where the ms sql server is running. What can be the problem? 
Please help me. My bosses are killing me because I could not solve this 
problem for weeks. :-(

Thanks,

  Laszlo

-- 
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



Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
On Wed, 2006-04-26 at 11:04, chris smith wrote:
 On 4/26/06, Mauricio Pellegrini [EMAIL PROTECTED] wrote:
  On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
   Mauricio Pellegrini a écrit :
Hi all
   
I'm trying to execute two querys and they execute perfectly in fact,
but after the execution of the first query there suposed to be some
variable setted to a certain value.
   
The problem is this variable is not available at the time the second
query runs.
   
I`ll try to explain a little bit further
   
//This is my first query
   
$quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
mysql_query($quer1);
   
// This is query #2
   
$query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 
doesn`t
exist
 
 If you try this through a mysql console or through something like
 phpmyadmin does it work?
 

Yes, it works.

 --
 Postgresql  php tutorials
 http://www.designmagick.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Using linkDisplayFields of FormBuilder

2006-04-26 Thread Joe Henry
On Tuesday 25 April 2006 4:36 pm, Tom wrote:
  instead we recommend emailing
 [EMAIL PROTECTED] where you are more likely to get answer.

You found the PHP-general list instead of the Pear-general list. Here's a link 
to the Pear mailing list page:

http://pear.php.net/support/lists.php

HTH
-- 
Joe Henry
www.celebrityaccess.com
[EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys

2006-04-26 Thread Martin Alterisio
You should be able to do this in two calls to the mysql_query() function.
mysql_query(SET @var1=3);
mysql_query(SELECT * from table1 Where [EMAIL PROTECTED]);

2006/4/26, Mauricio Pellegrini [EMAIL PROTECTED]:

 Hi all

 I'm trying to execute two querys and they execute perfectly in fact,
 but after the execution of the first query there suposed to be some
 variable setted to a certain value.

 The problem is this variable is not available at the time the second
 query runs.

 I`ll try to explain a little bit further

 //This is my first query

 $quer1= SET @var1=3 ;//Here I`m suposed to set the value for var1 to 3
 mysql_query($quer1);

 // This is query #2

 $query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1 doesn`t
 exist


 That wasn't really my first attempt. Originally
 I've tryied the whole thing in just one single query but mysql gave me
 an error message complinning about the semicolon

 Please look at this

 $quer1 = SET @var1=3 ;
 SELECt * from table1 Where [EMAIL PROTECTED]  ;


 This gave a syntax error from MySQL inmmediately before the ;
 (semicolon),


 Please any help greatefully appreciated

 Thanks
 Mauricio

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Debuggin PHP

2006-04-26 Thread hicham
Hello
 I'm a newbie in php world , and I'm trying to get a php 4 script work
on an php5 version
how do i debug php ? I get a blank page and nothing tells me what 's wrong ?

Thanks
hicham

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread John Nichel

hicham wrote:

Hello
 I'm a newbie in php world , and I'm trying to get a php 4 script work
on an php5 version
how do i debug php ? I get a blank page and nothing tells me what 's wrong ?

Thanks
hicham



Turn on error reporting.

--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Jochem Maas

hicham wrote:

Hello
 I'm a newbie in php world , and I'm trying to get a php 4 script work
on an php5 version
how do i debug php ? I get a blank page and nothing tells me what 's wrong ?


the hard way:
install and use Xdebug.

easy way 1:
buy a copy of Zend Studio, again install on the server part on your
server (which is automated if your development machine is your local 
machine)
- much simpler to setup than Xdebug and very easy to use.

easy way 2:
use lots of echo()/var_dump()/print_r() in your code to figure out
where it's breaking.

NB: turn on error_reporting to full:

ini_set('error_reporting', E_ALL | E_STRICT);

NB: turn on diplay_errors (or find your php or apache log, it depends,
and learn how to 'tail' it to what what if any errors are occuring)

ini_set('diplay_errors', 1);



Thanks
hicham



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Martin Alterisio
2006/4/26, John Nichel [EMAIL PROTECTED]:

 hicham wrote:
  Hello
   I'm a newbie in php world , and I'm trying to get a php 4 script work
  on an php5 version
  how do i debug php ? I get a blank page and nothing tells me what 's
 wrong ?
 
  Thanks
  hicham
 

 Turn on error reporting.

 --
 John C. Nichel IV
 Programmer/System Admin (ÜberGeek)
 Dot Com Holdings of Buffalo
 716.856.9675
 [EMAIL PROTECTED]


error_reporting(E_ALL);
at the beggining of your script

or

modify your php.ini


Re: [PHP] How to execute multiples querys

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 10:36, Mauricio Pellegrini wrote:
 On Wed, 2006-04-26 at 11:09, nicolas figaro wrote:
  Mauricio Pellegrini a écrit :
   $quer1 = SET @var1=3 ;
   SELECt * from table1 Where [EMAIL PROTECTED]  ;
  
  
   This gave a syntax error from MySQL inmmediately before the ;
   (semicolon),
  
 
 
 
  did you try to run the query above
  
  ( SET @var1=3 ; SELECt * from table1 Where [EMAIL PROTECTED] )
  
  directly from a mysql client ?
 
 Yes, I did and it Works perfectly.
 
 
  perhaps the @ is interpreted and you have to put a \ before it.
  try a print $quer1 once $quer1 is set.
 
 I've tried this too. The output is sintactically correct.
 I even copied the output of the query and pasted it to Mysqlcc an
 executed it perfectly.
 
 
 
 A few minutes ago I found that mysql_query() cannot execute more than
 one query at a time 
 so the form mysql_query(SET @var1=3 ; SELECT * from ) is invalid 
 
 
 But the other way should work

Try explicitly retrieving a resource ID from mysql_connect, and
explictly use that resource when making the query. Probably not the
problem, but sounds like something is being lost from one query to
another.

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 12:44, Jochem Maas wrote:
 hicham wrote:

 easy way 2:
   use lots of echo()/var_dump()/print_r() in your code to figure out
   where it's breaking.

If you're trying to track down an error using this technique (by far one
of the most popular techniques and time tested), be sure and use your
knowledge of binary search algorithms to speed up your search. Applying
the heuristic of guessing approximately where it's occurring will help
you greatly also :) This kind of technique though is mostly only
necessary when PHP does something stupid like segfault *grin*. Another
fantastic technique is if you know the error occurs at a specific
location, but don't know how the heck the script got there... you can
use debug_backtrace().

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How to execute multiples querys,IT is SOLVED!!

2006-04-26 Thread Mauricio Pellegrini
On Wed, 2006-04-26 at 13:07, Martin Alterisio wrote:
 You should be able to do this in two calls to the mysql_query()
 function.
 mysql_query(SET @var1=3);
 mysql_query(SELECT * from table1 Where [EMAIL PROTECTED]);
It worked this way!

It seems I musta had some other problem somewhere else thank you

Thank you all
MAuricio

 
 2006/4/26, Mauricio Pellegrini [EMAIL PROTECTED]:
 Hi all
 
 I'm trying to execute two querys and they execute perfectly in
 fact,
 but after the execution of the first query there suposed to be
 some
 variable setted to a certain value.
 
 The problem is this variable is not available at the time the
 second 
 query runs.
 
 I`ll try to explain a little bit further
 
 //This is my first query
 
 $quer1= SET @var1=3 ;//Here I`m suposed to set the value for
 var1 to 3
 mysql_query($quer1);
 
 // This is query #2 
 
 $query2=SELECT * from table1 where [EMAIL PROTECTED] //Here @var1
 doesn`t
 exist
 
 
 That wasn't really my first attempt. Originally
 I've tryied the whole thing in just one single query but mysql
 gave me 
 an error message complinning about the semicolon
 
 Please look at this
 
 $quer1 = SET @var1=3 ;
 SELECt * from table1 Where [EMAIL PROTECTED]  ;
 
 
 This gave a syntax error from MySQL inmmediately before the
 ; 
 (semicolon),
 
 
 Please any help greatefully appreciated
 
 Thanks
 Mauricio
 
 --
 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



Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
On Wed, 2006-04-26 at 13:48, Robert Cummings wrote:
 On Wed, 2006-04-26 at 10:36, Mauricio Pellegrini wrote:
  On Wed, 2006-04-26 at 11:09, nicolas figaro wrote:
   Mauricio Pellegrini a écrit :
$quer1 = SET @var1=3 ;
  SELECt * from table1 Where [EMAIL PROTECTED]  ;
   
   
This gave a syntax error from MySQL inmmediately before the ;
(semicolon),
   
  
  
  
   did you try to run the query above
   
   ( SET @var1=3 ; SELECt * from table1 Where [EMAIL PROTECTED] )
   
   directly from a mysql client ?
  
  Yes, I did and it Works perfectly.
  
  
   perhaps the @ is interpreted and you have to put a \ before it.
   try a print $quer1 once $quer1 is set.
  
  I've tried this too. The output is sintactically correct.
  I even copied the output of the query and pasted it to Mysqlcc an
  executed it perfectly.
  
  
  
  A few minutes ago I found that mysql_query() cannot execute more than
  one query at a time 
  so the form mysql_query(SET @var1=3 ; SELECT * from ) is invalid 
  
  
  But the other way should work
 
 Try explicitly retrieving a resource ID from mysql_connect, and
 explictly use that resource when making the query. Probably not the
 problem, but sounds like something is being lost from one query to
 another.
Thank you that's true.
Theres another module in the middle and that is getting only the last
query

Thanks to all
Mauricio

 
 Cheers,
 Rob.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Jochem Maas

Robert Cummings wrote:

On Wed, 2006-04-26 at 12:44, Jochem Maas wrote:


hicham wrote:




easy way 2:
use lots of echo()/var_dump()/print_r() in your code to figure out
where it's breaking.



If you're trying to track down an error using this technique (by far one
of the most popular techniques and time tested), be sure and use your
knowledge of binary search algorithms to speed up your search. Applying
the heuristic of guessing approximately where it's occurring will help


that'll be the old 'put the first debug echo in the middle of the
script technique :-)


you greatly also :) This kind of technique though is mostly only
necessary when PHP does something stupid like segfault *grin*. Another
fantastic technique is if you know the error occurs at a specific
location, but don't know how the heck the script got there... you can
use debug_backtrace().


very good tips!



Cheers,
Rob.


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] (Apache|php) Bug using modproxy

2006-04-26 Thread Jochem Maas



Lmwangi wrote:

Hi all,
 First time on the list... sorry for any errs.
 I am using mod_proxy to pass requests to an internal server in our
lan. The setup looks like

Enduser---INet_link-Mod_proxy_serverLan---PHP_script

Now,

this  does not work:

Enduser---https---Apache_mod_proxy-http---Destination_server.

* When a user submits a form (php) with a file upload and  $_POST
vars, the $_POST array is mangled (missing) elements and the $_FILES
array is empty

while this works:

 Enduser---http---Apache_mod_proxy-http---Destination_server.


almost definitely not a php problem - maybe using ProxyPass instead of
mod_proxy would work (probably requires https connection on the destination
server) - personally I have used Squid as a reverse proxy for this kind of
setup and let it deal with the https--http conversion - it works but if you
think the Apache stuff is voodoo then I need a new name for the Squid 
configuration
stuff ;-)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Eric Butera
On 4/26/06, hicham [EMAIL PROTECTED] wrote:

 Hello
 I'm a newbie in php world , and I'm trying to get a php 4 script work
 on an php5 version
 how do i debug php ? I get a blank page and nothing tells me what 's wrong
 ?

 Thanks
 hicham

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


(Assuming you're on *nix)

One thing I always do when I'm developing is to locate the error log that
PHP writes to.  You can find it by looking at error_log in php.ini or find
where Apache writes errors to.  Then I just tail -f that so that I can see
any errors including parse errors that just give you that no-ouput white
screen.  As others have mentioned always keep error_reporting to E_ALL.


Re: [PHP] (Apache|php) Bug using modproxy

2006-04-26 Thread Oscar Gosdinski
I have the configuration you described:

browser -- https- mod_proxy - http - php

and i don't have any problem with it. Maybe it's an Apache
misconfiguration. Can you send a snap of your httpd.conf?

On 4/26/06, Lmwangi [EMAIL PROTECTED] wrote:
 Hi all,
  First time on the list... sorry for any errs.
  I am using mod_proxy to pass requests to an internal server in our
 lan. The setup looks like

 Enduser---INet_link-Mod_proxy_serverLan---PHP_script

 Now,

 this  does not work:

 Enduser---https---Apache_mod_proxy-http---Destination_server.

 * When a user submits a form (php) with a file upload and  $_POST
 vars, the $_POST array is mangled (missing) elements and the $_FILES
 array is empty


--
Saludos
Oscar

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Sameer N Ingole

Robert Cummings wrote:

On Wed, 2006-04-26 at 12:44, Jochem Maas wrote:
  

hicham wrote:

easy way 2:

use lots of echo()/var_dump()/print_r() in your code to figure out
where it's breaking.



If you're trying to track down an error using this technique (by far one
of the most popular techniques and time tested), be sure and use your
knowledge of binary search algorithms to speed up your search. Applying
the heuristic of guessing approximately where it's occurring will help
you greatly also :) This kind of technique though is mostly only
necessary when PHP does something stupid like segfault *grin*.
Most of the times it is true, however, sometimes everything just fails. 
Apache continues to give segfaults on running a specific PHP script, 
which do don't find until you look into error logs of apache. Then you 
try to generate backtrace using gdb. All this while, on every try 
Apache+PHP keeps crashing on you.


gdb backtrace too does not help much. So finally you compile bare bones 
apache+php and Voila! Everything works just fine.. From there, you go on 
adding one module per compilation to find the defaulter module and run 
/that/ PHP script after every compile to see if it crashes. And after a 
few compiles you find an Apache module to be a real culprit.


--
Sameer N. Ingole
Blog: http://weblogic.noroot.org/
---
Better to light one candle than to curse the darkness.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 14:51, Sameer N Ingole wrote:
 Robert Cummings wrote:
  On Wed, 2006-04-26 at 12:44, Jochem Maas wrote:

  hicham wrote:
  
  easy way 2:
 use lots of echo()/var_dump()/print_r() in your code to figure out
 where it's breaking.
  
 
  If you're trying to track down an error using this technique (by far one
  of the most popular techniques and time tested), be sure and use your
  knowledge of binary search algorithms to speed up your search. Applying
  the heuristic of guessing approximately where it's occurring will help
  you greatly also :) This kind of technique though is mostly only
  necessary when PHP does something stupid like segfault *grin*.
 Most of the times it is true, however, sometimes everything just fails. 
 Apache continues to give segfaults on running a specific PHP script, 
 which do don't find until you look into error logs of apache. Then you 
 try to generate backtrace using gdb. All this while, on every try 
 Apache+PHP keeps crashing on you.
 
 gdb backtrace too does not help much. So finally you compile bare bones 
 apache+php and Voila! Everything works just fine.. From there, you go on 
 adding one module per compilation to find the defaulter module and run 
 /that/ PHP script after every compile to see if it crashes. And after a 
 few compiles you find an Apache module to be a real culprit.

I use binary search for module seg faults also when the module is
unknown :) Also for segfaults, the error log (or just plain run from
CGI) can be handy to see your output before the crash.

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Jay Blanchard
Pub,

Thank you for subscribing to and participating in the PHP users list, a
place where your PHP questions can be answered. Unfortunately your last
post contained several problems;

a. It was to long.
2. it was a JavaScript question.

Thank you,

Jay

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP Script to open phpBB2 accounts

2006-04-26 Thread Jochem Maas

Richard Lynch wrote:

...

A general Google for search terms likely to contain what you need. 
This often requires several tries and some finesse on input for terms

as common as phpBB and forum but an attempt must be made, even if
you're sure it will be fruitless...  Cuz Google is goddamned smart
sometimes. :-)


in the immortal words of the guy that got the whole php ball rolling:
of course you should be using Yahoo!



If we tried to answer all the questions for all the monstrosities of
software written in PHP (e.g. phpBB), we'd be in real trouble...

This list gets enough traffic as it is -- and some of that is
admittedly my fault :-)


only some heh? ;-)





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Jochem Maas

Jay Blanchard wrote:

Pub,

Thank you for subscribing to and participating in the PHP users list, a
place where your PHP questions can be answered. Unfortunately your last
post contained several problems;

a. It was to long.
2. it was a JavaScript question.

Thank you,

Jay


lol - that was almost perfect... you missed an 'o' ;-)





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] (Apache|php) Bug using modproxy

2006-04-26 Thread Jochem Maas

Lmwangi wrote:

Ok thanx. Let me try squid I have posted the mail on the apache
list.. Oh and btw i downgrade my rank. Its no longer voodoo.. So don't
go looking for new name ;-)


ah good - have fun with Squid - but beware it has more arms than you to fight 
with ;-)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Jay Blanchard
[snip]
lol - that was almost perfect... you missed an 'o' ;-)
[/snip]

I am allowed a missed 'o' as I am on the bus (and have been for almost
24 hours) chaperoning a high school band trip to Florida. :) 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread John Nichel

Pub wrote:

Hello,

I would really appreciate some help.



Then ask a php question.

--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP Script to open phpBB2 accounts

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 16:07, Jochem Maas wrote:
 Richard Lynch wrote:
 
 ...
 
  A general Google for search terms likely to contain what you need. 
  This often requires several tries and some finesse on input for terms
  as common as phpBB and forum but an attempt must be made, even if
  you're sure it will be fruitless...  Cuz Google is goddamned smart
  sometimes. :-)
 
 in the immortal words of the guy that got the whole php ball rolling:
   of course you should be using Yahoo!

Words only last as long as the medium upon which they are encoded... and
that includes brains -- unless of course there is an afterlife, but
arguing unprovable ideas is as futile as me saying that I can fly, but
only when nothing is looking *haha*. Undoubtedly immortal is an
exaggeration. Additionally, one's ability to create and advance software
does not necessarily lend to ones advertising credibility -- especially
when one is affiliated with said product/service/company. You are
however quite welcome to grovel before anyone you please, whether they
want you to or not.

  If we tried to answer all the questions for all the monstrosities of
  software written in PHP (e.g. phpBB), we'd be in real trouble...
  
  This list gets enough traffic as it is -- and some of that is
  admittedly my fault :-)
 
 only some heh? ;-)

Ahh but it's good traffic :)

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Stut

Jay Blanchard wrote:

[snip]
lol - that was almost perfect... you missed an 'o' ;-)
[/snip]

I am allowed a missed 'o' as I am on the bus (and have been for almost
24 hours) chaperoning a high school band trip to Florida. :) 


This one time, at band camp, I wrote an email to the PHP-General mailing 
list.


Doesn't quite work :(

-Stut

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Hosting php help

2006-04-26 Thread Jesús Alain Rodríguez Santos
Please I need a free hosting with php and mysql, and sendmail active.
If you know any site, please send to me the address.

-- 
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.



RE: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Warren Vail
This brings up a reoccurring issue for me and I'd be interested if anyone
else has given it any thought.  

PHP appears to me to be incomplete unless it can provide a way to provide
client (browser) side executables in a consistent language, namely PHP.
Developers get all excited about the elegence of the PHP language, and
somewhere along the way they discover they have been sandbagged (they have
to learn Javascipt too, if they want responsive GUI's).

One solution would be to develop a PHP Plugin and support that for all the
browsers out there, but another just occurred to me.  What if there was a
function that accepted PHP code as input and tranlated it to Javascript,
returning the resulting text ready for imbedding in html?

Any creative masochists out there?  Has it already been attempted?

Warren Vail

-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 26, 2006 1:07 PM
To: Pub; php-general@lists.php.net
Subject: RE: [PHP] New Help with Javascript Navigation

Pub,

Thank you for subscribing to and participating in the PHP users list, a
place where your PHP questions can be answered. Unfortunately your last post
contained several problems;

a. It was to long.
2. it was a JavaScript question.

Thank you,

Jay

--
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



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Evan Priestley
Tell you what: write file_get_contents() in Javascript, and I'll  
write the rest of it.


Evan

On Apr 26, 2006, at 4:36 PM, Warren Vail wrote:

This brings up a reoccurring issue for me and I'd be interested if  
anyone

else has given it any thought.

PHP appears to me to be incomplete unless it can provide a way to  
provide
client (browser) side executables in a consistent language, namely  
PHP.

Developers get all excited about the elegence of the PHP language, and
somewhere along the way they discover they have been sandbagged  
(they have

to learn Javascipt too, if they want responsive GUI's).

One solution would be to develop a PHP Plugin and support that for  
all the
browsers out there, but another just occurred to me.  What if there  
was a
function that accepted PHP code as input and tranlated it to  
Javascript,

returning the resulting text ready for imbedding in html?

Any creative masochists out there?  Has it already been attempted?

Warren Vail

-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 1:07 PM
To: Pub; php-general@lists.php.net
Subject: RE: [PHP] New Help with Javascript Navigation

Pub,

Thank you for subscribing to and participating in the PHP users  
list, a
place where your PHP questions can be answered. Unfortunately your  
last post

contained several problems;

a. It was to long.
2. it was a JavaScript question.

Thank you,

Jay

--
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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Natural order of things.

2006-04-26 Thread tedd

Hi gang:

I posted the following question to the MySQL list, but the only 
answer I received thus far was a php solution (it didn't work for 
what I wanted).


As such, maybe if I post a MySQL question to the PHP group, then I'll 
receive a MySQL answer -- so here goes:


I'm using the following query, and it works.

SELECT id, title, url_image_small
FROM $dbtable
WHERE type=type_title
ORDER BY title
LIMIT $offset, $rowsPerPage

But, it sorts stuff like this:

Basel Square 1
Basel Square 10
Basel Square 11
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9

What do I have to change to get it (the query) to sort like this:

Basel Square 1
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9
Basel Square 10
Basel Square 11

Thanks in advance for any answers/suggestions

tedd
--

http://sperling.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] php_gd2.dll not found

2006-04-26 Thread Ari Davidow
I am thoroughly confused.

 

I am working on a Windows XP box.

I have just upgraded my dev environment to Apache 2 (2.0.55, where
it was), php 5.1.2 (PHP 5.1.2 zip
http://www.php.net/get/php-5.1.2-Win32.zip/from/a/mirror
package), MySQL 5.0.20a.

 

Anomaly 1:

I carefully navigated the MySQL mess, got the required DLLs into
my /ext folder, noted where extensions are found in php.ini,
uncommented the lines to load mysql and php_gd2. MySQL drivers
load fine, so I am uncommented correctly and have correctly
designated the folder where extensions are to be found. I continue
to get a message that php_gd2 is not found. The message lists the
correct path and directory, so I have to suspect that this
particular php_gd2 does not work, does not work with php5, or has
otherwise gotten munged:

 

 PHP Startup: Unable to load dynamic library
'c:\php\ext\php_gd2.dll' - The specified procedure could not be
found.

 

I have tried also adding the php_gd2.dll file to the
WINDOWS\system32 folder, as well. Makes no difference, so I have
removed those files.

 

Anomaly 2:

When I do a phpinfo(); to see what is actually loaded (and to
ensure that the correct php.ini is being loaded, etc.), among the
info is the notice that I am using php 5.0.3-dev. I get the same
info when I telnet to localhost.

 

What might I be doing wrong? Is there a patch for php_gd2.dll that
I have missed? Have I somehow downloaded the wrong php version, or
could something simply have gotten corrupted?

 

Thanks,

Ari

 



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 16:47, Evan Priestley wrote:
 Tell you what: write file_get_contents() in Javascript, and I'll  
 write the rest of it.

I hope you're not going to welch!!

?php NOT;

function file_get_contents( path )
{
return ijinn_getContent( path );
}

function ijinn_getContent( path )
{
var content = false;

path = ijinn_localizePath( path );

if( navigator.appName == 'Microsoft Internet Explorer' )
{
httpRequest = new ActiveXObject( 'Microsoft.XMLHTTP' );
}
else
{   
httpRequest = new XMLHttpRequest();
}

httpRequest.open( 'get', path, false );
httpRequest.send( null );

if( httpRequest.status == 200 )
{
content = httpRequest.responseText;
}

return content;
}

?

Unfortunately, you're going to have a HELL of a time with dynamically
include()'ing source :)

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Natural order of things.

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 16:51, tedd wrote:
 Hi gang:
 
 I posted the following question to the MySQL list, but the only 
 answer I received thus far was a php solution (it didn't work for 
 what I wanted).
 
 As such, maybe if I post a MySQL question to the PHP group, then I'll 
 receive a MySQL answer -- so here goes:
 
 I'm using the following query, and it works.
 
 SELECT id, title, url_image_small
 FROM $dbtable
 WHERE type=type_title
 ORDER BY title
 LIMIT $offset, $rowsPerPage
 
 But, it sorts stuff like this:
 
 Basel Square 1
 Basel Square 10
 Basel Square 11
 Basel Square 2
 Basel Square 3
 Basel Square 4
 Basel Square 5
 Basel Square 6
 Basel Square 7
 Basel Square 8
 Basel Square 9
 
 What do I have to change to get it (the query) to sort like this:
 
 Basel Square 1
 Basel Square 2
 Basel Square 3
 Basel Square 4
 Basel Square 5
 Basel Square 6
 Basel Square 7
 Basel Square 8
 Basel Square 9
 Basel Square 10
 Basel Square 11
 
 Thanks in advance for any answers/suggestions

You need ot perform a type conversion from string to integer.

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Natural order of things.

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 16:57, Robert Cummings wrote:
 On Wed, 2006-04-26 at 16:51, tedd wrote:
  Hi gang:
  
  I posted the following question to the MySQL list, but the only 
  answer I received thus far was a php solution (it didn't work for 
  what I wanted).
  
  As such, maybe if I post a MySQL question to the PHP group, then I'll 
  receive a MySQL answer -- so here goes:
  
  I'm using the following query, and it works.
  
  SELECT id, title, url_image_small
  FROM $dbtable
  WHERE type=type_title
  ORDER BY title
  LIMIT $offset, $rowsPerPage
  
  But, it sorts stuff like this:
  
  Basel Square 1
  Basel Square 10
  Basel Square 11
  Basel Square 2
  Basel Square 3
  Basel Square 4
  Basel Square 5
  Basel Square 6
  Basel Square 7
  Basel Square 8
  Basel Square 9
  
  What do I have to change to get it (the query) to sort like this:
  
  Basel Square 1
  Basel Square 2
  Basel Square 3
  Basel Square 4
  Basel Square 5
  Basel Square 6
  Basel Square 7
  Basel Square 8
  Basel Square 9
  Basel Square 10
  Basel Square 11
  
  Thanks in advance for any answers/suggestions
 
 You need ot perform a type conversion from string to integer.

Sorry, just realized... Basel Square is part of the entry in the table
:/ Do you have entries that aren't prefixed with Basel Square?

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Natural order of things.

2006-04-26 Thread Stut

tedd wrote:

SELECT id, title, url_image_small
FROM $dbtable
WHERE type=type_title
ORDER BY title
LIMIT $offset, $rowsPerPage

But, it sorts stuff like this:

Basel Square 1
Basel Square 10
Basel Square 11
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9

What do I have to change to get it (the query) to sort like this:

Basel Square 1
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9
Basel Square 10
Basel Square 11


Never tried it mysql, but I am led to believe that sorting based on the 
result of the mysql SOUNDEX function may produce the results you want. 
Other than that, as far as I am aware there is no way to do this in 
MySQL without writing a stored procedure to do it.


-Stut

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Natural order of things.

2006-04-26 Thread tg-php
You could try separating out the number an formatting it with SQL and doing an 
ORDER BY on the post-processed number.  It doesn't have to appear in the SELECT 
columns portion to be able to use it in the ORDER BY section.


SELECT BookName, PageNum, Citation FROM BookQuotes ORDER BY LPAD(PageNum,4,'0');

You could also probably convert the number from a string to an actual number so 
it sorted numerically.

I think you get the idea.  Give it a try and let us know!  Then go back to the 
MySQL list and tell them how great PHP is.

-TG

= = = Original message = = =

Hi gang:

I posted the following question to the MySQL list, but the only 
answer I received thus far was a php solution (it didn't work for 
what I wanted).

As such, maybe if I post a MySQL question to the PHP group, then I'll 
receive a MySQL answer -- so here goes:

I'm using the following query, and it works.

SELECT id, title, url_image_small
FROM $dbtable
WHERE type=type_title
ORDER BY title
LIMIT $offset, $rowsPerPage

But, it sorts stuff like this:

Basel Square 1
Basel Square 10
Basel Square 11
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9

What do I have to change to get it (the query) to sort like this:

Basel Square 1
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9
Basel Square 10
Basel Square 11

Thanks in advance for any answers/suggestions

tedd
-- 

http://sperling.com



___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] php_gd2.dll not found

2006-04-26 Thread Richard Lynch
Are you sure you didn't mix-n-match your old DLLs from previous php
versions?

You can't do that...

On Wed, April 26, 2006 3:52 pm, Ari Davidow wrote:
 I am thoroughly confused.



 I am working on a Windows XP box.

 I have just upgraded my dev environment to Apache 2 (2.0.55, where
 it was), php 5.1.2 (PHP 5.1.2 zip
 http://www.php.net/get/php-5.1.2-Win32.zip/from/a/mirror
 package), MySQL 5.0.20a.



 Anomaly 1:

 I carefully navigated the MySQL mess, got the required DLLs into
 my /ext folder, noted where extensions are found in php.ini,
 uncommented the lines to load mysql and php_gd2. MySQL drivers
 load fine, so I am uncommented correctly and have correctly
 designated the folder where extensions are to be found. I continue
 to get a message that php_gd2 is not found. The message lists the
 correct path and directory, so I have to suspect that this
 particular php_gd2 does not work, does not work with php5, or has
 otherwise gotten munged:



  PHP Startup: Unable to load dynamic library
 'c:\php\ext\php_gd2.dll' - The specified procedure could not be
 found.



 I have tried also adding the php_gd2.dll file to the
 WINDOWS\system32 folder, as well. Makes no difference, so I have
 removed those files.



 Anomaly 2:

 When I do a phpinfo(); to see what is actually loaded (and to
 ensure that the correct php.ini is being loaded, etc.), among the
 info is the notice that I am using php 5.0.3-dev. I get the same
 info when I telnet to localhost.



 What might I be doing wrong? Is there a patch for php_gd2.dll that
 I have missed? Have I somehow downloaded the wrong php version, or
 could something simply have gotten corrupted?



 Thanks,

 Ari






-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] php_gd2.dll not found

2006-04-26 Thread tedd

At 4:52 PM -0400 4/26/06, Ari Davidow wrote:


I am thoroughly confused.

I am working on a Windows XP box.



A correlation, perhaps?  :-)

tedd

--

http://sperling.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Warren Vail
Evan,

Are you proposing something like AJAX does? My understanding is limited
here, so bear with me.  A control like a hidden imbedded frame (IFRAME) is
acted upon by Javascript to cause it to dynamically request loading a page
into the frame, and when loaded, the javascript processes the contents of
the frame without necessarily displaying it directly?
 
And then do the translation on the client?

Could work, but I was thinking more of doing the tranlation in a function in
PHP, but that may be because PHP is my perspective.  Something like;

--- snip --
Html stuff
?php echo scripttranslate(
Php code follows here Careful with quotes); ?
More html stuff
--- snip --

Or

--- snip --
Echo html stuff here
.scripttranslate(php stuff here...
. again carefull with quotes)
.more html stuff here);   // end of echo statement
--- snip --

Warren

-Original Message-
From: Evan Priestley [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 26, 2006 1:47 PM
To: Warren Vail
Cc: PHP General List
Subject: Re: [PHP] New Help with Javascript Navigation

Tell you what: write file_get_contents() in Javascript, and I'll write the
rest of it.

Evan

On Apr 26, 2006, at 4:36 PM, Warren Vail wrote:

 This brings up a reoccurring issue for me and I'd be interested if 
 anyone else has given it any thought.

 PHP appears to me to be incomplete unless it can provide a way to 
 provide client (browser) side executables in a consistent language, 
 namely PHP.
 Developers get all excited about the elegence of the PHP language, and 
 somewhere along the way they discover they have been sandbagged (they 
 have to learn Javascipt too, if they want responsive GUI's).

 One solution would be to develop a PHP Plugin and support that for all 
 the browsers out there, but another just occurred to me.  What if 
 there was a function that accepted PHP code as input and tranlated it 
 to Javascript, returning the resulting text ready for imbedding in 
 html?

 Any creative masochists out there?  Has it already been attempted?

 Warren Vail

 -Original Message-
 From: Jay Blanchard [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 26, 2006 1:07 PM
 To: Pub; php-general@lists.php.net
 Subject: RE: [PHP] New Help with Javascript Navigation

 Pub,

 Thank you for subscribing to and participating in the PHP users list, 
 a place where your PHP questions can be answered. Unfortunately your 
 last post contained several problems;

 a. It was to long.
 2. it was a JavaScript question.

 Thank you,

 Jay

 --
 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 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



Re: [PHP] Natural order of things.

2006-04-26 Thread Richard Lynch
Crude, but effective.

ORDER BY length(title) DESC, title

You may also need to make it be:

ORDER BY substring(title, 1, 10), length(title) DESC, title

so you can get them alphabetical to start off with (the first 10
chars) then by the length to hack the longer ones with multiple
digits at the end, then by title to get it in order within decimal
positions.

On Wed, April 26, 2006 3:51 pm, tedd wrote:
 Hi gang:

 I posted the following question to the MySQL list, but the only
 answer I received thus far was a php solution (it didn't work for
 what I wanted).

 As such, maybe if I post a MySQL question to the PHP group, then I'll
 receive a MySQL answer -- so here goes:

 I'm using the following query, and it works.

 SELECT id, title, url_image_small
 FROM $dbtable
 WHERE type=type_title
 ORDER BY title
 LIMIT $offset, $rowsPerPage

 But, it sorts stuff like this:

 Basel Square 1
 Basel Square 10
 Basel Square 11
 Basel Square 2
 Basel Square 3
 Basel Square 4
 Basel Square 5
 Basel Square 6
 Basel Square 7
 Basel Square 8
 Basel Square 9

 What do I have to change to get it (the query) to sort like this:

 Basel Square 1
 Basel Square 2
 Basel Square 3
 Basel Square 4
 Basel Square 5
 Basel Square 6
 Basel Square 7
 Basel Square 8
 Basel Square 9
 Basel Square 10
 Basel Square 11

 Thanks in advance for any answers/suggestions

 tedd
 --
 
 http://sperling.com

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] error message

2006-04-26 Thread cybermalandro cybermalandro
I have set in display_errors = off on my php.ini but I can still see ODBC
related error messages when I try to duplicate an ODBC error. Am I missing
something to turn this off?

Thanks!


Re: [PHP] Natural order of things.

2006-04-26 Thread tg-php
Going to amend this by saying that whereever the number you need to sort by is 
located, you should be able to extract it and do the padding trick even if it's 
in the middle of a string..  as long as the format is regular enough.

-TG

= = = Original message = = =

You could try separating out the number an formatting it with SQL and doing an 
ORDER BY on the post-processed number.  It doesn't have to appear in the SELECT 
columns portion to be able to use it in the ORDER BY section.


SELECT BookName, PageNum, Citation FROM BookQuotes ORDER BY LPAD(PageNum,4,'0');

You could also probably convert the number from a string to an actual number so 
it sorted numerically.

I think you get the idea.  Give it a try and let us know!  Then go back to the 
MySQL list and tell them how great PHP is.

-TG

= = = Original message = = =

Hi gang:

I posted the following question to the MySQL list, but the only 
answer I received thus far was a php solution (it didn't work for 
what I wanted).

As such, maybe if I post a MySQL question to the PHP group, then I'll 
receive a MySQL answer -- so here goes:

I'm using the following query, and it works.

SELECT id, title, url_image_small
FROM $dbtable
WHERE type=type_title
ORDER BY title
LIMIT $offset, $rowsPerPage

But, it sorts stuff like this:

Basel Square 1
Basel Square 10
Basel Square 11
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9

What do I have to change to get it (the query) to sort like this:

Basel Square 1
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
Basel Square 8
Basel Square 9
Basel Square 10
Basel Square 11

Thanks in advance for any answers/suggestions

tedd
-- 

http://sperling.com



___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] Hosting php help

2006-04-26 Thread Nicolas Verhaeghe
http://www.google.com/search?hl=enq=free+php+hosting

-Original Message-
From: Jesús Alain Rodríguez Santos [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 26, 2006 2:26 PM
To: php-general@lists.php.net
Subject: [PHP] Hosting php help


Please I need a free hosting with php and mysql, and sendmail active. If you
know any site, please send to me the address.

-- 
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Richard Lynch
On Wed, April 26, 2006 3:36 pm, Warren Vail wrote:
 One solution would be to develop a PHP Plugin and support that for all
 the

http://pecl.php.net/package/PHPScript

Just stumbled across it the other day, and it's on my check it out
list...

Reviews from those more knowlegable most welcome.

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Evan Priestley
No, I'm saying that Javascript can't read or write files on the  
client's machine, and that this is only one of a large number of  
basic limitations in the language's capabilities. It would be  
possible to write a script which took $a = 3 and converted it into  
var a = 3, but a huge number of PHP functions either can't be  
implemented in Javascript (file_get_contents) or are fundamentally  
unsafe to implement in Javascript (mysql_query), so you'd end up with  
a language you couldn't do anything with.


Evan

On Apr 26, 2006, at 5:07 PM, Warren Vail wrote:


Evan,

Are you proposing something like AJAX does? My understanding is  
limited
here, so bear with me.  A control like a hidden imbedded frame  
(IFRAME) is
acted upon by Javascript to cause it to dynamically request loading  
a page
into the frame, and when loaded, the javascript processes the  
contents of

the frame without necessarily displaying it directly?

And then do the translation on the client?

Could work, but I was thinking more of doing the tranlation in a  
function in

PHP, but that may be because PHP is my perspective.  Something like;

--- snip --
Html stuff
?php echo scripttranslate(
Php code follows here Careful with quotes); ?
More html stuff
--- snip --

Or

--- snip --
Echo html stuff here
.scripttranslate(php stuff here...
. again carefull with quotes)
.more html stuff here); // end of echo statement
--- snip --

Warren

-Original Message-
From: Evan Priestley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 1:47 PM
To: Warren Vail
Cc: PHP General List
Subject: Re: [PHP] New Help with Javascript Navigation

Tell you what: write file_get_contents() in Javascript, and I'll  
write the

rest of it.

Evan

On Apr 26, 2006, at 4:36 PM, Warren Vail wrote:


This brings up a reoccurring issue for me and I'd be interested if
anyone else has given it any thought.

PHP appears to me to be incomplete unless it can provide a way to
provide client (browser) side executables in a consistent language,
namely PHP.
Developers get all excited about the elegence of the PHP language,  
and

somewhere along the way they discover they have been sandbagged (they
have to learn Javascipt too, if they want responsive GUI's).

One solution would be to develop a PHP Plugin and support that for  
all

the browsers out there, but another just occurred to me.  What if
there was a function that accepted PHP code as input and tranlated it
to Javascript, returning the resulting text ready for imbedding in
html?

Any creative masochists out there?  Has it already been attempted?

Warren Vail

-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 1:07 PM
To: Pub; php-general@lists.php.net
Subject: RE: [PHP] New Help with Javascript Navigation

Pub,

Thank you for subscribing to and participating in the PHP users list,
a place where your PHP questions can be answered. Unfortunately your
last post contained several problems;

a. It was to long.
2. it was a JavaScript question.

Thank you,

Jay

--
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 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



Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Jochem Maas

BTW
Wez Furlong has written an ActiveScript compatible plugin that
allows running php clientside in the browser - YMWV.
/BTW

Robert Cummings wrote:

On Wed, 2006-04-26 at 16:47, Evan Priestley wrote:



...

nice func Rob. :-) now onward to HELL ...


?

Unfortunately, you're going to have a HELL of a time with dynamically
include()'ing source :)


function includeJS(jsPath)
{
// bogus URL/path to script?
if (!isString(jsPath) || !jsPath) {
return;
}

// remove extraneous spaces - just in case
jsPath = jsPath.trim();

// has the given script already been 'included'?
var scripts = document.getElementsByTagName(SCRIPT);
var scriptsLen = scripts.length;
for (var i = 0; i  scriptsLen; i++) {
if (scripts.src == jsPath) {
// the requested file has already been added (or was defined/linked 
from the start.
return;
}
}

// everything is ok, lets include the script.
var script = document.createElement(SCRIPT);

script.setAttribute(type, text/javascript);
script.setAttribute(src, jsPath);

document.getElementsByTagName(HEAD)[0].appendChild( script );
}

probably far from perfect but it's helped me out of a jam now and again.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] error message

2006-04-26 Thread Jochem Maas

cybermalandro cybermalandro wrote:

I have set in display_errors = off on my php.ini but I can still see ODBC
related error messages when I try to duplicate an ODBC error. Am I missing
something to turn this off?


restart the server?
also check that ini_set('display_errors', 0); doesn't have the desired effect.



Thanks!



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] error message

2006-04-26 Thread Richard Lynch
On Wed, April 26, 2006 4:08 pm, cybermalandro cybermalandro wrote:
 I have set in display_errors = off on my php.ini but I can still see
 ODBC
 related error messages when I try to duplicate an ODBC error. Am I
 missing
 something to turn this off?

Does ?php phpinfo();? reflect your changes to php.ini?
Does that output indicate you are changing the correct php.ini?
Did you restart Apache?

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] error message

2006-04-26 Thread cybermalandro cybermalandro
Yes,
Yes and
Yes although I am not running apache I am running IIS.

On 4/26/06, Richard Lynch [EMAIL PROTECTED] wrote:

 On Wed, April 26, 2006 4:08 pm, cybermalandro cybermalandro wrote:
  I have set in display_errors = off on my php.ini but I can still see
  ODBC
  related error messages when I try to duplicate an ODBC error. Am I
  missing
  something to turn this off?

 Does ?php phpinfo();? reflect your changes to php.ini?
 Does that output indicate you are changing the correct php.ini?
 Did you restart Apache?

 --
 Like Music?
 http://l-i-e.com/artists.htm





Re: [PHP] New Help with Javascript Navigation

2006-04-26 Thread Robert Cummings
On Wed, 2006-04-26 at 17:18, Jochem Maas wrote:
 BTW
 Wez Furlong has written an ActiveScript compatible plugin that
 allows running php clientside in the browser - YMWV.
 /BTW
 
 Robert Cummings wrote:
  On Wed, 2006-04-26 at 16:47, Evan Priestley wrote:
  
 
 ...
 
 nice func Rob. :-) now onward to HELL ...
 
  ?
  
  Unfortunately, you're going to have a HELL of a time with dynamically
  include()'ing source :)
 
 function includeJS(jsPath)
 {
  // bogus URL/path to script?
  if (!isString(jsPath) || !jsPath) {
  return;
  }
 
  // remove extraneous spaces - just in case
  jsPath = jsPath.trim();
 
  // has the given script already been 'included'?
  var scripts = document.getElementsByTagName(SCRIPT);
  var scriptsLen = scripts.length;
  for (var i = 0; i  scriptsLen; i++) {
  if (scripts.src == jsPath) {
  // the requested file has already been added (or was 
 defined/linked from the start.
  return;
  }
  }
 
  // everything is ok, lets include the script.
  var script = document.createElement(SCRIPT);
 
  script.setAttribute(type, text/javascript);
  script.setAttribute(src, jsPath);
 
  document.getElementsByTagName(HEAD)[0].appendChild( script );
 }
 
 probably far from perfect but it's helped me out of a jam now and again.

Been there, done that technique... unfortunately it can't be used to
dynamically load script that will be seen by the currently executing
scope... this isn't quite true... I think one browser saw it right off,
another saw it if I used eval on the retrieved source, but other
browsers don't see it until after the scope (function scope) exits. The
exact semantics are quite varying which provides for completely
unreliable loading of dyanamic script -- and to be frank I try to make
my stuff work with IE/FF/Opera. I could care less about NN4 in this day
and age :)

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Debuggin PHP

2006-04-26 Thread Richard Lynch
On Wed, April 26, 2006 11:30 am, hicham wrote:
  I'm a newbie in php world , and I'm trying to get a php 4 script work
 on an php5 version
 how do i debug php ? I get a blank page and nothing tells me what 's
 wrong ?

Check View Source in your browser to see if it's really blank.

Make sure PHP is installed and functioning with ?php phpinfo();?

Check your php.ini settings and see if errors are displayed, logged,
or discarded, and what your error_reporting is set to.

Also check the script itself to see if it resets error_reporting --
which,  if it does, is a clear indicator that the author of the script
didn't know what they were doing and you shouldn't use their script
anyway.

You can also use Firefox and its extension to see HTTP Headers to see
what headers, if any, come out of the server.

You can also run PHP from the command line to see what the script
outputs in that environment, which is sometimes useful, and sometimes
too different from web environment to be useful.  Just depends.

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



  1   2   >