Re: [PHP-DB] Secure database connectivity?

2001-04-20 Thread B. van Ouwerkerk
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

Re: [PHP-DB] Help with Apache+PHP4 on Windows ME

2001-04-20 Thread Johannes Janson
Hi, Does anybody know a solution? I am willing to show you my httpd.conf and php.ini if you like. httpd.conf would be helpful. only the relevant stuff like AddTpye application. Johannes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] Help with Apache+PHP4 on Windows ME

2001-04-20 Thread Cornelia Boenigk
Hi Brian it asked if I wanted to "Open or Save the file from the Current Location" instead of parsing it. It seems, that the Browser has a poroblem with the mime-type. Check wheather the default mime-type is set to text/html. Hop it helps Conni -- PHP Database Mailing List

RE: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-20 Thread Jonathan Hilgeman
I actually created an array of different conditions like: $ConditionsArray = array("Var1 500","Var2 1800","ID=43"); and then: $Conditions = join(" AND ", $ConditionsArray); This constructs: $Conditions = "Var1 500 AND Var2 1800 AND ID=43"; shrug Worked well for me. Jonathan Hilgeman

[PHP-DB] nested ifs?

2001-04-20 Thread Liz Bander
Before I delete something from the database, I need to make sure that there is only one entry, and not multiple ones. I can't do this via the database itself, because of the need for multiple entries that bear different names, but the same primary key (which I have since removed). I can't

Re: [PHP-DB] mysql -- Commercial DBs, When will I need to upgrade?

2001-04-20 Thread Larry Hotchkiss
Your DB needs sound more hardware intensive than anything. Your queries sound simple and I would bet you would never need to use anything but mysql. Also keep in mind that mysql/php/apache etc run on more than just PC's. There is some serious hardware out there that can handle

RE: [PHP-DB] PHP On Linux

2001-04-20 Thread Rankin, Randy
Try this: http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/ Randy Rankin Ben Cairns wrote: I have nearly 18 Months devel on Windows, but we are now moving to Linux, I have never installed PHP On Linux before, so could someone pls give me an 'Installation Guide' to follow for

Re: [PHP-DB] PHP On Linux

2001-04-20 Thread Larry Hotchkiss
Much of the "how to" will depend on the linux you go with. For example, on red hat 7 its all there and installable via RPM's so many of the tutorials on setting it up dont apply unless you dont use the available RPMs and you install via source. If your new to Linux, you may want to just

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-20 Thread JD Daniels
Thanks for the replies :) Victor's suggestion put me on the right track. (I still have trouble with language constructs) Heres what I have now.. All I need to do is name my form fields with the same name as the column names from the mysql table, and presto! now I can just add/remove from the

[PHP-DB] Treelike data: adjacency list or nested sets?

2001-04-20 Thread Tomás García Ferrari
Hello, I'm developing a system (with PHP-MySQL) in which I will have different articles published. Any given article can correspond to a category (or sub-category (or sub-sub-category)). Something like this: Cat 1 Sub 1.1 Sub-Sub 1.1.1 Sub-Sub 1.1.2 Sub 1.2 Sub 1.3

Re: [PHP-DB] Treelike data: adjacency list or nested sets?

2001-04-20 Thread Doug Semig
I almost always use "adjacency lists" along with another table for the actual categorization of the info (in your case, published articles). I find the "nested sets" design limiting unless you have complete foreknowledge of your tree/categories when initially populating the table. If you have to

[PHP-DB] PHP question needing info

2001-04-20 Thread Paul S
I have a question that I need help with. The question is that how do I execute a script in PHP. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP Database Mailing List

Re: [PHP-DB] PHP question needing info

2001-04-20 Thread Szii
*begins dousing Paul S with water before the flames start* -Szii - Original Message - From: Paul S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 3:04 PM Subject: [PHP-DB] PHP question needing info I have a question that I need help with. The question is

[PHP-DB] New with MySQL 3.23: Commands out of sync error (2nd try)

2001-04-20 Thread Alexander Fordyce
Resend of previous message. Should I be posting this to a more technical list? - - - - - - - - I have just run into a strange problem that I'm having a hell of a time extricating myself from. Here's the story... Recently, I upgraded to MySQL 3.23.33, mainly to experiment with some of the new

[PHP-DB] wrapped?

2001-04-20 Thread bryan
I have articles in the db, and use a wrap = "virtual": on my TEXTAREA when submitting them. So, my data is spaced out as I typed it. Is there a way to display the 'row' as is? So I want to get what I actually typed. I tried an str_replace(" " ,"BR", $text), trying to be sneaky and just

[PHP-DB] reword my question

2001-04-20 Thread Paul S
How do I execute a shell script in php? I just started to use php and I am learning it on the fly for a project. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP Database Mailing List

[PHP-DB] forget it

2001-04-20 Thread bryan
I found out that the PRE tag works sorry for the stupid question [ bryan fitch . programmer . [EMAIL PROTECTED] ]

RE: [PHP-DB] forget it

2001-04-20 Thread Alexander Fordyce
No problem... the other approach, along the lines of what you tried the first time, is to render the line breaks as HTML. PHP has a function to do that nicely... nl2br($str). -alex -Original Message- From: bryan [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 5:23 PM To:

[PHP-DB] calling a column into a popup

2001-04-20 Thread Beckie Pack
I'm creating a database where I'd like to relate a company name field to all the field in the database (mysql). what i'm trying to do is have a field pop up with all the current company names in a pop up list on a browser. so, for example, using a form i can enter all the data for a company

Re: [PHP-DB] reword my question

2001-04-20 Thread Szii
Read The Fine Manual? exec(); -Szii - Original Message - From: Paul S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 4:13 PM Subject: [PHP-DB] reword my question How do I execute a shell script in php? I just started to use php and I am learning it on the

RE: [PHP-DB] reword my question

2001-04-20 Thread Alexander Fordyce
Compile a cgi binary by leaving out the --with-apache directive, then you can use that to execute scripts from the command line and elsewhere. There's a good article about this at... http://www.phpbuilder.com/columns/darrell2319.php3 Have fun... alex -Original Message- From: Paul