Re: [PHP-DB] What are your DB driven/template strategies?

2003-09-02 Thread Colbey
On Mon, 1 Sep 2003, Colin Kettenacker wrote: The only alternative I came up with is to use .htaccess to redirect to my single initialization PHP file, but I am not sure if this is a good technique and of course it will only work on Apache. What about using php.ini's setting for

Re: [PHP-DB] Upload multiple files?

2003-08-29 Thread colbey
Very simple... Call you files being uplaoded file1, file2, fileX in the HTML form.. [html] form method=post action=uploadprocess.php enctype=multipart/form-data input type=file name=file1 size=20 input type=file name=file2 size=20 input type=file name=file3 size=20 input type=submit name=submit

[PHP-DB] PHP-DB Mailserver listed in spamcop?

2003-08-26 Thread colbey
http://spamcop.net/w3m?action=checkblockip=216.92.131.4 I just got a warning from PHP-DB mailserver that it cannot deliver to me because my server is blocking.. I checked and it looks like the list mailserver has been listed in spamcop by somebody? One of the list managers might want to take a

Re: [PHP-DB] php mssql tcpip

2003-08-22 Thread Colbey
Thoughts... I've used mssql via PHP on linux via tcp/ip 1433 with good success and performance.. Never used named pipes (I'm assuming you have to be an entire ms environment to do that) You might check into timing the process, perhaps the tcp/ip login is taking longer for authentication against

Re: [PHP-DB] Browser timing out.

2003-08-21 Thread colbey
Perhaps change it to an offline report? I've done that in the past, it get's scheduled or backgrounded and the results are either emailed to the person, or generated report stored in the database for quick load later on (user gets email that report is ready for viewing).. On Thu, 21 Aug 2003,

Re: [PHP-DB] Browser timing out.

2003-08-21 Thread colbey
Look at using server side compression, mod_Gzip or similar, PHP4.something also has compression handler built in.. When dealing with compressing raw HTML pages, very high compression levels can be reached.. Snippit from my mod_gzip+apache+php logs: ip.ip.ip.ip - - [21/Aug/2003:17:17:01 -0400]

Re: [PHP-DB] storing images in a table or in a directory

2003-08-20 Thread colbey
I store alot in databases.. when you deal with filesystem there can be issues with multiple webservers (need replication using something like rsync, etc).. I've used the db/filesystem link method before aswell but typically go with database nowdays.. You do have to query each time to get

Re: [PHP-DB] Conection to MS SQL 2000 from PHP in Linux

2003-08-09 Thread colbey
Few options.. compile using sybase-ct libraries.. or use something like freeTDS, or install odbc support.. I'd look at using freetds first.. On Thu, 7 Aug 2003, Jean Fernando Ortiz wrote: Hi all! I need to know how I must connect to MS SQL Server 2000 in a Win 2000 Server from my Internet

Re: [PHP-DB] sending data through FTP in PHP

2003-07-28 Thread colbey
FTP is used to tranfer files, typically not an array of data.. Depending what you mean.. From the sounds of things you need a protocol gateway instead of using FTP.. Unless you are loading that array of data into a file on the remote server at which point something will slurp it up and wait

Re: [PHP-DB] speeing up query and display...

2003-07-21 Thread colbey
A bit offtopic .. But 3000 X any kind of size = a good amount of rendered html data to be transmitted.. I'd make sure your using some kind of compression module on the server like mod_gzip ... that would cut down on download time dramatically (Especially for low bandwidth users) 3000 rows isn't

Re: [PHP-DB] mssql_bind problem....

2003-07-21 Thread colbey
I used to use MSSQL.. I've always called the stored procedures like you would call any method/function.. Have you tried just: // ** Query for user details *** // $query = sp_StaffDetail $var1, $var2; $result = mssql_execute($query); On Mon, 21 Jul 2003, A.J.Masterton wrote: DB

RE: [PHP-DB] mssql_bind problem....

2003-07-21 Thread colbey
I found this old piece of code.. not sure if it will still work: function calcExc($baseid, $targetid, $amount){ $sql = sp_curr_convert $amount, $baseid, $targetid; $res = sybase_query($sql); $obj = sybase_fetch_object($res); return $obj-AMOUNT; } I don't remember what the code

Re: [PHP-DB] MS-SQL = Exec stored procedures

2003-07-16 Thread colbey
my experience in the past is just: $SQL = sp_runthis $param1, $param2, $param3; $RES = mysql_query($SQL); may have to prefix with exec like you mentioned... change sp_runthis to your procedure name... probably still works the same.. On Wed, 16 Jul 2003, Stephen March wrote: Anybody have

Re: [PHP-DB] Database connection

2003-07-16 Thread colbey
undefined function means you don't have mysql support compiled in... prefixing any function with @ suppresses any error messages... On Thu, 17 Jul 2003, Martin wrote: I'm trying to use PHP 4.2.3 in a database application. ?php print Connected?; $dbcnx = mysql_connect(localhost,root,asda);

Re: [PHP-DB] Creating/Populating DB

2003-06-18 Thread colbey
This should be as simple as a PHP script that opens a connection to the destination server (with rights to do all actions you mentioned).. Opens a text file with all the SQL commands you want to issue, and starts firing them off at the server 1 by 1... Once you create the database, you need to

Re: [PHP-DB] Debugging/monitoring traffic to MySQL

2002-07-18 Thread colbey
On the MySQL server (could be the same machine) start mysql with -l arguement. Which enables connection and query logging.. YOu can just sit there and tail -f the server.log file to see all the querys/connections being executed in realtime... good look reading anything on a busy server ;)