[PHP-DB] Global variables, $_GET problem

2002-07-23 Thread Ruth Zhai
Hello php friends, We just upgraded our PHP to version 4.2.1. I realized that $var is no longer available from www.url.com/myphp.php?var=3 . As instructed in the document, we have tried two things: 1. I tried to use $_GET('var'), however, I got "Fatal error: Call to undefined function: array() i

Re: [PHP-DB] Global variables, $_GET problem

2002-07-24 Thread Ruth Zhai
; changing it? because registering globals should make $var available again > (but won't help with problem 1 :) > > HTH > > Beau > > // -Original Message- > // From: Ruth Zhai [mailto:[EMAIL PROTECTED]] > // Sent: Wednesday, 24 July 2002 11:39 AM > // To: [EMA

[PHP-DB] access DB via PHP classes

2002-10-07 Thread Ruth Zhai
Hi All, Although I am not so new to PHP (not expert either), this is the first time for me to use PHP class. I am starting a project, and plan to use partially OOP and partially traditional programming. I use PHP/MySQL. I have one class, DB_Do, which does every thing to do with database, and se

Re: [PHP-DB] access DB via PHP classes

2002-10-07 Thread Ruth Zhai
Thanks Wilmar, for sharing your experience with me. My problem now is that I have already got a class to do every thing related to database. If I don't use this DB class within other classes, I will have a lot of duplicated code. If I do use the DB class within other classes, I am not sure if i

Re: [PHP-DB] access DB via PHP classes

2002-10-08 Thread Ruth Zhai
Thank you again, Wilmar. As a newbie for OOP, I will keep my option open when I design this application. I have not come to a conclusion which way is better than another (I wish I had time to test all possibilities). I appreciate your comments, and will keep them in mind. Regards Ruth -

Re: [PHP-DB] sessions tutorial

2002-10-10 Thread Ruth Zhai
This is a very good tutorial about authentication using PHP and MySQL. If you don't use database, you may still learn some thing about sessions from there: http://phpcomplete.com/content.php?id=72 Ruth - Original Message - From: "Edward Peloke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: [PHP-DB] mysql - enum

2002-12-02 Thread Ruth Zhai
This is what I use: SHOW COLUMNS FROM table LIKE "field" I use the query result for a select field in HTML table. Ruth - Original Message - From: "Bastian Vogt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 11:41 PM Subject: [PHP-DB] mysql - enum > Hi, >

[PHP-DB] Linux+php+remote MS SQL

2002-12-12 Thread Ruth Zhai
Hi Everyone, I have spent a few hours searching on the internet, but still can not get the information I need. So I turn to you for help. I will be doing a web site which has a lot of data from a remote mssql server. The scripts will be in php and run on Linux. As requirements, the mssql will

Re: [PHP-DB] Linux+php+remote MS SQL

2002-12-15 Thread Ruth Zhai
a guess. I'm assuming you were asking if using connecting via ODBC is > slower. > > See: > http://www.php.net/manual/en/function.mssql-connect.php > http://www.phpbuilder.net/columns/alberto2919.php3 > > for more specific info regarding setup and mssql libraries. > > H

[PHP-DB] dump data, and save as a file

2003-02-13 Thread Ruth Zhai
Hi everyone, I want to dump some data from mysql into a file, and use php to force the browser to pop a download file window. This seems a simple procedure, but I am having trouble to make it work with IE. The following is what I did: ob_start(); $query = "SELE

Re: [PHP-DB] mysql to cvs file to excel

2003-02-23 Thread Ruth Zhai
This is what I use to generate a comma delimited csv file: $sql = "SELECT * FROM table INTO OUTFILE 'file.csv'" ." FIELDS TERMINATED BY \',\'" ." ENCLOSED BY \'\"\'"; Hope this helps. Ruth - Original Message - From: "Snijders, Mark" <[EMAIL PROTECTED]> T