[PHP-DB] How to Check Directory exist in Specific Folder

2002-11-19 Thread Jack
Dear all Does php have any script which can check if a directory exist in specific folder? Thx a lot Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Have fun! 3 Days for free! or for one month! every day 24 hours!

2002-11-19 Thread hotstuff
Show this line! http://www.tgpfriendly2.com/members/switzerland/pussyline/ it\'s an switzerline Have fun! Days for free! http://www.tgpfriendly2.com/members/switzerland/pussyline/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] How to Check Directory exist in Specific Folder

2002-11-19 Thread Joakim Andersson
Dear all Does php have any script which can check if a directory exist in specific folder? Thx a lot Jack if (is_dir (/path/to/your/folder) ) echo Dir exists; else echo Dir doesn't exist; Regards Joakim - This message

[PHP-DB] MySql security

2002-11-19 Thread Radovan Radic
Hi, Since i dont know any mysql group, i will try here - it is anyway related to php. When i want to make php/mysql application i have mysql on the server and i connect to it with mysql_pconnect(localhost,root,) and it works. I assume that any user or hacker could connect to mysql database like

RE: [PHP-DB] MySql security

2002-11-19 Thread Joakim Andersson
Hi, Since i dont know any mysql group, i will try here - it is anyway related to php. When i want to make php/mysql application i have mysql on the server and i connect to it with mysql_pconnect(localhost,root,) and it works. I assume that any user or hacker could connect to mysql

RE: [PHP-DB] Email Encryption?

2002-11-19 Thread Aaron Wolski
Hi All, I want to thank everyone for their suggestion. A short term solution we're simply going to remove the username from the email. This way if a hacker does obtain the email they don't have the complete details to gain access to the users account. I would like to know more about the code

Re: [PHP-DB] MySql security

2002-11-19 Thread Radovan Radic
how i do this in mysql. If this is offtopic can someone point me to any mysql newsgroup. I would say this is very offtopic, but this query should do the trick: GRANT select, update, insert ON your_db_name.* TO your_username@localhost IDENTIFIED BY 'your_password' Take a look in the MySQL

[PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
I know that this is not the forum for this question, I am only looking for a pointer in the right direction here. I need to gain a better understanding of HTML forms, specifically checkboxes. What I am looking for is once I present a list of checkboxes and the user makes his selections,

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ryan Jameson (USA)
input type=checkbox name=checkbox1 value=scoobydoo if this is checked the value scoobydoo will be put into the array with index checkbox1 which array is dependant on which method your form uses. :-) If it is not checked then there is no entry. in PHP with register_globals on the variable

[PHP-DB] formatted text, php and mysql

2002-11-19 Thread Griffiths, Daniel
Hi, hopefully someone can help me out with this.. I need to be able to copy text from a document, keeping carriage returns and white space chars, into a database and output the same to a web page. I have a field in a mysql table of type 'longtext' into which i can load text and keep the white

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
OK. If I am using the POST method and the checkbox 'name' for all of the checkboxes is 'system', how do I access the results? I am researching on the PHP site trying to figure out what this array is, and how I access this if the index name is the same for all elements. I am hoping that

Re: [PHP-DB] HTML Forms question...

2002-11-19 Thread 1LT John W. Holmes
OK. If I am using the POST method and the checkbox 'name' for all of the checkboxes is 'system', how do I access the results? I am researching on the PHP site trying to figure out what this array is, and how I access this if the index name is the same for all elements. I am hoping that

Re: [PHP-DB] formatted text, php and mysql

2002-11-19 Thread 1LT John W. Holmes
Have you looked at the nl2br() function? echo trtd . nl2br($content) . /td/tr; That may give you the output you're looking for. ---John Holmes... - Original Message - From: Griffiths, Daniel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 11:50 AM Subject:

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Rich Gray
If you name the checkbox as name=system[] then PHP will automatically create an array of the checkbox values which can be subsequently accessed via $_POST['system'][n] - be warned however that the '[]' can screw up any JavaScript code that refers to the checkbox object... HTH Rich -Original

RE: [PHP-DB] formatted text, php and mysql

