php-windows Digest 30 Apr 2010 09:07:52 -0000 Issue 3800
Topics (messages 30058 through 30066):
Re: MySQL database query passwort and username
30058 by: Niel Archer
Re: Unable to load php_msql.dll
30059 by: Richard Quadling
30061 by: Richard Quadling
30062 by: Richard Quadling
Compiling PHP with MS SQL Server Driver for PHP support
30060 by: Richard Quadling
30063 by: Venkat Raman Don
30066 by: Richard Quadling
Hoping to add a site search to my TAXA website
30064 by: Bill Mudry
30065 by: Ferenc Kovacs
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
> Hello,
>
> i am writing a login script with php and mysql:
>
> while($dbbenutzer = mysql_fetch_row($sqlbenutzername))
> while($dbpasswort = mysql_fetch_row($sqlpasswort)){
>
>
> echo $dbbenutzer[$i];
> echo $dbpasswort[$j];
> if($benutzername == $dbbenutzer and $pass == $dbpasswort){
> echo '<p>Sie haben sich erfolgreich angemeldet</p>';
> echo '<a href="willkommen.html">Willkommen</a>';
> }
> }
>
> }
>
> I have the username=benutzername in one column and the
> password=passwort in the oher column.
> Now i use mysql_fetch_row to go through the columns and try to compare
> the values given by sql select statement
> with the values provided by the user.
>
> The problem is that this code only finds the firs entry moritz and
> 123456 and not the second. There are two values in the database morith
> 123456 and thomas thorr. These are sample values for testing only.
>
> Is there an easier way to write a login script?
You will get more answers asking your questions in the database mailing
list php...@lists.php.net, rather than in a list for Windows related
matters.
> thank you
> Alexander
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
--- End Message ---
--- Begin Message ---
On 28 April 2010 17:21, Richard Quadling <rquadl...@googlemail.com> wrote:
> On 28 April 2010 17:13, Chris <cjav...@bellatlantic.net> wrote:
>> Pretty much the same exact thing.
>
> Excellent. So the library is loaded and working.
>
> What is the exact error are you getting? Is this on your machine or the
> server?
Anything?
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
On 29 April 2010 15:16, Chris Aveni <cjav...@bellatlantic.net> wrote:
> Richard, thanks so much for your expeditious help. Actually, the problem
> was that I had to move msql.dll to the root of the php dir. Not sure why as
> I have other servers running this same version, and the only thing in path
> is c:\php, not c:\php\extensions. Those cmds you gave me found the issue.
>
> Again, your time was very appreciated. If I could ever return the favor in
> some way just let me know.
>
> Chris
>
>
> -----Original Message-----
> From: Richard Quadling [mailto:rquadl...@googlemail.com]
> Sent: Wednesday, April 28, 2010 12:24 PM
> To: Chris
> Subject: Re: [PHP-WIN] Unable to load php_msql.dll
>
> Chris, I'm off home now, so won't be able to reply for a few hours.
>
> Richard.
>
> --
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>
>
>
C:\PHP should be in the path and contain any files required by PHP's extensions.
C:\PHP5\ext should not be in the path as PHP already knows how to find
the files here via the extension_dir setting in the php.ini file.
Take a look at http://docs.php.net/manual/en/install.windows.manual.php
and http://docs.php.net/manual/en/install.windows.commandline.php for
all the details on getting PHP working manually for windows.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
On 29 April 2010 15:16, Chris Aveni <cjav...@bellatlantic.net> wrote:
> Richard, thanks so much for your expeditious help. Actually, the problem
> was that I had to move msql.dll to the root of the php dir. Not sure why as
> I have other servers running this same version, and the only thing in path
> is c:\php, not c:\php\extensions. Those cmds you gave me found the issue.
>
> Again, your time was very appreciated. If I could ever return the favor in
> some way just let me know.
>
> Chris
>
>
> -----Original Message-----
> From: Richard Quadling [mailto:rquadl...@googlemail.com]
> Sent: Wednesday, April 28, 2010 12:24 PM
> To: Chris
> Subject: Re: [PHP-WIN] Unable to load php_msql.dll
>
> Chris, I'm off home now, so won't be able to reply for a few hours.
>
> Richard.
>
> --
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>
>
>
C:\PHP should be in the path and contain any files required by PHP's extensions.
C:\PHP5\ext should not be in the path as PHP already knows how to find
the files here via the extension_dir setting in the php.ini file.
Take a look at http://docs.php.net/manual/en/install.windows.manual.php
and http://docs.php.net/manual/en/install.windows.commandline.php for
all the details on getting PHP working manually for windows.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
Hi.
Compiling using VC9 Express Edition.
I'm ending up with a php_sqlsrv.dll of 88KB
The VC9 x86 nts version supplied by MS (php_sqlsrv_53_nts_vc9.dll) is 227KB.
If it had been just a few bytes, then OK, but to be over 40% smaller
is a significant difference.
Any ideas?
As far as I can tell, it all works just fine too!
Richard.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
Hi,
My guess is that SQL team may be linking with VC9 required libraries statically
and you are not. It works because you have VC9 runtime on your machine.
Thanks,
Don.
-----Original Message-----
From: Richard Quadling [mailto:rquadl...@googlemail.com]
Sent: Thursday, April 29, 2010 8:16 AM
To: php-windows
Subject: [PHP-WIN] Compiling PHP with MS SQL Server Driver for PHP support
Hi.
Compiling using VC9 Express Edition.
I'm ending up with a php_sqlsrv.dll of 88KB
The VC9 x86 nts version supplied by MS (php_sqlsrv_53_nts_vc9.dll) is 227KB.
If it had been just a few bytes, then OK, but to be over 40% smaller
is a significant difference.
Any ideas?
As far as I can tell, it all works just fine too!
Richard.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
On 29 April 2010 16:59, Venkat Raman Don <don.ra...@microsoft.com> wrote:
> Hi,
>
> My guess is that SQL team may be linking with VC9 required libraries
> statically and you are not. It works because you have VC9 runtime on your
> machine.
>
> Thanks,
> Don.
>
> -----Original Message-----
> From: Richard Quadling [mailto:rquadl...@googlemail.com]
> Sent: Thursday, April 29, 2010 8:16 AM
> To: php-windows
> Subject: [PHP-WIN] Compiling PHP with MS SQL Server Driver for PHP support
>
> Hi.
>
> Compiling using VC9 Express Edition.
>
> I'm ending up with a php_sqlsrv.dll of 88KB
>
> The VC9 x86 nts version supplied by MS (php_sqlsrv_53_nts_vc9.dll) is 227KB.
>
> If it had been just a few bytes, then OK, but to be over 40% smaller
> is a significant difference.
>
> Any ideas?
>
> As far as I can tell, it all works just fine too!
>
> Richard.
>
> --
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
Aha! Yes. Confirmed this by using Dependency Checker. Mine is
requiring MCVCR90.DLL and MS's isn't.
So, the next question is, considering all I've done to my build is
added --enable-sqlsrv=shared (as per the README.TXT in the SVN
repository) to my configure command, what is the "right" output?
configure --disable-zts --enable-win32service=shared
--enable-debug-pack --enable-wincache=shared --without-mysql
--without-mysqli --enable-sqlsrv=shared
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
Right now, the only way readers can search for anything in the wood
botanical tree I have built is by botanical (scientific) names:
www.prowebcanada.com/taxa
Most people would wish to find woods and information about them by
their common names
or perhaps other search terms such as by country they grow in and
other search choices.
I hope to be able soon, therefore, to install a general site search
engine that can search
through all the MySQL files being used to store all the data ---
hopefully one that is free code,
using PHP and downloadable from the Net.
Do any of you have favorite site search software you would recommend?
Other desired criteria include:
- All pages are dynamically driven. The search application
does not have to search
pages much because all data that shows is stored my MySQL
tables in a database
simply called 'taxa'. It needs to do its searching from
within those tables.
- Question: At some stage (setup?) would I have to specify
every table it should look
into? Could I also use different searches for each area
(eg. for species, for genera,
for families, etc.)
- PHP source code should be readily available in case I need
to modify something.
- I work on windows at home but the website is on a Linux
account at GoDaddy.
The software must therefore be independent of working only
on Windows.
- I have 6,500 records for the species table but that will
expand well past 12,000
eventually. The site search has to be able to handle that
and more. Many of the
programs on the Web talk in terms of how many pages but
that does not make
as much sense here as searching through thousands of records.
- Preferred: For setup, the simpler the better.
I took a quick initial look but am willing to bet that someone in our
group has one or more
favorite, proven solutions.
I look forward to your suggestions :-) .
Bill Mudry
Mississauga, ON
--- End Message ---
--- Begin Message ---
hi.
how many different tables are we talking about?
could you show us the structure of the tables?
if you are using myisam for the tables, you can use the built in full text
search feature (match ... against), or if you are not afraid of programming,
I would recommend solr or sphinx, but it can be an overkill.
if you want an easy way to allow your users to search your site, you could
build a sitemap, upload it to google (if you haven't did it yet) and use
google to search your site's content:
http://www.google.com/cse/
or
http://www.google.com/sitesearch/
Tyrael
On Thu, Apr 29, 2010 at 7:08 PM, Bill Mudry <billmu...@rogers.com> wrote:
> Right now, the only way readers can search for anything in the wood
> botanical tree I have built is by botanical (scientific) names:
> www.prowebcanada.com/taxa
> Most people would wish to find woods and information about them by their
> common names
> or perhaps other search terms such as by country they grow in and other
> search choices.
> I hope to be able soon, therefore, to install a general site search engine
> that can search
> through all the MySQL files being used to store all the data --- hopefully
> one that is free code,
> using PHP and downloadable from the Net.
>
> Do any of you have favorite site search software you would recommend? Other
> desired criteria include:
>
> - All pages are dynamically driven. The search application does not
> have to search
> pages much because all data that shows is stored my MySQL tables
> in a database
> simply called 'taxa'. It needs to do its searching from within
> those tables.
>
> - Question: At some stage (setup?) would I have to specify every
> table it should look
> into? Could I also use different searches for each area (eg. for
> species, for genera,
> for families, etc.)
>
> - PHP source code should be readily available in case I need to
> modify something.
>
> - I work on windows at home but the website is on a Linux account at
> GoDaddy.
> The software must therefore be independent of working only on
> Windows.
>
> - I have 6,500 records for the species table but that will expand
> well past 12,000
> eventually. The site search has to be able to handle that and
> more. Many of the
> programs on the Web talk in terms of how many pages but that does
> not make
> as much sense here as searching through thousands of records.
>
> - Preferred: For setup, the simpler the better.
>
> I took a quick initial look but am willing to bet that someone in our group
> has one or more
> favorite, proven solutions.
>
> I look forward to your suggestions :-) .
>
> Bill Mudry
> Mississauga, ON
--- End Message ---
