Re: [PHP-DB] Why use MySQL with PHP
I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- 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] please, please can we stop this kind of thing ..... !
He got his answer.. didn't he? If ppl would bother enough to READ the FINE manual these PHP related lists would have less then 70% of current traffic. i'm sure B (as we all were) was a newbie at some point. Yes. But being a newbie is a lame excuse for NOT searching the manual. Now.. the rest of this thread is going /dev/null Bye, B. -- 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] please, please can we stop this kind of thing ..... !
hmmm, one slipped through. There is a difference between really trying and just send a message to a list with a question which is in the manual and very easy to find too. If you don't understand the manual it's alright to ask. Would be stupid if you didn't. Take a look at www.devshed.com .. some great tutorials and general info can be found there. Have fun. B. At 15:05 20-8-01 +0100, Mark Milaszkiewicz wrote: A newbies opinion.. I'm just getting into PHP and MySql stuff at the moment, i own 2 books on them, i have the manual on my Hard Drive, and its ok saying you should consult these, but sometimes they seem to be written in gibberish, and also the books only have in them what the author thought was useful, I wanted to do a really basic online searchable database of all the dvds i owned, i was looking thru PHP4, buy choi, kent, lea... you know the one, and couldn't understand at all.. I bought a new book, and it helped a lot more, however, i still wanted to clarify certian things, as it told me to do one thing, and i didn't want it to do that. People like getting information out of other people, its all well and good reading a book, or reading the manual, but if someone can say, this is how you should do it, and it will work, its a lot better than being ignored, or told to read the manual.. sometimes it just doesn't say it the way i want to, so i need help. Its a public mailing list this, if you can help, great, brilliant, thats what we need.. we don't need people to tell us not to do certian things, etc etc. If you don't want to help, don't, just ignore the e mail, and hit the delete button, there is no need to be arrogant or anything like that, cos its not called for... Just my pov.. M -- 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] Proper Case Conversion
It's a bad habbit to crosspost!! strtolower() stroupper() sql mysql Bye, B. -- 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] Opps: Proper Case NOT lower case
Buy a good book (PHP 4 Bible)!! read some tutorials!! And CHECK the manual.. found at www.php.net what else did you think people created if for.. http://www.php.net/manual/en/ref.strings.php gives you all string manipulation fun stuff you want. ucfirst() is the solution. And last but not least STOP crossposting. sql, mysql Bye, B. -- 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] PHP5 is coming out!!!
P.S. I don't know when php 5 is coming out. aHaHaHa hehehe hohoho merry christmas thanks You can come here and ask questions. But why are you trying to fool people. This_is_not_funny. Bye, B. -- 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 to local MySQL server through socket '/tmp/mysql.sock'
At 09:35 24-4-01 -0400, franky wrote: I have this error Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) take a look in this lists archive. THis question has been answered over and over and over.. Bye, B. -- 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] Secure database connectivity?
file by FTP for example). If you're really paranoid, put the
username/password outside your htroot into a separate file, say
passwords.inc and include it into php with
include('/secure/passwords.inc'), but this isn't really needed, and
BTW, it won't make the connection method more secure, or insecure.
Perhaps I'm paranoid.. don't think it's bad.
I would recommend putting it outside the htroot.. this will prevent people
from seeing it if someone screws up the serverconfig..
Another thing I wouldn't call it password.inc.. if someone would gain
access to your userdir they would first look for something with password or
passwd in it.. give it an unrelated name..
I must agree that it won't make your PHP script more secure since it's
parsed. But it's always a good thing to be carefull.
Bye,
B.
--
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] Designing a database
So if you could give me some tips and pointers for what tables to create etc I would be grateful. You can find a few articles on www.devshed.com about database normalization. The whole idea is to put every piece of data only once in your database. And refer to them as an ID. Every ID must be unique and should never change.. so someones postalcode is a very bad idea. You can think of multiple designs.. I'm not going to do it for you.. It will and does take some time and.. unfortunately I'm not having lots of it :( To start you need to write down all data you want to add.. and what you want to be able to pull out of the database.. I found some good pointers in the book MySQL written by Paul DuBois. It handles MySQL and connections to MySQL databases.. Have fun.. B. -- 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] Secure database connectivity?
So I need a secure method for PHP to access a MySQL DB - I expect there's a million different ways of doing it, and I doubt any of them are simple...! You could start including a file from outside your HTML directory.. so Apache can't show it to the world.. but PHP can get it for inclusing.. I don't say this is the most secure way.. but much better then putting them all in your HTML directory.. Bye, B. -- 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] mysql -- Commercial DBs, When will I need to upgrade?
If anyone has had some experience with upgrading as your operations grow, I'd appreciate if you could answer ANY of the following questions: Did you say M$.. yuck.. if you think you need something else then MySQL you could take a look at PostgreSQL.. It's good, it's free and it doesn't have M$ written all over it :-) The subject sounds like commercial databases are better then OpenSource.. I don't think that's treu. You could find great solutions in OpenSource.. Like MySQL.. PostgreSQL and others.. I even know quite a few people on several lists who kicked off commercial products and started using opensource.. for various reasons. If you look at the specs.. you will see MySQL performs very good.. also with large databases. Having your own dedicated server will help you to get better performing websites.. Memory.. the more.. the better.. you can have to little but never to much of it.. If you're currently experiencing performance problems I would assume a dedicated server might help.. Bye, B. P.S. the subject is great flamebait.. -- 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] HTTP1.0/404 Not found
I want to know now to avoid displaying HTTP/1.0 404 Not found page. Despite the fact that i want say that everyone to go to index.php page on any non existing URL. pls tell me where to do the exact and how?. Add index.php to your httpd.conf think it's called directoryindex.. it says something like DirectoryIndex index.html index.htm you need to add index.php Thats all. Bye, B. -- 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] Fatal error: Call to unsupported or undefined function mysql_connect()
Such patience! You waited nearly 7 whole minutes before reposting your message! I don't run MySQL, so I'm not sure... but it looks like you probably don't have MySQL support in your version of PHP. Try: ?php phpinfo(); ? Also, include some more code.. Or even better, check out some of the fine tutorials at www.devshed.com www.phpbuilder.com www.phpnewbie.com If you're still not successful in connecting we'll be glad to check your code. Bye, B. -- 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] add php to apache
./configure --with-php=../php or more complicate... More complicated. You really should check www.devshed.com you can find more on how to install MySQL, PHP and Apache. Bye, B. -- 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] Only part of a field SQL
Is there a way to do this in the query? I am totally inexperienced. Why not remove the part you don't want to import.. very easy in Access. Bye, B. -- 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] Robust OO Shopping Cart 4 sale
This obviously was not sent to a hundred addresses indiscriminantly and is related to the nature of the list. therefore is not SPAM. I'm still considering it SPAM. Perhaps not by the definition you use but it's ment to sell a product.. else, but they are not well designed or have what people store want. They do not support the number of operating systems that we do, and are no where near as easy to install. The quality of a cart is not defined by the numbers of operatings it's supporting. The cart I'm talking about can be installed within 5 minutes if you already know the cart. Otherwise it takes you 15-30 minutes. The old docs did suck.. I wrote a new one and started writing a complete howto on that particular cart. Some free products may need additional work. But that goes for commercial products too. updates. We do not leave people hanging. Most opensource products I know don't either.. True, you need to do more work on your own. I think your experience with opensource is different from mine. It's clear you're defending yourself, although I don't know why. I've seen enough products I paid for and still the support sucks.. The free usergroups may know more then the paid support does.. A choice for buying a product or using opensource is not always a matter of how much you can or want to pay. IF you know how to write code you could always join with the developers op opensource and create a better product. Otherwise you may help them by writing docs, test and point them to bugs/errors or just ask for features.. Bye, B. -- 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] Robust OO Shopping Cart 4 sale
At 11:17 10-4-01 +0200, Bart A. Verbeek wrote: Just looked at the shopping-cart-website... Where is this e-maillink for more info?? Do yourself a favor. Take a look at www.fishcart.org it's free.. Bye, B. -- 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] Robust OO Shopping Cart 4 sale
No that is not what I said. If you go back and read I have been referring to merchants. I know that the company I work for has outstanding support. They are an exception. But if a company doesn't give you what you want go somewhere else. The only disadvantage: they already got my money. I don't mind to pay for something as long as it's really good and better then a free product. I find that most open source doesn't have great support either, and a company that charges for something will have more features that I want/need because if not then I will go somewhere else, and they have dedicated people on it. This depends on the kind of support you expect. I see lots of messages here, on the MySQL and on the ProFTPD list saying I want to do this but how.. The answer might be read a book or people are pointed to online documentation, or just RTFM. For someone like me, and quite a few others on this list, support the way you're company provides it is not needed.. Generally the open source side of things has developers who work on it in their spare time. Which leads to longer delays then commercial. I don't know if that's true. Opensource has more developers.. if say 10 people work on a project it might even become available sooner then a commercial product.. For most endusers support and easy to use/install are important reasons to buy a product.. Bye, B. -- 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] Call to undefined function: mysql_pconnect()
I am getting this error when I run a program that tries to access a mySQL DB trough PHP4. I've read that this error appears when the module for mySQL isn't present. A bit of code could help.. if it's caused by the wrong .so, you could try what happens if you compily PHP with the .so from the mysql source.. I would take a look at the code first.. perhaps try an example. Bye, B. -- 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] overrun??
I use PHP4pl1 with MySQL 3.22.32 That's OLD. 3.23.36 is current. Does other connects run without a problem? like with other databases?? If not, try what happens if you upgrade mysql to current and recompile PHP.. please, use the right API version.. I always prefer to use the one that comes with MySQL.. There are a few problems with a few versions MySQL in the 3.22 versions.. don't know of the top of my head which version and which problem. Another thing: try to use it with a known good script.. or try a tutorial.. depends a bit on your own expertise.. Bye, B. -- 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] mysql -- php
At 21:20 8-4-01 +0200, Adam wrote: Hello, I have a fresh instalation of mysql from the ditribution of RH7. What do I have to put into the user and host tables so that I can use MySQL through PHP (I doesn't have to be super-secure, just so that not everybody could get to my databases) I don't claim a very good long or short term memory.. but this is the second time I see this question.. Keep a question in the proper location two seperate threads is a bad idea. People on the installphp list don't know if you already received an answer.. The same goes for the PHP DB list.. Bye, B. -- 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] Validating forms
It is much more efficient to do that type of validation client-side, using Javascript. No sense in making another round trip to the server if not necessary. True.. but this only works if your visitor has javascript enabled.. the biggest avantage in serverside scripting IMHO is you can forse things to happen.. Besides, a visitor with a rather old browser might get bombed with javascript errors.. An if .. then loop will do the same but.. serverside. Bye, B. -- 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]
