Re: [PHP-DB] Can i add mysql_array into a session?

2004-02-02 Thread Louie Miranda
Thats not how it should work. Data is being passed because it will be used for something else; eg: editing/update, delete of ONLY SELECTED data Thats why, im wondering how to pass, from mysql_array to a $variable to another page. Btw, i already make it work. I catched all data using GET like

[PHP-DB] Inserting date with prepared statement

2004-02-02 Thread Tan Ai Leen
Hi all, I am using a PEAR DB prepared statement to insert date into mySQL. I tried several methods but the timestamp inserted is the current time instead of the one I specified. I have tried FROM_UNIX_TIME('1076565656'), date('YmdHis',1076565656); 20040130114049 , 2004-01-30 11:40:49, for

[PHP-DB] Re: Mail Function

2004-02-02 Thread suomi hasler
Graeme McLaren wrote: Evening all, I've written a script which sends emails, there is no problem with that. I was wondering how I can check for email bounces, anyone know how to do that? Cheers, G :) using php 4.3.3 i did the following observation: using the php mail function i created

[PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Christine Clerc
Hi, I need to turn data extracted from MySQL into an EXCEL spreadsheet (.xls, not a .txt that is imported into Excel). Is it possible ? Thank you. Christine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Griffiths, Daniel
theres an easy way if its a simple data table type spreadsheet your after, this works like a treat, at the top of your page that produces the data put - header(Content-Type: application/vnd.ms-excel); header(Content-Disposition: attachment; filename=\file.xls\); remember that your sending

Re: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Ignatius Reilly
C'est possible! I use the PEAR Spreadsheet_Excel_Writer for this purpose. Very nice. HTH Ignatius _ - Original Message - From: Christine Clerc [EMAIL PROTECTED] To: PHP DB list [EMAIL PROTECTED] Sent: Monday, February 02, 2004 11:02 Subject: [PHP-DB] From MySQL

Re: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Nitin Mehta
use simple export command select * into 'name.xls' from table name It should help Nitin - Original Message - From: Christine Clerc [EMAIL PROTECTED] To: PHP DB list [EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:32 PM Subject: [PHP-DB] From MySQL to EXCEL Hi, I need to turn

[PHP-DB] mysql_connect problem

2004-02-02 Thread DiZEM PGC
I try connecting to an existing mysql DB. The first time I directly called mysql_connect with all required params (Path/Database,User,Password) and established a connection without problems. Second time I have used a script that includes a self-written class containing a few Database functions.

Re: [PHP-DB] mysql_connect problem

2004-02-02 Thread Miles Thompson
At 03:42 PM 2/2/2004 +0100, DiZEM PGC wrote: I try connecting to an existing mysql DB. The first time I directly called mysql_connect with all required params (Path/Database,User,Password) and established a connection without problems. Second time I have used a script that includes a self-written

[PHP-DB] Mysql - Optimizing tables for search

2004-02-02 Thread Denzo
How do you optimize a table for search? And do you need to change anything in the php (sql select) to reflect these changes? I heard of creating an index or something, but can someone tell me how this works? Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Mail Function

2004-02-02 Thread Denzo
see www.php.net/imap Graeme McLaren [EMAIL PROTECTED] schreef in bericht news:[EMAIL PROTECTED] Evening all, I've written a script which sends emails, there is no problem with that. I was wondering how I can check for email bounces, anyone know how to do that? Cheers, G :) -- PHP

Re: [PHP-DB] PHP and mail forms

2004-02-02 Thread -{ Rene Brehmer }-
I wrote mine specially ... it runs with a preview phase which was pretty tricky to put in ... but the to-value is hardcoded in the script, cuz it just sends mail to [EMAIL PROTECTED] ... when the user fills in the form the script checks it for errors, and then either bounce back to the form if

[PHP-DB] Functions

2004-02-02 Thread Chris Payne
Hi there everyone, I need to write a function (New to them but starting to get the hang of it) that will take the field from a form and then do operations on it (To remove bad characters, any entered mysql commands etc ) now that's not a problem, what I want to do though is write a generic

Re: [PHP-DB] Functions

2004-02-02 Thread Micah Stevens
Chis, I think this might do what you want: foreach ($_REQUEST as $key = $value) { switch ($key) { case email: // do email stuff break; case address: // do address stuff

Re: [PHP-DB] Functions

2004-02-02 Thread Jochem Maas
elaborating (?spelling) on Micahs loop: funcs.php: ? function sanitize($glob = null) { if (is_null($glob) || !is_array($$glob)) { // set name of the global var we care about // if no valid name was passed to the function $glob = '_REQUEST'; } // using a

Re: [PHP-DB] Functions

2004-02-02 Thread Denzo
Easier is using their value, eg $email = email(replacement(functions($_POST['email']))); // or _GET $address = address(replacement(functions($_POST['email']))); ... Micah Stevens [EMAIL PROTECTED] schreef in bericht news:[EMAIL PROTECTED] Chis, I think this might do what you want: foreach

Re: [PHP-DB] Re: [PHP] Oracle + PHP

2004-02-02 Thread Luis Moran Ochoa
Ok, thanks I will try it. Michael Mauch wrote: Luis Moran Ochoa wrote: ORACLE_SID=OWEB ;export ORACLE_SID; ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME; TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN; ORACLE_BASE=/usr/oracle;