RE: [PHP-DB] NC takes forever to connect to the db
Similar yes, solution no... But it seem only to happen when I test on my internal test enviroment, not when deployed on more serious installed FreeBSD or Solaris servers. (Internally I use a Win2k Prof. installation *sigh*) / LJ -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: 11. december 2001 21:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] NC takes forever to connect to the db Hello, my application works fine with IE, but running it on NC it takes on certain connections forever to get a response from the server. But here it comes... as soon as I click on another window for example make Outlook the aktive window. NC connects in the backgroud fast as light! So what the hack is going on? Does anybody have similar experiance? Thanx for any help! Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
Well, need to hook up on mysql.com to check it out... 4.0 is already out on development, but even I tend to tell my clients I am on "the cutting-edge" *laugh* yeah, I know - bullshit buzzword - I prefer it to be stable releases before relying even remotely on these. mySQL 4.1 will become VERY exciting with the fulltext indexing (more than a mere OR search), Stored Procedures and even they promise an performance increase... hmm, our buddies at mySQL seem to make alot of promises, lets just hope they are not like politicians and actually will put a product behind the words to back it up. Monty and co. got my confidence, I look forward playing with a "new toy". Refs : http://www.mysql.com/products/mysql-4.0/index.html And : http://www.mysql.com/news/article-81.html / Lars > -Original Message- > From: matt stewart [mailto:[EMAIL PROTECTED]] > Sent: 15. november 2001 21:32 > To: 'Lars B. Jensen'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Why use MySQL with PHP > > > sounds wonderful - do you know when (roughly) it's gonna be released? > I thought that one of the reasons it was so fast was that the DB engine > wasn't cluttered with procedures? (which is why it's so damn good for > not-so-complicated sites)? > i'm no expert at all, but won't mySQL 4 therefore be slower? > > > -Original Message- > From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] > Sent: 15 November 2001 12:19 > To: matt stewart > Cc: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Why use MySQL with PHP > > > Stored procedures is missing in mySQL correct but is scheduled with the > exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main > force is it's performance, for certain tasks also with quite > large datasets > (few million rows) I had mySQL outperform major players as Microsoft SQL > Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. > > Again, it all comes down to make the optimal site for the job, not the > hardest technological. To revert a saying, why jump the fence where it is > the highest ? (thereby not saying we gotta jump where it is lowest, but > where it is appropriate to the task). > > So, with experience and knowledge from major sites running daily thousands > of sessions and millions of pageviews I know mySQL is capable of > the trick, > and with the mySQL 4 coming out, I for one is awaiting it with > anticipation. > Especially the "stored procedures" which totally would eliminate > my need for > Microsoft SQL Server. > > / Lars > > > -Original Message- > > From: matt stewart [mailto:[EMAIL PROTECTED]] > > Sent: 15. november 2001 20:45 > > To: 'søren eriksen'; [EMAIL PROTECTED] > > Subject: RE: [PHP-DB] Why use MySQL with PHP > > > > > > The main reasons are possibly later on its drawbacks - > basically, its main > > attraction is the ease of use, as it's so simple! > > MySQL and PHP fit together so well and for people just learning > scripting > > with databases, there's not much that's as easy to pick up quickly and > > produce basic database driven websites with. > > Obviously due to this, it's actually got no massive depth in > > terms of stored > > procedures (you can't), and won't be as effective or useful for running > > massive, complex sites that attract millions of visitors > > (something like SQL > > server would probably be better) but for most websites, it's free, it's > > easy, and it does the job! > > > > -Original Message- > > From: søren eriksen [mailto:[EMAIL PROTECTED]] > > Sent: 15 November 2001 20:34 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Why use MySQL with PHP > > > > > > Hi everybody > > I'm writing a synopsis about PHP and mySQL. > > I'm hoping someone can help me, and tell me why > > the combination og PHP and MySQL is so common. > > What makes MySQL such a good choice when using PHP? > > What seperates MySQL from others dbms? > > -Søren Eriksen- > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http:
RE: [PHP-DB] Why use MySQL with PHP
Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the "stored procedures" which totally would eliminate my need for Microsoft SQL Server. / Lars > -Original Message- > From: matt stewart [mailto:[EMAIL PROTECTED]] > Sent: 15. november 2001 20:45 > To: 'søren eriksen'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Why use MySQL with PHP > > > The main reasons are possibly later on its drawbacks - basically, its main > attraction is the ease of use, as it's so simple! > MySQL and PHP fit together so well and for people just learning scripting > with databases, there's not much that's as easy to pick up quickly and > produce basic database driven websites with. > Obviously due to this, it's actually got no massive depth in > terms of stored > procedures (you can't), and won't be as effective or useful for running > massive, complex sites that attract millions of visitors > (something like SQL > server would probably be better) but for most websites, it's free, it's > easy, and it does the job! > > -Original Message- > From: søren eriksen [mailto:[EMAIL PROTECTED]] > Sent: 15 November 2001 20:34 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Why use MySQL with PHP > > > Hi everybody > I'm writing a synopsis about PHP and mySQL. > I'm hoping someone can help me, and tell me why > the combination og PHP and MySQL is so common. > What makes MySQL such a good choice when using PHP? > What seperates MySQL from others dbms? > -Søren Eriksen- > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
*laugh* I was reading this and thought to reply simply for the fact Søren is fellow danish guy, but refrained momentarily till I got this one... There are many alternatives to mySQL and much more commercial too... Try get your hotshot boss to belive in mySQL rather from business buzzword Oracle (by know, I think 95% know Oracle is "the major db engine - especially on the ridiculus pricetag it comes with), but MSSQL, Sybase, PostgreSQL, Informix, Paradox ect ect ect. Okay, I am a bit colored by my short but exiting experience over 4 years pro. Since the zend guys came into the picture with the rewriting of php engine they worked quite close with monty and the boyz over at mySQL... The integration between these two systems is one of the closest and seemlessly I have seen to date, with experience from IPerForm/MSSQL6.5(later 7.0) - if you dont know IPerForm, be happy about it and never think of it - JSP/Servlet/Oracle and latest PHP/mySQL. It is unique, fast and never a problem needless what platform it runs on (though I advice noone to do Windowshosting with PHP/mySQL *ouch* can already feel I'm being dragged outside and beaten upon - Windows if for testing and development only, I always run on FreeBSD or Linux servers and it ruuuns smth) Hmm, about the Nasa part, I never conducted business quite like the guys at Nasa so I presume my needs is quite different - prefer to find the optimal solution... Heck, there are alot of bigshot sites out there running ASP *www* does that mean it is the optimal solution ? Wasn't it Ratschiller / Gerken (sorry if I got the names wrong) who had an entire chapter about the PHP / mySQL "tieup" - well, check their book out, I dont agree with it in full but it has its great parts... :) Enough storytelling, goodluck on your assignment / Lars PS. Søren, skriv hvis der er noget... Jeg har arbejdet de sidste par år med PHP / mySQL for firmaer som TDC KabelTV og lign. > -Original Message- > From: PHPGalaxy.com [mailto:[EMAIL PROTECTED]] > Sent: 15. november 2001 20:38 > To: søren eriksen > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Why use MySQL with PHP > > > My reasons: > 1) Heard of Oracle, didnt know it was a database program > 2) Never heard of PostgreSQL > 3) MySQL is the most talked about, from what I've seen, so > there's plenty of > people to get help from > 4) It's free. > 5) It runs in Windows > 5) NASA uses it, or so their site says > 6) It works! So I've no need to switch to anything else > 7) Most PHP webhosting services offer only MySQL. > 8) Gotta love that lil dolphin! > > > søren eriksen wrote: > > > Hi everybody > > I'm writing a synopsis about PHP and mySQL. > > I'm hoping someone can help me, and tell me why > > the combination og PHP and MySQL is so common. > > What makes MySQL such a good choice when using PHP? > > What seperates MySQL from others dbms? > > -Søren Eriksen- > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- > From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts > and Software on your Site. http://www.phpgalaxy.com/aff/ > > Also, get a fast free POP3 email account, you @php.la at > http://www.phpgalaxy.com/search/ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] phpdb error, need help
Clay, Looks like a small tweak in php.ini will do the trick for you. You can change the error_reporting below to something like error_reporting = E_ALL & ~(E_NOTICE | E_USER_NOTICE); The problem seems to be caused since the developers of the phpdb wrapper relies on the fact that a variable will be initialised automatically by PHP - heck, I often do that myself in simple vars, not arrays ect ofcourse. Try it and report back if it works or if you need further assistance Lars B. Jensen, CEO and Founder LJWeb GmbH www.ljweb.com > -Original Message- > From: Clay Culver [mailto:[EMAIL PROTECTED]] > Sent: 14. november 2001 12:21 > To: PHP DB List > Subject: [PHP-DB] phpdb error, need help > > > Hi, > > I have been using the phpdb wrapper on http://phpdb.linuxbox.com > for about a year now, and have used it to great extent. But now as I > have built a new http server for my company I seem to be getting an > error with it and the URL for the wrapper is not resolving so tech help > there won't work and there is no email address for the author listed. > > The error is this > [Quote] > Warning: Undefined variable: boolDBSelected in > D:\Inetpub\hells_horses\database\phpDB-mysql.lib on line 110 > [/Quote] > > You can view this in action here > http://207.216.247.148/hells_horses/database/codex/roster.php > To view what it should be doing go here > http://chh.darkness-is.com/database/codex/roster.php > I have put the phpdb.inc and the phpdb-mysql.lib in to a zip file and it > can be downloaded here http://chh.darkness-is.com/files/phpdb.zip below > is the code that I use to use this in a php page. > > [Quote] >include("phpDB.inc"); > $db = new phpDB(); > $db->connect("localhost", "guest", "guest", "CHH"); > ?> > > The only major changes to how I have the server setup is the > fact I am using PHP 4.0.6 and MySQL 3.23.44 the rest of the server > information is as follows. > > [Quote] > 2xPII Xeon 450 w/2MB cache > MSI 6135 Revision 1 > 2x512 ECC Registered Corsair PC100 RAM > 2xQuantim 18.9GB SCSI-3 7200 RPM HDD > 1x12GB Fujitsu EIDE 7200 RPM HDD > Windows 2000 Server w/SP2 and all the Windows Updates > [/Quote] > > Clay Culver > [EMAIL PROTECTED] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Can't connect Mysql using php
you need to install your PHP using ./configure --with-mysql rather than ./configure --without-mysql / LJ -Original Message- From: Jae [mailto:[EMAIL PROTECTED]] Sent: 27. september 2001 13:05 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Can't connect Mysql using php './configure' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-shared' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8' '--with-xml' thx "Jason Wong" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó 000a01c14674$87e58080$[EMAIL PROTECTED]">news:000a01c14674$87e58080$[EMAIL PROTECTED]... > >-Original Message- > >From: Jae [mailto:[EMAIL PROTECTED]] > >Sent: 26 September 2001 17:41 > >To: [EMAIL PROTECTED] > >Subject: [PHP-DB] Can't connect Mysql using php > > > > > > > >±H¥óªÌ: "Jae" <[EMAIL PROTECTED]> > >¦¬¥óªÌ: <[EMAIL PROTECTED]> > >¥D¦®: Re: Error on connecting to mysql database > >¤é´Á: 2001¦~9¤ë26¤é ¤U¤È 05:09 > > > >After recompile, the error still occurs. > >pls help > > > >"Jae" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó > >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >> I got this message when i call the php script, > >> > >> "Fatal error: Call to undefined function: mysql_connect() in > >> /home/jaelee/public_html/test01.php on line 6" > >> > >> what's wrong? > >> thx > > Run and tell us the output of the 3rd row of the first > table, ie the "Configure Command". > > -- > Jason Wong > Gremlins Associates > www.gremlins.com.hk > Tel: +852-2573-5033 > Fax: +852-2573-5851 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] USA Attacks
Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! > > >"In the year of the new century and nine months,From the sky will come a great King of Terror... >The sky will burn at forty-five degrees.Fire approaches the great new city..." >"There will be a great thunder,Two brothers torn apart by Chaos, >While the fortress endures,The great leader will succumb, >The third big war will begin when the big city is burning" > > --Nostradamus 1654 > Mihai Marcian Dumitrescu <[EMAIL PROTECTED]> wrote: I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] USA Attacks
It is replies like this that makes me understand the terrorism in the world... No doubt, it was a horrible act by cowards, but what comes up must come down. US has been playing with fire once too often and suddenly tasted their medicine - maybe time to rethink the "world police" strategy again. I feel sympathy for all who died in the incident for no cause. Dont get me wrong on that point ! / LJ -Original Message- From: Bartek Pawlik [mailto:[EMAIL PROTECTED]] Sent: 12. september 2001 14:35 To: [EMAIL PROTECTED] Subject: Odp: [PHP-DB] USA Attacks My deepest sympathy to all Americans, It's horrible, I can still believe it. Kill everyone who is involved into these attacks Bartek Pawlik Poland - Original Message - From: Steve Farmer <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 12, 2001 4:28 AM Subject: [PHP-DB] USA Attacks > Hi, > > My heart goes out to all our American cousins in their time of tragedy. > > Steve Farmer > -- > --- > "Minds are like parachutes, they work best when open" > Support free speech; visit http://www.efa.org.au/ > > Heads Together Systems Pty Ltd http://www.hts.com.au > Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- Zagraj z finalistkami Miss Polonia [ http://miss.onet.pl/start.html ] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] How can you hide database login passwd in your script?
The 600$ alternative http://www.zend.com/store/products/zend-developer-suite.php / LJ -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: 4. september 2001 23:32 To: '[EMAIL PROTECTED]'; rbtree Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? At $2400.00 per license, Zend Encoder is an expensive option -Original Message----- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 02, 2001 1:00 AM To: rbtree Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? An option would be using the Zend Encoder *snip* The Zend Encoder Unlimited allows code developers to encode their PHP script before distributing it. By saving the code in a closed Zend Intermediate Code format, the Encoder allows developers to protect source code from copyright infringement, enabling companies to create exclusive software solutions and commercial PHP applications. Business-oriented developers who want to enjoy the benefits of PHP scripting, without exposing their source code, will find the Zend Encoder Unlimited indispensable for all mission critical business applications that must protect the source code from copyright infringement. This product provides copyright and intellectual property protection, opening the way for the widespread acceptance of PHP for business and commercial applications, where protection of proprietary information is of primary concern. *snip* Ref : http://www.zend.com/store/products/zend-encoder.php / LJ -Original Message- From: rbtree [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 14:06 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? So how can I hide the database password in my PHP script? -Original Message----- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 02, 2001 1:00 AM To: rbtree Subject: RE: [PHP-DB] How can you hide database login passwd in your script? If someone breaks in, he/she likely have the skills to get into the mySQL as well . but no reason to make it too easy / LJ -Original Message- From: rbtree [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 14:01 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? Exactly.. But if someone breaks in .. I want to lessen the damage. With a C program it is hidden in the binary code. -Original Message----- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 02, 2001 12:55 AM To: Michael; [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? a .php file is only viewable on the server if users have access to the site through eg. FTP, Telnet or alike. When displaying or trying to download a PHP file, the server will first execute it and return the "result" being your HTML output or result of function, without login information nor PHP content. / LJ LJWeb GmbH -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 13:55 To: [EMAIL PROTECTED] Subject: [PHP-DB] How can you hide database login passwd in your script? How can you hide database login passwd in your script? I hate having to have scripts with passwords in it that can be viewed by others. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] How can you hide database login passwd in your script?
An option would be using the Zend Encoder *snip* The Zend Encoder Unlimited allows code developers to encode their PHP script before distributing it. By saving the code in a closed Zend Intermediate Code format, the Encoder allows developers to protect source code from copyright infringement, enabling companies to create exclusive software solutions and commercial PHP applications. Business-oriented developers who want to enjoy the benefits of PHP scripting, without exposing their source code, will find the Zend Encoder Unlimited indispensable for all mission critical business applications that must protect the source code from copyright infringement. This product provides copyright and intellectual property protection, opening the way for the widespread acceptance of PHP for business and commercial applications, where protection of proprietary information is of primary concern. *snip* Ref : http://www.zend.com/store/products/zend-encoder.php / LJ -Original Message- From: rbtree [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 14:06 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? So how can I hide the database password in my PHP script? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 02, 2001 1:00 AM To: rbtree Subject: RE: [PHP-DB] How can you hide database login passwd in your script? If someone breaks in, he/she likely have the skills to get into the mySQL as well . but no reason to make it too easy / LJ -Original Message- From: rbtree [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 14:01 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? Exactly.. But if someone breaks in .. I want to lessen the damage. With a C program it is hidden in the binary code. -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 02, 2001 12:55 AM To: Michael; [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? a .php file is only viewable on the server if users have access to the site through eg. FTP, Telnet or alike. When displaying or trying to download a PHP file, the server will first execute it and return the "result" being your HTML output or result of function, without login information nor PHP content. / LJ LJWeb GmbH -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 13:55 To: [EMAIL PROTECTED] Subject: [PHP-DB] How can you hide database login passwd in your script? How can you hide database login passwd in your script? I hate having to have scripts with passwords in it that can be viewed by others. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] How can you hide database login passwd in your script?
a .php file is only viewable on the server if users have access to the site through eg. FTP, Telnet or alike. When displaying or trying to download a PHP file, the server will first execute it and return the "result" being your HTML output or result of function, without login information nor PHP content. / LJ LJWeb GmbH -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 13:55 To: [EMAIL PROTECTED] Subject: [PHP-DB] How can you hide database login passwd in your script? How can you hide database login passwd in your script? I hate having to have scripts with passwords in it that can be viewed by others. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: replace string - case insensitive
Hugh, Looking through the code I am not doubting it works, but what I wonder if it is really a preferred choice over for example reg. expressions ? You have idea what would be the fastest performancewise choice here ? / LJ -Original Message- From: Hugh Bothwell [mailto:[EMAIL PROTECTED]] Sent: 16. august 2001 12:17 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: replace string - case insensitive "Lars B. Jensen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > depending on what you're replacing with what, a solution is eregi_replace. I > do not advice to upper nor lowercase the source as it will change parts of > data unwantedly. Yes, I agree; another solution is as follows: function alt_str_replace($search, $replace, $subject) { // Temporary copies of search string and subject string; // both shifted to lowercase to make the search case insensitive. $t_search = strtolower($search); $t_subject = strtolower($subject); // Initialize result string $res = ""; // Initialize search vars $search_offs = 0; $shift = strlen($search); // As long as another match is found... while (($t = strpos($t_subject, $t_search, $search_offs)) !== false) { // Copy non-matching portion of string $res .= substr($subject, $search_offs, $t-$search_offs); // Add replacement value $res .= $replace; // Update search offset $search_offs = $t + $shift; } // Add trailing end of string $res .= substr($subject, $search_offs); return $res; } Hope that helps... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
FW: [PHP-DB] Re: replace string - case insensitive
depending on what you're replacing with what, a solution is eregi_replace. I do not advice to upper nor lowercase the source as it will change parts of data unwantedly. / Lars www.ljweb.com -Original Message- From: Elman Cheng [mailto:[EMAIL PROTECTED]] Sent: 16. august 2001 10:41 To: J- E- N Cc: [EMAIL PROTECTED] Subject: [PHP-DB] Re: replace string - case insensitive try to change the string to uppercase or lowercase first. J- E- N wrote: > hello > > str_replace is case sensitive, what function should i use for case insensitive. > > thanks very much. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] start over on database read inorder to read from the beggining again
To run with less overhead, I would advice to only access the database when absolutely nessary. Therefor I would approach the problem with pasting the database result into an array and then doing the work from here - an array is much faster to work with rather than db. An approach could be / Lars LJWeb GmbH www.ljweb.com -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: 14. august 2001 13:40 To: Caleb Walker; [EMAIL PROTECTED] Subject: Re: [PHP-DB] start over on database read inorder to read from the beggining again > How can I run through a database like I am trying to do here? It seems like > at the end of the first I need to start over in order to start reading from > the beggining of the database on the second. > I hope that I hace explained my problem well if not please reply with your > questions. Thank you in advance. > > Caleb > > $connect = mysql_connect("$host","$user","$pass") OR (die("mysql_error")); > $selectdb = mysql_select_db("$db") OR (die("mysql_error")); > $result = mysql_query("SELECT * FROM teams where week='$list' ORDER BY date"); > while($view = mysql_fetch_row($result)) > { > code; > } > more code; > and > while($view = mysql_fetch_row($result)) > { > code; > } try adding: mysql_data_seek($result, 0); before your second loop. This should reset your dataset so you can loop again. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Merge two arrays into associative arrays?
With the risk of being wrong, I will try again... I just did a test with your data, "); print_r($c); print (""); ?> which should produce an associative array with keys from $a and values from $b. The result of this "operation" is Array ( [id] => ID [svrname] => Server Name [ipadd] => IP Address [domainname] => Domain Name ) . As I read your question, this is exactly what you look for, right ? / Lars www.ljweb.com - Original Message - From: "Shahmat Dahlan" <[EMAIL PROTECTED]> To: "Lars B. Jensen LJ Webnologics" <[EMAIL PROTECTED]> Cc: "Jonathan Hilgeman" <[EMAIL PROTECTED]>; "PHP-DB (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, May 22, 2001 8:52 AM Subject: Re: [PHP-DB] Merge two arrays into associative arrays? > This should have worked but my data are not single characters as I had showed > earlier. Maybe the examples below are clearer. > > $a=array("id","svrname","ipadd","domainname",); > $b=array("ID","Server Name","IP Address","Domain Name"); > > Thanks > > > "Lars B. Jensen, LJ Webnologics" wrote: > > > Have followed this group for a while, it is my turn to try send an response. > > > > Would this angle with a for loop not be better than a foreach angle ? > > > $a = array(1,2,3,4,5); > > $b = array("a","b","c","d","e"); > > $c = array(); > > > > $arraysize = sizeof($a); > > for ($i=0;$i<$arraysize;$i++) { > > $c[$a[$i]] = $b[$i]; > > } > > ?> > > > > / Lars > > www.ljweb.com > > > > - Original Message - > > From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> > > To: "'Shahmat Dahlan'" <[EMAIL PROTECTED]> > > Cc: "PHP-DB (E-mail)" <[EMAIL PROTECTED]> > > Sent: Monday, May 21, 2001 6:10 PM > > Subject: RE: [PHP-DB] Merge two arrays into associative arrays? > > > > > try: > > > > > > $a=array(1,2,3,4,5); > > > $b=array("a","b","c","d","e"); > > > $c = array(); > > > > > > foreach($a as $a_key => $a_value) > > > { > > > $c[$a_value] = $b[$a_key]; > > > } > > > > > > that should give you what you want. > > > > > > Jonathan > > > > > > -Original Message- > > > From: Shahmat Dahlan [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, May 21, 2001 12:23 AM > > > To: PHP-DB > > > Subject: [PHP-DB] Merge two arrays into associative arrays? > > > > > > > > > Is there anywhere possible for me to merge two arrays into associative > > > arrays? > > > > > > e.g. > > > $a=array(1,2,3,4,5); > > > $b=array("a","b","c","d","e") > > > > > > into > > > > > > $c=array(1 => "a", 2 => "b", etc... ) > > > > > > Thanks in advance.. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Merge two arrays into associative arrays?
Have followed this group for a while, it is my turn to try send an response. Would this angle with a for loop not be better than a foreach angle ? / Lars www.ljweb.com - Original Message - From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> To: "'Shahmat Dahlan'" <[EMAIL PROTECTED]> Cc: "PHP-DB (E-mail)" <[EMAIL PROTECTED]> Sent: Monday, May 21, 2001 6:10 PM Subject: RE: [PHP-DB] Merge two arrays into associative arrays? > try: > > $a=array(1,2,3,4,5); > $b=array("a","b","c","d","e"); > $c = array(); > > foreach($a as $a_key => $a_value) > { > $c[$a_value] = $b[$a_key]; > } > > that should give you what you want. > > Jonathan > > -Original Message- > From: Shahmat Dahlan [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 21, 2001 12:23 AM > To: PHP-DB > Subject: [PHP-DB] Merge two arrays into associative arrays? > > > Is there anywhere possible for me to merge two arrays into associative > arrays? > > e.g. > $a=array(1,2,3,4,5); > $b=array("a","b","c","d","e") > > into > > $c=array(1 => "a", 2 => "b", etc... ) > > Thanks in advance.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]