2002-11-19 Thread Griffiths, Daniel
great, works like a dream! many thanks Dan -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 17:12 To: Griffiths, Daniel; [EMAIL PROTECTED] Subject: Re: [PHP-DB] formatted text, php and mysql Have you looked at the nl2br() function? echo

[PHP-DB] retriving values from two tables

2002-11-19 Thread karthikeyan
Hi all, I am karthik. I am using using php with mysql. i am stuck with a qury. Pls hep me out. i have two tables. Here is table with sample data Table Name : Links linkid header 1 yahoo.com 2 google.com 3

Re: [PHP-DB] retriving values from two tables

2002-11-19 Thread 1LT John W. Holmes
Hi all, I am karthik. I am using using php with mysql. i am stuck with a qury. Pls hep me out. i have two tables. Here is table with sample data Table Name : Links linkid header 1 yahoo.com 2 google.com 3

Re: [PHP-DB] retriving values from two tables

2002-11-19 Thread Shannon Johnston
I'm not clear on what you're considering the 'main links'. You can use the linkid value to match the header in the Links table to the childid in the subLinks table. SELECT Links.header, subLinks.childid FROM Links, subLinks WHERE Links.linkid = subLinks.linkid; This should return values like

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ryan Jameson (USA)
You learn something new every day! I'll have to remember the [] thing. My way of handling this situation that does not screw up JavaScript is to assign the names sequentially, so instead of all the checkboxes being system they would be system0,system1,... Since PHP is so wonderfully easy to use

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ford, Mike [LSS]
-Original Message- From: Rich Gray [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 01:13 If you name the checkbox as name=system[] then PHP will automatically create an array of the checkbox values which can be subsequently accessed via $_POST['system'][n] - be warned however

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Hutchins, Richard
Not only does Mike's description below work really well for a single page, if you write all of your JS stuff like this, you can very easily use the same script on multiple pages. Portability! Works great for me. -Original Message- From: Ford, Mike [LSS] [mailto:[EMAIL PROTECTED]] Sent:

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Hutchins, Richard
Let me append my earlier post. If you write a function like this: function myfunction(name){ document.form.name.do_something_legal_to_this_object } All you have to do on subsequent pages is pass the name of the object into the function and you're good to go (e.g.

Re: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ignatius Reilly
Great piece of advice Mike. Thanks. Far from obvious. I was stuck with this problem since a few days. Will that also apply to n-dimensional array, like: document.form[system[]][0][1] ? Ignatius - Original Message - From: Ford, Mike [LSS]

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
Javascript... What's that??? Just kidding. I know what it is, but that is about the extent of my knowledge. Thanks for all the great feedback. I was actually just looking to be pointed in the right direction as this was a bit outside the scope of this group. You guys come

[PHP-DB] Inserting Picture into the image field in sybase db

2002-11-19 Thread midheart
Hello, all: I have one probelm about inserting picture into the image field in sybase db. Now, I could insert 15K picture into Sybase db, but just only 15K size. I have on idea how to make the size larger, at least expand it to be 60K. Does anyone have this experience? Does the image field in

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
OK. This has been most helpful, but now I am getting something strange. The first element of the array of data is behaving strangely. For the code snippet below I am not getting the first selected element displayed: ?php ... Some stuff snipped... $a = 0; ? ?php while

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Hutchins, Richard
I think it's because you're incrementing $a BEFORE you echo it out. That would cause your echo statement to start at the second item [1]. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 3:36 PM To: '1LT John W. Holmes'; 'Ryan

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
DUH!!! I'm an idiot. That was quite obvious. Thanks. Sorry for the stupid question. -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 2:40 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] HTML Forms

[PHP-DB] how to update a text BLOB in ODBC?

2002-11-19 Thread Jeff Stern
hi, i am having the devil of a time with this. have been researching it for 3 weeks. have posted to php.faqts.com (no answer), looked a million times on php.net, and www.borland.com/interbase, written people email (no response!) and even tried to get the people at easysoft to answer (they are

Re: [PHP-DB] how to update a text BLOB in ODBC?

2002-11-19 Thread Miles Thompson
Jeff, Check your SQL. Shouldn't $sql = insert into note_tbl (note) values ('${note}') where pkey = '45'; be UPDATE where pkey = '45' ? Or, do a delete where pkey = '45' followed by an insert. In that case check the synatx of your insert 'cause it doesn't look correct. HTH - Miles

[PHP-DB] mysql_num_rows()

2002-11-19 Thread Tyler Whitesides
Hi, I have been having some trouble with this, I mysql_num_rows() to find out how many rows there are and do an insert statement in the for loop for every row returned. So, if mysql_num_rows returns 17 then the for loops does an insert statement for every instance, when the 17 turns into zero the

[PHP-DB] standart variabels melfunction

2002-11-19 Thread Martin Allan Jensen
Hi all, I have a problem with my settings of Apache and PHP i think.. When i call for example ($PHP_SELF) instead of ($_SERVER[PHP_SELF]) i get no output, just like when i call the url www.servername.tld/test.php?mode=test And i want to call the mode like this: print($mode); I just get a empty

RE: [PHP-DB] standart variabels melfunction

2002-11-19 Thread Beau Lebens
[php.ini] register_globals=On Beau // -Original Message- // From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 20 November 2002 12:41 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] standart variabels melfunction // // // Hi all, // // I have a problem with my

Re: [PHP-DB] mysql_num_rows()

2002-11-19 Thread Jason Wong
On Wednesday 20 November 2002 09:11, Tyler Whitesides wrote: Hi, I have been having some trouble with this, I mysql_num_rows() to find out how many rows there are and do an insert statement in the for loop for every row returned. So, if mysql_num_rows returns 17 then the for loops does an

[PHP-DB] $_get 2 variables

2002-11-19 Thread Gavin Amm
Hi, I'm wanting to retrieve data from my database using 2 conditions in the WHERE clause. How do i pick up 2 different variables from the URL? i can get just 1 variable easily (eg: http://localhost/myscript.php?var1=blah) My question essentially is: what string do do i need to type into the URL

Re: [PHP-DB] $_get 2 variables

2002-11-19 Thread Ryan Gallagher
Quoting Gavin Amm [EMAIL PROTECTED]: Hi, I'm wanting to retrieve data from my database using 2 conditions in the WHERE clause. How do i pick up 2 different variables from the URL? i can get just 1 variable easily (eg: http://localhost/myscript.php?var1=blah) My question essentially is:

Re: [PHP-DB] $_get 2 variables

2002-11-19 Thread Ignatius Reilly
http://localhost/myscript.php?var1=blahvar2=blah2 Ignatius - Original Message - From: Gavin Amm [EMAIL PROTECTED] To: Php-Db (E-mail) [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 7:30 AM Subject: [PHP-DB] $_get 2 variables Hi, I'm

Re: [PHP-DB] how to update a text BLOB in ODBC?

2002-11-19 Thread Jeff Stern
thanks for the correction, miles and martin.. just an email typo. i still have the problem though. :( -- Jeff Stern 949-824-2326 [EMAIL PROTECTED] Social Sciences Computing Services University of California, Irvine 3151 Social Science Plz Irvine CA 92697-5100 On Tue, 19 Nov 2002,

Re: [PHP-DB] standart variabels melfunction

2002-11-19 Thread Ignatius Reilly
Martin, what you are experiencing is the normal way to call form variables. There is no problem. You should use register_globals=Off whenever possible. better security. Ignatius - Original Message - From: Beau Lebens [EMAIL PROTECTED] To:

Re: [PHP-DB] how to update a text BLOB in ODBC?

2002-11-19 Thread Ryan Gallagher
Quoting Jeff Stern [EMAIL PROTECTED]: thanks for the correction, miles and martin.. just an email typo. i still have the problem though. :( On Tue, 19 Nov 2002, Miles Thompson wrote: Jeff, Check your SQL. Shouldn't $sql = insert into note_tbl (note) values ('${note}') where

RE: [PHP-DB] how to update a text BLOB in ODBC?

2002-11-19 Thread David Russell
Hi Jeff, Just a question - why are you using ODBC instead of PHP's native Interbase connectivity? ODBC is definitely slower. I don't know anything about BLOBs under ODBC, but I could help you with direct Interbase connectivity, which I use extensively (but not for text fields - it makes it